Sedang Disiapkan

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

Kemahiran: Pemprosesan Data

Lihat lebih lanjut: 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, need to manufacture a product, link list, headline, catagories, business list

Tentang Majikan:
( 1 ulasan ) Palm Springs, United States

ID Projek: #7320