How Can We Help?
Kelkoo Product Data Feed | Build Guide
Column Attributes and Descriptions
Header Tag: offer-id
Kelkoo Column ID: 135
Data Type: text
Description: The identifier of each article must be unique within your account . It can not be reused from one feed to another for the same country and the same language. If you have multiple feeds to a country, the identifiers of articles in the various feeds must also be unique.
If your codes only appear once in your inventory and comply with the requirements listed below, we recommend that you use for this attribute.
Warning: After submitting an article, you should not change their identifier when updating your data feed .
Warning: After submitting an article, you must not use its identifier to designate a different product later .
Requirement: mandatory
Header Tag: title
Kelkoo Column ID: 1
Data Type: text
Description: Model name is limited to 80 characters. Example values: “EOS 400D”, or “Pull-over 100% wool”…
WARNING: Leaving the title field blank will mean the products are dropped by our process.
Requirement: mandatory
Header Tag: product-url
Kelkoo Column ID: 2
Data Type: text
Description: Link to offer
URL of product’s page on your own site. The url must start with either “http://” or “https://”.
WARNING: Your offer will not be displayed on Kelkoo if your URL does not begin with http:// or https:// .
Requirement: mandatory
Header Tag: landing-page-url
Kelkoo Column ID: 136
Data Type: text
Description: Link to offer
URL of product’s page on your own site. The url must start with either http:// or https://.
WARNING: The landing-page-url differs from the product-url field in the following way:
– Landing-page-url can’t integrate tracking – for instance: Lengow, Beezup, ShoppingFeed….
– Landing-page-url must be the final url seen by the user, and use the domain name of your shop.
Requirement: mandatory
Header Tag: price
Kelkoo Column ID: 3
Data Type: text
Description: Net price for a typical customer.
Should not include possible reduction from a voucher code…(see dedicated fields below)
Requirement: mandatory
Header Tag: brand
Kelkoo Column ID: 4
Data Type: text
Description: Product’s brand
Requirement: mandatory
Header Tag: description
Kelkoo Column ID: 5
Data Type: text
Description: product specifications. This is free text, limited to 300 characters (no use of html).
Requirement: mandatory
Header Tag: image-url
Kelkoo Column ID: 6
Data Type: text
Description: Link to an image of the offer. Enter the largest image available on your site. They should not contain any watermark or logo of trade. It is recommended to provide images on a white background in jpg, png or gif..
Minimum recommended size 300 * 300.
Maximum size 6 600 000 pixels. Examples:
* image 1024 * 768 = 786 432 pixel = OK
* image 1600 * 1200 = 1 920 000 pixel = OK
* image 1518 × 5908 = 8 968 344 pixel = NOT OK
WARNING: Your image will not be displayed on Kelkoo if your URL does not begin with http://.
Requirement: mandatory
Header Tag: ean
Kelkoo Column ID: 7
Data Type: text
Description: EAN code product, you guarantee a good matching at the product level. We support:
* UPC-E (6 digits)UPC-E (
* EAN-8/UCC-8/GTIN-8 (8 digits)
* UPC-A/GTIN-12 (12 digits)
* EAN-13/UCC-13/GTIN-13 (13 digits)
* ISBN-13 (13 digits for books)
* EAN-14/UCC-14/GTIN-14 (14 digits)
If you cannot supply EAN codes for a specific reason, please contact your Kelkoo account manager or contact us here
Requirement: mandatory
Header Tag: merchant-category
Kelkoo Column ID: 8
Data Type: text
Description: Category :
Please fill with a relevant category name, as this field is used by our categorization process. For example, “Accessories” would be somewhat confusing for our process, while “Car accessories” or “PC tuning accessories” have a much more better chance to to fill the proper category…
Requirement: highly recommended
Header Tag: merchant-category
Kelkoo Column ID: 8
Data Type: text
Description: Category :
Please fill with a relevant category name, as this field is used by our categorization process. For example, “Accessories” would be somewhat confusing for our process, while “Car accessories” or “PC tuning accessories” have a much more better chance to to fill the proper category…
Requirement: highly recommended
Header Tag: availability
Kelkoo Column ID: 9
Data Type: numeric
Description: Availability of a product. Accepted values are as follow :
1 = In Stock
4 = Preorder
5 = Available on Order
WARNING: Your offer will not be displayed on Kelkoo if this field is blank
Requirement: mandatory
Header Tag: delivery-cost
Kelkoo Column ID: 10
Data Type: numeric
Description: Please provide here exact amount of your product’s delivery price. This applies only for delivery at home, not for withdrawal in a shop, warehouse, or else…
Warning: Your offer will not be displayed on Kelkoo if this field is blank.
Requirement: mandatory
Header Tag: delivery-time
Kelkoo Column ID: 11
Data Type: text
Description: Delivery time for product after order. Example values :
* x – y days
* x days
* x – y hours
* y hours
* x – y weeks
* y weeks
Requirement: highly recommended
Header Tag: condition
Kelkoo Column ID: 12
Data Type: numeric
Description: Product status. Values expected:
0 = new (considered as default value)
1 = used
2 = refurbished
3 = open box
4 = returned
5 = damaged
6 = overstock
7 = liquidation
8 = unknown
9 = download (for pure-bits products)
10 = offers for professional
Requirement: highly recommended
Header Tag: ecotax
Kelkoo Column ID: 13
Data Type: numeric
Description: Accepted values in this field (numeric):
* Offer is not affected by the environmental tax, indicate ‘0’
* Offer is affected but price does not include ecotax, specify the amount of the tax
* If the total price of the offer already contains environmental tax, enter ‘0’
Requirement: highly recommended
Header Tag: warranty
Kelkoo Column ID: 14
Data Type: text
Description: Warranty applied to the offer. Typically expected values:
* x years + additional information
* x months + additional information
* check site
Ex. : 2 years manufacturer warranty, 6 months on site
Requirement: highly recommended
Header Tag: mobile-url
Kelkoo Column ID: 15
Data Type: text
Description: URL of your ‘mobile website’ containing details of the products and the ‘buy button’ to the corresponding product
Requirement: recommended
Header Tag: kelkoo-category-id
Kelkoo Column ID: 16
Data Type: numeric
Description:
Requirement: recommended
Header Tag: mpn
Kelkoo Column ID: 17
Data Type: text
Description: MPN code (manufacturer part number) for product. This helps with the integration of your product.
Requirement: mandatory
Header Tag: sku
Kelkoo Column ID: 18
Data Type: text
Description: SKU code for product. This helps with the integration of your product.
Requirement: optional
Header Tag: color
Kelkoo Column ID: 19
Data Type: text
Description: Color of the element. If the item is available in several colors, you can specify multiple colors, or use the delimiter “;”to separate each value.
Requirement: recommended
Header Tag: unit-price
Kelkoo Column ID: 20
Data Type: text
Description: Unit Price. Ex. 14,56 EUR/kg, 0.14 ? per 100 ml, per 100ml = 14.56
Requirement: recommended
Header Tag: unit-price-measure
Kelkoo Column ID: 137
Data Type: text
Description: The measure in which the product is sold. E.g. 300 ml if a 300 ml bottle, 0.75 l if a regular sized wine bottle, etc.
Requirement: recommended
Header Tag: unit-price-base-measure
Kelkoo Column ID: 138
Data Type: text
Description: The base measure in which to show price against. E.g. 100 ml if to show 5.60 eur / 100 ml, 12.90 eur / 0.75 l, etc.
Requirement: recommended
Header Tag: offer-type
Kelkoo Column ID: 21
Data Type: text
Description: Offer type Mainly 2 possible values : “single” or “bundle”.
Requirement: recommended
Header Tag: merchant-info
Kelkoo Column ID: 22
Data Type: text
Description: This field allows you to associate additional information to your brand (and not the product). Ex: company overview, points of sale, delivery. (limited to 150 characters, including spaces).
Requirement: optional
Header Tag: currency
Kelkoo Column ID: 23
Data Type: text
Description: Ex. EUR, GBP, DKK etc.
Requirement: optional
Header Tag: image-url-2 (plus 3-4)
Kelkoo Column ID: 24-26
Data Type: text
Description: Link to an alternative image of the offer. Enter the largest image available on your site. Each image must be different
Requirement: optional
Product Features
Header Tag: green-product
Kelkoo Column ID: 27
Data Type: numeric
Description: Ecological product. Indicate whether the product can be considered environmentally friendly (green):
1 = yes
0 = no (or empty = default value)
Requirement: recommended
Header Tag: green-label
Kelkoo Column ID: 28
Data Type: text
Description: Eco-label product. Ex: NF Environment, FSC, Fair Trade, …
Requirement: recommended
Header Tag: sales-rank
Kelkoo Column ID: 29
Data Type: numeric
Description: The classification of this product in terms of sales for the merchant. Lower numbers indicate they are most often sold.
Requirement: optional
Header Tag: unit-quantity
Kelkoo Column ID: 30
Data Type: numeric
Description: The quantity of contents. Ex: package contains 8 units of toothpaste.
Requirement: optional
Header Tag: made-in
Kelkoo Column ID: 31
Data Type: text
Description: The country where the product was manufactured.
Requirement: optional
Header Tag: efficiency-class
Kelkoo Column ID: 32
Data Type: text
Description: Efficiency class of offer (A+++,A++,A+,A,B,C,D,E,F,G).
Requirement: optional
Shipping Method
Header Tag: shipping-method
Kelkoo Column ID: 33
Data Type: text
Description: Method of delivery related charges. Ex Post Office, UPS, DHL, Colissimo, Kiala …
Requirement: recommended
Header Tag: delivery-cost-2
Kelkoo Column ID: 34
Data Type: numeric
Description: Alternative delivery cost
Requirement: recommended
Header Tag: shipping-method-2
Kelkoo Column ID: 35
Data Type: text
Description: Method of delivery related charges. Ex Post Office, UPS, DHL, Colissimo, Kiala …
Requirement: recommended
Header Tag: delivery-cost-3
Kelkoo Column ID: 36
Data Type: numeric
Description: Alternative delivery cost
Requirement: recommended
Header Tag: shipping-method-3
Kelkoo Column ID: 37
Data Type: text
Description: Method of delivery related charges. Ex Post Office, UPS, DHL, Colissimo, Kiala …
Requirement: recommended
Header Tag: delivery-cost-4
Kelkoo Column ID: 38
Data Type: numeric
Description: Alternative delivery cost
Requirement: recommended
Header Tag: shipping-method-4
Kelkoo Column ID: 39
Data Type: text
Description: Method of delivery related charges. Ex Post Office, UPS, DHL, Colissimo, Kiala …
Requirement: recommended
Header Tag: zip-code
Kelkoo Column ID: 40
Data Type: numeric
Description: Postal code of the shop. Specific to the U.S., but necessary for all countries to allow geo-location
Requirement: recommended
Header Tag: stock-quantity
Kelkoo Column ID: 41
Data Type: numeric
Description: Number of products in stock
Requirement: optional
Header Tag: shipping-weight
Kelkoo Column ID: 42
Data Type: text
Description: Weight of the item to ship.
Requirement: optional
Header Tag: payment-methods
Kelkoo Column ID: 43
Data Type: text
Description: List of accepted payment methods (Visa, Paypal …)
Requirement: optional
Coupon
Header Tag: voucher-title
Kelkoo Column ID: 44
Data Type: text
Description: Voucher title. Limited to 80 characters including spaces
Requirement: recommended
Header Tag: voucher-description
Kelkoo Column ID: 45
Data Type: text
Description: Voucher description. Limited to 180 characters including spaces
Required in France
Requirement: optional
Header Tag: voucher-url
Kelkoo Column ID: 46
Data Type: text
Description: Voucher url. Link to your voucher page if available, or to your home page otherwise (limited to 20 characters including spaces).
Required in France
Requirement: optional
Header Tag: voucher-code
Kelkoo Column ID: 47
Data Type: text
Description: Voucher code. Code users have to type to benefit from your site’s voucher. Limited to 20 characters including spaces.
Required in France
Requirement: optional
Header Tag: voucher-start-date
Kelkoo Column ID: 48
Data Type: date
Description: Starting date for you voucher, formatted as YYYY-MM-DD (ex : 2015-01-29)
Requirement: optional
Header Tag: voucher-end-date
Kelkoo Column ID: 49
Data Type: date
Description: Starting date for you voucher, formatted as YYYY-MM-DD (ex : 2015-01-29)
Requirement: optional
Crossed Price/ Sales
Header Tag: price-no-rebate
Kelkoo Column ID: 50
Data Type: numeric
Description: Crossed prices. Price of your offer excluding rebate amount. Will be displayed scratched, next to effective price on rebates periods, and should be ignored otherise. Strictly numeric field (no alphabetical character or symbol…), with a dot as decimal separator (no comma).
Requirement: recommended
Header Tag: percentage-promo
Kelkoo Column ID: 51
Data Type: numeric
Description: Leave this field empty, Kelkoo will calculate it for you
Requirement: optional
Header Tag: occassion
Kelkoo Column ID: 52
Data Type: text
Description: Used to mark offers for special events like Christmas day, Valentine day, and so on.
Requirement: optional
Header Tag: promo-start-date
Kelkoo Column ID: 53
Data Type: date
Description: Starting date for promotion. Formatted as YYYY-MM-DD (ex : 2015-10-29).
Requirement: optional
Header Tag: promo-end-date
Kelkoo Column ID: 54
Data Type: date
Description: End date for promotion. Formatted as YYYY-MM-DD (ex : 2015-10-29)
Requirement: optional
User Agreement
Header Tag: user-rating
Kelkoo Column ID: 55
Data Type: numeric
Description: Note to users. How users rated the product on the merchant site, 1 to 5, with 5 being best
Requirement: optional
Header Tag: nb-reviews
Kelkoo Column ID: 56
Data Type: numeric
Description: Number of user reviews. The number of user reviews for this product on the merchant site
Requirement: optional
Header Tag: user-review-link
Kelkoo Column ID: 57
Data Type: numeric
Description: The URL for the user reviews on the merchant site.
Requirement: optional
Header Tag: video-link
Kelkoo Column ID: 58
Data Type: numeric
Description: The URL to a video of the product.
Requirement: optional
Header Tag: video-title
Kelkoo Column ID: 59
Data Type: numeric
Description: The title of the video.
Requirement: optional
This is the complete list of standard retail/ shopping fields. There are a host of other fields related to specialised product areas – fashion, software, real estate, movies, CD, books, wine, tyres, mobile phones, cars and ticket sales.
You can find details of these if they relate to your store by following the field details table link below.