With a CSV file you add many products at once, or update products you already have. You prepare the file in a spreadsheet, match its columns to the product fields, and the platform handles every row.

Before you start

  • You have the product editor role.
  • Your file is a .csv file, saved as UTF-8. The first line holds the column names. The maximum size is 5 MB.
  • Commas, semicolons and tabs all work as separators. The platform detects the separator itself. In Excel, save as CSV UTF-8 (Comma delimited).
  • Values that contain the separator or a line break must be in double quotes. Spreadsheet programs do this for you.
  • Tip: start from an export, so your columns already match. See Exporting products to a CSV file.

Steps

  1. In the sidebar, open Offering & Logistics and then Products. On the My Products page, click Import CSV. Drag your file into the upload area, or click to choose it. You see a preview of the first 5 rows.
  2. Match the columns. For every CSV column, pick the product field it belongs to, or — Do not import —. You can choose each field only once. The platform suggests a field for each column, with a percentage that shows how sure it is. Check every suggestion. At least one column must be mapped.
  3. Saved mapping: if the column names match a mapping you saved earlier, it is applied automatically (Saved mapping '…' applied.). If they match only partly, the mapping is applied and you check the new columns. Want to reuse your choices next time? Tick Save this mapping for future imports and enter a name. The same name overwrites the old mapping. Remove a mapping with Delete mapping.
  4. Choose the File language: the language of the texts (NL, EN, DE, FR or ES). Does your file contain several languages? Choose Multiple languages, and then pick the Language column (locale) that holds a language code per row (nl, en, …).
  5. Click Import. Every row is handled on its own: a wrong row does not stop the others. When it is done, the product list refreshes.
  6. Imported products appear in the list as drafts (Draft, Not published). Complete each one with Complete in the product generator, or publish several at once (see Good to know).

Fields and formats

These are the product fields you can pick in the mapping. The field names are shown in Dutch on every screen.

  • SKU: the platform's product code. Empty means a new product, and the platform creates the SKU. Filled in means you update that existing product of yours. An unknown SKU is refused.
  • Externe referentie (external reference): your own code. It only finds a product that already has this reference (set in the product generator). A new reference in the file is refused. If you give both a SKU and a reference, they must belong to the same product.
  • Productnaam (product name), Korte omschrijving (short description), Lange omschrijving (long description): texts in the file language.
  • Tags: written as a list in brackets and quotes, for example ["tent","camping"]. Any other form makes the row fail.
  • Merk (brand): text. Jaar van aankoop (year of purchase): a whole year, for example 2023.
  • Conditie (condition): exactly NEW, GOOD, FAIR or POOR, in capitals. Anything else makes the row fail.
  • Online beschikbaar (available online): true, 1, yes or ja means yes. Anything else, or empty, means no.
  • Categorie ID (category ID): the internal category code. The easiest way is to copy it from an export of a product you made in the product generator.
  • Attribuutset sleutel (attribute set key) and Parent UUID (for variants: the ID of the parent product): advanced fields. Copy them from an export.
  • Afbeeldingen (images): file names or web addresses, separated by |. Hoofdafbeelding URL (main image URL): the address of the main image, stored as text.

Images

The import only stores the image names. Then click Upload images and select the files. They are matched by the names in your import, or by a file name equal to the SKU or the external reference, optionally with a sequence number (SKU-000123_2.jpg). The maximum is 25 MB per image. Web addresses from your import can be fetched with Fetch. Only public internet addresses work.

Updating existing products

A row with a SKU updates that product. By default, an update changes only what the row fills in. Safest tip: export, edit and import the same file.

  • A column you did not map, or an empty cell, keeps the current value of the product. The texts in other languages stay as they are. A file with only the SKU column plus the columns you want to change is enough.
  • Tick Clear missing fields in the import dialog and a column you did not map, or an empty cell, is cleared. With one file language, the texts of the product in other languages are removed too. The dialog shows a warning. Use it only when the file holds the full product, for example a file you exported.
  • With Multiple languages, rows only add or update the texts of their own language, for products that already exist (use the SKU). For new products, use one language. In multi-language mode, each language row of a new product becomes a separate product.
  • Your live (published) product does not change until you publish. The list shows Unpublished changes. An import that changes nothing does not mark a product as changed.
  • Undo before publishing: on a product in the list, click Revert changes to set its unpublished changes back to the live version. For several at once, select them, click Batch process and then Revert to live. This only works for products that are already published. You cannot undo it.

Good to know

  • Not part of the import, so set them in the product generator: prices and deposit (step Pricing), stock and availability, delivery, attribute values, documents and video. Importing prices is not available yet.
  • Attribute values for many products at once: select the products, click Batch process, choose Add or update an attribute, pick the attribute and the value, and click Apply to … products.
  • Publishing many products: select them, click Batch process, choose Publish changes and then Publish now, or schedule it. A new product is only published when it is complete: name and category, at least one photo, a language text, availability, a delivery method and a price. Incomplete products are listed with what is missing.
  • If more than 30 minutes pass between uploading the file and clicking Import, upload the file again.

Related