Export your product and product model data
This article explains how to configure product, product model, and combined product and product model export profiles, and how to define which data gets exported. It covers Global settings, Content tab filters and the specific behavior of the combined export.
To learn how to create, run, or manage export profiles in general, see the Export your data article.
Configure global settings
Once you have created a product or product model export profile, click Edit to configure it. In the Global settings tab, the following properties are available:
| Property | Details |
|---|---|
| Decimal separator | Defines the character used as a decimal separator in the exported file |
| Date format | Defines the format used for dates in the exported file |
| Measurement format | Defines whether measurement units are exported as their code/label or their symbol |
| Delimiter (CSV only) | Defines the character used to delimit fields in the CSV file |
| Enclosure (CSV only) | Defines the character used for field enclosure in the CSV file |
| Number of lines per file (XLSX only) | Defines the maximum number of rows per file for XLSX exports |
| With header | Defines whether the first row of the exported file contains column names |
| Export media | When enabled, all media (from Asset Collection, image, and file Attributes) are exported. The output is an archive containing the file and a media folder. |
| Export with labels | Defines whether exported values display labels instead of codes |
| Headers with labels* | Defines whether column headers display labels instead of codes |
| File locale* | Defines the Locale in which labels are displayed |
| With product UUID (product export only) | Adds the product UUID as the first column. Not available for product model exports. |
| With product completeness (product export only) | Adds the product Completeness ratio for all exported Locales. Not available for product model exports. |
*Only visible when Export with labels is enabled.
If you export with labels instead of codes, the resulting file cannot be re-imported into the PIM.
If the Asset Collection Attributes of your products are linked to Asset Families with a media link Attribute used as main media, exporting the products will not produce an archive. Instead, you will get a CSV or XLSX file with a column containing the URL of the media.
Define what to export
For product and product model exports, an additional Content tab is available. Use it to define precisely which data to export — including filtering by one or several Channels, Locales, Attributes, Family, quality score, date condition, and Category. To learn more, see the Product Export Builder article.
For combined product and product model exports, the same Content tab is available. See the Combined product and product model export section below.
Metric conversion is deactivated when multiple Channels are selected
When you select more than one Channel in the Content tab, metric conversion is automatically deactivated. Measurement values are exported as-is, without being converted to each Channel's measurement units.
Default columns in the exported file
By default, every product export file includes the following columns:
- Main identifier
- Categories
- Enabled
- Family
- Parent (if applicable)
- Groups
- Association types
- Created
- Updated
Association type columns appear in your export file only if at least one of the exported products has had an association at some point. To guarantee association columns always appear regardless of product data, use a Tailored Export profile and explicitly configure the association columns.
User group rights on product data (Enterprise Edition only)
For product exports, the PIM applies your permissions based on the user groups you belong to:
- If you have no view right on products in a given Category, no information about those products will be exported.
- If you have no view right on a given Attribute Group, Attributes in that group will not be exported.
- If you have no view right on a given Locale, no product data for that Locale will be exported.
To learn more, see the Access rights on products article.
Combined product and product model export
The combined product and product model export is available for Advanced and Premium customers only. It is not supported in Tailored Export or Quick Export.
The combined export allows you to export both products and product models into a single CSV or XLSX file, preserving the full hierarchical structure of your catalog in one operation.
This is particularly useful when you need to:
- Export a complete catalog hierarchy (product models, sub-models, and variants) in a single file
- Share a full product structure with third parties or downstream systems
- Re-import enriched product and model data back into the PIM in one step
Understand the combined export file structure
The exported file organizes rows in depth-first hierarchical order:
- Product model A
- Sub-model A1 (child of A)
- variant products belonging to A1
- Sub-model A2 (child of A)
- variant products belonging to A2
- Sub-model A1 (child of A)
- Product model B…
Every row includes an entity_type column as its first column (product or product_model). The uuid column is filled for products and empty for product models. The code column is filled for product models and empty for products.
Column order: entity_type → code → uuid → main identifier → Family → Family variant → parent → Categories → enabled → groups → association types → remaining Attributes (alphabetical).
Create a combined export profile
To create a combined export profile, select one of the following jobs when creating a new profile:
- Product and product model export in CSV
- Product and product model export in XLSX
Configure a combined export profile
Once the profile is created, click Edit. The profile contains four tabs: Properties, Global settings, Content, and History.
In the Properties tab, edit the label and configure a storage destination.
In the Global settings tab:
| Property | Details |
|---|---|
| Decimal separator | Defines the character used as a decimal separator in the exported file |
| Date format | Defines the format used for dates in the exported file |
| Measurement unit format | Defines whether measurement units are exported as their Code or their Symbol |
| Delimiter (CSV only) | Defines the character used to delimit fields in the CSV file |
| Enclosure (CSV only) | Defines the character used for field enclosure in the CSV file |
| Number of lines per file (XLSX only) | Defines the maximum number of rows per file. Default: 10,000. |
| With header | Defines whether the first row of the exported file contains column names. Enabled by default. |
| Export media | When enabled, all media are exported as an archive. Enabled by default. |
| With labels | When enabled, exported values display labels instead of codes. Disabled by default. |
| Headers with labels* | When enabled, column headers display labels instead of codes |
| File locale* | Defines the Locale in which labels are displayed. Required when With labels is enabled. |
*Only visible when With labels is enabled.
If you export with labels instead of codes, the resulting file cannot be re-imported into the PIM. Always export with codes if you intend to use the file for re-import.
In the Content tab, define exactly which data to export. You can filter by channel, locales, attributes, family, quality score, date condition, and category.