Kaufland Inventory Feed EN.xlsx

	A	B	C	D	E	J	K
1
2	Kaufland Inventory Feed Template
3	from february 2023
4
5
6
7	Introduction
8		Please see the three sheets: definition, examples, template.				Please note that your prices must take currency fluctuations into account.
9		You can use the sheet "template" to fill in your data.				Kaufland does not perform dynamic currency conversions for you.
10
11
12	Data
13		The following fiels need to be inserted:
14		ean	product's EAN or ISBN number
15		condition	the number indicating the product's condition
16			100	new	Neu
17			200	used - like new	Gebraucht - wie neu
18			300	used - very good	Gebraucht - sehr gut
19			400	used - good	Gebraucht - gut
20			500	used - acceptable	Gebraucht - akzeptabel
21		price	The product's price in euro cent (e.g. 499 for 4,99€). The highest price allowed is 1 mio. €.
22			If you have your prices as Euro incl. comma (e.g. € 4.99), simply insert them in the price_cs column. The price column should be left empty in this case.
23		currency	The currency in which the price is given. You can only upload offers in the currency associated with the country you want to sell in. [Euro=EUR] or [Czech Korunas =CZK]
24		handling_time	The offer handling time indicates the time (in business days, Monday to Friday) between receiving the order and handing over the package to the shipping service provider.
25			Together with the transport time, which is specified in the shipping settings in the Seller Portal, this results in the delivery time, which is displayed to the customer on the offer page.
26			The following should be noted here:
27			- Please specify only the number of working days (Monday to Friday), e.g. "2" = 2 working days.
28			- The values must be greater than or equal to 0. (0 means same day handed over to carrier)
29			- Please check your transport time and cut-off time in the Seller Portal as well as the correct linking of offer and shipping group.
30
31		You may fill in the following fields:
32		comment	Comment on the condition of used products (visible to the customer); 200 characters max.
33		id_offer	Your article ID to identify offers (only visible to you). This ID must be unique
34		id_warehouse	Specification of the warehouse settings configured by you in the Kaufland account for the respective offer.				Go to Warehouse Settings
35		count	Number of available items (if you want to offer the item more than once).
36		minimum_price	Price for the option "Low price automatic" in Eurocent (minimum price you want to offer, e.g. 499 for € 4,99)
37			If you have your prices as Euroincluding comma (e.g. € 4,99), just add them in the minimum_price_cs column. The minimum_price column should be left empty in this case.
38		price_cs	(_cs= comma-separated) The price of the item in comma or dot separated amounts (e.g. 12.99 or 12.99 for 12.99€).
39			If the price column AND the price_cs column contain values, we use only the price column
40		minimum_price_cs	(_cs= comma-separated) price for the "lowest price automatic" option in comma or dot separated amounts (e.g. 4.99 or 4.99 for 4.99€)
41			If the column minimum_price AND the column minimum_price_cs contain values, we use only the column minimum_price
42		id_shipping_group	Specification of the shipping group configured by you in the Kaufland account for the respective offer				Go to Shipping Settings
43
44
45
46
47	Save
48		The file now has to be converted and saved.
49		Please proceed as follows:
50		1	Switch to template tab
51		2	Click File > Save As
52		3	Select "CSV UTF-8 (separated by separator)" as the file type
53		4	Confirm the subsequent questions with Yes or OK
54		Ready! You can now upload the file to Kaufland Marketplaces
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100