Quick export your products

Summary

 

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.

 

Starting a quick export

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
  3. Click on Quick Export at the bottom of the screen.
  4. On the pop-up that opened, select the relevant options

 

Launching a Quick Export with Basic Settings

You can use simplified quick export options by selecting 'Without export profile' and choosing from the presented settings.

  • CSV to generate CSV (comma-separated values) files
  • XLSX to generate XLSX (Microsoft Excel) files
  • Export profile (Yes/no) to generate a quick export or use settings from an existing export profile
  • Visible attributes only (Yes/no) to export attributes selected as columns in the Product Grid or all attributes
  • Locales to list all the locale translations to be exported for localizable attributes. If you select 'yes' in ‘visible attributes only’, the current locale will be selected by default. If you select 'no' in ‘visible attributes only’, all locales from the current channel will be selected by default.
  • With labels to define if the export file displays values' labels instead of values' codes.
  • Export with codes or labels to export the attribute values or their codes, except the media (from asset collection, image, or file attributes)
  • Media (Yes/No) to export the attribute values including the media (from asset collection, image, or file attributes)
  •  UUID (Yes/No)  to export the product values including or except the product UUID (the associated products will also be displayed with their main identifier or the UUID)
  1. 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.

 

 

Track the progress of your quick export

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.

To be able to see the progress of your quick export, the role of the user must include the permission View process tracker. Please read how to check your role's permissions.

 

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.

 

Download your product export

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

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.

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, 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
 

 

Exporting with Pre-Configured Profiles

For advanced configurations, select an existing export profile from the 'Exports' section of the PIM. 

When using an existing export profile, products or product models will be exported according to the profile's configuration. However, your current product grid selection will override the profile's product selection.

  1. First, choose the desired format (CSV or XLSX)
  2. Then, select 'With export profile'.

 

 

The export profiles listed in the dropdown will depend on your selection 

  • If you selected only products, only product-related profiles will appear.
  • If you selected only product models, only product model-related profiles will appear.
  • If you selected both products and product models, profiles related to both will appear. However, if you then choose a product-related profile, only products from your selection will be exported; product models will be ignored.

 

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