Products: how to export them to an Excel file
Export products from the THRON catalog to an Excel file (.xlsx) for consultation, analysis, or bulk editing of data. You can export the entire catalog, filtered products, or a specific selection, choosing which attributes and localizations to include in the file.
If you often export the same attributes, use export profiles: you save the configuration once and recall it with one click, without rebuilding it from scratch on every export.
Prerequisites
To export products, you need read access to the product catalog assigned by your administrator. In the file, you will only find attributes you have permission to view.
Product selection: entire catalog or targeted selection
Before exporting, decide which products to include:
All products: if you do not select any rows, you export all products. If you applied a filter, you export all filtered products.
Specific selection: select the checkboxes next to the products you are interested in. The checkbox in the table header selects all products on the current page; to select them all, use the button in the table footer.
Apply filters and search before selecting: as soon as you select at least one product, filters and search are disabled. Selection is not preserved across different pages: navigating to the next page deselects products from the previous one.
Quick export: suggested profiles and saved profiles
From the Products list, click Export. In the Export via profiles menu, you have three options:
Situation |
What to use |
|---|---|
You often export the same set of attributes |
Saved profiles |
You want to export based on currently displayed products or repeat a previous export |
Suggested profiles |
No profile covers your needs |
Manual export |
The Saved profiles and Suggested profiles tabs appear when at least one saved profile is visible to you. Otherwise, the menu only displays suggested profiles.
Suggested profiles
THRON dynamically suggests profiles based on your current product selection (for example, the filtered family) and your previous exports. The list adapts according to how you are using the catalog at that moment.
Click the info icon next to a profile to view the Profile configuration: export type, localizations, and included attributes in the order they will appear in the file. Click the profile to export immediately, skipping the configuration flow.
Saved profiles
In the Saved profiles tab, you will find profiles created within your organization. Click a profile to export using the saved configuration.
You can only view and use profiles consisting of attributes you have permission to view. The Visible profiles counter at the bottom of the list indicates how many profiles you can see compared to the total configured: if the first number is lower, some profiles contain attributes you cannot access.
If you are missing a profile that a colleague uses, ask the user and permissions administrator in your organization to check your attribute permissions.
Export procedure: configuration and download
Step 1: Start manual export
Click on Products in the sidebar.
Select the products of interest or leave the list unselected.
Click on Export in the top right, then select Manual export.
Step 2: Configure the export
In the Export configuration screen, on the left you will find the Summary of selected products: applied filters or the list of selected codes, which you can copy. On the right, in File setup, configure your file:
Choose the mode: Export by codes or Export by labels.
Under Which localizations do you want to export?, leave All localizations or select Choose localization and specify the ones you need.
Under Which attributes do you want to export?, leave All attributes or select Choose attributes: the top-right button becomes Choose attributes and takes you to the attribute selection screen.
If exporting by labels, also indicate How to show references? (By product code or By product label) and How to show assets? (By asset ID, By filename, or By URL). When using URL, select the pKey to use from your active shares, including those from applications you own.
By default, all attributes and all localizations are exported by codes: if no changes are needed, click Export to proceed immediately.
Mode |
File appearance |
|---|---|
Export by codes |
Attribute and option codes. Localizations are columns in the same product row, following the |
Export by labels |
Attribute and option labels, with a dedicated tab for each localization. If a label is not translated, the code appears. |
A file exported by labels is intended for consultation and cannot be re-imported. If you need to edit data and re-import it, export by codes.
Step 3: Choose attributes and their order
In the Choose which attributes to export screen:
Under Available attributes, use Search and the Families, Groups, and Type filters to find attributes, then select them. Hold Shift to select multiple attributes at once, or use the header checkbox to select all. The identifier attribute is already selected; you can uncheck it if not needed.
Under Sort selected attributes, drag attributes into the desired column order for the file. Use Remove all to start over.
Click on Export, or save the configuration as a profile first (Step 4).
Attributes fall into two categories: system attributes, marked SYS (Categories, Family, Hierarchy level, Master, Variation, Variation group), and other data model attributes, marked ATT. The default order matches your selection order: selecting B then A places B, A on the right. Selecting all attributes arranges them alphabetically, with system attributes at the top.
Step 4: Save configuration as a profile
To reuse the configuration, click on Save profile. In the Export profile modal, review the summary of what will be exported, then choose:
Create new: enter a Profile name, up to 100 characters.
Update existing: choose the profile to overwrite.
Click on Save to save the profile, or Save and export to save and launch the export immediately.
The profile saves the entire configuration, not just the attributes:
export mode, by codes or by labels
localizations to include
selected attributes and their order
pKey used to represent Assets, where applicable
You cannot save a profile that exports All attributes: export profiles require a specific attribute selection. The "all" set depends on the permissions of the person running the export, which would yield inconsistent results across users for a shared profile.
Start from a saved profile
To modify or duplicate a profile, use it as a starting point in manual export:
In Export configuration, click on Use a profile and choose from Available profiles. A message summarizes the selected profile's settings.
Click on View attributes, then reorder, remove, or add attributes.
Click on Save profile and select Update existing to overwrite the original, or Create new to keep both versions.
To return to an unconstrained configuration, choose Clear profile selection. Manual exports also feed suggested profiles.
Background operations: how to monitor and receive the file
Processing runs in the background without interrupting navigation on the platform:
At startup, the message Export started successfully! appears.
During processing, a progress icon appears in the top bar next to the bell icon.
Click the bell icon to check activity status: once finished, the entry Product export completed will appear.
You will receive the XLSX file by email.
Standard export preset
Recommended configuration:
Create a saved profile for each recurring use (such as a sales channel or B2B catalog) and agree on profiles with your team: they are shared and limited in number.
Select only necessary attributes to reduce file size and speed up processing.
If the file needs to be re-imported, export by codes and leave column headers unchanged.
Technical limits and constraints
Parameter |
Limit / Constraint |
|---|---|
Output format |
XLSX file (Microsoft Excel) |
Maximum number of products per export |
1,000,000, due to Excel worksheet limits |
Maximum number of attributes per export |
500 |
Multiple values separator |
Comma ( |
Maximum number of saved profiles |
10 per platform, regardless of how many each user sees |
Profile name |
Up to 100 characters |
Visibility of saved profiles |
All profiles are public and shared among users with access to Products: there are no private profiles |
Reduction of rights on an attribute |
All profiles containing that attribute automatically disappear from the user's list, without manual action |
## Additional articles
- Configure the Data Model for your Products
- Import products into the platform
-
- Need help?
For technical issues, contact support@thron.com.