CSV Feed Import

The transfer of offer data to idealo is done by using an export file (CSV, TXT, XML). These files are usually created through an export function in your shop system and can be retrieved using the respective link. Alternatively the export file can be hostet on a FTP- or Webserver (HTTP/HTTPS) for retrieval). The provided data is usually fetched and imported every 30 minutes by idealo.

Example Feed

sku	brand	title	categoryPath	url	eans	description	price	paymentCosts_paypal	deliveryCosts_dhl	deliveryTime	imageUrl	…
123456	Samsung	Samsung Galaxy S20	Smartphone & Tablets	www.myshop.de/s10	1234567890123	Dual SIM, water resistant, triple camera, newest wifi	499.99	0.00	0.00	Delivered in 1-3 working days	https://myshop.de/philips-hue-weiss-und-farbig-10.jpg	…
234412	Samsung	Samsung Galaxy S20	Smartphone & Tablets	www.myshop.de/s20	1234567890127	With the Samsung Galaxy S20 you get a mobile with high performance and one of the best cameras on the market.	585.00	0.00	0.00	Delivery in 5 working days	https://myshop.de/philips-hue-weiss-und-farbig-10.jpg; https://myshop.de/philips-hue-weiss-und-farbig-12.jpg	…
345311	Samsung	Samsung Galaxy Watch 3	Smart Watches	www.myshop.de/watch3	1234567890645	If you like to combine innovation technology with an elegant design you should take a Samsung Galaxy Watch 3!	379.00	0.00	3.99	Delivery on the next working day		…
…	…	…	…	…	…	…	…	…	…	…	…	…

sku

brand

title

categoryPath

url

eans

description

price

paymentCosts_paypal

deliveryCosts_dhl

deliveryTime

imageUrl

…

123456

Samsung

Samsung Galaxy S20

Smartphone & Tablets

www.myshop.de/s10

1234567890123

Dual SIM, water resistant, triple camera, newest wifi

499.99

0.00

Delivered in 1-3 working days

https://myshop.de/philips-hue-weiss-und-farbig-10.jpg

…

234412

Samsung

Samsung Galaxy S20

Smartphone & Tablets

www.myshop.de/s20

1234567890127

With the Samsung Galaxy S20 you get a mobile with high performance and one of the best cameras on the market.

585.00

0.00

Delivery in 5 working days

https://myshop.de/philips-hue-weiss-und-farbig-10.jpg; https://myshop.de/philips-hue-weiss-und-farbig-12.jpg

…

345311

Samsung

Samsung Galaxy Watch 3

Smart Watches

www.myshop.de/watch3

1234567890645

If you like to combine innovation technology with an elegant design you should take a Samsung Galaxy Watch 3!

379.00

0.00

3.99

Delivery on the next working day

…

Requirements for showing offers on idealo

Overal rules:

The following listed offer states have to always be marked clearly in the offer.
The state can be marked in the title of the offer or in an extra column of the feed.
Each offer that is declared as "new" must have the full scope of delivery i.e. original goods including all original accessories
Violation of the listed requirements can lead to prompt exclusion of listing the offers in the price comparison

