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):
- 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)
- You should then be logged in like this:
- 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.
- 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:
- 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.
- 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.