7.2 Export Attributes


To export attributes to a separate file of CSV format use the option in the top toolbar. Open the Attributes section of Store Manager and press the 'Export Data' tool.

Export Data option

Or use the context menu to find the required command:

Export Data in Context menu

The export process will start from the page, where you should specify the file name for your exported data and its location. Use the button with three dots to open the drive system on your computer and select the necessary direction.

Select file to export

If you want to rewrite the existing file make sure it is readable and openable - try to open and preview this file previously. In case you didn't specify the necessary filename it will be created after export automatically.

You have a possibility to place attributes on the FTP server, provided that you have all necessary FTP access details.

Export data on the FTP

Check the correctness of specified credentials by going to the Settings->Preferences->FTP sector of Store Manager. The 'Test connection' button helps to verify FTP connection.

In order to proceed with exporting you should get the following message:

FTP test connection

In other case you need to contact with your hosting company to check FTP data.

In the FTP form specify also the FTP directory for your source file. Press the 'browse' button to open the FTP categories tree and find necessary location.

'Load configuration' field below allows to upload and use the previously saved export configuration from wizard list directly or from a separate file .

Load configuration field

Press the 'triangle' to open the drop-down list and choose necessary configuration or click on the 'Open configuration' button to select desired configuration file.

To clear the whole configuration list at once - hit the 'triangle' in the 'open configuration' option and choose the appropriate command from a list.

As well as delete the selected configuration by pressing the appropriate button in the same list:

Delete or clear configuration

In the wizard form you have numbered steps of export procedure in the left - you can press necessary step here or use the button below which takes you to next page (step) of export.

Numbered boxes or 'Next' button

2. On the following step of export process select delimiter characters for fields data separation. Be sure to check them to ensure proper configuration and accurate attributes exporting.

CSV delimiter step of export

Generally, use the following delimiter characters as comma (,), semicolon (;) and tab character ( ), however other symbols can be applied as well.

Quote string values - this specifies the character used to separate strings in the CSV file. It is recommended to leave this field checked.

3. The next option moves to the 'Fields to export' step. You have determine what attributes data you want to be exported.

Fields to Export step

Drag necessary ones in the left side and drop them to the right or use the appropriate buttons in the middle:

- move all fields from the right to the left pane at once (1)

- transfer only selected data from the left to the right side (2)

- move back the displaced fields from right to the left (3)

- reverse all displaced fields to their initial positions (4)

You can find the appropriate options in the context menu as well. Use the right-mouse clicking in each parts of this step (left and right) to open the drop-down options list:

a) context menu of the left pane:

Add options in context menu

b) context menu of the right pane:

Context menu of the right pane

If you need to add some formula for merging columns, replacing/removing data or increasing/decreasing some values during export process use the ‘Add simple expression field’ button which calls the 'Expression Editor form'.

Use expression field

Expression - special formula allows to add the additional information or facilitates the changing of exported 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.

'Help' button in the Expression Editor

To check if the specified formula is workable, press ‘Execute Expression’ button in the top. You should get the result without any errors in the separate window.

‘Insert...’ option helps to choose the corresponding database field values as components of expression formula.

'Inseert...' option in Expression Editor

In case you want to customize exported data and use the SQL formula 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 to have the appropriate SQL skills to create the correct and workable formula.

'The field names in first row, but not values' option should be checked, if the first row of the .csv file contains such data as the column titles or column names:

Fields names in the first row

See the example file provided below:

Column names in the first row

Otherwise this option can be un-checked.

The next step allows to select the records for exporting. You can export all attributes or just the selected ones depending on the checked position above.

Records to export

Open the advanced options fields after pressing the button in the right to check the value delimiters which will be used to separate fields data in the export file.

Also check the multiple records separator - delimiter between multiple fields value.

Advanced options form

Use the 'Set Default' button to return the default values of these settings.

After pressing 'Export' button will start the process of data transferring from Store Manager to a file that you have specified on the first step of wizard.

start exporting

On the Preview step you can see the exported data with all configured separators between the fields values from the previous step.

You can see the following actions below:

- just finish exporting and close the wizard - choose ‘Nothing’ action;

- to open the directory with your export file - choose the second action from a list;

- check exported information in a file - select ‘Open result file’ action.

Preview step of export

Check one of the listed actions above.

In addition, save current export configuration to be able to use it in the future export process.

Specify configuration name in the appropriate field and press 'Save configuration’ button - export settings will be saved in the wizard directly.

Hit the triangle next to the current option and from the drop-down list choose the 'Save configuration to a file' command - it will be saved separately.

Save current export configuration

To remove selected configuration from the wizard list or clear all list at once - use the following options from the same list:

'Save configuration' options

Press 'Finish (Page Down)' to complete the process and close the wizard.

To get the additional information of export attributes procedure move on this page of useful article:

How to Export WooCommerce Attributes?

By eMagicOne Inc.