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: [login to view URL]
OSCommerce is CreLoaded v6.2b2b
This is a standard configuration but has had a modification for linking products installed as found here:
[login to view URL]
Hi you, Let do it effectively I have read your requirements carefully, so that I would like to join into this project. Based on my experience, I believe that we will reach the best results. Thanks you so much