How to Import products in bulk?

How to Import products in bulk?


Notes
Products are items or catalogs displayed to customers. This guide will help you create and manage multiple products efficiently. Each product has its own detailed page with descriptions, images, and specifications to give customers a clear understanding and help them make informed decisions

Step-by-Step Guide to Import Products in Bulk:

1. Initiate Import Products:

  • On the left sidebar, click on the Products option.
  • Click the Add Product button in the top-right corner of your screen.
  • Choose the Import Products option to bulk upload products.

2. Download the File Template:

  • On the Import page, click on the Download File Template option and click Next.


3. Fill in the Product Details:

  • Open the downloaded template and fill in the necessary details for each product.
  • Notes for Filling Details:

    • Slider Images:
      Add multiple product image URLs separated by commas to show a slideshow.
      Example:
               https://example.com/image1.jpeg, https://example.com/image2.jpeg
    • Brand Name:
      Select the brand from the drop-down menu in the Excel sheet.
    • MRP:
      To enter prices like 1999.00, type a single quote (
      ') before the number in Excel to keep the format.
    • Product Specifications:
      Add specifications in the format:
      Key: Value. Use a new line for each specification.


  • After completing the Excel sheet, upload the file. Once uploaded, click Next.

4. Preview the Data and Import:

  • After uploading, the system will prompt you to preview the data. Review it carefully to ensure all details are accurate.

  • Click the Import button to complete the bulk import. Once done, a confirmation screen will appear.

Conclusion

By following these simple steps, you can easily import products in bulk into the portal. This makes managing large quantities of products quick and efficient.

FAQ

1. What file format should I use for product import?

You must use the template file downloaded from the portal. Uploading in any other format may cause errors.


2. How should I add multiple product images?

Add all image URLs in the Slider Images column separated by commas.
Example:
https://example.com/image1.jpeg, https://example.com/image2.jpeg


3. Why do prices like 1999.00 not appear correctly in Excel?

Excel automatically removes decimal formatting.
To fix this, add a single quote ( ' ) before the number:
'1999.00


4. How do I add product specifications in the template?

Write specifications in the format:
Key: Value
Add each specification on a new line within the same cell.


5. What happens if some required fields are missing?

The system will show an error during the preview stage. You must correct the data in the file and re-upload it.


6. Can I edit products after they are imported?

Yes. After import, you can individually edit any product by opening its product page.


7. How many products can I upload at once?

There is no strict limit, but uploading very large files may take longer depending on file size and internet speed.


8. Can I import products for multiple brands in one file?

Yes, as long as each product's Brand Name is correctly selected in the template.


9. What if the image URLs are incorrect or broken?

The import will still succeed, but the product images will not display. You must correct and update them manually later.


10. Will the system notify me after a successful import?

Yes. After clicking Import, you will see a confirmation message indicating the import was completed.