2.2. Export Categories

In the "Category" section you have the possibility to transfer categories to a separate file by using the Export Wizard tool.

Export categories option

Follow these steps to perform the export process successfully:

1. Specify the file where your data will be located after export. If you want to update the existing file, make sure that it is acceptable and readable.

Specify file to export

To verify the correctness of FTP details close the wizard and go to Preferences - > Database Connection - > FTP - > and press the [Test Connection] button. If you get the following message as shown on the illustration below, you are able to proceed with exporting:

Test connection button

The "Load configuration" field serves for uploading previously saved export configuration:

Load confuguration

This significantly speeds up the passage of the steps of the export procedure.

There are steps of the export procedure listed on the left in the Wizard form. You can select the necessary step from this list or press the [Next] button to proceed.

Numbered boxes on the left

2. On the next step of export select delimiter characters for fields data separation.

Be sure to check them to ensure proper configuration and accurate exporting of WooCommerce categories.

Delimiters step of export

The resultant export file is usually generated for further processing, and subsequent reimporting, or import into another store, or application.

3. [Fields to export] - you should determine what categories fields you want to be exported. Choose necessary ones on the left and move them to the right with the corresponding buttons in the middle.

Fields to Export form

Expression - special formula that allows to add information, or change exporting data, based on the application of one, or more, logical rules, designate what action(s) should be performed on the field values that also may be determined by the evaluation of the expression. Use the [Help] button on the top for more details on expression special syntax with provided examples.

In case you want to customize exported data and use an SQL query to make the changes in the field's value, click the [Add extended expression field] button. This will call the "Custom SQL" form. Note: you need some SQL skills to create the correct formula in it.

Expression Edtor form

4. The fourth step of export shows the following information:

Export options step

In the "Advanced options" form, which appears, you can preview the basic export fields, which you should check and, if necessary, edit. And also to check multiple records separator - delimiter between multiple fields value.

Multiple records separators

You should specify the path on your computer to the categories images. Use the [...] button to open the drive system and choose the necessary location.

Path to images folder

Click [Export] to start data transferring.

Press export to start exporting

The resulting form shows summary results of the process.

Results step of export

You have an opportunity to save the current export configuration.

Save configuration options

Click the [Finish] button to complete the export process and close the Wizard window.

Additional information on export categories process via Store Manager functional, is available on the page of useful articles:

Export WooCommerce Categories Smoothly