How Can We Help?

< All Topics
Print

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.

Kelkoo Help Documentation

Product Data Feed

Field details table