How do I upload products in bulk?

Before starting the Bulk Import process, make sure you must be ready with the below data:

  • Product should be available in the excel sheet, for better uploading we will suggest you to download the sample file from the panel. 
  • Images of the product should be available in a folder.
  • Product Sheet size should not be more than 20 MB.
  • Please make sure that the image name mentioned in the sheet should match with the name of image available in the image folder.
  • We suggest you to compress the image size to not more than 300 KB, this helps in better performance of your website and improves the loading time of the site as well. Maximum size allowed in our system is 500 KB.

You can download and use IrfanView software for compressing the images in one go.

  • Please save the file with extension of “.csv” or “.txt” by selecting “Save as type”

 

Steps to be followed for Bulk Import Process-:

 1. Click on Catalog and then Import Products.

http://puu.sh/cgNBD/8265dc4379.png  How do I upload products in bulk? 8265dc4379

 

2. Click on Upload image first, Image manager pop-up will come up.

3. Upload all the images available in the folder by selecting all and simply drop them in the Image manager where DROP HERE text is display.

http://puu.sh/cgO70/401eb2a00c.png  How do I upload products in bulk? 401eb2a00c

4. Now the images are uploaded on the server, click on the background screen to continue.

5. Click on Step1 and then click on BROWSE to upload file. Leave rest settings to default and click on Save & Continue button on the top right of the screen.

http://puu.sh/cgOzm/60be09380a.png  How do I upload products in bulk? 60be09380a

6. Now configure the Global Settings of the sheet as per your requirements and click on Save & Continue Please refer to the Import Table for complete description of the global settings.

http://puu.sh/cgOPg/0a5667d001.png  How do I upload products in bulk? 0a5667d001

7. If you want to make any adjustment in the uploaded sheet then refer to Import Table for complete description of the same else click on Skip

http://puu.sh/cgPpw/93e4ef7b93.png  How do I upload products in bulk? 93e4ef7b93

 

8. Now, Map the Field with the respective Feed Field Name in the Sheet and click on Save & Continue.

http://puu.sh/cgPzc/d1455c5abf.png  How do I upload products in bulk? d1455c5abf

http://puu.sh/cgPIx/a6a901d5d9.png  How do I upload products in bulk? a6a901d5d9

 

Note- In case, you are using Advance sheet format to upload products, then make sure to map all the fields with the fields available in the sheet.

Also, In case of Dependent Option, the mapping order should be same as in the sheet.

Example- 1st option field should be map with option1, 2nd option field should be map with option2 & 3rd option field should be map with dependent option field.

http://puu.sh/cgPG1/4e742ca0d2.png  How do I upload products in bulk? 4e742ca0d2

  • We suggest you to save the setting profile name as it will helps in saving the settings done by you starting from global settings to Import settings.
  • If you wish to clear all the existing data from the store then select “YES” in front of “EMPTY STORE BEFORE IMPORT” and click on “IMPORT” else select “NO” and configure the settings as per your requirement.

http://puu.sh/cgQsh/a6bb496241.png  How do I upload products in bulk? a6bb496241

 

http://puu.sh/cgQuq/36517c3f09.png  How do I upload products in bulk? 36517c3f09

9. Products Uploaded Successfully and it will redirect you to Manage Products section.

http://puu.sh/cgQAw/a2d5ef2a28.png  How do I upload products in bulk? a2d5ef2a28

 

Was this answer helpful?

 Print this Article

Also Read

How to Export Product data?

To start exporting your product data, follow these steps: Click on Catalog>Export...

How to add/manage Brand/Manufacturer group?

Brand or manufacturer name are any product’s identity. So, we always suggest to create brands...

How to add products in the store?

How to add products in the store? In order to add a product manually, first ensure you have...

How to create product options or variants?

Product options are the variants of product in which the product is available. Variant depends...

How to sell digital products on your KartRocket store

1. Go to your App Store2. Look for the Digital Products App and Turn On3. Go into the Products...