What's new in Serenity EE & GE?
Discover our features per version

Heads up! This is the documentation for our Akeneo Serenity Enterprise and Growth editions. Serenity clients benefit from exclusive access to our latest PIM features. If you're interested in other versions, click on the drop down menu on the top right corner or check out everything you need to know about your version.

Quick export your products

#What?

Akeneo allows you to export your search result or a selection of products from the PIM grid to a CSV file or a XLSX file. This can be used to retrieve structured product information and thus create your own reports, graphics, etc.

#How?

To start the export of product information from the products' grid:

  1. Search for products in the grid with the appropriate filters
  2. Select the products on which you want to perform the operation via the selection tool: all the products recorded, all visible products from the ongoing page, none of the products and the products for which you have ticked the 1st column Bulk action
  3. Click on Quick Export at the bottom of the screen.
  4. On the pop-up that opened, select the relevant options:
    • CSV to generate CSV (comma-separated values) files
    • XLSX to generate XLSX (Microsoft Excel) files
    • Grid context to generate files according to your current view
    • All attributes to generate files with all your product attributes
    • With codes to define if the export file displays values' codes instead of values' labels.
    • With labels to define if the export file displays values' labels instead of values' codes.
    • Without media to export the attribute values except the media (from asset collection, image, or file attributes)
    • With media to export the attribute values including the media (from asset collection, image, or file attributes) Quick Export checkboxes
  5. In the top-right corner, click on Export

To save time, your selections are stored in your local session. It means the next time you click on Quick Export, the same options will already be selected.

After you've launched a quick product export from the product grid, you can easily jump to this task's progress details in the process tracker. Indeed, you just need to click on the link to the job detail directly embedded in the flash message that confirms the quick export launch. Quick Export flash message

The action is processed as a back-end task, so that you can continue to work on the PIM. When the process is done, you are the only user to be notified. To download your file, click on the notification you received in the bottom-right corner or go to Activity then click on Process tracker and on the desired job.

On the report page, you can download your selection by clicking on Download generated files in the top-right corner.

Quick Export download

Two files are created:

  1. A file with the selected products named <NUMBER>_products_export_grid_context_<LOCALE>_<CHANNEL>_<YYYY-MM-DD>_<HH_MM_SS> with .csv or .xlsx extension
  2. A file with the selected product models named <NUMBER>_product_models_export_grid_context_<LOCALE>_<CHANNEL>_<YYYY-MM-DD>_<HH_MM_SS> with .csv or .xlsx extension

The created files enclose one line per product or product model exported, and a column for each product information available. The format of the generated file is the same as for the product import and export in CSV or XLSX format with the Akeneo connector.

XLSX file example

Only the working channel is taken into account, and thus all the locale information required for the channel is exported. The working locale is not taken into account.

For this export from the grid, the completeness, the product status, their classification are not taken into account to determine what information can be exported. All the products and product models selected in the product grid, regardless of their details, are exported to the CSV file or XLSX file.

Note that the following columns are not exported: Label, Image, Complete, Created at, Updated at and Variant products.

The quick export takes into account the user permissions on locales and attributes groups:

  • If a user has no view right on a locale, the localizable values for this locale are not exported
  • If a user has no view right on an attribute group, the attributes for this attribute group are not exported

Want to find out more? Take a look at these related articles