https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 03:56:10 +0000 Sun, 24 Dec 2006 11:20:40 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=566 https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ https://forum.productcart.com/data-base-table-upload_topic566_post1664.html#1664 Author: JacktheBear3
Subject: 566
Posted: 24-December-2006 at 11:20am

Ok, Merry Christmas to anyone reading the forums today.

In reference to the above; if you have lots of categories (like 760 of them) has anyone done the following successfully......

Since the upload of xls file is limited to 2 tiers of Category tree, and maybe you want your items in say 5 categories...... if you upload the item  (after the item is in the store database from initial upload) several times just using the sku and category columns changing the secondary category to fit the categories that are third and fourth tier.

Will the system map them and add them to the other categories without over writting the initial categories assigned from the prior upload?


]]> Sun, 24 Dec 2006 11:20:40 +0000 https://forum.productcart.com/data-base-table-upload_topic566_post1664.html#1664 https://forum.productcart.com/data-base-table-upload_topic566_post1663.html#1663 Author: JacktheBear3
Subject: 566
Posted: 23-December-2006 at 2:46pm

Is it possible to simply export the Categories table to Excell.... Update it, configuring all the ID and tier levels , and then replace the Categories table with the updated table?

I am using MS Szl, am not a DBadmin or anything but I had made some errors and wanted to change them.... when accessing the table in MyLilAdmin it seemed quite easy to do and made me wonder if there were some special reasons such as the index key for the record being previously assigned to a product etc....

Jack
]]> Sat, 23 Dec 2006 14:46:45 +0000 https://forum.productcart.com/data-base-table-upload_topic566_post1663.html#1663