Devam Ediyor

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.


Beceriler: Veri İşleme

Daha fazlasını gör: 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

İşveren Hakkında:
( 1 değerlendirme ) Palm Springs, United States

Proje NO: #7320