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:
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.
"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:
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.
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:
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:
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.
"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:
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.
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:
< - to select and move all fields from the left to the right at once .
< - to move only the selected field(s) to the right.
< - to move back all data to the left at once.
< - 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:
If you leave this field unselected, you will get the following file after export:
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.
Use the CONCAT function to combine the required fields values. For example, the "Taxonomy_ID" and "Name" columns.
Your expression should look like this:
[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.
To verify the formula press the [Execute Expression] button and you will see the result in the next form.
Press [Next] to get back to the first Editor's page and click on the [OK] button to save your expression.
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.
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.
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".
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.
Also, check the multiple records separator - delimiter between multiple records.
After pressing the [Export] button you launch the transfer process.
On the export results step you can see the following actions below:
- "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:
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:
The [Finish] button allows to close the wizard and go back to work in Store Manager.