Step 1 – Choosing Import Settings

In the first step you choose the general import and CSV settings, and how and where to insert the uploaded products.

The general settings:

In this section, you choose the primary category, products will be assigned to, if no category is specified in the CSV/XLS/XSLX file. You also specify the vendor, for which you are uploading the products.

The CSV settings:

In this section you can specify the type of CSV file you are using for the bulk import. You can choose between commata and semicolon separated values. If you are using a XLS or XLSX file for the upload, you can skip this section.

The import settings:

In this section, you specify the rules that will be applied, for the uploaded products. The following rules are available:

Data Rule Description
Overwrite Existing Data - Add New Existing products will be updated and new products will be added.
The following fields are mandatory for the CSV/XLS file, if you use this rule:
  • Product ID
  • Name
  • Price
Keep Existing Data - Add New Existing products will not be modified and only new products will be added through the import file.
The following fields are mandatory for the CSV/XLS file, if you use this rule:
  • Product ID
  • Name
  • Price
Clear Existing - Add New Existing products will be cleared and new products will be added through the import file.
The following fields are mandatory for the CSV/XLS file, if you use this rule:
  • Product ID
  • Name
  • Price
Update Existing Products Only (with Presets) Only already existing products will be updated through the import file, but form presets will still be used.
The presets for a default category, if no category is set in the CSV/XLS file, and the availability preset will be used.
The following fields are mandatory for the CSV/XLS file, if you use this rule:
  • Product ID
Update Existing Products Only (without Presets) Only already existing products will be updated through the import file, but form presets will be ignored.
The presets for a default category and the availability preset will NOT be used.
This setting allows you to update existing products without the need to add additional fields (that you don’t want to change) to the CSV/XLS file. The following fields are mandatory for the CSV/XLS file, if you use this rule:
  • Product ID

Additionally, you can set a product availability in this section, if you didn’t define the product availability in your import file.

After setting the desired options, select a file and press the “upload file” button to proceed to step 2 of the bulk import process.