Term	Definition	Requirements idealo
Differential taxation	The differential taxation of movable goods is only relevant for commercial merchants who are resellers (see § 25a UStG). It is used to prevent that the sales tax is added in whole again on an article that changed owners multiple times. In this case the VAT does not have to be included. The invoice will only have the complete prices stating "including VAT". Articles with the hint "differentially taxated" are not necessarily Artikel used goods.	Distinct identification, if an offer has a differential taxation or not The notation “differential taxation if applicable” is not allowed Needs an additional identification of the article is "new" or "used"
EU-Goods	EU-Goods are goods that are not produced for the German market but for another european market and were imported from there to Germany.	EU-Goods means goods for the european economic area EU-Goods has to be identified distinctly in the title of the offer or feed EU-Goods has different EANs than DE-Goods
Grey-Goods	Grey-Goods are goods that were produced/distributed in a third party country outside of the european economy market but can end up with german consumers through some sales channels.	The offer will be blocked by idealo if the shipping takes place outside of the european economy market. The goods can be listed at idealo if the shipping occurs with Germany. If the offer is in reality EU-Goods (shipping occurs within the european economy market) it should be indentified as EU-Goods instead of Grey-Goods.
Neutral packaging	A neutral packaging does not give any hints as to the type of good. New goods are still new even if the original packaging is missing.	Needs an additional identification of the article is "new" or "used". Despite the neutral packaging original ware including original accessories is compulsive.
Outer packaging	In general this is an additional packaging needed for shipping. The reasons can be: Protection of the goods Being able to ship the goods (esp. with small articles) Outer packaging because of quantities.	An outer packaging has no influence on the condition of goods. If the goods are new than original goods including all original accessories are compulsory. Mandatory identification with articles that usually do not have an outer packaging (e.g. mobile phones, etc.).
Bulk	Bulk-goods are articles that are purchased by the merchant in great numbers and are re-sold to the customers in smaller quantities. Since the goods are delivered in big boxes they are re-sold without any original packaging, software or manuals. This applies for customers: Goods are new and mostly have a manufacturer/merchant guarantee (or at least warranty). Bulk-goods are through the identification not per se a reason for a reclamation but the customer can revoke the order as with any other purchase.	Packing of smaller quantities from mass orders Goods are new i.e., original goods including all original accessories is mandatory see “Outer packaging”
Used B-Ware Refurbished	Refurbished devices are used articles which have been fully restored, cleaned and checked by the manufacturer/merchant. B-Ware are second grade goods that are new or in mint condition and fully functional but not sold in the normal catalog. B-Ware can be articles where the original packaging is damaged or not available anymore (e.g. exhibits) or returned articles from customers (e.g. when invoking their right to revoke the order). It can be goods that were returned unblemished or with articles with minor (e.g. optical) deficits which still work flawlessly or it can be special items or remainders, i.e. goods that were not sold.	even articles that are marked as "in mint condition" are counted as "used goods" at idealo IMPORTANT: B-Ware that cannot legally be distinguished as used goods (because it was never used) has a guarantee of two years. A shortening to one year is only applicable for real used goods.
Demo-Goods	Demo-Goods has certain functional limitations, can only be used for a restricted amount of time or was used as an exhibit. Demo-Ware is a shareware for demonstrative purposes or for testing with a limited functionality.	Demo-Ware is treated as used goods at idealo
Minimum order	A minimum order is the smallest number of items that a shop is prepared to sell. It is necessary to mark offers that cannot be purchased individually accordingly.	Necessary adjustments price Please make sure that the offer price reflects the total price for the minimum purchase quantity. Separate column Send us a additional column ‘quantity’ within your data feed in which the quantity of the offer, e.g.: "2", is noted. offertitle Expand the offertitle accordingly by specifying the quantity, e.g: “2 pieces” directly in the title
Minimum order surcharge	A minimum order surcharge is a price surcharge that is charged if an order is below a certain minimum order value. For offers below the minimum order value, it is therefore mandatory to indicate this for the listing on idealo.	For affected offers, the following columns must be transmitted with the corresponding values: 1. Minimum order surcharge (required): Amount in EUR - idealo adds this to the shipping costs. 2. Delivery comment (optional / recommended): Reference to the minimum order surcharge (e.g. “A minimum order surcharge of X EUR is already included in the shipping costs. This is not applicable from XX EUR!").
Minimum order value	The minimum order value refers to the lowest amount that a customer must reach when making a purchase in an online shop in order to be able to place an order.	For affected offers below the minimum order value limit, it is necessary to provide a shipping comment in a separate column (e.g. "Minimum order value: XX EUR"). Offers below the minimum order value can only be displayed with this comment.

Term

Definition

Requirements idealo

Differential taxation

The differential taxation of movable goods is only relevant for commercial merchants who are resellers (see § 25a UStG). It is used to prevent that the sales tax is added in whole again on an article that changed owners multiple times. In this case the VAT does not have to be included. The invoice will only have the complete prices stating "including VAT". Articles with the hint "differentially taxated" are not necessarily Artikel used goods.

Distinct identification, if an offer has a differential taxation or not
The notation “differential taxation if applicable” is not allowed
Needs an additional identification of the article is "new" or "used"

EU-Goods

EU-Goods are goods that are not produced for the German market but for another european market and were imported from there to Germany.

EU-Goods means goods for the european economic area
EU-Goods has to be identified distinctly in the title of the offer or feed
EU-Goods has different EANs than DE-Goods

Grey-Goods

Grey-Goods are goods that were produced/distributed in a third party country outside of the european economy market but can end up with german consumers through some sales channels.

The offer will be blocked by idealo if the shipping takes place outside of the european economy market.
The goods can be listed at idealo if the shipping occurs with Germany.
If the offer is in reality EU-Goods (shipping occurs within the european economy market) it should be indentified as EU-Goods instead of Grey-Goods.

Neutral packaging

A neutral packaging does not give any hints as to the type of good. New goods are still new even if the original packaging is missing.

Needs an additional identification of the article is "new" or "used".
Despite the neutral packaging original ware including original accessories is compulsive.

Outer packaging

In general this is an additional packaging needed for shipping. The reasons can be:

Protection of the goods
Being able to ship the goods (esp. with small articles)
Outer packaging because of quantities.

An outer packaging has no influence on the condition of goods.
If the goods are new than original goods including all original accessories are compulsory.
Mandatory identification with articles that usually do not have an outer packaging (e.g. mobile phones, etc.).

Bulk

Bulk-goods are articles that are purchased by the merchant in great numbers and are re-sold to the customers in smaller quantities. Since the goods are delivered in big boxes they are re-sold without any original packaging, software or manuals.

This applies for customers: Goods are new and mostly have a manufacturer/merchant guarantee (or at least warranty). Bulk-goods are through the identification not per se a reason for a reclamation but the customer can revoke the order as with any other purchase.

Packing of smaller quantities from mass orders
Goods are new i.e., original goods including all original accessories is mandatory
see “Outer packaging”

Used

B-Ware
Refurbished

Refurbished devices are used articles which have been fully restored, cleaned and checked by the manufacturer/merchant.

B-Ware are second grade goods that are new or in mint condition and fully functional but not sold in the normal catalog. B-Ware can be articles where the original packaging is damaged or not available anymore (e.g. exhibits) or returned articles from customers (e.g. when invoking their right to revoke the order). It can be goods that were returned unblemished or with articles with minor (e.g. optical) deficits which still work flawlessly or it can be special items or remainders, i.e. goods that were not sold.

even articles that are marked as "in mint condition" are counted as "used goods" at idealo
IMPORTANT: B-Ware that cannot legally be distinguished as used goods (because it was never used) has a guarantee of two years. A shortening to one year is only applicable for real used goods.

Demo-Goods

Demo-Goods has certain functional limitations, can only be used for a restricted amount of time or was used as an exhibit.

Demo-Ware is a shareware for demonstrative purposes or for testing with a limited functionality.

Demo-Ware is treated as used goods at idealo

Minimum order

A minimum order is the smallest number of items that a shop is prepared to sell. It is necessary to mark offers that cannot be purchased individually accordingly.

Necessary adjustments

price
Please make sure that the offer price reflects the total price for the minimum purchase quantity.

Separate column
Send us a additional column ‘quantity’ within your data feed in which the quantity of the offer, e.g.: "2", is noted.

offertitle
Expand the offertitle accordingly by specifying the quantity, e.g: “2 pieces” directly in the title

Minimum order surcharge

A minimum order surcharge is a price surcharge that is charged if an order is below a certain minimum order value. For offers below the minimum order value, it is therefore mandatory to indicate this for the listing on idealo.

For affected offers, the following columns must be transmitted with the corresponding values:

1. Minimum order surcharge (required):
Amount in EUR - idealo adds this to the shipping costs.

2. Delivery comment (optional / recommended):
Reference to the minimum order surcharge (e.g. “A minimum order surcharge of X EUR is already included in the shipping costs. This is not applicable from XX EUR!").

Minimum order value

The minimum order value refers to the lowest amount that a customer must reach when making a purchase in an online shop in order to be able to place an order.

For affected offers below the minimum order value limit, it is necessary to provide a shipping comment in a separate column (e.g. "Minimum order value: XX EUR"). Offers below the minimum order value can only be displayed with this comment.

General formating rules

The order of the shown columns is arbitrary.
Each line corresponds to one offer.
You can pass along the export file in a compressed ZIP or gZIP format.
The link where the file is hosted can be password protected.
Encoding: UTF-8
Column separator: ,
Decimal separator: .
Separators within a column, e.g. for lists of EAN-codes: ;
For further CSV format specifications see RFC-4180

Energy Label Attributes

Attribute name	Description	Example	Requirements
EEC_efficiencyClass	Efficiency Class Classification of energy consumption according to EU regulations. Required for offers with labeling obligation.	A	Allowed values if EEC_version=1: A, B, C, D, E, F, G Allowed values if EEC_version=0: A+++, A++, A+, A, B, C, D, E, F, G
EEC_spectrum	Spectrum The classification spectrum of the given product category. Required for offers with labeling obligation.	A-G	Allowed values if EEC_version=1: A, B, C, D, E, F, G Allowed values if EEC_version=0: A+++, A++, A+, A, B, C, D, E, F, G For a range: separated with - (minus)
eec_labelUrl	Label URL The image URL of the EEC label. Please ensure that the image resolution is high enough, so the QR code can be scanned. Required for offers with labeling obligation.	http://www.link.to/label.jpg	URLs have to comply to RFC-3986.
eec_dataSheetUrl	Data Sheet URL The URL of the EEC datasheet (PDF). Required for offers with labeling obligation.	http://www.example.com/datasheet.pdf	URLs have to comply to RFC-3986.
EEC_version	Version Optional: This information helps idealo identifying the label version, to ensure that it is displayed correctly. 0 = old label version, 1 = new label version.	0	Either 0 or 1

Attribute name

Description

Example

Requirements

EEC_efficiencyClass

Efficiency Class
Classification of energy consumption according to EU regulations. Required for offers with labeling obligation.

Allowed values if EEC_version=1: A, B, C, D, E, F, G
Allowed values if EEC_version=0: A+++, A++, A+, A, B, C, D, E, F, G

EEC_spectrum

Spectrum
The classification spectrum of the given product category. Required for offers with labeling obligation.

A-G

Allowed values if EEC_version=1: A, B, C, D, E, F, G
Allowed values if EEC_version=0: A+++, A++, A+, A, B, C, D, E, F, G
For a range: separated with - (minus)

eec_labelUrl

Label URL
The image URL of the EEC label. Please ensure that the image resolution is high enough, so the QR code can be scanned. Required for offers with labeling obligation.

http://www.link.to/label.jpg

URLs have to comply to RFC-3986.

eec_dataSheetUrl

Data Sheet URL
The URL of the EEC datasheet (PDF). Required for offers with labeling obligation.

http://www.example.com/datasheet.pdf

URLs have to comply to RFC-3986.

EEC_version

Version
Optional: This information helps idealo identifying the label version, to ensure that it is displayed correctly. 0 = old label version, 1 = new label version.

Either 0 or 1

Attributes Documentation

Attribute name	Description	Example	Requirements
sku	Article number in the shop Required	ABC-1322-2-17	Freely selectable unique shop specific ID.
brand	Brand is the manufacturer or brand name of the company that manufactures or produces the product. Separately transmitted brand names play an important role in offer search, product allocation and brand filtering. Required	Sony	Please submit the manufacturer name. For own brands, please provide us with the shop name.
title	Product name Required	Canada Goose Carson down-jacket men, navy blue	For an optimal product recognition please include the manufacturer + model name/number (additional information may include size, colour, material, etc.). Information that is not relevant to the offer (promotional text) is prohibited.
categoryPath	The offers category in the merchants shop. Required	Clothes, Shoes & Accessories > Men’s Clothing > Shorts	Providing this value will allow us to map to the appropriate idealo category. Please provide the path starting at the main category. Please refrain from using manufacturer or model information or unspecific category information like "discounted" or "Summer-Sale".
url	The URL to the offer page in the merchants shop. Required	http://www.myOffer.eu/offer123	URLs have to comply to RFC-3986. For product variants the variant shown at idealo has to be preselected at the shop (e.g. by using parameterized URLs).
han	HAN (Manufacturer’s Article Number) is a unique identification number assigned by manufacturers to identify their own products. These numbers are used to uniquely identify products within the company and along the supply chain. Required	DMC-TZ10EB-K	Please transmit one HAN per offer. Additively, the transmission of the attribute "brand" is required for successful product creation.
description	A short description of the offer. Required	Digital Camera EOS D5300 with 24 MP and optical Image stabilization, including telephoto lens	A precise and detailed description will allow us a better presentation of your offer. Maximum 1000 chars pure text. Avoid HTML and other formatting, as this could lead to incorrect product assignment. Please use this to provide age restrictions for video games or movies according to USK/FSK as well as legal advisories for toys.
imageUrl	URL to the product image Required	cdn.philips-hue-weiss-und-farbig-10w-e27.jpg,cdn.produktbild_max/philips-hue-schwarz-10w-e27.jpg	A list of image URLs for the offer. The first one will be the main picture. The RFC 3986 standard applies. Please use standard web formats (png or jpg) up to 3MB. The quality of the images has a direct influence on the search ranking of the offers in our catalog; images with a white background have a higher ranking.
merchantName	Marketplace merchant name. Optional	Example merchant	Der merchant name is only necessary for product feeds of marketplaces, in which different merchants are listed, that have to be distinguished.
merchantId	Marketplace merchant Id. Optional	merchant12x	The merchant ID is only necessary for product feeds of marketplaces, in which different merchants are listed, that have to be distinguished.
price	The price of the offer. Required	177.99	Please provide the price including VAT. The decimal separator has to be the same for all prices (shipping and handling costs, etc.). Please provide the price without a currency sign. For offers with a minimum purchase quantity, please note that the offer price reflects the total price for the minimum purchase quantity.
basePrice	The price per unit Required for products subject to base price labelling	1,99€ / 100g	For offers requiring a base price according to to §2 PAngV we need the price per unit for 1 kg, 1 l, 1 m, 1 m² oder 1 m³ at the offer. Free text.
formerPrice	The original price of the offer Optional	199.99	The original price of the offer before any price reduction is applied. The price will not be displayed on idealo.de but is required by us for price comparison purposes. Please enter the former price without currency symbols.
voucherCode	The code of the voucher applicable the offer. Optional	CAR10 (10% discount for any articles of the category tyres until Dec 31st!)	Format: "VOUCHER (description of the voucher / validity period)". The voucher text can be up to 200 chars and must include the time when it is valid. Vouchers have to be available to all customer groups: E.g. deals for new customers are not allowed. Please note that you must also send us the discounted price (“specialPrice”) in a separate column.
deposit	The deposit price. Optional	20.00	One way, reusable and battery deposit. Required for offers which obligatory deposit.
deliveryTime	Delivery time information for the offer. Required	1-3 working days	Time until the goods arrive at the customer. Please provide precise information und use working days. Online merchants are legally obliged to tell the customer when the goods can be expected. Imprecise phrases like "ready for shipment" or qualifying additions like "presumably" are disallowed.
deliveryComment	Comment on shipping. Optional	store pickup possible, shipping includes waste disposal	Additional information regarding the shipping. Maximum 150 cars pure text. Avoid HTML and other formats. Promotional and advertising texts are not allowed.
maxOrderProcessingTime	Maximum processing time (in working days). Optional	1	The maximum number of working days required to prepare the order before shipping. The minimum for this value is 1. Same-day shipping, i.e. a maxOrderProcessingTime of 0, can be implemented by transmitting a maxOrderProcessingTime of 1 and an additional configuration of the cut-off time in idealo business.
freeReturnDays	Free return Optional	14	The amount of days within free return is granted.
fulfillmentType	The fulfillment type for this offer. Optional	PAKETDIENST	For a better representation of the possible delivery options, it is highly recommended to specify the shipping method. "Allowed values: "Parcel_Service" or "Package Service"; "Freight_Forwarder" or "Spedition"; "Download" and "Letter" or "Briefversand"."
twoManHandlingFee	The fee for "Two man delivery to place of installation". Optional	20.00	Additional costs incl. VAT for the optional forwarding service "Delivery to the installation site". Possible values (in EUR) are: - If "delivery to the installation site" is possible and free of charge, then the value 0.00 should be entered in this field. - If costs are incurred for "delivery to the installation site", then the corresponding numerical value must be entered. - The decimal separator must be consistent for all price information. - If this field is left blank, it is assumed that the option "delivery to the installation site" is not applicable.
disposalFee	The disposal fee. Optional	3.79	Additional costs incl. VAT for the optional service "old appliance collection". Possible values (in EUR) are: - If "old appliance collection" is possible and free of charge, then the value 0.00 is to be entered in this field. - If costs are incurred for the "old appliance collection", then the corresponding numerical value is to be entered. - The decimal separator must be consistent for all price information. - If this field is left blank, it is assumed that the option "old appliance collection" is not applicable.
condition	State the article is in. Optional	EXCELLENT	Use in combination with "conditionType". Accepted values: EXCELLENT, VERY_GOOD, GOOD, ACCEPTABLE
conditionType	Condition of article. Optional	REFURBISHED	Use in combination with "condition". Accepted values: NEW, AS_NEW, REFURBISHED, USED
gtin	GTIN (Global Trade Item Number) or EAN (European Article Number) is a unique internationally recognised identification number for a product in a specific version (e.g. size, colour). This number enables the automatic allocation of offers to a product and significantly increases the visibility of your offer on idealo. By transmitting GTIN/EAN, you have the opportunity to significantly increase your traffic. Until 2009, the GTIN was still known as an EAN. GTIN and EAN therefore mean the same thing. An GTIN/EAN can be obtained directly from the manufacturer/wholesaler. Required	4029011568541	Please submit one EAN/GTIN per offer.
quantity	Number of pieces	2	Please send us the number of items in a separate column for each offer, e.g: "1" or "2" if several identical items are being offered at one total price.
deliveryCosts	Delivery costs At least one delivery cost has to be provided Required	3.95	If no delivery costs apply, transmit "0.00". Each delivery method requires its own column! Please provide the delivery costs for the cheapest method in EUR. Examples for column names: deliveryCosts_ups, deliveryCosts_fedex, deliveryCosts_deutsche_post Supported service providers: deutsche_post, dhl, dhl_go_green, download, dpd, fedex, german_express_logistics, gls, gls_think_green, hermes, pick_point, spedition, tnt, trans_o_flex, ups
paymentCosts	Payment method with optional fees. At least one payment method has to be provided. Optional	0.00	Required for every payment method to be displayed on idealo for this offer. If no fees apply, transmit "0.00". Each payment method requires its own column! Examples for column names: paymentCosts_credit_card, paymentCosts_cash_in_advance, paymentCosts_giropay etc. Supported payment methods: PayPal, Credit card, Cash in advance, Cash on delivery, Direct debit, Google checkout, Giropay, Invoice, Postal order, Paysafecard, Sofortueberweisung, Amazon payment, Electronical Payment Standard, Ecotax, bizum
used	Indication whether this offer is used (as opposed to new). Outdated, please use "conditionType" and "condition" instead. Optional	true	When the field is omitted we assume that it is not used.
download	Indicates whether this offer is downloadable (as opposed to physical goods). Optional	true	When the field is omitted we assume that it is not a download.
replica	Indication whether this offer is a replica (as opposed to original). Optional	true	When the field is omitted we assume that it is not a replica.
size	The offers indication of size. Required	medium	Offer specific and meaningful indication of size for relevant categories. For each size variant a single offer must be transmitted. EU sizes are recommended for shoes. UK/US sizes have to be marked accordingly (e.g. UK 9.5). Moreover there are not any guidelines concerning content and structure.
colour	The offers indication of colour. Required	red	Offer specific and meaningful indication of colours for relevant categories. For each colour variant a single offer must be transmitted. Moreover there are not any guidelines concerning content and structure.
gender	The offers indication of gender. Optional	female	For each variant a single offer must be transmitted. Moreover there are not any guidelines concerning content and structure.
material	The offers indication of material. Optional	cotton	Offer specific and meaningful indication of material for relevant categories. For each material variant a single offer must be transmitted. Moreover there are not any guidelines concerning content and structure.

Attribute name

Description

Example

Requirements

sku

Article number in the shop
Required

ABC-1322-2-17

Freely selectable unique shop specific ID.

brand

Brand is the manufacturer or brand name of the company that manufactures or produces the product. Separately transmitted brand names play an important role in offer search, product allocation and brand filtering.

Required

Sony

Please submit the manufacturer name. For own brands, please provide us with the shop name.

title

Product name
Required

Canada Goose Carson down-jacket men, navy blue

For an optimal product recognition please include the manufacturer + model name/number (additional information may include size, colour, material, etc.). Information that is not relevant to the offer (promotional text) is prohibited.

categoryPath

The offers category in the merchants shop.
Required

Clothes, Shoes & Accessories > Men’s Clothing > Shorts

Providing this value will allow us to map to the appropriate idealo category. Please provide the path starting at the main category. Please refrain from using manufacturer or model information or unspecific category information like "discounted" or "Summer-Sale".

url

The URL to the offer page in the merchants shop.
Required

http://www.myOffer.eu/offer123

URLs have to comply to RFC-3986. For product variants the variant shown at idealo has to be preselected at the shop (e.g. by using parameterized URLs).

han

HAN (Manufacturer’s Article Number) is a unique identification number assigned by manufacturers to identify their own products. These numbers are used to uniquely identify products within the company and along the supply chain.

Required

DMC-TZ10EB-K

Please transmit one HAN per offer. Additively, the transmission of the attribute "brand" is required for successful product creation.

description

A short description of the offer.
Required

Digital Camera EOS D5300 with 24 MP and optical Image stabilization, including telephoto lens

A precise and detailed description will allow us a better presentation of your offer. Maximum 1000 chars pure text. Avoid HTML and other formatting, as this could lead to incorrect product assignment. Please use this to provide age restrictions for video games or movies according to USK/FSK as well as legal advisories for toys.

imageUrl

URL to the product image
Required

cdn.philips-hue-weiss-und-farbig-10w-e27.jpg,cdn.produktbild_max/philips-hue-schwarz-10w-e27.jpg

A list of image URLs for the offer. The first one will be the main picture. The RFC 3986 standard applies. Please use standard web formats (png or jpg) up to 3MB. The quality of the images has a direct influence on the search ranking of the offers in our catalog; images with a white background have a higher ranking.

merchantName

Marketplace merchant name.
Optional

Example merchant

Der merchant name is only necessary for product feeds of marketplaces, in which different merchants are listed, that have to be distinguished.

merchantId

Marketplace merchant Id.
Optional

merchant12x

The merchant ID is only necessary for product feeds of marketplaces, in which different merchants are listed, that have to be distinguished.

price

The price of the offer.
Required

177.99

Please provide the price including VAT. The decimal separator has to be the same for all prices (shipping and handling costs, etc.). Please provide the price without a currency sign. For offers with a minimum purchase quantity, please note that the offer price reflects the total price for the minimum purchase quantity.

basePrice

The price per unit
Required for products subject to base price labelling

1,99€ / 100g

For offers requiring a base price according to to §2 PAngV we need the price per unit for 1 kg, 1 l, 1 m, 1 m² oder 1 m³ at the offer. Free text.

formerPrice

The original price of the offer
Optional

199.99

The original price of the offer before any price reduction is applied. The price will not be displayed on idealo.de but is required by us for price comparison purposes. Please enter the former price without currency symbols.

voucherCode

The code of the voucher applicable the offer.
Optional

CAR10 (10% discount for any articles of the category tyres until Dec 31st!)

Format: "VOUCHER (description of the voucher / validity period)". The voucher text can be up to 200 chars and must include the time when it is valid. Vouchers have to be available to all customer groups: E.g. deals for new customers are not allowed. Please note that you must also send us the discounted price (“specialPrice”) in a separate column.

deposit

The deposit price.
Optional

20.00

One way, reusable and battery deposit. Required for offers which obligatory deposit.

deliveryTime

Delivery time information for the offer.
Required

1-3 working days

Time until the goods arrive at the customer. Please provide precise information und use working days. Online merchants are legally obliged to tell the customer when the goods can be expected. Imprecise phrases like "ready for shipment" or qualifying additions like "presumably" are disallowed.

deliveryComment

Comment on shipping.
Optional

store pickup possible, shipping includes waste disposal

Additional information regarding the shipping. Maximum 150 cars pure text. Avoid HTML and other formats. Promotional and advertising texts are not allowed.

maxOrderProcessingTime

Maximum processing time (in working days).
Optional

The maximum number of working days required to prepare the order before shipping. The minimum for this value is 1. Same-day shipping, i.e. a maxOrderProcessingTime of 0, can be implemented by transmitting a maxOrderProcessingTime of 1 and an additional configuration of the cut-off time in idealo business.

freeReturnDays

Free return
Optional

The amount of days within free return is granted.

fulfillmentType

The fulfillment type for this offer.
Optional

PAKETDIENST

For a better representation of the possible delivery options, it is highly recommended to specify the shipping method. "Allowed values: "Parcel_Service" or "Package Service"; "Freight_Forwarder" or "Spedition"; "Download" and "Letter" or "Briefversand"."

twoManHandlingFee

The fee for "Two man delivery to place of installation".
Optional

20.00

Additional costs incl. VAT for the optional forwarding service "Delivery to the installation site". Possible values (in EUR) are: - If "delivery to the installation site" is possible and free of charge, then the value 0.00 should be entered in this field.
- If costs are incurred for "delivery to the installation site", then the corresponding numerical value must be entered.
- The decimal separator must be consistent for all price information.
- If this field is left blank, it is assumed that the option "delivery to the installation site" is not applicable.

disposalFee

The disposal fee.
Optional

3.79

Additional costs incl. VAT for the optional service "old appliance collection". Possible values (in EUR) are:
- If "old appliance collection" is possible and free of charge, then the value 0.00 is to be entered in this field.
- If costs are incurred for the "old appliance collection", then the corresponding numerical value is to be entered.
- The decimal separator must be consistent for all price information.
- If this field is left blank, it is assumed that the option "old appliance collection" is not applicable.

condition

State the article is in.
Optional

EXCELLENT

Use in combination with "conditionType".
Accepted values: EXCELLENT, VERY_GOOD, GOOD, ACCEPTABLE

conditionType

Condition of article.
Optional

REFURBISHED

Use in combination with "condition".
Accepted values: NEW, AS_NEW, REFURBISHED, USED

gtin

GTIN (Global Trade Item Number) or EAN (European Article Number) is a unique internationally recognised identification number for a product in a specific version (e.g. size, colour). This number enables the automatic allocation of offers to a product and significantly increases the visibility of your offer on idealo. By transmitting GTIN/EAN, you have the opportunity to significantly increase your traffic.

Until 2009, the GTIN was still known as an EAN. GTIN and EAN therefore mean the same thing. An GTIN/EAN can be obtained directly from the manufacturer/wholesaler.

Required

4029011568541

Please submit one EAN/GTIN per offer.

quantity

Number of pieces

Please send us the number of items in a separate column for each offer, e.g: "1" or "2" if several identical items are being offered at one total price.

deliveryCosts

Delivery costs
At least one delivery cost has to be provided

Required

3.95

If no delivery costs apply, transmit "0.00". Each delivery method requires its own column!
Please provide the delivery costs for the cheapest method in EUR.
Examples for column names: deliveryCosts_ups, deliveryCosts_fedex, deliveryCosts_deutsche_post
Supported service providers:
deutsche_post, dhl, dhl_go_green, download, dpd, fedex, german_express_logistics, gls, gls_think_green, hermes, pick_point, spedition, tnt, trans_o_flex, ups

paymentCosts

Payment method with optional fees.
At least one payment method has to be provided.

Optional

0.00

Required for every payment method to be displayed on idealo for this offer. If no fees apply, transmit "0.00". Each payment method requires its own column!
Examples for column names: paymentCosts_credit_card, paymentCosts_cash_in_advance, paymentCosts_giropay etc.
Supported payment methods: PayPal, Credit card, Cash in advance, Cash on delivery, Direct debit, Google checkout, Giropay, Invoice, Postal order, Paysafecard, Sofortueberweisung, Amazon payment, Electronical Payment Standard, Ecotax, bizum

used

Indication whether this offer is used (as opposed to new).
Outdated, please use "conditionType" and "condition" instead.
Optional

true

When the field is omitted we assume that it is not used.

download

Indicates whether this offer is downloadable (as opposed to physical goods).
Optional

true

When the field is omitted we assume that it is not a download.

replica

Indication whether this offer is a replica (as opposed to original).
Optional

true

When the field is omitted we assume that it is not a replica.

size

The offers indication of size.
Required

medium

Offer specific and meaningful indication of size for relevant categories. For each size variant a single offer must be transmitted. EU sizes are recommended for shoes. UK/US sizes have to be marked accordingly (e.g. UK 9.5). Moreover there are not any guidelines concerning content and structure.

colour

The offers indication of colour.
Required

red

Offer specific and meaningful indication of colours for relevant categories. For each colour variant a single offer must be transmitted. Moreover there are not any guidelines concerning content and structure.

gender

The offers indication of gender.
Optional

female

For each variant a single offer must be transmitted. Moreover there are not any guidelines concerning content and structure.

material

The offers indication of material.
Optional

cotton

Offer specific and meaningful indication of material for relevant categories. For each material variant a single offer must be transmitted. Moreover there are not any guidelines concerning content and structure.

Car part Specific Attributes

Attribute name	Description	Example	Requirements
oen	Original replacement part number as provided by the car manufacturer A list of original equipment manufacturer numbers. Alternatively you can use a column per number.	VW#123 615 301, BMW#876 647 9879	OEN are important for our automated product recognition and for finding the offer in our search.
kba	Car type IDs of the "Kraftfahrt-Bundesamt" A list of unique car type IDs at "Kraftfahrt-Bundesamt" (HSN und TSN) to identify the correct car spar parts.Alternatively you can use a column per number.	46988 205/55R16	KBA are important for our automated product recognition and for finding the offer in our search. Offers containing PZNs are preferred in the product creation. We can generate a qualitative and quantitative better traffic when these are provided.

Attribute name

Description

Example

Requirements

oen

Original replacement part number as provided by the car manufacturer
A list of original equipment manufacturer numbers. Alternatively you can use a column per number.

VW#123 615 301, BMW#876 647 9879

OEN are important for our automated product recognition and for finding the offer in our search.

kba

Car type IDs of the "Kraftfahrt-Bundesamt"
A list of unique car type IDs at "Kraftfahrt-Bundesamt" (HSN und TSN) to identify the correct car spar parts.Alternatively you can use a column per number.

46988 205/55R16

KBA are important for our automated product recognition and for finding the offer in our search. Offers containing PZNs are preferred in the product creation. We can generate a qualitative and quantitative better traffic when these are provided.

Lenses Specific Attributes

Attribute name	Description	Example	Requirements
diopter	Diopter The diopter measurement for contact lenses.	+20.00	This value should be preceded by a "+" or "-".
baseCurve	Base curve The baseCurve is a diopter measurement, in millimeters, of the inside curve of your contact lenses.	8.34
diameter	Diameter The diameter of the contact lens.	12.34
cylinder	Cylinder The cylinder of the contact lens.	-0.75	This value usually is preceded by a "-".
axis	Axis The axis of the contact lens. Measured in degrees, the axis references the placement of the power in the lens, to compensate for the cornea’s shape when there is astigmatism.	10	The value is between 0° and 180°.
addition	Addition The addition for multi focal contact lenses.	1.0	This value has no leading sign.

Attribute name

Description

Example

Requirements

diopter

Diopter
The diopter measurement for contact lenses.

+20.00

This value should be preceded by a "+" or "-".

baseCurve

Base curve
The baseCurve is a diopter measurement, in millimeters, of the inside curve of your contact lenses.

8.34

diameter

Diameter
The diameter of the contact lens.

12.34

cylinder

Cylinder
The cylinder of the contact lens.

-0.75

This value usually is preceded by a "-".

axis

Axis
The axis of the contact lens. Measured in degrees, the axis references the placement of the power in the lens, to compensate for the cornea’s shape when there is astigmatism.

The value is between 0° and 180°.

addition

Addition
The addition for multi focal contact lenses.

1.0

This value has no leading sign.

Speaker Specific Attributes

Attribute name	Description	Example	Requirements
quantity	Number of pieces	2 speakers	Please provide the information "1 speaker" or "2 speakers" per offer in a separate column. Alternatively you can extend the offer title with the information: "Price per piece" or "Price per pair".

Attribute name

Description

Example

Requirements

quantity

Number of pieces

2 speakers

Please provide the information "1 speaker" or "2 speakers" per offer in a separate column. Alternatively you can extend the offer title with the information: "Price per piece" or "Price per pair".

Wine Specific Attributes

Attribute name	Example	Requirements
alcoholicContent	12,7 % vol
allergenInformation	Contains sulfite
countryOfOrigin	South Africa
quantity	0.75 litres
bottler	Boekenhoutskloof Winery, Excelsior Road, Franschhoek, 7690, Südafrika
importer	CWD Champagner- und Wein-Distributionsgesellschaft, Griegstr. 75, 22763 Hamburg, Deutschland	The importer only needs to be send if the wine was produced outside of the EU.

Attribute name

Description

Example

Requirements

alcoholicContent

12,7 % vol

allergenInformation

Contains sulfite

countryOfOrigin

South Africa

quantity

0.75 litres

bottler

Boekenhoutskloof Winery,
Excelsior Road,
Franschhoek, 7690,
Südafrika

importer

CWD Champagner- und Wein-Distributionsgesellschaft,
Griegstr. 75,
22763 Hamburg,
Deutschland

The importer only needs to be send if the wine was produced outside of the EU.

Tyre Specific Attributes

Attribute name	Description	Example	Requirements
fuelEfficiencyClass	Fuel efficiency class The applicable fuel efficiency class of the tyre according to Regulation (EU) 2020/740 (letter "A" to "E")	A	Values between A and E.
wetGripClass	Wet grip class The applicable wet grip class of the tyre according to Regulation (EU) 2020/740 (letter "A" to "E")	B	Values between A and E.
externalRollingNoise	External rolling noise The external rolling noise measured value (N, in dB(A)) in decibels of the tyre according to Regulation (EU) 2020/740	71	A whole number which represents the value in decibel between 67 and 71.
externalRollingNoiseClass	Rolling noise class The applicable external rolling noise class of the tyre according to Regulation (EU) 2020/740 (letter "A" to "C")	B	Values between A and C.
snowGrip	Snow grip Indication of whether the tyre satisfies the minimum snow grip index values set out in UNECE Regulation No 117.	true	Boolean
iceGrip	Ice grip Indication of whether the tyre satisfies the relevant minimum ice grip index values.	false	Boolean
eec_labelUrl	Label URL The image URL of the EEC label. Please ensure that the image resolution is high enough, so the QR code can be scanned. Required for offers with labeling obligation.	http://www.link.to/label.jpg	URLs have to comply to RFC-3986.
eec_dataSheetUrl	Data Sheet URL The URL of the EEC datasheet (PDF). Required for offers with labeling obligation.	http://www.example.com/datasheet.pdf	URLs have to comply to RFC-3986.

Attribute name

Description

Example

Requirements

fuelEfficiencyClass

Fuel efficiency class
The applicable fuel efficiency class of the tyre according to Regulation (EU) 2020/740 (letter "A" to "E")

Values between A and E.

wetGripClass

Wet grip class
The applicable wet grip class of the tyre according to Regulation (EU) 2020/740 (letter "A" to "E")

Values between A and E.

externalRollingNoise

External rolling noise
The external rolling noise measured value (N, in dB(A)) in decibels of the tyre according to Regulation (EU) 2020/740

A whole number which represents the value in decibel between 67 and 71.

externalRollingNoiseClass

Rolling noise class
The applicable external rolling noise class of the tyre according to Regulation (EU) 2020/740 (letter "A" to "C")

Values between A and C.

snowGrip

Snow grip
Indication of whether the tyre satisfies the minimum snow grip index values set out in UNECE Regulation No 117.

true

Boolean

iceGrip

Ice grip
Indication of whether the tyre satisfies the relevant minimum ice grip index values.

false

Boolean

eec_labelUrl

Label URL
The image URL of the EEC label. Please ensure that the image resolution is high enough, so the QR code can be scanned. Required for offers with labeling obligation.

http://www.link.to/label.jpg

URLs have to comply to RFC-3986.

eec_dataSheetUrl

Data Sheet URL
The URL of the EEC datasheet (PDF). Required for offers with labeling obligation.

http://www.example.com/datasheet.pdf

URLs have to comply to RFC-3986.

Medical Products Specific Attributes

Attribute name	Description	Example	Requirements
pzn	PZN (Pharmacy Central Numbers) is a unique identification number for pharmaceutical products in a specific version (dosage forms, dosage or package size) in Germany. This number enables the automatic allocation of offers to products and significantly increases the visibility of your offer on idealo. By submitting PZN, you have the opportunity to significantly increase your traffic. Required for pharmaceutical products	01627586	Please submit one PZN per offer.

Attribute name

Description

Example

Requirements

pzn

PZN (Pharmacy Central Numbers) is a unique identification number for pharmaceutical products in a specific version (dosage forms, dosage or package size) in Germany. This number enables the automatic allocation of offers to products and significantly increases the visibility of your offer on idealo. By submitting PZN, you have the opportunity to significantly increase your traffic.

Required for pharmaceutical products

01627586

Please submit one PZN per offer.

Medical dietary supplement Specific Attributes

Attribute name	Description	Example	Requirements
pzn	PZN (Pharmacy Central Numbers) is a unique identification number for pharmaceutical products in a specific version (dosage forms, dosage or package size) in Germany. This number enables the automatic allocation of offers to products and significantly increases the visibility of your offer on idealo. By submitting PZN, you have the opportunity to significantly increase your traffic. Required for pharmaceutical products	01627586	Please submit one PZN per offer.
productCategory	Name of shop category	Medicines > Painkillers
productType	Product group	Headache tablets
indicationsForUse	Indication of the indication for which the product can be used	Pain & inflammation
storageInstructions	Information on how to store the product	Store in a dry place
warnings	Information on what to look out for when handling/using the product	Keep out of the reach of children
dosageForm	Indication of the form in which the product is sold	Tablets, soft capsules, suppositories
quantity	Quantity or content	120 pieces
activeIngredient	A list of all active ingredients	Acetylsalicylic acid (ASA), paracetamol, caffeine
additionalInformation	A list of additional information about the product	lactose-free, gluten-free, vegan, etc.
netQuantity	Transmission with unit ("g", "kg", "ml", "l")	180g
listOfIngredients	A list of all ingredients (according to LMIV)	Microculture mixture, corn starch filler, capsule shell hydroxypropyl methylcellulose, anti-caking agent magnesium salts of fatty acids, colouring copper-containing complexes of chlorophyllins, D-biotin, anti-caking agent silicon dioxide

Attribute name

Description

Example

Requirements

pzn

01627586

Please submit one PZN per offer.

productCategory

Name of shop category

Medicines > Painkillers

productType

Product group

Headache tablets

indicationsForUse

Indication of the indication for which the product can be used

Pain & inflammation

storageInstructions

Information on how to store the product

Store in a dry place

warnings

Information on what to look out for when handling/using the product

Keep out of the reach of children

dosageForm

Indication of the form in which the product is sold

Tablets, soft capsules, suppositories

quantity

Quantity or content

120 pieces

activeIngredient

A list of all active ingredients

Acetylsalicylic acid (ASA), paracetamol, caffeine

additionalInformation

A list of additional information about the product

lactose-free, gluten-free, vegan, etc.

netQuantity

Transmission with unit ("g", "kg", "ml", "l")

180g

listOfIngredients

A list of all ingredients (according to LMIV)

Microculture mixture, corn starch filler, capsule shell hydroxypropyl methylcellulose, anti-caking agent magnesium salts of fatty acids, colouring copper-containing complexes of chlorophyllins, D-biotin, anti-caking agent silicon dioxide

Cosmetic Specific Attributes

Attribute name	Description	Example
productType	Group of products	Face Cream
quantity	Transmission with unit ("g", "kg", "ml", "l")	100ml
skinType	for skin care products only	dry skin
hairType	for hair products only	stressed hair
effect	Information on the effect that can be achieved by using the product	moisturizing
series	Product range	Schwarzkopf Osis
label	Information on seals, certificates, awards, etc	Ecolabel
additionalInformation	A list of additional information about the product	vegan, silicone free, parabens free
forTheTreatmentOf	Indication of the treatment for which the product is applicable	Itching, Spliss
areaOfUse	Indication of the area for which the product is applicable	Belly, Face, Legs
texture	Texture of the product	Cream
allergyInformation	A list of all allergenic substances	free from parabens
ingredients	A list of all ingredients	Panthenol, copper, zinc, manganese
hold	for hair products only	5
finish	for hair products only	glossy, shiny

Attribute name

Description

Example

Requirements

productType

Group of products

Face Cream

quantity

Transmission with unit ("g", "kg", "ml", "l")

100ml

skinType

for skin care products only

dry skin

hairType

for hair products only

stressed hair

effect

Information on the effect that can be achieved by using the product

moisturizing

series

Product range

Schwarzkopf Osis

label

Information on seals, certificates, awards, etc

Ecolabel

additionalInformation

A list of additional information about the product

vegan, silicone free, parabens free

forTheTreatmentOf

Indication of the treatment for which the product is applicable

Itching, Spliss

areaOfUse

Indication of the area for which the product is applicable

Belly, Face, Legs

texture

Texture of the product

Cream

allergyInformation

A list of all allergenic substances

free from parabens

ingredients

A list of all ingredients

Panthenol, copper, zinc, manganese

hold

for hair products only

finish

for hair products only

glossy, shiny

Change Log

Date	Comment
2024-10-02	Added condition type und condition attributes
2024-05-29	Updated: Requirements for showing offers on idealo, Attributes Documentation, Car part Specific Attributes, Tyre Specific Attributes, Medical Products Specific Attributes, Medical dietary supplement Specific Attributes, Cosmetic Specific Attributes
2024-03-05	Added medical dietary supplement and cosmetic attributes
2023-07-24	Updated descriptions for EAN, PZN, HAN, and Brand
2023-03-03	Corrected limit for image sizes
2023-01-04	Remove direct checkout related attributes
2021-05-21	Changed "tire" to "tyre"
2021-05-12	Updated tire attributes
2021-04-01	Added energy label attributes

Any Questions?

If you have any questions about your product feed data, our Technical Account Management team will be more than happy to help:

E-Mail: tam@idealo.de
Tel.: Ask for a callback