Variant Suggestions CSV Files

This page describes the file format of the variant suggestions CSV files. For information on how to import these files into the Kaufland marketplace, see the Managing Variant Suggestions page.

Overview

One way to get variant suggestions into the Kaufland marketplace is with variant suggestions CSV files (see the Managing Variant Suggestions page. To maximize sales, you should group your products with variants. This enables users to better find your products by searching, browsing and filtering on the Kaufland marketplace site.

File Format

The variant suggestions files must be CSV files with semicolon separators and UTF-8 character encoding. The first line of the CSV file should be a header line with: 

ean;parent_ean;variant_attributes;action
Column Description
ean Mandatory: EAN (European Article Number) of the product.
parent_ean Mandatory: Identifier of the variant. This needs to be a valid EAN of the parent product.
variant_attributes Optional: All attributes relevant for the variant, separated by a comma.
action Optional: Defines the action for the variant.
  • - If empty or not provided, the default value is encourage, which adds the variant to a product.
  • - Use discourage to remove the variant from an existing product.

Here is an example of a partial variant suggestions data file, displayed as table, as it would be in spreadsheet software:

ean parent_ean variant_attributes action
8945085546346 4124102788893 colour
4124102788893 4124102788893 colour
6484759040462 4124102788893 colour
2493874020064 4124102788893 colour encourage
1252445707071 4124102788893 colour discourage
6633663891438 8514476545826 height,colour encourage
8514476545826 8514476545826 height,colour encourage
8911039691234 6867350126126 weight,length encourage
9066532731364 6867350126126 discourage
6867350126126 6867350126126 discourage
5202543304099 6867350126126
7862397008909 6867350126126

Here is the same data in the CSV format that the Kaufland marketplace expects: 

ean;parent_ean;variant_attributes;action
8945085546346;4124102788893;colour;
4124102788893;4124102788893;colour;
6484759040462;4124102788893;colour;
2493874020064;4124102788893;colour;encourage
1252445707071;4124102788893;colour;discourage
6633663891438;8514476545826;"height,colour";encourage
8514476545826;8514476545826;"height,colour";encourage
8911039691234;6867350126126;"weight,length";encourage
9066532731364;6867350126126;;discourage
6867350126126;6867350126126;;discourage
5202543304099;6867350126126;;
7862397008909;6867350126126;;
;;;

Things to note:

  • - This is just a partial example and does not contain most of the variant attributes you should include.
  • - The first row is the header and it has to contain exactly the same names: ean, parent_ean, variant_attributes, action
  • - The variant attribute is not needed and also you can add as many as you need separated with comma. All the attributes values can be found in: /attributes and use the field name from the attribute data.
  • - The action column determines how a variant is handled:
    • If empty, it defaults to encourage, meaning that the item will be added to the variant group.
    • If set to encourage, the item will be explicitly added to the variant group.
    • If set to discourage, the item will be removed from the variant group.

Note: Keep in mind that your submission is a suggestion and will be evaluated with suggestions from both other sellers and our AI model. The final Variant Group displayed might therefore differ from your suggestion.

Example File

You can download an example file with 3 variant suggestions where we have the following information:

  • - One variant suggestion that want to group these eans: [8945085546346, 4124102788893, 6484759040462, 2493874020064] and at the same time he does not want this ean: [1252445707071] in this variant group (action: discourage, in case that another suggestion is adding it).
  • - Another variant suggestion that groups these two eans: [6633663891438, 8514476545826] and does not discourage anyone.
  • - And another variant suggestion that is grouping three eans: [8911039691234, 5202543304099, 7862397008909] and does not want in that variant group these two eans: [9066532731364, 6867350126126] in this variant group.

Here is the example: Example Variant Suggestion CSV file