2.2. Import Settings
You have to run 'Import Wizard' to set up custom settings for import process.
Click “Create or Modify Import Configuration” button to run 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 browse button to select a file.
If your file to import locates on your FTP server - you should choose the third variant and specify your ftp details in the appropriate fields . Use 'browse' button in order to find necessary location (path) to the file.
Also, you can use saved import configuration in drop-down menu. Select configuration title and press “Load Settings” to use necessary configuration.
Click “Next” button to proceed to Fields Delimiter block.
In this window you can select necessary delimiter from the list or enter one.
This option will be useful, if you have nonstandard delimiter in .csv file. For example =, *, etc.
You can enter you nonstandard delimiter in drop-down box.
Also, check quote string values for text fields. Default value is " (double quotes). You can change it in input box and category delimiter
If you mark checkbox “Import Images” check you Store Manager FTP settings in Preferences .
Click “Next” button to continue import process.
In the next step of import procedure you can choose the necessary store views to which you want 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” button to continue import process.
In the next window you can assign .csv file values with Shopping Cart field.
Choose Products Identification Method - how import procedure can determine whether the product already exists or it should be created as new and assign product fields to appropriate columns of .csv file:
You have to assign(link) 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 .csv file - by this formula it will be multiplied by 10 and then stored into product price field
After formula operation you can see changed price in selected column.
Pressing on “Next” button you'll see preview 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” button to change import settings.
If you get expected import result, press “Next>” button to open Import Options Window (final step of 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.