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

icecat
By
October 20, 2016

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:

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

or

http://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:

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

or in case of Full Icecat subscriptions:

http://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:

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

Example:

http://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 http://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 Icecat Live

Manual for Icecat Li...

Open Icecat Live is a free service that enables you to insert real-time product content from some 30...
 November 8, 2016
http url

Manual for Icecat UR...

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

Manual for Icecat CS...

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

Iceclog Launch and I...

“Iceclog” (Icecat content-log) is our new blog, where you will find...

 August 26, 2016
trademagazine-taitra-taiwan

TradeMag Taiwan: The...

TradeMag in Taiwan interviewed Icecat CEO Hoogeveen and APAC director JJ Jan in its August 17, 2016 ...
 August 19, 2016
Icecat is National Champion in European Biz Awards

Icecat Nominated as ...

Icecat NV has been nominated by the European Business Awards (EBA), within the category of busines...
 September 6, 2016
Full Icecat Live

Manual for Full Icec...

If you use the html variant of Full Icecat Live, you don't need to read this manual. But, in case th...
 August 26, 2016
Smartwatches with searchables

What Etailers Want a...

Etailers and brands have their own view on their products and they subsequently live in their own wo...
 August 10, 2016
Field notes by Beth Kinder

10 Tips for Successf...

Based on the experience of thousands of Icecat and PIM implementations, I distilled the ten most cr...
 August 29, 2016
Product video in Icecat

PIM for rich media a...

There's a whole lot of confusion around the term PIM - Product Information Management system. A lot ...
 August 9, 2016
Putting things together

How a good PIM can u...

Spreadsheets, tons of spreadsheets for a new series launch. For marketeers their recurring nightmar...
 September 1, 2016
Fun's baby doll

Bol.com and Fun work...

Content Supplier Icecat develops a standard for product information for toy brands. The standard for...
 September 6, 2016
FireShot Screen Capture #010 - 'Product data-sheet Cooler Master NotePal Erg_' - uk_icecat_biz_en_p_cooler-master_r9-nbs-e32k-gp_notebook-cooling-pad

Cooler Master offers...

Cooler Master is now providing its Benelux and Nordics c...
 August 12, 2016
checklist manufacturer xml

Checklist for Great ...

Brands like Philips, HP, 3M, Whirlpool and Tefal, start to understand the need for investing in the...
 September 14, 2016
wall-writer-in-action

Iceclog Editor Guide...

The Iceclog Editor Guidelines are a quick guide for contributors to the Iceclog blog or "cl...
 August 17, 2016
language-country-locale-code-table

Icecat Locales and L...

Within Icecat a large number of languages or locales (language and country combinations) are support...
 August 19, 2016
top10_tomtom_cats_q2_2016_2015

TomTom re-entered Ic...

TomTom is a brand in change, which re-entered the Icecat Top 100, as all its fast-growth categories,...
 August 2, 2016
Also holding ag

ALSO acquires Apple ...

ALSO Holding AG (SIX:ALSN) announces that it is in exclusive talks to acquire Dutch Apple and suppli...
 September 2, 2016

Manual for Personali...

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

What Should Etailers...

Bitcoin's hype in 2014, leading to its all-time-high of close to 1200 USD or 900 EUR, has marked t...
 September 19, 2016
apple_watch_series1

Apple Watch: a Usefu...

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
Gigabyte_laptop

Gigabyte adds Where ...

Gigabyte, the Taiwanese PC components and notebook brand, adds Where-To-Buy (WTB) to its UK websit...
 September 23, 2016
Macy's webstore

Macy’s got it:...

Macy's Inc. announces to close 100 of its US stores, 14% of its footprint, to start with locations ...
 August 12, 2016
ecommerce

10 Dos and Don’...

How to successfully manage your new webshop? From social content marketing to check out and shipping...
 October 12, 2016
Update

Reviewing WordPress,...

We selected WordPress as we got positive references, and as it's the most popular open source
 August 31, 2016
NPEX SME Stock Exchange

E-commerce syndicato...

THIS ANNOUNCEMENT DOES NOT CONSTITUTE AN OFFER TO BUY, OR THE SOLICITATION OF AN OFFER TO SELL, SECU...
 November 3, 2016
top10_fast_growth_categories_q2_2016_toys

Electronic toys boom...

The Fast-Growth Categories in Icecat in Q2-2016, are led by electrical, toys, beauty categories and ...
 August 3, 2016

Icecat’s Globa...

Icecat's global mission is to provide e-commerce partners with high-quality product information that...
 September 8, 2015

FAQ for Brand Owners

