Filtering and analyzing large datasets can be a challenge. Whether you’re trying to pinpoint specific product sheets or need to extract data based on unique identifiers, knowing how to navigate and filter this information efficiently is crucial. In this blog post, we’ll guide you through the process of using Excel to filter data from Icecat’s CSV files.
Open Icecat: https://data.icecat.biz/export/freexml/<Lang_Code>/files.index.csv.gz
Full Icecat: https://data.icecat.biz/export/level4/<Lang_Code>/files.index.csv.gz
The list of the codes can be checked here: https://iceclog.com/icecat-locales-and-language-code-table/
path
– The path to the productsheet, can be in level4/ or freexml/ folder.product_id
– Icecat internal unique identifier.updated
– last modification time in format YYYYMMDDHHMMSSquality
– product quality (Icecat, Supplier). For deleted products quality is REMOVED.supplier_id
– Brand ID, can be matched with SuppliersList.xml.gzprod_id
– MPNcatid
– Category ID, can be matched with CategoriesList.xml.gzm_prod_id
– Mapped MPN for the same product. If there is> 1 mapped MPN, the product row is duplicated for each new mapped MPN. What is mapping?ean_upc
– GTINon_market
– If the product is available on the market in the current locale. 1 for true, 0 for false. Only active products can be found here: on_market.index.csv.gzcountry_market
– Active markets for the product, separated with “;”.model_name
– A brief marketing name of a product.product_view
– Product ratinghigh_pic
– Main product imagehigh_pic_size
, high_pic_width
, high_pic_height
– Main product image resolutionm_supplier_id
– ID of the mapped productm_supplier_name
– Brand of the mapped productean_upc_is_approved
– If GTIN is confirmed by its provider.Limited
– Brand limitation on the productDate_Added
– Date when the product first appeared in the Icecat database.ean_upc_format
– How many digits the GTIN containsBrandID |
---|
1 |
2 |
3 |
2. Follow the steps shown above and once the files.index.csv is uploaded click on New Source
3. Upload the list of values as a second source
4. Transform the column of values into List entity using Transform → Convert To List
5. Return to files.index.csv Data, then use the Excel formula to filter the values based on the list of values you provided. For instance, here is the formula to filter the SupplierID on the external list: = Table.SelectRows(#"Changed Type", each List.Contains(Sheet1, [supplier_id]))
6. The general formula is: = Table.SelectRows(#"Changed Type", each List.Contains(<LIST_NAME>, [<COLUMN_TO_MATCH>]))
Icecat's commitment to reducing plastic use is driven by a strong responsibility towards the environment…
Retail media is making a strong comeback, not as a passing trend but as a…
Motorola, a global leader in technology and innovation, partners with Icecat. Renowned for its iconic…
Español debajo ↓ We are excited to announce that the Icecat team will be visiting…
For small businesses looking to scale, the complexity and inefficiency of systems and processes can…
¿Listo para crear, personalizar y distribuir el contenido de tu marca desde una sola plataforma?…