6.1. Export Product Tags


To save your product tags from Store Manager to a .csv file and have an opportunity to use it in the future for transferring to another place via import, perform the export tags, firstly, with the Export Wizard tool.

Find the necessary option in the "Product Tags" page from the top toolbar, or open the context menu and choose the command from the list:

Export products tag options

The initial page requires specifying the file name and location where your exported data will be placed. If a particular file doesn't indicated and selected, it will be created automatically.

'Specify file to export' step

"Upload file via FTP" - select this checkbox, if you want to place your data in the directory on the FTP server. In the form, as shown below, you should specify proper access details:

Upload file via FTP

You can check the correctness of these data in Settings -> Preferences -> FTP by pressing the [Test Connection] button. After receiving the message, as on the illustration below, you can proceed with the uploading data on FTP server.

FTP is succesful

In other case, clarify your main access details with your hosting company to be able to continue.

Use the "Open Configuration" field, if you have previously saved export configurations. Choose the one you need from the wizard saved list or upload the necessary configuration from a file:

Export Configuration field

The [Next] button moves you to the following export step. In order to go to the export step you need, without going through all the steps gradually, use the numbered boxes with the export steps' titles inside on the left:

Numbered boxes in the left and Next button

2. Select fields delimiter and quote characters page contains some important settings to separate data. You can see the typical delimiter types in the drop-down list, but you can choose your own delimiter symbol as well.

Select delimiter character

"Quote string values" specifies the character used to separate strings in the CSV file. Leave this field selected, in another case, you can get the incorrect data after exporting:

Quote string values

3. The next step - "Fields to export" - divided into two panes. The left one with all fields that can be exported and the right one - the area with the field list that will be exported.

Field to export

To export necessary field value - just drag it from the left and drop it to the right pane.

Use the following option tools as well:

Move all fields at once

< - to select and move all fields from the left to the right at once .

Move selected field

< - to move only the selected field(s) to the right.

Move back all fields at once

< - to move back all data to the left at once.

Move back selected field

< - to transfer the selected field from the right to the initial position on the left.

First row in .csv file contains field names but not values. Select this checkbox, if your file with exported data should have the names in the field in the first row, as on the example below:

Field Names in the first row

If you leave this field unselected, you will get the following file after export:

Not the field names in the first row

Create the formula to extend your exported data, for example, combine some values positions in the relevant fields of store database. It can be possible with the simple expression.

Launch the Expression Editor form to generate the necessary formula.

Add simple expression

Use the CONCAT function to combine the required fields values. For example, the "Taxonomy_ID" and "Name" columns.

Your expression should look like this:

Example of simple expression

[Insert Database Field Value] helps to choose the fields you need for formula.

Use the [Help] button at the top of the editor form for more details on expression special syntax with provided examples.

&#39;Help&#39; button in Expression Editor form

To verify the formula press the [Execute Expression] button and you will see the result in the next form.

Execute Expression button

Press [Next] to get back to the first Editor's page and click on the [OK] button to save your expression.

Execute expression formula

You will get the additional field with the specified expression on the left. Drag-and-drop it to the right pane and your formula will be exported to a file with the other selected data.

Drag ad drop expression to the right pane

To add more complex formula, that allows to make changes to your store database tables requires some SQL skills and can be done by helping with the Custom SQL editor.

To launch the editor form directly from this step of export use [Add extended expression field] above.

Add extended expression formula

Look through the following documentation about the Custom SQL sector of Store Manager.

4. The fourth step of the export is "Export Options". Select the records you want to export - "All" or "Selected only".

Records to export

Press [Show/Hide advanced options] and the form with the main date and time formats will open. You can leave these settings as they are.

Advanced options form

Also, check the multiple records separator - delimiter between multiple records.

Multiple records separator

After pressing the [Export] button you launch the transfer process.

On the export results step you can see the following actions below:

Actions after export
  • "Nothing" - just complete the export and close the Wizard;
  • "Open directory containing result file" - after export, the directory, where is the file with exported data, will be displayed;
  • "Open result file" - it gives a possibility to view the source export file right after the export process.

Select the one you want to be performed.

Save current export settings to the Wizard list directly or to a separate file by choosing the appropriate option below and you can use this configuration during the next export process:

Save configuration field

If you have any unused or inactive configurations, you can remove them from the wizard list by helping with "Delete configuration" (see an illustration below) .

To clear all configuration list at once - choose the corresponding option from the drop-down command menu:

Delete or Clear list

The [Finish] button allows to close the wizard and go back to work in Store Manager.