Easy Populate Advanced

[thornhillguy]

I purchased & installed the easy populate advanced module in order to be able to import products from an older access database.

The instructions seem to be sketchy and I am so unsure of what to do and am in desperate need to move these items into zen cart. The zencart is a new installation and I thought it would be a breeze to export/import into it.

Cannot get any support from the author of the advanced module.

Help please.

[schoolboy]

The data in your Access Database needs to be exported to a MS excel file, which in turn needs to be saved as a TAB DELIMITED txt file before it can be used by Easy Populate.

Before any more detailed help can be offered, it is necessary to know just WHAT the nature is (content and fields) of your Access database.

The data you wish to import into your zc store has to be compliant with the table and field structures inherent in your zc database, and also compliant with the structure of EP.

[thornhillguy]

I have exported the access db to a tab deliminated excel file
In Zencart created the identical category names and in the same order as they appear.

Attached is a copy of the text file with column headings included.

I really have no clue how to get this done.

Thanks a bunch.

[schoolboy]

Your spreadsheet's column headings are:

"idProduct"
"idSupplier"
"description"
"details"
"price"
"listPrice"
"bToBPrice"
"imageUrl"
"smallImageUrl"
"sku"
"listHidden"
"weight"
"deliveringTime"
"active"
"hotDeal"
"cost"
"visits"
"sales"
"emailText"
"stockLevelAlert"
"formQuantity"
"showInHome"
"dateAdded"
"hasPersonalization"
"freeShipping"
"isBundleMain"
"isDonation"
"bonusPoints"
"searchKeywords"
"length"
"width"
"height"
"rental"
"idStore"
"idStock"
"user1"
"user2"
"user3"
"imageUrl2"
"imageUrl3"
"imageUrl4"

A handful of these are similar to the fields that EP can populate, so in these cases you just need to change the column headers, Then it's a case of choosing what other data to include and what to exclude... and where you cannot include it as a separate field, consider CONCATENATING some of the data fields/cells so you could strip it into the product description text.

As it stands, this spreadsheet cannot be used by easy populate.

My WIKI describes what you need to do.
http://www.zen-cart.com/wiki/index.php/Easy_Populate

[thornhillguy]

Actually I only need to export a few of the fields,

"idProduct"
"description"
"price"
"imageUrl"

The rest are not important, I do not know where I would be changing the column headers or where I would get the right column header names.

Thanks

[thornhillguy]

I read the wiki modified the text file but still get this error message

File Import Failed! Primary index column v_products_model or c_categories_index_path missing from uploads file. Please consult the readme.html file for more information