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.




Comments