ProductCart Shopping Cart Software Forums : Importing Categories only https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 10:03:44 +0000 Sat, 03 Jan 2009 21:00:04 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=1140 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Importing Categories only : Hi, Are these categories the real...]]> https://forum.productcart.com/importing-categories-only_topic1140_post8119.html#8119 Author: Hamish
Subject: 1140
Posted: 03-January-2009 at 9:00pm

Hi,
   Are these categories the real ones, or just an example?
For this scenario I would probably use product options for the color, or, if the different color indicates a different SKU then I would use the Apparel add-on - see http://wiki.earlyimpact.com/productcart/products_options
Note, although it's called the "Apparel" add-on that's just one use for it.
If you have specifics about the categories that you don't wish to discuss on the public forum then you can drop me a PM.

The optimum category structure is a subjective thing and totally depends on whatever will make it easy for customers to get to the products they wish to purchase quickly and simply, so they are not tempted to shop elsewhere. 
That's one of the great things about the Apparel Add-on. Instead of the customer perceiving that, for example, there are 36 different versions of the same product in a list which they then have to select from, they are offered a single "product" and select the (say) size and color that they wish on a single page. ]]> Sat, 03 Jan 2009 21:00:04 +0000 https://forum.productcart.com/importing-categories-only_topic1140_post8119.html#8119 <![CDATA[Importing Categories only : Hamish,I needed the categoryID...]]> https://forum.productcart.com/importing-categories-only_topic1140_post8113.html#8113 Author: johnway2
Subject: 1140
Posted: 03-January-2009 at 2:26pm

Hamish,
I needed the categoryID to load deeper levels of categories where the categories have the same name, per the PC documentation and sample category template. But I just was thinking and I don't think you can use the product import feature with more than two levels IF you have categories with the same name.
For example, let's say I have three top categories, Car, Truck & Van and then under each of those I have Dodge, Toyota & Chevrolet and then under each of those Red, Blue and Green. When I perform a PRODUCT export, products in Car - Dodge - Red will have the same Category (Red) and Parent Category (Dodge) as the products in Truck - Dodge - Red.

I probably just need to create a flatter hierarchy.

Any thoughts on a better category approach to this situation?

Thanks,
]]> Sat, 03 Jan 2009 14:26:00 +0000 https://forum.productcart.com/importing-categories-only_topic1140_post8113.html#8113 <![CDATA[Importing Categories only : Hi John, Any URL that contains...]]> https://forum.productcart.com/importing-categories-only_topic1140_post8109.html#8109 Author: Hamish
Subject: 1140
Posted: 03-January-2009 at 5:32am

Hi John,
     Any URL that contains a link to a category will show the ID, so the "manage categories" page effectively makes them all available - in the link to each category. I'm curious as to why you need the ID value.

I've also got an idea for a work-around for loading all the categories, although it would work best if there are no proper product records loaded yet. In summary the plan is to load a set of dummy products with the categories and then delete the products, leaving the categories behind.

Use the product import feature and provide values for:
SKU
Product Name
Description
On-line Price
Inactive - Set this flag so these fake products are not visible in the storefront.

There are several approaches.
A) Use real SKU's for products that will be later properly uploaded - in which case your done as the product records will be updated with the correct values when you upload or update the products with the correct values later.

B) Make the SKU's unique (easily done in excel) and preferably nothing like the real SKU's you will be using, although that really won't matter if are deleting all the products afterwards. After importing ...
    - If ONLY the products you imported are set as "Inactive" use “purgeInactiveProducts.asp” which is available from the WIKI page linked to below.
    -  If they are the ONLY products then use “purgeProducts.asp” where you can choose to purge them all. 
The notes on the WIKI link below arte IMPORTANT - please read and understand all the ramifications before running the code.
http://wiki.earlyimpact.com/how_to/remove_all_products

Note - If you already have real products loaded including inactive ones then you would end up having to delete the "fake" products individually, in which case this is not likely to save any time, unless, as above, you can make them the only "inactive" products.
 
I HAVE NOT TESTED THIS, but if your doing this with an empty DB then there is no real risk.
]]> Sat, 03 Jan 2009 05:32:22 +0000 https://forum.productcart.com/importing-categories-only_topic1140_post8109.html#8109 <![CDATA[Importing Categories only : I figured out a workaround for...]]> https://forum.productcart.com/importing-categories-only_topic1140_post8108.html#8108 Author: avalight
Subject: 1140
Posted: 03-January-2009 at 12:46am

