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.

Note: Please note that the 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:

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 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 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

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 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 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

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