Manual for Icecat CSV Interface

Alexandr Kravtsov
By
open-csv-optimized

This document describes the CSV (Comma-Separated Values) variant of Icecat’s Open Catalog Interface: a set of standards, data structures, files and functionalities for the exchange of product data.

Icecat provides customers with the ability to download CSV product data by

  1. using a real-time call based (URL) interface to access product data-sheets
  2. generating personalized or customized CSV files based on your catalog
  3. through direct access to our Icecat Data indexes and repositories

In this post, we describe only (1) the real-time calls to CSV data-sheets. Generating personalized files is discussed separately. In case of 3, check out the documentation for the Icecat XML Data Interface, as the same directories also contain CSV variants of index files, which can be used to retrieve product data-sheets in CSV format.

Other available interfaces are:

In general, we advise to use the XML (or JSON) interfaces for downloading Icecat data-sheets. Interfaces based on these data formats are most robust, provide you with most flexibility and provide you with the most complete data set per product. However, sometimes the use of a CSV format is easier and more pragmatic, depending on the capabilities of the e-business infrastructure of your company.

In case that you need more information or have questions, don’t hesitate to contact us.

Our Global Mission

Icecat’s global mission is to provide e-commerce partners with high-quality product information that helps their buyers make better purchase decisions, in any world language, in any country and on any device or media.

Advantages of upgrading to Full Icecat

The CSV interface may be accessed by all Icecat Data (XML) users using at least an Open Icecat account. Open Icecat users can access the data of the sponsoring brands.
Full Icecat users can access the data of all brands in the Icecat database.

