From Bosscart Documentation

Instructions for uploading products with csv uploader

1. Fill the id column ( first column ) only if the product with that id needs to be edited. New product does not need id.
2. Code ( second column ) is mandatory. It is code of the product being added or edited. Duplicate value is not accepted. It will show error and the row and the rows after it wont be uploaded
3. Quantity ( third column ) is mandatry. Please enter a numeric value . It means the no of products in the stock
4. Master Category ( fourth column ) is mandatory . Enter the main category name here. If checkbox with label ' Insert New Categories form CSV ?? ' is checked new category will be created in database if the category with same name does not exist.
5. Category , Sub Category ( fifth, sixth and seventh column ) is not mandatory. Enter the category in the hierarchy that the products rests on.
6. Master category2 to Sub Sub category3( Eighth Column to Fifteenth Column ) is for second and third category. They can be left blank or can be filled as for the first category structure
7. tax inclusion ( sixteenth column ) is mandatory. Insert ' No ' if the product is not taxable . ' Yes ' if it is taxable
8. vat inclusion ( seventeenth column ) is mandatory. Insert ' No ' if the product is not vat applicable ' Yes ' if it is vat applicable
9. free shipping ( eighteenth column ) is mandatory. Insert ' Yes ' if it is the products ships for free . No if the shipping charge is required
10. meta description ( nineteenth column ) ( mandatory ) enter the meta description for the product
11. meta keyword ( twentieth column ) ( mandatory ) enter the meta keyword for the product
12. name ( Twenty First column ) ( mandatory ) enter the name for the product .
13. Original Price ( Twenty second column ) ( mandatory ) enter the price of the product
14. Discounted Price ( Twenty third column ) ( optional ) enter the discounted price of the product (this price will be applicable as price of product if entered )
15. Product Weight ( Twenty fourth column ) ( optional ) enter the numeric value of the product weight. Do not include unit. unit will be the default unit that is applicable in the shop
16. Description ( Twenty Fifth column ) ( mandatory ) Enter the product description.
17. Promoline ( Twenty Sixth column ) ( mandatory ) Enter the promo line for the product.
18. Manufacturer ( Twenty Seventh column ) ( mandatory ) Enter the product manufacturer name. If the manufacturer name is not present in the database new manufacturer will be added.
19. attribute 1, Value 1 , Unit 1 , Price1 , Stock1 , Weight1 and so on ( optional ) . Enter the product specific attribute name , its value , its unit,Its additional prices ,its stock and its weight. Maximum 10 such attributes can be added.
20. image 1 to image 7 ( optional ) . Enter the product image names .
    1. The names should not contain special characters.
    2. The images with the same name should be uploaded to
       • images/products directory (size should be 800 X 600 )
       • images/products/productdetail directory ( size should be 300 X 296)
       • images/products/thumbnails directory ( size should be 80 X 80 )
       • images/products/thumbnail2 directory ( size should be 120 X 120 )
       • images/products/thumbnail3 directory ( size should be 250 X 240 )

Other insturctions

1. Do not keep ' , ' in the value . Keep [comma] in where it is needed.
2. Do not keep rows empty ( the rows below the empty row wont be uploaded )