In Category section you have a possibility to transfer categories to a separate file by using the Export wizard tool.
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.
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
Load Configuration field serves for uploading previously saved export configuration:
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:
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.
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.
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.
4. The fourth step of export shows the following information:
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.
You should specify the path on your computer to the categories images. Use '...' button to open the drive system and choose the necessary location.
Clicking on Export, you start data transferring.
The resulting form shows summary results of the process.
You have an opportunity to save the current export configuration.