Easy Populate question

[mrbuzzsaw]

that is what i was planning on doing how do i make it pull those populated files?

[mrbuzzsaw]

these seem to be my options


Download EP and Froogle Files

Download Complete tab-delimited .txt file to edit (Attributes Not Included)
Download Model/Price/Qty tab-delimited .txt file to edit
Download Model/Category tab-delimited .txt file to edit
Download Froogle tab-delimited .txt file
Download Model/Attributes tab-delimited .txt file


the
Download Model/Price/Qty tab-delimited .txt file to edit

has a couple of attributes in it but the rest is not populatd

[Crunch]

If you have a new store, manually add a few products to your new store and then choose:
Download Complete tab-delimited .txt file to edit (Attributes Not Included)

This gives you a template to build from when you want to mass add new products or mass update existing products.

Be sure to check out the Easy Populate Wiki and the readme.txt file. Both of those helped me when first using this contribution.

[schoolboy]

The BASIC rule for attempting to import existing data into zencart (data that is in a spreadsheet that has "alien" column headers and thus a possibly different assembly of the data fields) is to first understand the Zencart structure. And people are pointing you to my WIKI, which I hope will give you a better understanding of EP1.2.5.4 .

After you have gotten a grasp of what EP does for the Products Table(s) in zencart, you can then look at your existing sheet, to see how it will need to be re-organized (and possibly re-shaped) for essential data to go into zencart.

I fully agree that (after you have installed and configured EP - I would recommend 1.2.5.4 or 12.5.5) you should add a few products to your zenshop in the NORMAL WAY - ie: via the shop's Admin Console.

Then... do a EP dump of your data, open the file in a spreadsheet, and see how it has arranged the product data you added earlier.

Then, look at that spreadsheet you are hoping to use...

There may, for example, be PRODUCT DESCRIPTION DATA stretching across several columns. In zencart, such data is all housed in ONE field (column).

In my earlier days, I worked on a site for an education equipment supplier. Their product description data was housed in SEVERAL fields on the company database:-

[Overall Description] - [Curriculum Reference] - [Key stage] - [Specifications]

Now, zencart does NOT have fields for:
[Curriculum Reference] - [Key stage] - [Specifications]

so I had to work out a way of JOINING UP the data in these additional fields, so that they became part of the Overall description.

Now, if you know MSExcel, then you would JOIN UP all this data using Excel's CONCATENATE(xxxx) forumla...