6. Product Tags‎ > ‎

6.1 Export Product Tags

fmProductTags


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:.


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 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:


Upload file via FTP

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.


Test FTP credentials


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 :


Export Configuration field


'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 checked - in another case you can get the incorrect data after exporting:



Quote string values

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. 


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:

- to select and move all fields from the left to the right at once - Move all fields at once;


- to move only the selected field(s) to the right - Move selected field;


- to move back all data to the left at once - Move back all fields at once;


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



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:


Field Names in the first row

If you leave this field unchecked, 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 appropriate 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' 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.  


'Help' button in Expression Editor form

To verify the formula - hit 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 the 'Add extended expression field' option above.


Add extended expression formula

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.


Records to export


'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.


Advanced options form


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


Multiple records separator

After pressing '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 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:


Delete or Clear list

'Finish' button allows to close the Wizard and go back to work in Store Manager.

Comments