Export your data

Summary

Overview

This feature allows you to provide your product information to third parties like e-commerce platforms, mobile applications, suppliers, or simply to extract information from the PIM for your own use.

You have two ways to export your product information:

  • Manual download: execute the job from the PIM user interface, then download the generated file.
  • Automatic delivery: set a file path in the export profile configuration so the PIM drops the file automatically when the job runs.

When exporting data, Akeneo PIM extracts data from the PIM and converts it into a specific format, either as a file or directly to a third-party application (e.g., Magento).

Exports support two file formats: CSV and XLSX.

You can export product data and catalog entities such as families, categories, and attributes.

Steps of an export

The export process is straightforward:

  1. Create an export profile (see below for more information)
  2. Launch a CSV or XLSX file export

What is an export profile?

An export profile defines how an export will be performed. Each profile is based on:

  • A code to uniquely identify the profile
  • A job that defines what will be exported and in which format (e.g., a category export in XLSX, a product export in CSV for Magento)
  • A set of configuration fields available as a form in the PIM. Each profile can have its own configuration.

Browse your export profiles

To view the available export profiles:

  1. Log in with a user account with permission to View the list of profiles for exports
  2. Go to the Exports menu
  3. To narrow down the list of displayed export profiles, use the available filters above the grid or the search bar (searches on the label)

To see the details of an export profile, click on the relevant row in the grid.

Create a new export profile

To create a new export profile:

  1. Log in with a user account with Create an export profile permission
  2. Go to the Exports menu
  3. Click on Create export profile
  4. Fill in all required fields in the pop-up window:
    • A unique code
    • A label to identify the profile more easily
    • A job according to what you wish to export
  5. Click Save to finalize the profile creation. The profile page is then displayed and you can configure it.

Update an export profile

To update an export profile:

  1. Log in with a user account with the relevant permissions
  2. Go to the Exports menu
  3. Click on the export profile to modify
  4. Click the Edit button
  5. Make your changes
  6. Click Save to update the profile

In the General properties tab, you can edit the label of your profile. 
In the Global settings tab, available properties depend on the export job. For example, for the XLSX product export, you will find the following properties:

Property Details
File path Defines where to export the generated file (not available in Serenity offer)
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 Defines the character used to delimit fields in the CSV file
Enclosure Defines the character used for field enclosure in the CSV file
Number of lines per file 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 Adds the product UUID as the first column
With product completeness Adds the product completeness ratio for all exported locales

*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, when you export the products, you won't get an archive. You will only export a CSV or XLSX file with a column containing the URL of the media.

For product and published product exports, an additional Content tab is available. Use it to define precisely which products or published products' data to export. To learn more, see the Product Export Builder article.

If a user has no role permission to modify an export profile, any Enterprise Edition user group rights they may have will also be ignored. For example, a user without the Edit profiles of exports permission cannot edit a specific export profile even if their user group grants it.

Duplicate an export profile

To create a new profile based on an existing one:

  1. Select the export profile to duplicate
  2. Click Edit
  3. In the top right corner, click the three dots ... and select Duplicate
  4. Enter a label and a code, then click Save

Download and upload an export profile

To copy an export profile from one instance to another (e.g., from staging to production), you can download its configuration and import it into a new profile on the target instance.

Download an export profile configuration:

  1. Select the export profile to copy
  2. Click Edit
  3. In the top right corner, click the three dots ... and select Download Profile Configuration

Upload the configuration to another instance:

  1. Create a new profile on the target instance
  2. Click Edit
  3. In the top right corner, click the three dots ... and select Import Profile Configuration
  4. Upload the configuration file you downloaded

This functionality is available for:

  • Tailored export
  • Product export
  • Product model export

Permissions and properties are not included in the downloaded configuration.

Run an export

  1. Go to the Exports menu
  2. Click on the export profile to execute
  3. Click the Export now button
  4. The execution page displays and refreshes automatically so you can monitor progress

When the export ends, a notification appears in the top right corner of the PIM.

An email notification can also be sent depending on your user configuration. For further details, please refer to the Manage your account article.

By default, your exported files always contain the following columns:

  • Main identifier
  • Categories
  • Enabled
  • Family
  • Parent (if applicable)
  • Groups
  • Association types
  • Created
  • Updated

If you only want to export specific data, consider using Tailored Export profiles.

With the user groups rights (EE only)

Rights on the product information

For product and published product exports, the PIM applies your permissions based on the user groups you belong to:

  • If you have no view right on products in the Goodies category, no information about those products will be exported
  • If you have no view right on the Marketing attribute group, attributes in that group will not be exported
  • If you have no view right on the de_DE locale, no product data for that locale will be exported

To learn more, see the Access rights on products article.

Rights on export execution

Execution permissions can be configured per export profile. If you cannot launch an export, check that you have the right to run it in the Permissions tab of the export profile in edit mode. See the Access rights on imports/exports article for more details.

 

Combined product and product model export

The combined product and product model export is available for Advanced and Premium customers only. It is available as a dedicated export profile job and 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 removes the need to manage separate export files for each entity type.

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

How the combined export file is structured

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
  • Product model B…

Every row includes an entity_type column as its first column, indicating whether the row is a product or a product_model. The uuid column is always present, filled for products, empty for product models. The code column is filled for product models and empty for products.

Column order in the exported file follows a fixed structure: 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 product and product model export profile, select the relevant job:

  • 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 to configure it. The profile contains the following tabs: Properties, Global settings, Content, and History.

In the Properties tab, you can edit the label of your profile and configure a storage destination.

In the Global settings tab, the following properties are available. The CSV profile includes Delimiter and Enclosure fields; the XLSX profile includes a Number of lines per file field instead.

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 (from asset collection, image, and file attributes) are exported as an archive containing the file and a media folder. 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.