Zen Cart Logo
Forums / General Questions / Uploading photos and price sheets

Uploading photos and price sheets

Views: 645

Results 1 to 2 of 2
1 Jan 2013, 9:15 AM
#1
ediesinc avatar

ediesinc

New Zenner

Join Date:
Jan 2010
Posts:
15
Plugin Contributions:
0

Uploading photos and price sheets

What I am trying to do is take one of our suppliers price file that I have converted over to the format that is needed to use easy populate. Where I am running into problems is linking the photos to the correct decriptions/ items. Any ideas on how best to accomplish this without going to each listing and pulling in the photo?

I am doing this with a couple of supplies as they seem to change or update their price files twice a year and would just like an eaiser way to update ours as well.

Thanks for all your help

Eric

1 Jan 2013, 10:01 AM
#2
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Uploading photos and price sheets

ediesinc:

What I am trying to do is take one of our suppliers price file that I have converted over to the format that is needed to use easy populate. Where I am running into problems is linking the photos to the correct decriptions/ items. Any ideas on how best to accomplish this without going to each listing and pulling in the photo?

I am doing this with a couple of supplies as they seem to change or update their price files twice a year and would just like an eaiser way to update ours as well.

Thanks for all your help

Eric

If you get a spreadsheet of data from a supplier, then this spreadsheet needs to be EDITED first, and the data put into a format that is compatible with the zencart database structure.

If you are using Easy Populate (and version 4 is the correct one to use if you have zencart 1.5.x), then you should first create a DOWNLOAD file from your database using easy populate file export.

When you have a data dump from easy populate of your EXISTING data, you will see what DATABASE FIELDS are involved. There will be COLUMN HEADERS in the spreadsheet, such as:

v_products_model
v_products_image

... and under each column will be the data relevant to each field that easy populate works with.

I wrote a tutorial for Easy Populate 1.2.5.4 (and much of it is relevant to Easy Populate version 4), with a few differences. Firstly EP4 must be saved as a CSV file - not TAB-DELIMITED, and you no longer need the EOFEOF column.

There are support threads for both versions.

My tutorial is at: http://www.zen-cart.com/wiki/index.php/Easy_Populate