However attractive the free Open Icecat database is, the Full-Icecat database still contains many, many more brands: 10,000s (see https://icecat.biz/menu/vendors/index.htm). If you want specific brands to be included into free Open Icecat, please, recommend Icecat to your manufacturer contacts.

Read more about the main advantages of Full Icecat over free Open Icecat.

If you want to upgrade to Full Icecat, please contact us via the contact form, or click on the “request Full Icecat access” link after the User Login.

International Standards Supported

Apart from JSON, Icecat is compliant with an increasing number of international standards. See, here a quick overview of such supported standards.

Open Icecat Fair Use Policy

The user of Open Icecat product data (in a free Open Icecat subscription or as part of the Full Icecat data) is required to respect the Open Icecat Fair Use Policy.

Explicitly relevant for website development is:

  • to mention explicitly the “Specs Icecat” on all product datasheets, with a link to the Icecat.biz web site
  • to include explicitly an “AS IS” disclaimer, an example of which can be found at https://www.icecat.biz/menu/disclaimer/index.htm (available in several languages).

1. Real-time CSV interface

The Icecat CSV product data-sheet consists of following columns:

Column titleExplanation
Requested_prod_idManufacturer’s product identifier used in your product feed
Requested_GTIN(EAN/UPC)Requested numerical GTIN (EAN/UPC) code from your product feed
Requested_Icecat_idRequested numerical internal Icecat identifier from your product feed
ErrorMessageContains a textual explanation (not an error code!) why the system did not provide information on requested identifiers
SupplierProduct’s brand or manufacturer name
Prod_idManufacturer part number
Icecat_id (product_id)Internal numerical product identifier used in the Icecat database
GTIN(EAN/UPC)GTIN(EAN/UPC) codes that corresponds to a product
CategoryCategory name
CatIdNumerical category identifier
ProductFamilyProduct family name
ProductSeriesProduct series name
ModelProduct or model name
UpdatedThe date of the most recent change of product data-sheet in Icecat
QualityProduct quality indication
On marketOn market indicator
Product viewsNumerical value that shows number of data-sheet views in Icecat
HighPicLink to high resolution of main product image
HighPic ResolutionMain product image resolution
LowPicLink to low resolution product image
Pic500x500Link to medium (500px) resolution image
ThumbPicLink to thumbnail image
Folder_PDFLink to PDF leaflet
Folder_Manual_PDFLink to PDF manual
ProductTitleProduct title
Short descShort editorial description of product data-sheet
ShortSummaryDescriptionAutomatically generated short summary description
LongSummaryDescriptionAutomatically generated long summary description
LongDescMarketing text
ProductGalleryLinks to gallery images separated by comma
ProductGallery ResolutionResolution of product gallery images (separated with | symbol, if several)
360Content type with a 360 degree (or so called 3D) product view
EU Energy LabelEU Energy Label
EU Product FicheEU Product Fiche (PDF or html data-sheet)
PDFPDF files
Video/mp4Product videos
Other multimediaOther multimedia content types
ReasonsToBuyReasons to buy (feature bullet descriptions)

Columns with product specifications are included and have column headers such as “Spec #”, so that each new specification (feature) is included in a new column in the output CSV file. The number of specifications depends on the number of spec values in the respective product data-sheet. A cell with a specification value consists of a spec name, spec value and a measure unit (if present).
Those columns also contain spec group names. Spec groups consist of multiple specs, which are grouped under its respective spec group, to make reading a spec table more easy for a buyer.

Example:
Column header – Spec 1
Value – Processor

Column header – Spec 2
Value – Processor clock speed: 3.2 GHz

Column header – Spec N (where N is any spec number)
Value – Display

Column header – Spec N+1
Value – Display diagonal: 17”
Where:
Processor, Display – spec groups
Processor clock speed, Display diagonal – feature names
3.2, 17 – feature values
GHz, “ – units

Example string from CSV, where the spec groups “Design” , “Processor” and “Memory” are marked red:

"Design","Product type: Notebook","Colour of product: Black, Silver","Form factor: Clamshell","Processor","Processor clock speed: 1.3 GHz","Processor family: AMD E","Processor model: E2-3800","Processor cores: 4","Processor threads: 4","Processor cache: 2 MB","Memory","Internal memory: 8 GB","Internal memory type: DDR3-SDRAM","Maximum internal memory: 16 GB","Memory form factor: SO-DIMM",……..

2. URL call format

The Icecat real-time CSV interface, supports URL requests by:

  • GTIN (EAN/UPC) code(s)
  • GTIN (EAN/UPC) code(s) + category (id)
  • Brand Product Code + Brand (vendor name)
  • Brand Product Code + Brand (vendor name) + category (id)
  • Icecat internal numerical product identifier(s) (icecat_id)
  • Icecat internal numerical product identifier(s) + category (id)

Please, find a more detailed description of each parameter below:

  • ean_upc – GTIN (EAN/UPC) code (one or several separated by comma)
  • prod_id – manufacturer product code or comma separated list of product codes or alternative manufacturer product codes that are on the market and are mapped to an Icecat data-sheet (m_prod_id)
  • brand – the manufacturer’s brand name (including alternative brand names present in the Icecat supplier mappings)
  • icecat_id (product_id) – unique internal Icecat identifier of a product data-sheet, which can also be provided as a comma separated list
  • lang – the language identifier (Icecat returns the EN data-sheet by default if no lang is selected in the URL request)
  • cat – an optional, but advised parameter, where user may add the Icecat numerical identifier of a product category to reduce the probability of unexpected data-sheets
  • output – the type of output (Enter “productcsv”Icecat returns product XML if no output type is provided)

Important: Red marked parameters are mandatory. A request only with ean_upc or icecat_id (product_id) without vendor and brand name is recognizable by the system and will return a datasheet.

Below you may find examples of URL calls:
https://data.icecat.biz/xml_s3/xml_server3.cgi?prod_id=;brand=Philips;lang=;output=productcsv
https://data.icecat.biz/xml_s3/xml_server3.cgi?ean_upc=8711500354532,8711500354501;lang=EN;output=productcsv
https://data.icecat.biz/xml_s3/xml_server3.cgi?prod_id=4347B007,8576B064;brand=canon;lang=IT;output=productcsv

3. Access to rich content

Icecat provides access to special type of content – rich media – via XML, xml_s3 and real-time CSV interfaces.
Rich media content can be requested by  the special output parameter: output=richproductcsv

Examples:
https://data.icecat.biz/xml_s3/xml_server3.cgi?product_id=17727188;lang=NL;output=richproductcsv
https://data.icecat.biz/xml_s3/xml_server3.cgi?ean_upc=8710103608011;lang=NL;output=richproductcsv

Note: for certain brands rich media can be restricted to their Authorized Resellers. Contact Icecat, if you think that you miss certain rich media assets that you expected to receive.

4. URL symbols encoding

Since some manufacturer product codes may consist of special symbols like +, #, !, %, _ or space Icecat may process these only if URL encoding of such symbols is included in the URL request.

Examples:
WBE3321A+NFSM = WBE3321A%2BNFSM
3580S4X BNDL = 3580S4X%20BNDL

5. IP Access Limits

Icecat sets up a limit on the number of simultaneous requests from each IP to ensure the stability of the service. Icecat users cannot send more than 25 simultaneous CSV URL requests. Full Icecat users can request CSV URL data only from IP addresses listed in their Icecat account profile. Requests from unregistered IPs are not processed. In such cases system returns an error message.

 

Likethumbsup(5)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