How can we help?
< All Topics

How to import product categories in bulk using excel?

To add E-Com categories in bulk using excel, follow the below-mentioned steps.

Step 1: Go to E-Com Categories

Click on Actions button and then go to E-Com Category.

Step 2: Click on Import Categories

You can find Import Categories under the Actions button.

Step 3: Click on Download Sample

This sample file consist of an Excel sheet containing columns in appropriate order.

While uploading bulk categories through Excel, this particular order must be followed. Hence, you should first download the sample and make changes in that file only to avoid any anomaly.

Step 4: Edit the file

Once you click on Download Sample, an excel sheet will open up on your computer. This sheet will give you a basic idea of what information will be filled in the columns.

If you can’t figure out what to write in each column then check out Step 3 of this guide. [Add a link to the article How to add product categories]

Upload all the categories into this file and save it on your computer.

Step 5: Click on Select File

After clicking on Select File, you can choose the Excel sheet consisting of the E-Com categories. Select that file on your computer.

Step 6: Click on Import Excel

Now that you have selected the E-Com categories excel sheet, click on Import Excel to bulk import the products.

You will be able to see all the categories have been added in the list.

You can bulk import more product categories by repeating the same process.

Was this article helpful?
0 out Of 5 Stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Previous How to bulk import Products using excel?
Next How to add Product Categories?
Table of Contents