How to import and export WooCommerce Product Categories

Export and import all your product categories as a separate post using the WooCommerce Product Import Export plugin. This article explains the import and export procedure of WooCommerce product categories in a detailed manner.

To export WooCommerce product categories:

• Click on WebToffee Import/Export(Basic) > Export.

As a first step, you need to choose the post type as Product Categories.

Choose from the below options to continue with your export:

• Quick export : exports the basic/standard fields.
• Based on a pre-saved template : exports data as per the specifications(filters, selective column, mapping etc) from the previously saved file.
  Note: The template will be listed in the drop down only if you have saved it in previous exports, if you go through the Advanced export, at Step 5 you will get an option to save the template. Once you save that, next time when you want to export a pre-saved template, it will be populated within the drop down.
• Advanced export: Takes you through a detailed process of filtering/column selection/advanced options that may be required for your export.
  Note: You can also save this file as a template for future use.
  

Filter data that needs to be exported as per the below criteria.

1. Sort Columns: Select the column on the basis of which you want to sort the export data.
2. Sort: Sorts the selected sort column in ascending or descending order as specified.

• Click on Step 4 to proceed further.

The column names appearing in this section can be edited if required. The preferred names and choices that were last saved can be viewed by choosing a pre-saved template. You can also move the columns to reorder the arrangement.

On reaching Step 5, the following window will appear, from where one can export in batches.

• Save the template file for future export as shown below(if needed).
  

  

• Click on Export to finish.

To import WooCommerce products categories:

• Click on WebToffee Import/Export(Basic) > Import.

As a first step, you need to choose the post type as Product Categories.

Choose from the below options to continue with your import:

•  Quick import : Preferred if your input file was exported using the same plugin.
•  Pre-saved template : Retains the previous filter parameters and other column specifications as per the chosen file and imports data accordingly.
  Note: The template will be listed in the drop down only if you have saved it in previous imports, if you go through the Advanced import, at Step 4 you will get an option to save the template. Once you save that, next time when you want to import a pre-saved template, it will be populated within the drop down.
• Advanced import: Imports data after a detailed process of filtering/column selection/advanced options. This file can be saved for future use.
  Note: You can also save this file as a template for future use.

The column names appearing in this section can be edited if required. The preferred names and choices that were last saved can be viewed by choosing a pre-saved template.

• Click on Step 4 to proceed.

On reaching Step 4, the following window will appear, from where one can import in batches. You can either Skip or Update the entry, if the category exists in the store.

• Save the template file for future imports as shown below(if needed).
  

  

• Click on Import to finish.

Following the above mentioned steps, you can export and import all the WooCommerce product categories with ease. Do share your queries in the comment section.