Inventory CSV Files
This page describes the file format of the inventory CSV files. Inventory CSV files provide you a way to perform bulk updates of the inventory information you have saved to the Kaufland marketplace. For information on how to import these files into the Kaufland marketplace, as well as general information about how inventory data is handled, see the Managing Inventory page.
Overview
There are two types of inventory CSV files:
- Inventory Feeds: A file which describes the complete inventory data for every product you are offering for sale.
- Inventory Command Files: A file which only contains the differences between your current inventory and the data on the Kaufland marketplace.
Both file types are used to apply changes to the data on the Kaufland marketplace.
You can add both of these types of files by uploading the file to a publicly accessible web server and sending a
POST request to the /import-files/inventory-feed or the /import-files/inventory-command REST API endpoint.
Note: Units fulfilled by Kaufland are not affected by import files. Read more about FBK.
Offers on multiple storefronts
Every inventory CSV file's changes are performed with respect to a single storefront, which must be specified when adding the import file via REST API.
If you are selling on multiple storefronts, units will be connected via your id_offer.
As discussed on the Managing Inventory page, when units on different storefronts are connected by id_offer and the quantity or warehouse of one is updated, the others are also updated.
When there are multiple pending import files of different storefronts, they are not guaranteed to run in the order added.
Therefore, if there are multiple pending import files of different storefronts, and they specify different warehouses or quantities for connected units, either file's values may be stored for all connected units.
id_offer field must be UNIQUE across the seller's entire inventory.
Inventory Feeds
If you send an inventory feed to Kaufland marketplace, we will replace all of your current inventory data for that one storefront with exactly the data in the file. Anything that is not included in the file will be deleted from that storefront of Kaufland marketplace, and all new and changed products will be updated in that storefront. The below sections describe the Kaufland inventory feed file format.
File Header
You should always include a header line in your Inventory Feed files. The header contains the names of the fields that will be set for the products in the file. The order of the fields in the file is not important.
Descriptions of allowed fields:
| Field | Required | Max Length | Description | Example |
|---|---|---|---|---|
| ean | Required | 13 | The EAN or ISBN. | 5060004769643 |
| condition | Required | 17 | The condition of the product. A list of possible condition values is available under Conditions. | 100 |
| price | Required (if price_cs is not set) | 10 | The price of the unit in the relevant currency. Expressed as the integer number of cents in the relevant currency. This value must be greater than zero, and has a maximum that differs by currency (maximum 25 million CZK or 1 million EUR). | 4999 |
| currency | Required | 3 |
The currency the prices are provided in.
This is just a double check.
You are just allowed to upload offers in the currency connected to the market you want to sell on.
ISO 4217 is the standard used for accepted Currencies.
Full list of available currencies can be found in Endpoints documentation under Schemas -> Currency |
EUR |
| comment | Optional | 250 | A comment related to the product. The text is shown on the product page on the Kaufland marketplace for used products. | Leichte Gebrauchsspure |
| id_offer | Optional | 40 | An identifier from the seller which can be used for tracking. This is also used to connect offers over multiple storefronts | 439A-0218756 |
| id_warehouse | Optional | 50 | The warehouse ID the product is located in. | 1235 |
| count | Optional | 3 | Number of unit(s) for sale in your inventory. If count > 1, the product will be offered for sale multiple times. | 3 |
| minimum_price | Optional | 10 | The minimum price to be used for the Tiefstpreis-Automatik (automatic lowest price adjustment) feature, if that is enabled for your account. Expressed as the integer number of cents in the relevant currency. | 3999 |
| price_cs | Required (if price is not set) | 10 | The price of the unit in the relevant currency, supporting decimal prices (with a comma as the decimal separator). This value must be greater than zero, and has a maximum that differs by currency (maximum 25 million CZK or 1 million EUR). | 49,99 |
| minimum_price_cs | Optional | 10 | The minimum price to be used by the Tiefstpreis-Automatik (automatic lowest price adjustment) feature, if that is enabled for your account. Expressed in the relevant currency, and supporting decimal prices (with a comma as the decimal separator). | 39,99 |
| id_shipping_group | Optional | 255 | ID of the shipping group for this product. A shipping group specifies countries the product can be delivered to in which time and at which price and by which carrier. | 3425 |
| handling_time | Required | 6 | The amount of working days till the order will be handed over to the carrier. Has to be equal to or bigger than zero [>=0]. | 2 |
Example of a complete inventory export file: example file
Inventory Command Files
Inventory Command files are also a kind of CSV file, but without a header line at the top. Instead, the first field of each line contains a command and the subsequent fields vary based on the command. Because of the lack of a header, the subsequent fields must be in the expected order. The correct fields and order for each command is listed below. Kaufland marketplace accepts three different commands in inventory command files. Every command consists of both required and optional fields.
Here are the available commands:
| Command | Description |
|---|---|
| UPSERT | UPDATE or INSERT: For the current storefront, either updates an existing offer or inserts a new one. If the offer is connected to units on other storefronts, quantities and warehouses will be updated to match. |
| DELETE | Stop offering a product for sale on the current storefront. |
| FLUSH | Delete all offered products. Offers on other storefronts will be left intact. |
UPSERT
The UPSERT command lists a new product for sale or, if a similar offer already exists, updates the existing offer.
The determination of whether a similar offer already exists is the same as described for the POST /units/ endpoint.
The following fields are allowed:
| Field | Required | Max Length | Description | Example |
|---|---|---|---|---|
| ean | Required | 13 | The EAN or ISBN. | 5060004769643 |
| condition | Required | 17 | The condition of the product. A list of possible condition values is available under Conditions. | 100 |
| price | Required (if price_cs is not set) | 10 | The price of the unit in the relevant currency. Expressed as the integer number of cents in the relevant currency. This value must be greater than zero, and has a maximum that differs by currency (maximum 25 million CZK or 1 million EUR). | 4999 |
| currency | Required | 3 |
The currency the prices are provided in.
This is just a double check.
You are just allowed to upload offers in the currency connected to the market you want to sell on.
ISO 4217 is the standard used for accepted Currencies.
Full list of available currencies can be found in Endpoints documentation under Schemas -> Currency |
EUR |
| comment | Optional | 250 | A comment related to the product. The text is shown on the product page on the Kaufland marketplace for used products. | Leichte Gebrauchsspure |
| id_offer | Optional | 40 | An identifier from the seller which can be used for tracking. This is also used to connect offers over multiple storefronts | 439A-0218756 |
| id_warehouse | Optional | 50 | The warehouse ID the product is located in. | 1235 |
| count | Optional | 3 | Number of unit(s) for sale in your inventory. If count > 1, the product will be offered for sale multiple times. | 3 |
| minimum_price | Optional | 10 | The minimum price to be used for the Tiefstpreis-Automatik (automatic lowest price adjustment) feature, if that is enabled for your account. Expressed as the integer number of cents in the relevant currency. | 3999 |
| price_cs | Required (if price is not set) | 10 | The price of the unit in the relevant currency, supporting decimal prices (with a comma as the decimal separator). This value must be greater than zero, and has a maximum that differs by currency (maximum 25 million CZK or 1 million EUR). | 49,99 |
| minimum_price_cs | Optional | 10 | The minimum price to be used by the Tiefstpreis-Automatik (automatic lowest price adjustment) feature, if that is enabled for your account. Expressed in the relevant currency, and supporting decimal prices (with a comma as the decimal separator). | 39,99 |
| id_shipping_group | Optional | 255 | ID of the shipping group for this product. A shipping group specifies countries the product can be delivered to in which time and at which price and by which carrier. | 3425 |
| handling_time | Required | 6 | The amount of working days till the order will be handed over to the carrier. Has to be equal to or bigger than zero [>=0]. | 2 |
DELETE
Issuing the DELETE command deletes your listing of a product from this storefront of the Kaufland marketplace. You must give the EAN of the product. If you specified one, you can also specify an id_offer, so that only the specified unit is deleted, not all units for the product.
| Field | Required | Description | Example |
|---|---|---|---|
| ean | Required | The EAN or ISBN of the product. | 5060004769643 |
| id_offer | Optional | The seller-defined unique ID of a unit that belongs to the product. | 4390218756 |
FLUSH
The FLUSH command does not take any parameters. When Kaufland marketplace encounters a FLUSH command, it deletes all units from the storefront for the seller who sent the file. This command is useful for deleting all products and re-listing them, when incremental updates are not possible.
Examples
Here are some examples of lines from command files.
UPSERT;5060004769643;100;4999;EUR;;4390218756;1235;67;;;;3425;2
With this command you are listing 67 units of the game "Sonic Rivals" for €49.99. The condition is set to new (100). The id_offer is 4390218756 and you state a handling in two days.
DELETE;5060004769643;4390218756
If you want to be sure you're editing exactly one unit, you should include an id_offer. This command deletes the listing you added above and specifies the id_offer 4390218756. Alternatively, you could have also run this command:
DELETE;5060004769643
This would delete all of your units with this EAN.
FLUSH; UPSERT;5060004769643;100;4999;EUR;;4390218756;1235;67;;;;3425;2
This command deletes ALL of your units and then adds the same game again.
Conditions
Here are the allowed values for product condition. You can only submit integer value.
| String | Integer |
|---|---|
| NEW | 100 |
| USED - AS NEW | 200 |
| USED - VERY GOOD | 300 |
| USED - GOOD | 400 |
| USED - ACCEPTABLE | 500 |