I need to import 6,000 products from which is in excel format to fresh magento installation. All product must be imported with proper category and attributes set as per the excel data. Product details in excel format are not exported from another magento, it was from a whole seller. Attached the data's of the excel format. Please bid if you have past experience with magento import and provide me the url of magento websites you have developed so far.
In one of the product document named [login to view URL] products have no images, need to browse for images and upload the same together with products.
I would like to give you few inputs for your better understanding of both excel sheets.
[login to view URL] dropship file (fields)
Path - category
code - sku
Name - Product name
caption - description
Price - Price
Your Cost - Cost
msrp - Manufacturer's Suggested Retail Price
but category must be like Mens, Womens, Unisex, Bath & Body as primary category and their products (like fragrance, Gift Sets), as sub-category and Alphabet letters ( A, B, C, D..)are final category that holds products.
2. Inventory File
Color, Material and Style are attributes.. with images to be uploaded...