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: Local File, HTTP URL to file, FTP URL to file, Google spreadsheets
Select the .csv file for import if you choose the “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 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 a nonstandard delimiter in the .csv file. For example [#], [*] etc. You can enter your nonstandard delimiter in the drop-down box.
Check quote string values for the text fields. The default value is ["] (double quotes)
At the Fields Delimiters and Additional Settings step, select the categories in the Category tree delimiter. Also, select the delimiter to separate images in the Image Gallery and Multiple values in one column delimiters
Check the category options:
Use ID as a category path
Keep current categories associations
Check the Import files option for Downloadable Products import
If you select the Images checkbox, check your Store Manager FTP settings in Preferences[F12] and select necessary options for the correct import
In the next step of the import process, you can choose the necessary store views where you want to import your data.
You can select the date format type during the .csv file import according to your Shopping Cart settings. For example [dd.MM.yyyy] for Europe, [yyyy.MM.dd] for USA and Canada.
You can change the separator format "," or ". " for decimal, thousand, date&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 the expected import result, press [Next>] to open the "Import Options" window (final step of the import process).
Important note: Automated product import requires creating a 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 the database.
So, to avoid that, a separate import configuration for each manufacturer is required.
Select product inserting options and Import methods,
Add and Modify – products from the .csv file will be added and modified
Add only – Only new products will be added, existing products will not be changed
Modify Only – Existing product changes only, new products will not be added.
Just Add – Add product without checking
Finally, specify the import configuration name to store settings. Import configuration contains all settings you’ve set before.
Click on the Save” button to complete wizard work.
If you have import configuration saved, you can choose it from the drop-down list and press the '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.