Quick Guide for Real-Time Data (xml, csv) Requests

icecat
By

Because of the size of index files, it is in many cases advised to use real-time data requests. This simplifies the import of Icecat data, as there’s no need for first matching your catalog with Icecat’s very large index files. Especially, in case of smaller, focussed catalogs, it’s more efficient to use the real-time method. A prerequisite is that your catalog contains product identifiers, such as Brand+Part Code, and/or GTIN (EAN, UPC).

If you decide to use – or switch your interface to – real-time Icecat Data requests, you effectively bypass the (very large) index files. In your requests you only need to download data that is present in your product catalog, and therefore this method is very efficient. We would advise to always evaluate the real-time method first, as it will avoid downloading the very large index files.

The description below is based on section 2.2. of the Icecat XML manual:
https://www.icecat.biz/forum/getAttachment/?attachment_filename=3331

Links to call real-time product data

Examples links, if you need to get an xml file of product ‘Compaq 6710b Base Model Notebook PC’.
Manufactured by HP, with part number RJ459AV, in English, the call will be:

https://data.Icecat.biz/xml_s3/xml_server3.cgi?prod_id=RJ459AV;brand=hp;lang=en;output=productxml

In case you want to retrieve data on the basis of a GTIN code (EAN or UPC).

https://data.Icecat.biz/xml_s3/xml_server3.cgi?ean_upc=4960999358246;lang=en;output=productxml

An example of the English standardized version of Canon 1447B006:

https://data.Icecat.biz/xml_s3/xml_server3.cgi?prod_id=1447B006;brand=Canon;lang=en;output=productxml 

The general format of the call is:

https://data.Icecat.biz/xml_s3/xml_server3.cgi?prod_id=<product code brand>;brand=<brand name>;lang=<language code>;output=<output>

or

https://data.Icecat.biz/xml_s3/xml_server3.cgi?ean_upc=<GTIN code>;lang=<language code>;output=<output>

Where:
prod_id: the manufacturer product code of the requested product,
brand: name of the manufacturer or brand of the requested product,
ean_upc: the EAN or UPC code to identify a product,
lang: the language or locale code like EN, NL, FR, DE-CH, see the complete language/locale table,
output: the type of response. It can be productxml (the product XML file), productcsv (the product CSV file), richproductcsv (for rich media assets associated to the product) and metaxml (the index or meta information on the Brand + ProdID/M_Prod_ID or EAN/UPC).

For more information on real-time CSV access see the Icecat CSV manual, which is a variant of the calls above.

Call by Icecat ID

If you call by Icecat ID, the most efficient calls are in case of Open Icecat:

https://data.icecat.biz/export/freexml/en/29627732.xml

or in case of Full Icecat subscriptions:

https://data.icecat.biz/export/level4/en/29627732.xml

Where “en” can be replaced by any language/locale code. And 29627732 is de unique Icecat ID for a product. Icecat IDs are retrieved from the Icecat index files, as explained in the complete XML documentation.

Also the xml_s3 service can be used, but is slightly less efficient:

https://data.Icecat.biz/xml_s3/xml_server3.cgi?product_id=<Icecat product code>;lang=<language code>;output=<output>

Example:

https://data.Icecat.biz/xml_s3/xml_server3.cgi?product_id=29627732;lang=en;output=productxml

Access rights

Take care that in case  of Full Icecat, your IP addresses from where you request data are listed in your user profile.
Use the Icecat access credentials that you receive upon (free) registration.

You have data access depending on your subscription: Open Icecat versus Full Icecat, Data versus URL, and the languages or locales to which you are authorized.

Likethumbsup(2)Dislikesthumbsdown(0)

  • commented on October 25, 2016 by Francesco

    Hello, which is the best method to collect all products id?
    We have many different between https://data.icecat.biz/export/freexml.int/ and https://data.icecat.biz/export/freeurls/

    Should not have the same list of products?

    Likethumbsup(0)Dislikesthumbsdown(0)
  • commented on October 27, 2016 by Gloria Serafini

    Hi Francesco,
    You should use https://data.icecat.biz/export/freexml.int/. Here, you can find product IDs to all Open Icecat datsheets (the daily index is default) and links to the related XMLs. Product_ID is the Icecat ID, while Prod_ID is the Manufacturer Part Number (MPN) or product code.

    Likethumbsup(0)Dislikesthumbsdown(0)

Leave a Reply

Your email address will not be published. Required fields are marked *

open-live-optimized

Manual for Icecat Live: Real-Time Product Data in Your App

Icecat Live is a (free) service that enables you to insert real-time product content from some 300 m...
 June 1, 2016
World map

Iceclog Launch and Improved Icecat LIVE Documentation

“Iceclog” (Icecat content-log) is our new blog, where you will find...
 August 26, 2016
http url

Manual for Icecat URL: Links to Product Data-sheets and Images

Version: 1.20, October 4, 2016.The purpose of this post is to explain the Icecat URL method to ...
 October 4, 2015
open-csv-optimized

Manual for Icecat CSV Interface

This document describes the CSV (Comma-Separated Values) variant of Icecat's Open Catalog Interface...
 September 28, 2016
wall-writer-in-action

Iceclog Editor Guidelines: Writing Compelling Posts

The Iceclog Editor Guidelines are a quick guide for contributors to the Iceclog blog or "cl...
 August 17, 2016
open-personalized-csv-optimized

Manual for Personalized Interface File and Catalog

Via the Icecat website and login area, a user can generate personalized or customized CSV or Excel f...
 October 5, 2016
apple_watch_series1

Apple Watch: a Useful Tool or a Smart Toy?

After six months spent with my Apple Watch, I am still not sure if I consider it a useful tool or "j...
 September 30, 2016

Manual for Testseek Product Reviews Integration via Icecat

Icecat provides aggregated expert reviews from our partner Testseek, as an add-on service for both O...
 October 19, 2015

Manual for Open Icecat JSON Product Requests

JSON (JavaScript Object Notation) is an increasingly popular means of transferring to data, comparab...
 February 17, 2017
ball-752070_960_720

FAQ for Brand Owners

Icecat is an independent global syndicator of rich product content. In...
 October 19, 2016