Inventory Files
This page describes the inventory files. Inventory 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 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 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 File Format
When interacting with the Kaufland marketplace through our seller-API, you have the flexibility to choose between two file formats:
- CSV: please refer to the section CSV Format
- XML: please refer to the section XML Format
Both are fully supported for managing Inventory Feeds and Inventory Command Files, so you can choose what works best for you!
Whether you opt for the simplicity of CSV or the structured nature of XML, our platform ensures seamless processing of your inventory data, enabling efficient synchronization and management of product listings on Kaufland's platform.
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 structure.
Descriptions of allowed fields:
| Field | Required | Max Length | Description | Example |
|---|---|---|---|---|
| ean | Required | 14 | 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 | 100 | 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 Smart Pricing, please provide minimum price if you want to use Smart Pricing. 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 Smart Pricing, please provide minimum price if you want to use Smart Pricing. 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 |
| vat_indicator | Required |
VAT indicator determining the VAT rate of the unit. The indicator should match the available
VAT indicator of the storefront. You can find the most recent VAT indicator mapping at the
/vat-indicators/ REST API endpoint.
|
standard_rate | |
| eco_participation | Optional | 10 |
Warning! Providing this field will not have any effect for now.
The Eco-Participation value in eurocents (integer). Only relevant for specific products on the French storefront. |
99 |
Inventory Command Files
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 | 14 | 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 | 100 | 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 Smart Pricing, please provide minimum price if you want to use Smart Pricing. 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 Smart Pricing, please provide minimum price if you want to use Smart Pricing. 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 |
| vat_indicator | Required |
VAT indicator determining the VAT rate of the unit. The indicator should match the available
VAT indicator of the storefront. You can find the most recent VAT indicator mapping at the
/vat-indicators/ REST API endpoint.
|
unspecified | |
| eco_participation | Optional | 10 |
Warning! Providing this field will not have any effect for now.
The Eco-Participation value in eurocents (integer). Only relevant for specific products on the French storefront. |
99 |
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.
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 |
| "REFURBISHED___AS_NEW" | 110 |
| "REFURBISHED___VERY_GOOD" | 120 |
| "REFURBISHED___GOOD" | 130 |
| "REFURBISHED___ACCEPTABLE" | 140 |