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 by helping with Export Wizard tool.
Find the necessary option in the Product Tags page from the top toolbar or open the context menu and choose the appropriate command from a 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 via FTP - check this field if you want to place your data in the appropriate directory on the FTP server. In the form below you should specify the properly access details:
You can check the correctness of these data in Settings -> Preferences -> FTP by pressing the 'Test Connection' button. After receiving such message as in 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.
'Open Configuration' field - use it if you have the previously saved export configurations. Choose the one you need from the Wizard saved list or upload the necessary configuration from a file :
'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 checked - in another case you can get the incorrect data after exporting:
3. Next step - 'Fields to export' - divided into two panes - the left one with all fields which can be exported and the right one - the area with the field list which 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 - check this field, in case, your file with exported data should have the names on the field in the first row, as in the example below:
If you leave this field unchecked, you will get the following file after export:
Create the formula to extend your exported data - for example, combine some values positions in the appropriate 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' option helps to choose the fields you need for formula.
Use 'Help' button at the top of the editor form for more details on expression special syntax with provided examples.
To verify the formula - hit 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 the 'Add extended expression field' option above.
Look through the following documentation about the Custom SQL sector of Store Manager.
4. The fourth step of export is Export Options page. Select the records you want to export - all or the selected ones.
'Show/Hide advanced options' button - press it 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 '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 a wizard list by helping with 'Delete configuration' option (see an illustration below) .
To clear all configuration list at once - choose the corresponding option from a following drop-down command menu: