How to Bulk Upload Physical Products (Seller)

  • Log In:

    • Log in to the system with the appropriate credentials.

  • Navigate to Physical Products:

    • From the navigation, go to Products > Physical Products.

  • Category and Brand Creation:

    • Create a category for the product. Skip if it already exists.

    • Create a brand for the product. Skip if it already exists.

  • Subcategory Creation:

    • Create a subcategory for the product by selecting the right category and brand.

    • Skip if the subcategory already exists.

  • Skip Steps for Vendor (Vendor Only):

    • For vendor product upload, skip steps 3-5.

  • Go to Physical Bulk Upload:

    • Navigate to Products > Physical Products > Physical Bulk Upload.

  • Download Skeleton File:

    • Click 'Download product Bulk Upload Skeleton File' to download the skeleton file.

    Instructions for bulk upload

    • Data till column AP is for product rest for product variant(s)

    • You can add more variants by repeating variants data in sequence for ex. in sample file first product have 1 variants and second product have 2 variants

    • Atleast one variant is mandatory and for type simple_product only one variant is allowed

    * You can keep fields blank which are optional

    products data

    1. category id - You can find from categories section - mandatory

    2. tax - You can find from products >> tax section - optional

    3. product type - It must be simpleproduct or variableproduct - mandatory

    4. stock type - If you don't want stock management leave it blank. else

      Case 1 - if product type is simple_product it must be 0 (Stock will be managed product wise)

Case 2 - if product type is variable_product and you want to manage stock product wise stock type should be 1

Case 3 - if product type is variable_product and you want to manage stock variant wise stock type should be 2

    5. name - Name of the product - mandatory

    6. short description - Short descriotion about product - optional

    7. indicator - 0 -> none | 1 -> veg | 2 -> non-veg - optional

    8. cod allowed - 0 if COD not allowed - 1 if COD allowed - optional (default will be 1)

    9. minimum order quantity - optional (default will be 1)

    10. quantity step size - optional (default will be 1)

    11. total allowed quantity - optional (Leave it blank if no such restrictions)

    12. is prices inclusive tax - 0 if prices are not inclusive tax - 1 if prices are inclusive tax - optional (default will be 0)

    13. is returnable - 0 if product is not returnable - 1 if product is returnable - optional (default will be 0)

    14. is cancelable - 0 if product is not cancelable - 1 if product is cancelable - optional (default will be 0)

    15. cancelable till - It must be received, processed or shipped (case sensitive) if product is cancelable otherwise leave it blank

    16. image - You can copy relative path from media section - mandatory (for ex. uploads/media/2021/07.jpg)

    17. other images - You can copy relative path from media section. in case of multiple images paths must be separated with ,(comma) - optional (for ex. uploads/media/2021/07.jpg,uploads/media/2021/07.jpg)

    18. video type - It must be youtube or vimeo(case sensitive) - optional

    19. video - Video link - optional

    20. tags - It must be comma separated for ex. TV,AC,Cooler etc. - optional

    21. warranty period - For ex. 6 months - optional

    22. guarantee period - For ex. 1 year - optional

    23. made in - optional

    24. sku - set it if stock type is 0 or 1- optional

    25. stock - set it if stock type is 0 or 1 - optional

    26. availability - set it if stock type is 0 -> 0 - not available 1 - available - optional

    27. description - long description about product - optional

    28. deliverable_type - add one of the following value as required to your product. - mandatory "0" - for product is not ready to delivarable in zipcodes which are in Database. "1" - for product is delivarable in all zipcodes which are in Database. "2" - for product is delivarable in these included zipcodes which are in Database. "3" - for product is delivarable except this zipcodes which are in Database.

    29. deliverablezipcodes - List as per the above option(DeliverableType) you selected. And it should be comma separated like 1,2,3 - mandatory

    30. deliverablecitytype - add one of the following value as required to your product. - mandatory "0" - for product is not ready to delivarable in cities which are in Database. "1" - for product is delivarable in all cities which are in Database. "2" - for product is delivarable in these included cities which are in Database. "3" - for product is delivarable except this cities which are in Database.

    31. deliverablecities - List as per the above option(Deliverablecity_type) you selected. And it should be comma separated like 1,2,3 - mandatory

    32. brand - add brand of your database which you want to add it in that product - mandatory

    33. hsncode - add your product hsncode - mandatory

    34. pickuplocation - add your pickuplocation ( you can find it in your panel -> pickup location ) - mandatory

    35. extra_description - add extra description of your product - mandatory

    variants data

    1. attribute value ids - You can find from products >> attribute values section. it must be in format 3,4,5 - optional

    2. price - Price of the product. it must be greater than special price - mandatory

    3. special price - Discounted price of the product. it must be smaller than price - optional - default will be 0 means no discounted price

    4. sku - set it if stock type is 2 - optional

    5. stock - set it if stock type is 2 - optional

    6. images - You can copy relative path from media section. in case of multiple images paths must be separated with ,(comma) - optional (for ex. uploads/media/2021/07.jpg,uploads/media/2021/07.jpg)

    7. availability - set it if stock type is 2 -> 0 - not available 1 - available - optional

    8. weight - weight of your product - mandatory

    9. height - height of your product - mandatory

    10. breadth - breadth of your product - mandatory

    11. length - length of your product - mandatory

  • Download Example File:

    • Click 'Download product Bulk Upload Example File' to download the example file for guidance.

  • Fill and Upload Data:

    • Fill the downloaded skeleton file with product data.

    • Upload the filled file in the 'Upload Your Products' section.

  • Follow Instructions:

    • Refer to additional instructions on the Products > Physical Products > Physical Bulk Upload page.

Still need help?

Contact us

Delivery