Exporting WooCommerce Product Categories – WooCommerce Product Import Export Plugin

Since categories are a useful way to sort and organize your products, our Product Import Export Plugin For WooCommerce enables you to export hierarchical category structures as well as multiple categories that are associated with a specific product. Hence, you can easily export your categories and subcategories to a CSV/XML file.
While exporting, 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 two products in your WooCommerce store. The products with respective categories are as shown in the screenshot of the WooCommerce product page below:

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

• Navigate to WooCommerce > Product Im-Ex section of the plugin. Under the Product tab, move to Export Product in CSV /XML Format section by clicking the Export button, as shown below:

If you wish to skip a certain number of products, enter an offset value from which you wish to start the export. You can specify a limit to export a finite number of products. You can also specify specific product categories and product types to be exported. Configure other settings and select desired columns to be exported and click on Export Products(CSV)/Export Products(XML) to start exporting products to CSV/XML file respectively.

To know more about exporting products, read this article.

A screenshot of the exported CSV file is as shown below:

Note: You can download a sample CSV here.

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