En cours

Wholesale Master List Separation

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:


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.


Compétences : Traitement de Données

en voir plus : wholesale price list upc xls, wholesale master list, products to manufacture, placed, manufacture online, manufacture my product, manufacture items, list my business online, i want to manufacture my product, height and length, a business manufacture want, product list upc xls, online business list, manufacture products, wholesale, to do list, sku, sku inventory, segment, price list

Concernant l'employeur :
( 1 commentaire ) Palm Springs, United States

Nº du projet : #7320