Via the Icecat website and login area, a user can generate personalized or customized CSV or Excel files that only contain product data for products that are relevant for your company or process. It helps to simplify your implementation process. The personalized files that are generated by Icecat in CSV or Excel format contain both the basic information and rich media assets of the Icecat product data-sheets matching your catalog. To obtain personalized files, you first need to upload your catalog or price file via the User Login area.
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.
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 CSV interface may be accessed by all Icecat Data (XML) users – free or paid. 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 are interested in subscribing to the Full Icecat database, please contact us via the website. If you want specific brands to be included into free Open Icecat, please, recommend Icecat to your manufacturer contacts.
What are 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.
The following CSV conventions are followed in Icecat’s CSV output files:
Column separator: , (comma) Line break: \n Quote symbol: “ Escape symbol: “ Optional quotation: N
To generate unique personalized CSV files, the Icecat system requires a product feed (a product catalog or price file) from a user. It could be a CSV, XML or Excel (XLS or XLSX) file, with at least the main product identifiers for matching purposes:
The quality of your product feed is one of the main factors that determines the quality of the Icecat match.
NOTE: uploading XML product feeds might require support from Icecat. CSV or Excel product feeds hardly ever require support.
Here, you can read more about relevant product feed file formats and structures: CSV: https://en.wikipedia.org/wiki/Comma-separated_values Excel: https://en.wikipedia.org/wiki/Microsoft_Excel_file_format#File_formats
Based on the product identifiers described above, the Icecat system is performing a match between your product feed and the Icecat database. Icecat automatically adds product information to your matching data and generates customized files that can be downloaded from the «My Icecat» page in CSV or XLS and can be used for your e-business purposes. The download can be manual or fully automated.
Icecat generates the following types of personalized CSV output files:
Using the PIF might simplify your implementation process by outsourcing the matching process to the Icecat platform.
The PIF is a customized index file that contains basic information about matched product data-sheets like product identifiers such as internal product ID, part code, and GTIN (EAN/UPC), and paths to Icecat Data or URL links, based on your subscription. The PIF can be used for accessing data-sheets in any data format, such as Icecat CSV, Icecat XML, Icecat JSON or Icecat Live.
Optional is a field for “internal product identifier”. Its presence in the PIF might in some cases simplify the process of data processing for you. It allows you to match an Icecat data-sheet by your company’s own internal product ID.
The last column Path contains a link to product data-sheet that the Icecat system generates based on the subscription type (e.g., URL links or XML Data) associated to your Icecat account, and the associated authorization for certain local repositories.
The PCF is a customized file with detailed information per matched product. This type of file is available only to users with an Icecat Data subscription. Icecat supports two different options of this file: – PCF without spec names as column headers (default option)
– PCF with spec names as column headers (default option)
If you are interested in getting second option, please click on icon near “Personal catalog file (CSV)” block title. System will save your decision, so next time your PCF will have exactly the same structure as you have chosen.
You can also read more about additional functions available in user panel below in 4. User Interface
The first three columns contains the information for your information that allows you to understand on what basis Icecat system found a matching between an item from your file and product from Icecat database.
The rich media assets (CSV) refer to a customized CSV file with links to media assets per Icecat product data-sheet that was matching your feed. This type of file is available only to users with a Data (or XML) subscription.
Rich media file content:
This paragraph provides description of CSV-related interface that located in “My Icecat” panel. Every Icecat user have access to that panel where Icecat hosts many useful features and functionalities.
To get to “My Icecat” user panel please open our website and click “Login” at the upper right corner. Please enter your login name and password or click Register as new new user (free) to register. User panel contains a tab that visible to every Icecat user – “My downloads”. For XML users this tab separated on two parts.
The left area called “XML content” and contains a general information of your XML subscription:
The right area called “CSV personalized content” and consist of following information:
This section provides a step-by-step guide to get personal CSV files.
Please, also assign the column with your internal unique product identifier in your product feed, if applicable.
If the preview is not visible to you, please check if the file format of your product feed is correct or contact us for support.
Read further: Manuals, CSV, excel, Icecat, open catalog interface
Does you service allow me to do an EAN lookup by product name?
I have a XML/CSV file with a couple of thousand product names & brands which I need to lookup/match the correct existing EAN. Preferably by bulk uploading CSV.
Is it possible with your system? Do i need to register for a full Icecat for that?
Please let me know.
Thanks in advance. Miler
Yes it does. We reply to you separately.
I'm trying to create csv with icecat, the truth is not clear when I ask that suva file from my pc I do not understand if it should be empty or full of products ando super lost if someone could show video or pass me a sample csv.
Dear Joaquin, thanks for your comment. We should better understand your path. Please contact us and we will support you. Kind Regards, Gloria
We also have so many laptop batteries and adapters for selling, but really I do not find the correct way to upload,how to upload the price list and product detail. I think it must has a templet there,where is it?
In section 2 you describe that a dedicated list of product codes and/or EAN is necessary for individual download. Is there also a possibility to get all products by e.g. brand name?
Thanks in advance
Yes, use a "batch" interface https://iceclog.com/manual-how-to-import-product-content-into-your-webshop-via-icecat/ from the index you can select the brands that you want. Probably, handy to limit to market as well.
Hi Julie, thanks for your message! You can actually follow step-by-step this guide, namely at point #5. If you have questions on how to go ahead with uploading your price list, please contact us
Is there a possibility to force PIF creation after uploading new price list, not via the icecat interface, but via an API call / URL request?
Hi Remi, yes there is. Please, contact your account manager.
I am in UK and need full products catalogue. what do i need to do to get it regularly on json format. please advice
You can register here for free https://icecat.biz/en/authorization . (Your comment had been forwarded internally already before)
I generated a csv file based on my supplier data, and the file generated is 1.34 gb csv, when I download it, it downloads too fast for a 1.34 gb file so not surprisingly the file is corrupt. What could be the problem?
Thank you Younes
I will send you an email to understand the problem better and put you in contact with the right person to help you solve it.
Kind Regards, Laura
Your email address will not be published. Required fields are marked *
This site uses Akismet to reduce spam. Learn how your comment data is processed.