Import
Before importing, you first need to create a correctly formatted CSV file. It is especially important to use the correct field names in the header. Figure 19 shows an example.
Figure 19: Field names in the header of the import file for productsThe field names in the header have two parts, the name and the ID. The name corresponds to the name of the fields in the product detail view. You can modify this name if necessary. The internal names (IDs) are enclosed in square brackets and must never be changed. You can also interchange columns, as long as each column keeps its own heading.The following rules are applied to the values in the import file:
- Column does not exist in the file: The values in the database will not be changed.
- Column does exist in the file, but no data entered: The corresponding data is deleted in the database.
- Column does exist in the file, and contains data: The corresponding data is replaced in the database by the data from the file.
The various fields have the following meaning for the import:Table 13: parameters for importing product data
When all the parameters have been set correctly, start the import by clicking Import. If problems occur during import, you will receive a relevant message. In the case of large files, the total number of errors is limited to 100 error messages.