Whatever the original source of your data, it must be arranged to meet the structure of the zencart database.
If you open one of the SAMPLE FILES from easypopulate v4, you will see the names of the column headers. These names cannot change.
So what you need to do is arrange the data from your supplier's spreadsheet, so that the content can be listed under relevant Easypopulate column headers.
Your supplier may have a column called PRODUCT INFORMATION. Now there is no column called "PRODUCT INFORMATION" in Easy Populate - but there is a column called "v_products_description_1".
So it is probable that all you need do is get the product information from your supplier, an make sure the column header is v_products_description_1, and not PRODUCT INFORMATION.
The same principle applies to all the data and column headings.
However, sometimes a supplier may have product information is SEVERAL DIFFERENT COLUMNS - in which case you may need to use spreadsheet FORUMLAS to merge the content of one column with the content of others.
In MS EXCEL for example, the =CONCATENATE(parameters here) formula will join the contents of specified cells. A knowledge of how your spreadsheet operates is very valuable, as this can save you huge amounts of time and effort.


Reply With Quote
