Export parts/prices to excel/CSV?

I'm a designer with virtually no programming experience.

My customer is still running Zencart 1.2.6d with no intentions of upgrading (cost to migrate the custom template being at issue)

I've got a nice little database publishing application written for InDesign (Adobe page layout program) that will run out a variety of different customized pricelists that are all easily customized for him. All it needs is a CSV file.

Ultimately, i'd like to get the part number, the description, the price, and the image file name associated with each record from ZenCart into a CSV.

But, i could get by with just the description and price if there are issues with getting all the data.

Is this a simple SQL query i can send the database, or is there some other Zen plugin that can do this?

Thanks for any suggestions.

cudaboy71:

I'm a designer with virtually no programming experience.

My customer is still running Zencart 1.2.6d with no intentions of upgrading (cost to migrate the custom template being at issue)

I've got a nice little database publishing application written for InDesign (Adobe page layout program) that will run out a variety of different customized pricelists that are all easily customized for him. All it needs is a CSV file.

Ultimately, i'd like to get the part number, the description, the price, and the image file name associated with each record from ZenCart into a CSV.

But, i could get by with just the description and price if there are issues with getting all the data.

Is this a simple SQL query i can send the database, or is there some other Zen plugin that can do this?

Thanks for any suggestions.

Hi cudaboy,

Were you able to find anything that helps you with this as I am looking for the same sort of thing.

Thanks

not directly from zencart. and, i never found the image file name (though i really didnt dig that hard...the price and description ended up being enough). but, i was able to extract the data i needed out of mysql with a little work....basically copying data from two tables into one excel workbook. here are the relevant notes i took at the time:

2. log into sql manager

3. open [yoursqldatabase]

4. open 'products' table

5. click the export icon at the top of the main products window

6. choose excel 2000 format

7. click 'go'. file will download

8. repeat 4-7 above with the 'products description' table

9. open each of the files in excel. the first column in each is the primary key. sort by this key, in ascending order.

10. copy column 2 (the item description) from the 'products description' table data to the 'products' table.

FYI, i can't remember which column it is. but, one of the columns in the products data is the category ID# from zencart. after you get the parts and description data into one file, you can use this ID# column to sort by category.

i was then able to save the excel file out as a tab-delim text file and import it into my database publishing application to create a formatted pricelist in about 5 seconds.

good luck. hope that helps.

Or try using the Easy Populate Mod to download all this info.

Or try using the Easy Populate Mod to download all this info.

well, see now that's the kind of info i could have used 9 months ago. better late than never ;)