Batch product updates, importing .csv to MySQL

I downloaded and installed the latest version of Zen Cart yesterday. The only customization that I have applied so far is the Cherry Zen template. I did not install the demo product information as I didn't want to bother with having to delete them all.

I was wondering, is there a standardized way of handling batch product updates? I've been looking around in phpMyAdmin, and there are a LOT of tables affiliated with the products. The company for whom I'm setting up this site has an inventory of over 30,000 items, so batch updates are their only option. Is there a tool with which I can handle these updates? Or, if I should just import .csv's into the MySQL database, which product tables should be updated? I really hope it's not all of them...

:blush:

Thanks,
Dale

You should be looking at the Easy Populate Free (EP) or Easy Populate Advanced version.

Sweet. Thanks a lot. I haven't had an opportunity to look through all the modules. I really appreciate your reply, I will most definitely give that a look.

:smile:

Dale

Look here too:

http://www.zen-cart.com/wiki/index.php/Easy_Populate

I have read over the Easy Populate Wiki, I have downloaded the add-on, and it is now installed. It looks very promising. However, in the download provided from the sofware add-ons area on this site, there are no sample Excel or any other kind of files as indicated in the Wiki article. Anyone know where I might find a sample tab-delimited file?

Thanks again.

Dale
:smile:

They are in the "temp" folder that comes with the module.

... Or you can create 1-2 sample products and export from your Easy Populate from Zen Cart :smile:

Sweet! I should've thought of that!

:oops:

Thanks a lot for the help. I have now successfully uploaded 13,000ish items using Easy Populate. I'm in the process of breaking up the .csv file so I can get all 31,207 uploaded. This was exactly what I needed. Thank you very much.

Dale

:clap:

I'm glad that it worked out for you. I'm in the process of cleaning all products from my suppliers and I'll upload them all to my site. I hope will work for me too. :smile:

gnro:

I'm glad that it worked out for you. I'm in the process of cleaning all products from my suppliers and I'll upload them all to my site. I hope will work for me too. :smile:

Hello again! I know is a little late :blush: but...

I can import and export many products, but I now have a few small issues, which I'm not sure are related to Easy Populate:

• sometimes I end up with multiple quotes where there was only one (I think there are some words about this in the php file, but I'm not using "Smart Tags")
• when I export products and then modify only the price, then import back the products, the combination of the "mp" letters disappears from any word (example: "temporary" after import is "teorary")

What is the possible problem?
Please post if you have some ideas. Thank you!