2.1. Import Settings
You have to run the Import Wizard to set up custom settings for the import process.
< - Click this button to run the Import Wizard and configure import settings.
Specify Import source: File, HTTP URL or FTP URL
Select .csv file for import if you choose “Local file” type for import.
Then press the browse button to select a file:
If your file to import is located on your FTP server, you should choose the third variant and specify your ftp details in the relevant fields . Use the browse button in order to find necessary path to the file.
Also, you can use saved import configuration in the drop-down menu. Select configuration title and press [Load Settings] to use the necessary configuration.
Click the [Next] button to proceed to the Fields Delimiter step. In this window, you should select a necessary delimiter from the list or enter your own. This option will be useful if you have nonstandard delimiter in .csv file. For example =, *, etc. You can enter you nonstandard delimiter in the drop-down box.
Also, check quote string values for the text fields. Default value is " (double quotes). You can change it in the input box and category delimiter. If you select the “Import Images” checkbox, check you Store Manager FTP settings in Preferences .
Click [Next] to continue the import process.
On the next step of the import process, you can choose the necessary store views where you want to import your data.
You can select date format type during csv file import according to you Shopping Cart settings. For example: dd.MM.yyyy for Europe, yyyy.MM.dd for USA and Canada.
You can change separator format "," or ". " for decimal, thousand, date and time.
Click [Next] to continue the import process.
In the next window you can assign .csv file values with the "Shopping Cart" field.
Choose "Products Identification Method", that is how the import procedure can determine whether a product already exists, or it should be created as a new one, and assign product fields to the corresponding columns of a .csv file:
You have to assign those fields you want to import. Fields that are not linked, will not be imported (changed).
Additionally, you can use mathematical expression for numeric fields (for example, price column).
Example: if you'd like to increase price on 10 percentages enter such formula:
=[CSV_COL(x)] * 1.1
Where x is price value from a .csv file.
With this formula it will be multiplied by 10 and then stored into the "product price" field.
After formula operation you can see changed price in selected column.
Press [Next] to preview the result window. Take into account, review window is used to demonstrate what you'll get after the import.
Note, that at this step you can preview results but products were not imported into your store yet.
If you are not satisfied with the import results, click [<Back] to change import settings.
If you get expected import result, press [Next>] to open the "Import Options" window (final step of the import process).
Important note: Automated product import requires creating separate import configuration for each manufacturer (1 import=1 manufacturer).
It is caused by the fact that the majority of files differ greatly in structure and some information can be incorrectly assigned to certain fields in database.
So, to avoid that, separate import configuration for each manufacturer is required.
Select product inserting options and Import methods,
- Add and Modify – products from .csv file will be added and modified
- Add only – Only new products will be added, existing products will not be changed
- Modify Only – Existing products changes only, new products will not be added.
- Just Add – Add product without checking
Finally, specify import configuration name to store settings. Import configuration contains all settings you’ve set before.
Click on “Save” button to complete wizard work.
If you have import configuration saved, you can choose it from the drop-down list and press 'Run import' process.
You can see your import data processing in the following message:
When the import is complete you can see a window that is divided into two parts - the upper one displays the data before importing, and the lower - after import.
The corresponding coloration allows investigate changes: green-colored data indicates the appearance of new units, blue-colored - updated (modified), and red-colored - those that have been removed from the database after import.
In our case, we see a list of new products that have been uploaded to the database after the import procedure:
In the left corner you can see the date of import processes which have been launched in the addon area. You have an opportunity to preview imported data by clicking the corresponding button in the addon's toolbar and this import title will be checked with the checkbox in the history list on the left.