Helpcenter +918010117117 //" [email protected]
B4,309-10 Spaze iTech Park, Sector 49, Sohna Road, 122001 Gurgaon India
call to replace anchor tags contains '/admin' in href

How to add variants of products in bulk?


Suppose you want to sell the products that have multiple variants. Let us take the example of a sweatshirt which has many variants depending on size and color. You want to upload the variants of the size of a sweatshirt in bulk without wasting your time in one by one manual upload.



StoreHippo offers an easy way to update the variants for multiple products through CSV file at the same time. To do so, follow the process given below:

  1. Go to Products > Products section in StoreHippo Admin Panel.
  2. Click on the Export button to export the product CSV file.
  3. A dialog box for exporting file opens. Fill up the fields as shown below:
  4. Click on Send to Email. The CSV file is sent to you in the email or you can download the file from Export logs.
  5. View the downloaded CSV file. The name of all the product variants are the same but the price, SKU, and weight can be different for different variants. The CSV file appears like this:
  6. Go to the option1_name column of the product for which you want to add variants. Then enter the value of the variant in the option1_value column. For example; you can put option name as 'size' and option value as 'XS'. You can provide option sets for your product variants in the option_set column.

  7. You can add another variant by providing the name and value in option2_name and option2_value columns respectively.
  8. If you want to add more such variants, add more fields such as option3_name & option3_value and so on in the header column and provide their values.
  9. When you have entered all the desired variants, go to the Products section of the admin panel. Click on the Import button to import the edited CSV file.
  10. The dialog box for importing file opens. Upload the file in which you made changes and click on Import file.
  11. You can check the status of the imported CSV file by clicking on the notification icon or in Import logs.
  12. The variants will be updated in the admin panel and storefront.