Product Export
What the Product export contains and the meaning of each field.
Overview
The Product export contains your full product catalogue. 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. The export includes names and descriptions in the selected language, stock availability for the country you are operating in, classification and identification codes, properties, and image and document links.
Typical uses include reviewing and auditing your catalogue offline, sharing product data with customers or colleagues, and preparing bulk updates.
Generating the Export
Navigate to Settings → Files → Exports and create a new export with the type Product.
Filters
| Filter | Description |
|---|---|
| Language | Language for translated fields such as name and description; defaults to your current language. |
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 the selected language. |
sku | Stock keeping unit of the product or variant. |
manufacturer | Manufacturer of the product; variant rows show the parent product's manufacturer. |
brand | Brand of the product or variant. |
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 on your own website, if provided. |
description | Description of the product or variant, in the selected language. |
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. |
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. |
properties | All product properties as a comma-separated list of (name, value) pairs, in the selected language. |
image_url_1 … image_url_5 | URLs of up to five product images. |
document_name_1 / document_url_1 … document_name_5 / document_url_5 | Name and URL pairs for up to five attached documents. |
created_at | Date and time when the product or variant was created. |
updated_at | Date and time when the product or variant was last updated. |