Export Categories

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

Export categories option

Follow such 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 'Test Connection' button. If you get such message as an illustration below you are able to proceed

with exporting:

Test connection button

Load Configuration field serves for uploading previously saved export configuration:

Load confuguration

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

In the wizard form you have numbered steps of export procedure in the left - you can press necessary step here or use the 'Next 'button below:

Numbered boxes on the left

2. On the following 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 re-importing, or import into another Store, or application.

3. Fields to export form - you have determined what categories fields you want to be exported. choose necessary ones on the left and move them to the right by using the appropriate buttons in the middle.

Fields to Export form

Expression - special formula that allows for the addition of information, or facilitates the changing of exporting data, based upon the application of one, or more, logical rules, designating what action(s) should be performed on the field values that also may be determined by the evaluation of the expression. Use 'Help' button in 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 on the ‘Add extended expression field’ . You will call the Custom SQL form and need necessary 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 '...' button to open the drive system and choose the necessary location.

Path to images folder

Clicking on Export, you 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 on the 'Finish' button to complete the export process and close the Wizard window.

The additional information on export categories process via Store Manager functional you can find in the appropriate page of useful articles:

Export WooCommerce Categories Smoothly

By eMagicOne Inc.