Importing a product spreadsheet into a new store
I have a question about importing products in a fresh install of ZC 1.5 using phpMyAdmin. This is a new store. Not an upgrade. What's the best way to do this?
I have a spreadsheet including the product model, description, prices, weight and product name and the URL's to the photo's for that item, category it's in, and also spreadsheet for the cat name, products to cats etc.
In the past I was using Navicat and it worked great, I could copy and paste entire columns into the products and products to cats tables and such via navicat, worked AOK.
Now I am using phpMyAdmin to do backups and import and export, so was wondering what would be the best way to do this with phpMyAdmin.
Can anyone direct me to either a FAQ or howto or Link, hints on importing in this way with phpMyAdmin?
Thanks for any info.
Happy to be a Zen Cart Monthly Donor! :)
Bookmarks