Importing Products

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

   Hello all,

I'm importing products from ZenCart and I need to make sure all the information transfers correctly. Does anyone know which fields in ZenCart map to ProductCart fields, or where I can find this information?

This would be a huge help; thank you in advance!

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
jfusion Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 04-June-2010 Status: Offline Points: 0	Post Options Post Reply Quote jfusion Report Post Thanks(0) Quote Reply Topic: Importing Products Posted: 29-June-2010 at 6:48pm
	Hello all, I'm importing products from ZenCart and I need to make sure all the information transfers correctly. Does anyone know which fields in ZenCart map to ProductCart fields, or where I can find this information? This would be a huge help; thank you in advance!

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 29-June-2010 at 6:56pm
	I don't have the exact fields any longer but when I converted a ZC store to PC it wasn't that difficult. IIRC I believe 2 ZC tables contained the product data and after exporting the MySQL database tables to .XLS it was just a matter of concatenting the data from the two tables into the single import spreadsheet.

jfusion Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 04-June-2010 Status: Offline Points: 0	Post Options Post Reply Quote jfusion Report Post Thanks(0) Quote Reply Posted: 30-June-2010 at 4:00pm
	Greg, thanks for the help. I think I have the fields mapped out now, but I'm having trouble importing categories. I got the category names from the categories_descriptions table in ZenCart, but whenever I try to import them (I tried names and short description first, then just names) I get an error from product cart. The problem is that for some reason I can only see the top part of that yellow triangle with the exclamation point in it, and there's no description of the problem. The page is productcart/pcadmin/techErr.asp?err=473838386-125418, I don't know if that error number at the end helps. What could be going wrong? Should I be doing this through product import rather than category import? Thanks again.

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 30-June-2010 at 4:10pm
	That error is likely recorded in the error log - see the help menu in the admin. It's pretty tough to try to debug this sort of issue without being personally involved and looking at the data. Might want to submit a support request. OTOH, and some others will do this differently, but I tend to have the client manually prepare their category structure ahead of product import. That way you know it is set correctly and might not fool around trying to get the category import done. That may not be what one wants to do with a lot of categories, but it's your call.

jfusion Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 04-June-2010 Status: Offline Points: 0	Post Options Post Reply Quote jfusion Report Post Thanks(0) Quote Reply Posted: 01-July-2010 at 2:25pm
	Ok, I didn't want to manually manipulate the data so it all matched, but I did do that and it worked. I gave up on the category import and did that through the product import. Thanks for the advice, it definitely shortened the project for me. One thing I'm stuck on now, which hopefully is a much simpler problem, is that the previous cart didn't have category images. Is there a setting to have categories use an image from a product in that category for its thumbnail? Thanks again.

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 01-July-2010 at 2:48pm
	Not really. Each category has it's own distinct images and each need to be set individually. Now that your categories are created, might want to export them - set the images names - and re-import.