I figured out a workaround for this missing element in PC Admin side...In order to export or get a listing for the current information in the categories table, I ended up logging into my MSSQL database and running a query.  To manage your database Microsoft offers a free tool called Microsoft SQL Server Management Studio Express:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
If you can run an MS access query, you can figure this out too.  I output the query to a text report and loaded into Excel. You will have to get log in access from your hosting company.  The field names in the categories table do not match exactly to the names in the PC documentation, but you can figure that out too.  Except for the sort order, maybe Hamish or someone can tell me the field name for the sort order. 
Thanks

]]> Sat, 03 Jan 2009 00:46:48 +0000 https://forum.productcart.com/importing-categories-only_topic1140_post8108.html#8108 <![CDATA[Importing Categories only : I agree with avalight. Also, I...]]> https://forum.productcart.com/importing-categories-only_topic1140_post8107.html#8107 Author: johnway2
Subject: 1140
Posted: 02-January-2009 at 11:06pm

I agree with avalight. Also, I don't see any way to get the CategoryID once you have performed the initial upload.]]> Fri, 02 Jan 2009 23:06:14 +0000 https://forum.productcart.com/importing-categories-only_topic1140_post8107.html#8107 <![CDATA[Importing Categories only : I notice that this category import...]]> https://forum.productcart.com/importing-categories-only_topic1140_post8078.html#8078 Author: avalight
Subject: 1140
Posted: 01-January-2009 at 4:11pm

I notice that this category import feature has now been added to ProductCart, so that is good news. However, how about a "Export for re-import" feature, similar to the way the Import Product wizard works.   Has anyone written a script for this?
Thanks
]]> Thu, 01 Jan 2009 16:11:14 +0000 https://forum.productcart.com/importing-categories-only_topic1140_post8078.html#8078 <![CDATA[Importing Categories only : You can easily import that information...]]> https://forum.productcart.com/importing-categories-only_topic1140_post3454.html#3454 Author: ProductCart
Subject: 1140
Posted: 01-October-2007 at 5:02pm

You can easily import that information into your store database by using the import features that are built into MS SQL and MS Access. A simple CSV file with the category ID, title and description meta tags will work. You can create it in MS Excel.

If you are using MS SQL, see if your Web hosting company provides with an administration area that gives you access to MS SQL import/export tools. Many do so.

If you are using MS Access: turn off your store, download the MDB file, import the information, and re-upload the file to your Web server. Then turn the store back on.

We hope this helps!

]]> Mon, 01 Oct 2007 17:02:22 +0000 https://forum.productcart.com/importing-categories-only_topic1140_post3454.html#3454 <![CDATA[Importing Categories only : Yep, I figured that part out....]]> https://forum.productcart.com/importing-categories-only_topic1140_post3449.html#3449 Author: avalight
Subject: 1140
Posted: 30-September-2007 at 12:08pm

Yep, I figured that part out.  I will still have to manually enter the meta tag information for each category eventually.
Thanks again
]]> Sun, 30 Sep 2007 12:08:32 +0000 https://forum.productcart.com/importing-categories-only_topic1140_post3449.html#3449 <![CDATA[Importing Categories only : Ultimately, these Categories will...]]> https://forum.productcart.com/importing-categories-only_topic1140_post3448.html#3448 Author: ProductCart
Subject: 1140
Posted: 30-September-2007 at 10:33am

Ultimately, these Categories will contain products, right?  If you were to add the products during the import, the Categories will be created... so our suggestion would be to simply make sure that your import file contains the products that will be assigned to these Categories, and then you won't have to create them individually via the ProductCart Control Panel.]]> Sun, 30 Sep 2007 10:33:55 +0000 https://forum.productcart.com/importing-categories-only_topic1140_post3448.html#3448 <![CDATA[Importing Categories only : thanks for the note back. Yes,...]]> https://forum.productcart.com/importing-categories-only_topic1140_post3445.html#3445 Author: avalight
Subject: 1140
Posted: 30-September-2007 at 12:38am

thanks for the note back. 
Yes, I think it should be added for a future release.  i have about 200 categories to enter the extra information into.
Yikes.

]]> Sun, 30 Sep 2007 00:38:02 +0000 https://forum.productcart.com/importing-categories-only_topic1140_post3445.html#3445