The purpose of data import is to bulk import objects like products or customers from outside using delimiter structured files (CSV). The import functionality is also able to update a huge amount of data, e.g. product prices.
Import profiles summarize all required information to individually control the import operation. These include in particular:
Uploading of files used as the data source
Type of object to be imported, e.g. product, customer etc.
CSV specific settings
Import field data mapping
Setup of automatic scheduled imports
...
Click on Add New to create a new import profile. On the following page, you must upload your import file and select the import object. After clicking on Save, you will be redirected to the new import profile .
Click the name of the import profile to edit it.
...
Data imports can be executed automatically via scheduled tasks at any time. Therefore a scheduled task is assigned to each import profile when it is created. This task is always unscheduled by default, thus the profile will never automatically execute. Click Execution to get a link to the related task and to change the scheduling settings .
Object Types
The import framework supports the following object types:
Product
Category
Customer
Newsletter Subscriber
CSV specific settings
Input Field | Description |
|---|---|
Quote all fields | Defines whether to set quotation marks around all field values. |
Trim values | Defines whether to remove space characters at start and end of a field value. |
Supports multilines | Defines whether field values with multilines are supported. |
Delimiter | Choose the field separator. |
Quote character | Choose the quotation character. |
Inner quote character | Choose the inner quote character used for escaping. |
| Info |
|---|
The first row of a CSV file must contain headers of the columns that they stand for. |
...