Enriched Product Export
What the Enriched Product export contains and the meaning of each field.
Overview
The Enriched Product export contains your product catalogue alongside data extracted automatically from each item's public product page URL. For every field that can be enriched, the export shows both the value stored in your catalogue and the value found on the product page (in the enriched_ columns), so you can compare them and spot missing or outdated catalogue data.
Each product and each product variant is written as its own row: product rows have the product_identifier column filled in, while variant rows have the variant_identifier column filled in instead. Items without a product page URL, or whose page could not be read, have empty enriched_ columns.
Generating the Export
Navigate to Settings → Files → Exports and create a new export with the type Enriched Product.
Filters
| Filter | Description |
|---|---|
| Language | Language for translated fields such as name and description; defaults to your current language. |
| Extract from | Where enriched data is read from: the fully rendered product page (browserHtml, the default) or the raw page response (httpResponseBody). |
You can optionally set a row limit to cap the size of the export.
The stock, always_available and lead_time column names are suffixed with the code of the country you are currently operating in (for example stock_US), and the values reflect stock information for that country.
Fields
| Column | Description |
|---|---|
product_identifier | Your unique identifier for the product; empty on variant rows. |
variant_identifier | Your unique identifier for the product variant; empty on product rows. |
name | Name of the product or variant in your catalogue, in the selected language. |
enriched_name | Product name extracted from the product page. |
sku | Stock keeping unit in your catalogue. |
enriched_sku | SKU extracted from the product page. |
manufacturer | Manufacturer of the product; variant rows show the parent product's manufacturer. |
brand | Brand in your catalogue. |
enriched_brand | Brand name extracted from the product page. |
enriched_image_url_1 … enriched_image_url_5 | URLs of up to five images found on the product page. |
unit_size | Size of one unit (e.g. pack quantity or volume). |
unit_label | Label describing the unit (e.g. each, box, litre). |
product_page_url | URL of the product page the enriched data was extracted from. |
description | Description in your catalogue, in the selected language. |
enriched_description | Description extracted from the product page, as HTML. |
stock_<country> | Quantity in stock for the country in the column name; empty if no stock record exists. |
always_available_<country> | Yes means the item is always available in that country regardless of the stock quantity; otherwise No. |
lead_time_<country> | Lead time in days for that country. |
mpn | Manufacturer part number in your catalogue. |
unspsc | UNSPSC classification code. |
unspsc_version | Version of the UNSPSC code set the code belongs to. |
upc | Universal Product Code. |
ean | European Article Number. |
itf-14 | ITF-14 packaging barcode. |
jan | Japanese Article Number. |
cas | CAS registry number (chemical substances). |
inchi | IUPAC International Chemical Identifier. |
inchikey | Hashed InChIKey form of the chemical identifier. |
enriched_mpn | Manufacturer part number extracted from the product page. |
properties | All catalogue properties as a comma-separated list of (name, value) pairs, in the selected language. |
enriched_property_name_1 / enriched_property_value_1 … enriched_property_name_30 / enriched_property_value_30 | Name and value pairs for up to thirty additional properties found on the product page. |