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:

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

Compétences : Traitement de Données

Voir plus : wholesale master list, products manufacture, placed, manufacture online, manufacture items, height length, business manufacture want, product list upc xls, online business list, wholesale, sku, sku inventory, segment, need manufacture product, link list, headline, catagories, business list, batch program, inventory files, list code, want manufacture product, inventory update, taking information, page list

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

N° du projet : #7320