This document describes the manual for Icecat CSV interface (Comma-Separated Values) variant of Icecat’s Open Catalog. 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:
In this post, we describe only (1) the real-time calls to CSV data-sheets. Generating personalized files is discussed separately. In the 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 using the XML (or JSON) interfaces for downloading Icecat data-sheets. Interfaces based on these data formats are most robust, provide you with the 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.
Please, note that some brands have a restrictive syndication policy, in which they allow access to certain digital assets or other product data only to authorized resellers. In general, it is therefore good to request authorization from brands with which you have established formal relations via the Icecat website.
In case you need more information or have questions, don’t hesitate to contact us.
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, and get a free Vendor Central (PIM) service included.
However attractive the free Open Icecat database is, the Full-Icecat database still contains more than 10,000s brands. If you want specific brands to be included in free Open Icecat, please, recommend Icecat to your manufacturer contacts.
Read more about the main advantages of Full Icecat over free Open Icecat. In case you need higher catalog coverage, you will need Full Icecat. For more information, see the Icecat Subscription Plans.
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.
Apart from JSON, Icecat is compliant with an increasing number of international standards. See, the quick overview of such supported standards.
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:
The Icecat CSV product data-sheet consists of following columns:
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 measuring 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 easier for a buyer.
If an user wants to get CSV file in the format when the feature names are in the header, he/she should use the a specific key: “wide_features_format=1” at the end of the URL that calls CSV file.
Column header – Spec 1Value – Processor
Column header – Spec 2Value – Processor clock speed: 3.2 GHz
Column header – Spec N (where N is any spec number)Value – Display
Column header – Spec N+1Value – Display diagonal: 17”Where:Processor, Display – spec groupsProcessor clock speed, Display diagonal – feature names3.2, 17 – feature valuesGHz, “ – 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",……..
See also Digital Asset Types as Represented in Icecat’s Open Catalog Interfaces.
The Icecat real-time CSV interface, supports URL requests by:
Please, find a more detailed description of each parameter below:
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=productcsvhttps://data.icecat.biz/xml_s3/xml_server3.cgi?ean_upc=8711500354532,8711500354501;lang=EN;output=productcsvhttps://data.icecat.biz/xml_s3/xml_server3.cgi?prod_id=4347B007,8576B064;brand=canon;lang=IT;output=productcsv
In case user wants the feature names to have as titles of the columns: https://data.icecat.biz/xml_s3/xml_server3.cgi?prod_id=4347B007,8576B064;brand=canon;lang=IT;output=productcsv;wide_features_format=1
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
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.
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%2BNFSM3580S4X BNDL = 3580S4X%20BNDL
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.
Read further: Manuals, manuals
Hello we have a problem. We have full ice cat subscription. BUT When we are trying to get a request for a file with prod_id , message appears "The requested XML data-sheet is not described in the Ice cat database" . But on the web-site its exist why ? and sometimes we have such message "the requested product exist only in Full Ice cat " But we have access to full ice cat why it happens also ?
We replied to Dmitry as he had made his question product specific.
Same problem with me Full icecat subscription
You are matching products based on the brand name + the product code and GTIN. In case the respective GTIN is attached to a different product (not described one) in the Icecat database, the system gives you the result based on the GTIN identifier. So you get the message that product is not described. We are working now to improve this logic. Meanwhile, you can try to match your product feed based only on the brand name + the product code.
Hi, I am trying to import the gallery via link - do I need any special permissions? I've whitelisted my server IP but it seems to fail at this stage, can you advise please? I am trying to import data fields into WordPress which works, EXCEPT gallery. Thank you.
No special permission are needed. You can test individual links in your browser.
Hi there! How do you find a list of Brand (vendor name) that can be used please?
We have a list of products and their associated vendor name, eg HP. However you use HP while we use HP Inc. so we would need a list that we can create a cross reference table for.
Thanks in advance.
Hi Jamie, Thanks for your response. Which country are you established in? Based on that a responsible country manager will contact you. Regards, Wouter
Hi, We host the webshop of one of your Spanish customers. For some reason images aren't displayed. For example: http://images.icecat.biz/img/gallery/2226_4159158186.jpg is displayed http://images.icecat.biz/img/gallery/36687746_3478561051.jpg isn't displayed
Do you have any thoughts about this.
Looking forward to your answer.
Probably a Full Icecat image. Make sure that you download the image to your own server.
Your email address will not be published. Required fields are marked *