Welcome to the Kelkoo Group Customer Service

Product data feed


File formats

The Product data feed can be a CSV, XML or any kind of structured text file.
Preferably you should set up a script that exports data from your database to a file, and set up a routine to keep this file updated.

 

XML format

If you opt for an XML file, here are some recommendations to ease the integration.
Please note that an invalid xml file can not be operated by our system and your offers will not be updated.

  • Name your file “'<sitename>_kelkoo_<countryprefix>.xml”
  • Respect the name of the XML tags as shown in the Fields details table
  • To validate your XML file, it is preferable to insert the contents of the text fields in a CDATA section
    The description often includes non-escaped specific characters such as &, >, or <. The CDATA section is not analyzed. Thus, we recommend using it if you do not take care to validate your XML Product data feed before sending it to us.
    • For example :
<description>
<![CDATA[
You can insert specific characters such as &,>, or <. Your xml file will still be valid.
]]>
</description>
    • Specify the encoding of your file in the header
<?xml version="1.0" encoding="utf-8"?>

 

    • Sample XML file
    • Below an example that shows one product in a product file. For XML validation you can use http://validator.w3.org/ (external link)
<?xml version="1.0" encoding="UTF-8" ?>
<products>
    <product>
        <title><![CDATA[100 Pant fleece pant, men's 10/11]]></title>
        <product-url><![CDATA[http://www.merchant.com/product/100-pant-fleecebukse-herre-1011-19959.aspx]]></product-url>
        <price>599.00</price>
        <brand><![CDATA[The North Face]]></brand>
        <description><![CDATA[The North Face TKA 100 Pant fleece pant is designed for cold conditions and fits very well under the shell clothing.]]></description>
        <image-url><![CDATA[http://www.merchant.com/uploads/pictures/21691-128.jpg]]></image-url>
        <ean>4856349257328</ean>
        <merchant-category><![CDATA[Clothing - Men - Pants - Outdoor Pants]]></merchant-category>
        <availability>1</availability>
        <delivery-cost>99.00</delivery-cost>
        <delivery-time><![CDATA[1-3 days]]></delivery-time>
        <condition></condition>
        <ecotax></ecotax>
        <warranty></warranty>
        <mobile-url></mobile-url>
        <kelkoo-category-id></kelkoo-category-id>
        <mpn><![CDATA[AJGW]]></mpn>
        <sku></sku>
        <colour></colour>
        <unit-price></unit-price>
        <offer-type></offer-type>
        <merchant-info></merchant-info>
        <currency></currency>
        <image-url-2></image-url-2>
        <image-url-3></image-url-3>
        <image-url-4></image-url-4>
        <green-product></green-product>
        <green-label></green-label>
        <sales-rank></sales-rank>
        <unit-quantity></unit-quantity>
        <made-in></made-in>
        <occasion></occasion>
        <keywords></keywords>
        <shipping-method></shipping-method>
        <delivery-cost-2></delivery-cost-2>
        <shipping-method-2></shipping-method-2>
        <delivery-cost-3></delivery-cost-3>
        <shipping-method-3></shipping-method-3>
        <delivery-cost-4></delivery-cost-4>
        <shipping-method-4></shipping-method-4>
        <zip-code></zip-code>
        <stock-quantity></stock-quantity>
        <shipping-weight></shipping-weight>
        <payment-methods></payment-methods>
        <voucher-title></voucher-title>
        <voucher-description></voucher-description>
        <voucher-url></voucher-url>
        <voucher-code></voucher-code>
        <voucher-start-date></voucher-start-date>
        <voucher-end-date></voucher-end-date>
        <price-no-rebate></price-no-rebate>
        <percentage-promo></percentage-promo>
        <promo-start-date></promo-start-date>
        <promo-end-date></promo-end-date>
        <user-rating></user-rating>
        <nb-reviews></nb-reviews>
        <user-review-link></user-review-link>
        <video-link></video-link>
        <video-title></video-title>
    </product>
</products>

 

Text format

If you choose a text file, here are some recommendations:

  • Name your file ‘<sitename>_kelkoo_<countryprefix>.txt’ and save it in UNIX format / DOS
  • Use field separators to separate offers, the new line allows our system to distinguish between offers.
  • You can use any type of field separator.
  • Of course, the field separator should not be present within a same field (for example in the description). The tab will be the only field separator accepted for a the Kelkpack offer.
  • All offers must contain the same number of fields. If a field is blank, the field separator must be present.
  • Example of a text file with a Tab (t) separator:
    title	product-url	price	brand	description	image-url	merchant-category	ean	availability	delivery-cost	delivery-time	condition	ecotax	warranty	mobile-url	kelkoo-category-id	mpn	sku	color	unit-price	offer-type	merchant-info	currency
    Tunelink Home 	http://tracking.lengow.com/shortUrl/1158-17881-618213/	49.90	New Potato	Tunelink Home Recepteur Bluetooth et télécommande universelle - Connectez votre Chaine HiFi en Bluetooth grâce à votre Smartphones	https://images.grosbill.com/imagesproduitnew/images150jpg/618213.jpg	mobilite_pda > accessoire audio	815166010035	1	3	Sous 2 à 3 jours	0	0.00	garanti 3 ans			1101-TLHMEA1	618213					EUR
  • Example that shows the first two lines in a .csv file:
    "title";"product-url";"price";"brand";"description";"image-url";"ean";"merchant-category";"availability";"delivery-cost";"delivery-time";"condition";"ecotax";"warranty";"mobile-url";"kelkoo-category-id";"mpn";"sku";"colour";"unit-price";"offer-type";"merchant-info";"currency";"image-url-2";"image-url-3";"image-url-4";"green-product";"green-label";"sales-rank";"unit-quantity";"made-in";"occasion";"keywords";"shipping-method";"delivery-cost-2";"shipping-method-2";"delivery-cost-3";"shipping-method-3";"delivery-cost-4";"shipping-method-4";"zip-code";"stock-quantity";"shipping-weight";"payment-methods";"voucher-title";"voucher-description";"voucher-url";"voucher-code";"voucher-start-date";"voucher-end-date";"price-no-rebate";"percentage-promo";"promo-start-date";"promo-end-date";"user-rating";"nb-reviews";"user-review-link";"video-link";"video-title"
    "100 Pant fleece pant, men's 10/11," "http://www.merchant.com/product/100-pant-fleecebukse-herre-1011-19959.aspx", "599.00", "The North Face"; "The North Face TKA 100 Pant fleece pant is designed for cold conditions and fits very well under the shell clothing. "" http://www.merchant.com/uploads/pictures/21691-128.jpg "" 0732075821555 "," Clothing - Pants - Outdoor Pants "," 1 "," 99 "," 1-3

File transfer

 

There are two possible ways for recovering your file which are explained below. Your file should be named kelkoo_<countryprefix>.xml or kelkoo_<countryprefix>.txt. The partner file must always keep the same name.

You can check file recovery hours at the following page: Accessibility

HTTP transfer mode

To use this transfer mode, you must provide a URL where we can find your complete Product data feed.
For example: http://yoursite.fr/kelkoo.xml
In the case of large volumes of data, your http server must be set to allow the complete download of the Product data feed.

FTP transfer mode

If you want to submit your file to your FTP account, you must provide:

  • The address / URL of your FTP server
  • The name of the file(s) used, zipped if possible
  • A login and a password

On demand, you have the possibility to host your file on a Kelkoo FTP server. We will communicate your login and password as soon as your Kelkoo FTP server account will be created.

FTP upload using Internet Explorer

You may use a FTP program (for instance FileZilla) or follow these steps (using internet explorer):

  1. Type in the following URL including username and password: ftp://username:password@ftpkelkoo.kelkoo.net/ (username/password need to be changed into the values provided by Kelkoo)
  2. You should then be logged in like this:
    product data feed ftp transfer
  3. The next step is to open a FTP site in Windows Explorer. Press Alt, click View, and then click Open FTP Site in File Explorer.
  4. You will then be prompted again for the username and password. Type in the provided values given by Kelkoo. The two steps look like this:
    product data feed ftp transfer for IE
  5. After opening the FTP Site, you are ready to upload your file. This can be done by either drag and drop, or copy paste into the FTP folder from your local folder.
  6. After either drag and drop or copy paste, you should see a confirmation that the file is being uploaded.

The Product data feed has now been uploaded successfully to your FTP account and you can inform your technical contact at Kelkoo.