The import function allows you to quickly add or update product and offer information. All content and offer fields can be filled via an import.

Click the plus sign at the bottom right of the import page to upload a file. The file types .XLSX (Excel), .CSV, .XML, .TXT, .JSON, or a URL (Feed) are supported in the import function.

Upload the file by dragging it there or click 'Choose File' to select the desired file.

For importing an Amazon or Bol content export, we have developed a conversion mode. This makes mapping the fields in the following steps easier. When importing one of these files, choose the Amazon or Bol conversion mode.

Note! This conversion mode only works with a content export that comes directly from Amazon or Bol and has not been edited afterward.

By clicking upload, the file is added. You can then start setting up and mapping the import file.

In step 1, you set the import and file settings.

This is the name of the import run. Enter a recognizable name here. By default, we use the file name.

There are three import options available;

1. Create and Update

Products not yet known in ProductFlow are newly created. Existing products already known in ProductFlow are updated.

This is based on the selector selected (step 2).

2. Create Only

Only products not yet known in ProductFlow are newly created.
Nothing is done with products already known in ProductFlow.

This is based on the selector selected (step 2).

3. Update Only

Only products already known in ProductFlow are updated.
New products not yet known in ProductFlow are not imported or created.

It is possible to select a base product. All new products are created with the information from the selected base product.
Read here more about using base products.

It may happen that multiple columns in the import file have the same column name. By setting Unique Columns to 'yes', the mappings are automatically applied to all columns with the same column name.

This means you only need to map the column once, and it will be automatically applied to all columns with that name.

Select the sales channels for which you need mapping suggestions. By minimizing the number of sales channels you select, the performance and accuracy of the suggestions are optimized.
Example:

If you select Bol NL here, you will receive mapping suggestions for Bol NL fields when mapping the columns.

When enabling this setting, fields for the basic content are excluded from the mapping process. This means that only sales channel-specific fields can be mapped.

Select the language for which you want to import the fields.

Select the currency for which you want to import the fields.

Select the separator used in the import file. This refers to the separator used in one column, where multiple contents are present, which should be imported separately.

Example:
Image1>Image2>Image3

Separator = >

Tip! You don't necessarily have to choose a separator from the dropdown. It's also possible to enter one yourself. Do this by typing the desired separator and then clicking it in the dropdown.

With this setting, all duplicate SKUs from the import file are ignored. Use this setting only when importing content for family products; in other situations, this is not desirable!
Read here how to import content for families.

Indicate what the header in the file is. Do this by selecting the dot next to the header.

Additionally, you have the option to ignore tabs. This is only possible if the import file consists of multiple tabs.
Select the tab and choose 'Ignore tab' if you want to ignore the selected tab. This tab will not be included during the import. All information on the ignored tab cannot be mapped.

All information is updated or created based on the selector. The selector ensures that the product or offer information ends up with the correct product. An SKU or EAN is often selected here.

Note! If you want to create new products, an SKU is required.

In the dropdown under 'Column', select the column from the import file. You then map this to a ProductFlow selector field.
When selecting the SKU mapping, you have the option to select a conversion. This is only used if you want to use the EAN as an SKU. When you choose 'Convert to EAN13', the EAN is converted to a valid 13-digit EAN. The outcome depends on the type of EAN; in some cases, leading zeros are added, and in others, a number combination.

In this step, you map all columns to a ProductFlow field. The content of the column is placed in the mapped field after importing.

Below you will find all columns from the import file. The header is shown as selected in step 1. It is possible to search for a column by entering the column name in the search bar.

Here, the first three values from the column are shown.
If there are no values in a column, that column will be excluded from the mapping process.

Select the desired mapping from the dropdown. Depending on the settings configured in step 1, both basic and sales channel-specific fields will be displayed here. In some cases, a mapping suggestion is already filled in.

Note! The mapping (suggestion) must always be saved. You do this by clicking the save icon.

It is possible to select multiple mappings for one column. You do this by clicking the plus sign next to the mapping dropdown, after which an additional dropdown will appear. You can then select a new mapping in this dropdown.

This way, it is possible to map the information from one column to multiple different ProductFlow fields.

Only applicable to information that requires a unit, such as dimensions, weights, and prices. The representation is set to automatic detection by default. For prices, we use the default currency from step 1. For dimensions and weights, automatic detection only works if a unit is in the same column as the value, for example, 5 g or 5 grams. When the value and the unit are in two separate columns, automatic detection does not work, and you must enter a manual representation.

The default language from step 1 is automatically applied to all mappings where a language is applicable. It is possible to change the language per mapping by selecting a different language in the dropdown.

The default delimiter from step 1 is automatically applied to all mappings where a delimiter may be applicable. It is possible to change the delimiter per mapping by selecting/filling in a different delimiter in the dropdown.

Mappings can be 'removed' by clicking the cross. Each mapping must still be saved. Once a mapping is saved, it disappears under the 'Mapping' tab and appears under the 'Mapped' tab.

All saved mappings are under the 'Mapped' tab. Here you can see at a glance which fields are mapped and will be filled from the import. You also have the option to undo a mapping. You do this by clicking the arrow next to the mapping. The mapping will be 'removed,' and the field will return to the 'Mapping' tab, where you can attach a different mapping to it. Additionally, from the 'Mapped' page, you also have the option to add an extra mapping to a field that is already mapped. You do this by clicking the plus sign next to the mapped field. An extra dropdown will appear where you can add a new mapping.

After the desired fields are mapped, the import file is analyzed. Depending on the file size and the number of mapped fields, this may take a while.

After analyzing, a (possible) error report is generated.

All products with an Error message will be completely skipped during import. These products will not be created/updated.

Only the fields/mappings where the Warning message applies will be skipped during import. The other fields, where there is no message, will be imported as usual.

Here, general Messages about a product and/or field/mapping are displayed. The products and fields/mappings will be imported as usual.

By clicking the Error messages with content button, you download the error report in the form of a .CSV file. This provides an overview of all products from the import file, including the associated content and error message. Based on this file, you have the opportunity to resolve the error messages and re-import the file.

Important, the file has not yet been actually imported at this step. This only happens after you click the import button in the bottom right corner.

Depending on the file size and the number of mapped fields, importing may take a while.

Tip! We recommend always importing images separately. These are often heavier mappings, and if you combine this mapping with multiple other mappings in one import run, it may take longer.

After importing, the import runs are displayed in step 5.

Here, the date and time of import are displayed. This is the moment when the import button was clicked in step 4.

Here, the name of the user who performed the import run is displayed.

Here, the number of products that have been updated/created is displayed.

Here, the number of content changes per import run can be seen. When you click here, you will see all changes per product. From this page, it is also possible to undo the changes.

Note! This is currently only possible with content changes; offer changes from the import cannot be undone.

Here, a tally of all products that were not imported is displayed. These are often the same products that received an error message in step 4 (review). These products were not imported. Click on the number of messages to see which products are involved.

Here, a tally of all fields/mappings that were not imported is displayed. These are often the same products that received a warning message in step 4 (review). These fields/mappings were not imported. Click on the number of messages to see which fields are involved.

Here, a tally of all products with a message is displayed. These are often the same products that received a message in step 4 (review). Click on the number of messages to see which products are involved.

Here you can see whether the import run was successful or not.
Checkmark = Successful import run

Exclamation mark = There are products skipped during import (errors)

From the product overview, it is possible to filter by an import run. As a result, all products from the import run will be displayed.

Check out this article for tips on importing specific information or files.