Project Detail

Description

Our products are currently listed on Amazon UK and our inventory is stored in an Excel Spreadsheet for 15,000 products. We

need to be able to easily convert this into a file/files which can be uploaded to our website SQL database. We will do this

once a month where stock quantities and prices may be changed and some new products added so it needs to be quite a simple

process which we can do ourselves.

Our website already has "Easy Populate Basic" and "Easy Populate Advance" installed but we are unsure how to use these

features with the Excel file from Amazon since the column headings are different. The order of some columns would need to be

changed and some columns ignored.

I think what we need is for somebody who understands CSV files and EasyPopulate to create a script or program for us to run

to convert the XLS (or Excel Exported CSVfile) into a compatible EasyPopulate file. (and check that it works!)

I have attached a copy of an Excel file with highlighted column headings which I would like the contents to be translated to

our OSCommerce website (Yellow columns are Amazon XLS headings, pink are OSC database fields)
I have also attached a CSV file which is an exported version of the XLS file which may be easier to work with.

Basic info about our website:
Current URL until live: simon.justlaptops.com
OSCommerce is CreLoaded v6.2b2b
This is a standard configuration but has had a modification for linking products installed as found here:
http://tinyurl.com/yd9fyfa


Additional files submitted:
GAF OCT 2009.zip