Importing WooCommerce Product Categories – WooCommerce Product Import Export

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

Since categories are a useful way to sort and organize your products, our Product Import Export Plugin For WooCommerce enables you to import hierarchical category structures as well as multiple categories which are associated with a specific product. Hence, you can easily import your categories and subcategories into a CSV file.
Product categories must be entered in the uploading CSV file. While importing, if a product has multiple categories, they are separated by ‘|’, and if a product has a category with a hierarchical structure, they are separated with ‘>’.

Let us understand this procedure with the help of the following example:

Suppose, you have the following two products in your CSV file. The products with respective categories are as shown in a sample CSV below:

spreadsheet-1

Note: You can download a sample CSV here.

Following are the steps to import products with their respective categories:

  • Navigate to WooCommerce > Product Im-Ex section of the plugin. Under Product > Import, move to Import Product in CSV Format section, as shown below:

Import-Products

Import settings Choose a file from the file selection option and click Upload file and import. You can also map the fields with column headings (CSV file header), and use Evaluation field to fix/update the required value for the particular field. Finally, click Submit to import the products into your online store.

To know more about importing products, read this article.

Once the import is successful, we can see the products have come perfectly into the system.

import-successful

The plugin also generates thumbnails for products by using URL of images which is specified in the CSV file.

The products get imported as shown below:

imported-product-1

Following are the product edit pages of the respective simple and variable products.

Simple Product

Simple-Product-1

In the above image, you can see the simple product – Samsung Galaxy Ace Duos is imported to WooCommerce with a product category Mobile Phone, as specified in the CSV.

Variation Product

Variable Product

In the above image, you can see the variation product – Men’s Cotton T-Shirt is imported to WooCommerce with the hierarchical product category, as specified in the CSV.

You can view the imported categories under Products > Categories section. It is as shown below:

Product categories

To know more about other features of the plugin, read the documentation.

The Best Product Import Export Plugin for WooCommerce

#1 in WordPress Official Plugin Repository With 40,000+ Active Installs

#1 in Customer Satisfaction With Most 5 Star Reviews

WebToffee Guarantee: Get Your Money Back if You Are Not Satisfied With The Product

Buy Now!

5 thoughts on “Importing WooCommerce Product Categories – WooCommerce Product Import Export

  1. Kenneth Augustyn says:

    Stunning article you have shared with us and it will be very valuable for me to increase my skills. I really impressed by your blog because you have good knowledge of import product categories. I really thankful to you.

  2. jmjose
    jmjose says:

    “Condensate Pump > Apollo Pump” is what is in the Products Categories field but the import still fails. However, upon checking the Product Categories list, Apollo Pump and its parent category Condensate Pump were created but has 0 products in it. Can you help me debug as to why this is happening?

  3. info1170
    info1170 says:

    When exporting my products the categories are separated with “|” however, when they are imported the | doesn’t separate them properly. For example, if the export has “Category A|Category B” the categories are imported as one category with the name “Category A|Category B”, not two separate categories.

    Can you help me find a solution to this?

Leave a Reply

Your email address will not be published. Required fields are marked *