Data Base Table upload ?

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
JacktheBear3 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 11-October-2006 Status: Offline Points: 0	Post Options Post Reply Quote JacktheBear3 Report Post Thanks(0) Quote Reply Topic: Data Base Table upload ? 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

JacktheBear3 Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 11-October-2006 Status: Offline Points: 0	Post Options Post Reply Quote JacktheBear3 Report Post Thanks(0) Quote Reply 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?