Managing Import Profiles

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

To manage import profiles, go to Configuration > Import.

You can directly execute the scheduled task that is configured by a profile by Run Now in the profile list and watch  the progress of the import. Activity Log opens the log file for the last import. It contains important information (like errors) about the last execution of the profile.

Creating and Editing Import Profiles

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 Saveyou 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

220px|Input FieldDescription
Quote all fieldsDefines whether to set quotation marks around all field values.
Trim valuesDefines whether to remove space characters at start and end of a field value.
Supports multilines

Defines whether field values with multilines are supported.

DelimiterChoose the field separator.
Quote characterChoose the quotation character.
Inner quote characterChoose the inner quote character used for escaping.

The first row of a CSV file must contain headers of the columns that they stand for.

Import field data mapping

You can optionally set for each field of the import file whether and for which object property the data should be imported. Fields with equal names are always imported as long as they are not explicitly ignored. Not yet selected properties are highlighted in the selection list. It is also possible to define a default value which is applied when the import field is empty.

 

By changing the data delimiter, stored assignments becomes invalid and reset.