Icecat is an independent global syndicator of rich product content. In...

 October 19, 2016
Icecat Top 10 Brands Q2 2016

Icecat Top 10 brands...

The leading Icecat Top 1000 brands in Q2-2016 are respectively HP (+15%), Lenovo (+92%) and Philips ...
 August 2, 2016

Open Icecat Fair Use...

A user of Open Icecat will conform to this Open Icecat Fair Use Policy and do its best to avoid to h...
 October 2, 2015
guide-through-difficult-terrain-color

Icecat API Manual Gu...

This Icecat API Manual Guidelines is written to help to increase the usability and consistency of t...
 August 16, 2016
FD Icecat naar beurs

Icecat’s IPO A...

Last week there was abundant response to Icecat's IPO announcement of November 3, 2016. Mainly in th...
 November 6, 2016
Redcoon webshop closed

Is Redcoon closing s...

According to an unconfirmed internal email seen by   October 3, 2016
top10_categories_Q2_2016_notebooks_pc_workstations

All-In-One PCs and N...

All-In-One-PCs and desktop-PCs continue to expand explosively in Q2-2016. Also leading category Note...
 August 3, 2016

Quick Guide for Real...

Because of the size of index files, it is in many cases advised to use real-time data requests. Thi...
 October 20, 2016
Apple down the stairs

Apple versus Verstag...

Verstager, the European Commission's (EC) competition chief, ruled that Apple has to pay it's reason...
 September 4, 2016
Icecat top 10 Fast Growth Brands Q2 2016

Weidmüller and Stud...

The fastest developing E-channel brands in Q2-2016 are connectivity brands Weidmüller and Alcasa, w...
 August 2, 2016
takeaway-thuisbezorgd-ipo

Takeaway.com eyes 1 ...

Takeaway.com, the Amsterdam based meal delivery service, plans its IPO on September 30, at Euronext...
 September 20, 2016
Interview radio Lets talk business

Interview Icecat CEO...

Ron Lemmens of Newbusinessradio.nl/Let's Talk Business interviewed Icecat CEO Martijn Hoogeveen abou...
 November 23, 2016
Iceimport by Iceshop

Connecting to 300 un...

If you want to see stock and prices integrated in your webshop or ERP, Iceimport is a great service....
 October 18, 2016
Japan shopping street

Online Shopping Mark...

If you have never visited Japan, I’m pretty sure you will picture a lot of common stereotypes. For...
 October 31, 2016
Top 10 Brands Icecat Q3-2016

Philips Number 1 Bra...

In Q3, 2016, Philips overtook HP as the number one brand in the Icecat channel monitor. This is the ...
 October 20, 2016
escape room game

Dutch “Identit...

Identity Games, a Rotterdam toys company, offers standardized product information to its e-tailers v...
 October 27, 2016
Sales Manager Position

Icecat is hiring: Sa...

Location: Icecat office Amsterdam Time: Full time Education: Completed Bachelor/University level e...
 September 17, 2016

Manual for Testseek ...

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

Icecat is hiring: Fr...

Published on: October 17, 2016
Location: Amsterdam
Operating schedule: ...
 January 1, 2015
Ecom Pro PIM solutions

Ecom Pro: managing p...

Ecom Pro is helping retailers in The Netherlands to enrich their product data from several sources, ...
 October 19, 2016
website hamburger menu

Changes in the Iceca...

To make Icecat’s website more user friendly, a few changes have be...

 October 8, 2016

Content License Icec...

Version: 1.24 June 30, 2015 THIS CONTENT LICENSE (“License”) is applicable to any content ser...
 June 30, 2015

Open Content License

This document outlines the principles underlying the Open Content (OC) movement and may be redistri...
 October 2, 2015

General Terms &...

Version: January 24, 2014
  1.  January 24, 2014

Sales Manager Position

Icecat is hiring: Re...

Location: Amsterdam
Operating schedule: Full time
Education: Master deg...
 August 17, 2016
Sales Manager Position

Icecat is hiring: Sa...

Location: Amsterdam/Nieuwegein
Operating schedule: Full time
Education:...
 September 17, 2016

E-COMMERCE CONTENT E...

Location: Manila, Philippines
Operating schedule: Full time
Education: ...
 August 17, 2016
RTL7 interview at Business Class

RTL TV interview of ...

Today, was the broadcast in the RTL7 Business Class program of an interview of Martijn Hoogeveen by ...
 November 27, 2016
nordics_flags

Marketing & Sal...

Icecat is looking for an enthusiastic trainee, fluent in one of the Scandinavian languages, to expan...
 August 28, 2016