2.2. Import Settings

fmHTMLMessageDialog

You have to run Import Wizard to set up custom settings for import process.

Automated product import addon


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

Select file option

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' 
Browse button 
button in order to find necessary location (path) to the file.

Specify filename

Also, you can use saved import configuration in drop-down menu. Select configuration title and press “Load Settings” to use necessary configuration.

Load and saved 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.

Select fields delimiters


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.

Select Store View

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.

Base formats


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:


Assign columns to database fields


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

Expression to price


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

Expression to a 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.

Preview import data


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

Import options



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,
Import method:
  • 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 “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. 

Run import process


You can see your import data processing in the following message:

Run import data processing


when the import is complete you can see a window that is divided into two parts - the upper one displays the data before import, 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 the list of new products that have been uploaded to the database after the import procedure:

Import is complete


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 checkbox in the history list on the left.

Preview import option


By eMagicOne Inc.

Comments