Wholesale Master List Separation

In Progress Posted Oct 25, 2004 Paid on delivery
In Progress Paid on delivery

I am taking my business online and the wholesale companies that I work with use 1 (one) large .xls files for the items that are available. I need to have the files separated into separate tables/files so that I may upload them to MySql for the ShopingCart program that I am using. The companies update this file every 3 months, so I need to be able to run the .xsl files through and have the inventory information placed into its correct tables.

The xls files have the following headings:

SKU, BRAND,WHOLESALE PRICE, SRP,SEGMENT,CATEGORY,CONTENT GROUP ,BURST, HEADLINE,BULLETS,IMAGE FILE,WEB LINK,UPC CODE, LENGTH, WIDTH,HEIGHT,WEIGHT,PAGE

I need to place the information into the following tables:

Catagories, Catagory Description, Manufacture, Manufacture Information, Products, Product Catagories, and Product Descriptions.

Please see the attached files as examples. I want to use a shopping cart program called OsCommerce, which uses MySql, but I need to do batch changes, not one at a time. The files are from the Demo that comes with the program.

Thanks

Data Processing

Project ID: #7320

About the project

11 proposals Remote project Active Oct 25, 2004