6.2. Import Product Tags
Note: before import implementation, in case you perform it at the first time, we strongly recommend to make a backup of your store database!
You can make a backup using Tools -> Database Backup/Restore
To import product tags from a file, launch the wizard Import tool in Store Manager.
Find the necessary option on the top toolbar of the Product Tags page, or open the context menu with right-click, and select the necessary command from the drop-down list:
The first step - "Source Selection"
This step of Import requires specifying a file with data to import and its location.
You have an opportunity to use a file from your local drives, FTP or web server.
- If you use a local file, select the first checkbox - "Local file" - and use the browse button to open the local drive system at your computer (see an illustration above). Selected file should be openable and readable.
- "HTTP URL to file" - this position means you have an access to a web-server where your data to import is located. First of all, try to open that file in your web browser by specifying the full URL path in the search box.
- "FTP URL to file" - this position allows to upload data from a FTP server.
Make sure you use proper FTP settings, firstly. Go to the "Preferences" section of Store Manager and open the "FTP Settings" page. There, press the [Test Connection] button to verify the correctness of your FTP credentials.
If you get the message, as on the illustration below, you can proceed with the importing from the FTP.
In case your details are not correct, contact with the hosting company to agree on the main details.
Load configuration field helps to use previously saved import configurations during the current process. This significantly speeds up the passage of the following steps of Import.
Find necessary configuration from the wizard list directly or from a file with the browse arrow next to the [Open Configuration] button. It calls the drop-down menu:
To delete the existing import configurations or clear the whole configuration list at once, press the corresponding buttons from the current drop-down menu (see an illustration above).
In the wizard form, there are the numbered steps of the Import procedure on the left. Press the necessary step or use the button below, which takes you to the second page (step) of Import.
The second step - "Delimeter"
On this step you should select fields delimiter and quote characters. The typical delimiters are the comma (,), semicolon (;) and tab character ( ), however other symbols can be used as well.
On the preview table you can see how selected delimiter affects data displaying.
The "Quote string values" checkbox specifies the character used to separate strings in the CSV file.
The third step - "Fields Links"
This window is divided into two panes. The left pane - "Database Fields" - shows the list of fields in your database that can receive import data. To assign .csv column to the database field, you should select a field at the left and then click a column on the right pane.
Use the drop-down list to find the necessary source field:
"Identification Fields" - check the necessary positions from the drop-down list. There are two identifiers: "Name" and "Term Taxonomy ID" by which the WooCommerce Import will search for a product tags.
Use the top toolbar to facilitate the linking process.
[Auto Link All] works only in case the file columns names are the same as the store database fields.
[Unlink All] clears all "CSV col" values at the left pane.
To auto fill/unlink the selected columns on the left side, use the corresponding buttons on the top toolbar.
To modify data that is imported, for example, combine the values of some columns, you can use the simple expression formula. You can specify a necessary formule in the Expression Editor form.
Click the [Help] button on the top for more details on expression special SQL syntax with provided examples.
To combine columns use the CONCAT function and press the [Insert value from import source] button on the toolbar to select the necessary fields value.
In order to be able to check the correctness of the created formula use [Execute Expression]. You will get the result in the lower table. Press [OK] to save expression and close the editor.
The "Skip Rules" area serves to create special rules, so data covered by them will be skipped (not imported).
To create a rule use the plus sign at the bottom of the form. To remove the selected rules from the list, press the minus sign.
Fill the fields in the rules form:
- "Value type 1" and "Value type 2" - the value of the rule equation that can be taken from the database, or from a source file, or from expression formula.
- Indicate the value for your rule.
- Clarify the equation sign between the two parts of the rule.
In case of using the expression formula, you should specify the value to which this expression will be used. You can take it from the store database or from a file’s data.
By using the plus sign you can create as many rules as you need.
< - [Add Custom SQL] helps to open the Editor for SQL query creation. This is an extended expression formula, which is used for customization of imported data, for example, extract certain positions from the database or group data by a certain position, etc.
Note: you should have some SQL skills to generate proper SQL formula. Check the documentation about Custom SQL section of Store Manager for more details.
To remove the selected SQL query from the list, press the corresponding button, as shown on the illustration below:
Check if all necessary data is linked with the relevant columns in the source file.
Note: the fields that have relevant CSV columns assigned will be updated and all the other - unassigned - will not be changed after import.
If the main actions on this step are done, you can go to the final page of import process - "Options."
The fourth step - "Options"
On this step you should select the Import method. There are the following methods:
- "Add and Modify" means the new data will be added to the product tags list and will update the existing ones.
- "Add Only" serves for adding the new positions without any modifications.
- "Modify Only" can be selected, if you need to update the existing in your database records and do not want to add the new ones.
- "Just Add" allows to add the products from a file as a NEW without searching or validating existing data. Be careful, this action can lead to the duplicate records at your database!
The [Show/Hide advanced options] button allows to see/to hide the basic time and date separators. You can set these settings as default by using the [Set Default] button :
Check the "Multiple records separator" field. This field is used to separate a large number of records. If the data have too many columns, it will be automatically transferred to the next row in the file.
< - To preview the data that will be imported, press the corresponding button and you will see the result in the next window.
Attention! The import process will start, when you press the [Import] button!
If all settings are correct, continue the procedure. If you see any errors or warnings on the Import Preview step, return to the previous step and try to change settings.
The last window of the WooCommerce Import wizard displays results and errors, if any emerged in the course of the import process.
Save the current configuration to be able to use it in future. To do so, press the arrow browse button in the eponymous option in the final step of the Import wizard:
Choose the necessary destination directly in the Wizard list, or to a separate file.
In addition, you can delete unused configurations from the list, or clear the whole list at once, by using the following options from the drop-down menu:
Click the [Finish] button to exit the wizard and check your data after importing.