In Progress

Creloaded (Oscommerce) Products CSV Convert (Easypopulate?)

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: [url removed, login to view]

OSCommerce is CreLoaded [url removed, login to view]

This is a standard configuration but has had a modification for linking products installed as found here:

[url removed, login to view]

Skills: Data Processing, Excel, PHP, Script Install

See more: csv easy populate oscommerce, easy populate csv, create products, convert excel to website, csv spreadsheet, think pink, simple csv, QUANTITIES, products, pink, csv, csv php, creloaded, copy products, amazon stock, php process csv, spreadsheet csv, inventory files, php create csv file, php excel csv, excel file convert, script process excel files, populate excel spreadsheet spreadsheet, convert database program, create csv file inventory

About the Employer:
( 29 reviews ) Leatherhead, United Kingdom

Project ID: #527648

Awarded to:

oscworker

Please check a PMB.

$160 USD in 1 day
(82 Reviews)
6.7

7 freelancers are bidding on average $99 for this job

AtlanticSoft

Hi please check pmb for details.

$100 USD in 5 days
(179 Reviews)
7.8
agihcam

Please refer to PMB.

$50 USD in 1 day
(40 Reviews)
5.2
mmysoft

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

$90 USD in 3 days
(8 Reviews)
3.7
refractocd

Please refer to PM.

$100 USD in 5 days
(6 Reviews)
3.3
vivek9717238772

I need of only one days for your project.

$150 USD in 1 day
(0 Reviews)
0.0
arincal

I have huge experience in this type of job. I can do it witin 1 day..

$40 USD in 1 day
(0 Reviews)
0.0