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.