Import products into the platform
This guide explains how to import or update the product catalog via XLSX Excel file in four steps: upload and validation, import setup, attribute matching, and start import. The system manages categories and variants, offers detailed reports, and requires specific permissions. Technical limits and best practices for an effective import are indicated.
To import products into the platform you must be an Administrator or have the permission "Can create and modify products"
Preparation of the Import File
The system only accepts XLSX files. You have two ways to prepare the document:
- Export and Modify: Export existing products, modify the values and re-import the file.
- Creation from scratch: Create a new Excel file specifying an attribute for each column.
Best Practice
- Use column names identical to THRON Attribute Codes; the system will perform automatic mapping, reducing manual intervention.
- In Excel, set columns with multiple values (e.g., sizes, colors) as Text. This prevents values like "2024,2023" from being interpreted as decimal numbers.
- Before loading thousands of rows, run a test with a small file of 10-20 rows.
Import the Products
From the product list, click Import in the top right to access the guided flow.
Step 1 - Upload and Validation
- Access the Products area.
- Click on the Import button in the top right.
- Drag your XLSX file into the upload area. The system will perform an immediate scan to verify that the file is not corrupted and that the format is supported.
Step 2 - Import setup
Import mode:
- Update existing: Modifies only the products already present (identified by unique code).
-
Add new & update existing: Creates new cards if the code does not exist and updates existing ones.
- Variants Management: If you manage products with variants, activate the option and map the columns: Variation (e.g., color/size), Hierarchy level, Master (parent product) and any Variation group.
Categories Association
To link products to categories, activate the relevant option and specify the column of the file that contains the paths.
- Activate the option Yes, import associations.
- Select the column of the file with the paths.
Required format: Use > to separate levels and , for multiple paths.
-
Example:
master-catalog > accessories > bags - Example:
master-catalog > accessories > bags, master-catalog > accessories > summer bags
You can choose to automatically create categories not yet present in the Data Model. Keep in mind that:
- the reference catalog must already exist on the platform;
- if the import of associated products fails, the category is created anyway;
- the created categories can be checked in the execution report and managed from Settings → Catalogs and Categories.
Once all mandatory fields are filled in, click Attribute association to proceed.
Step 3 - Attribute Matching and start import
The system proposes a matching between the File Columns and the Platform Attributes.
For each proposed row there is an Ignore button to exclude the column from the import without deleting it from the file.
Blocking errors that prevent proceeding
- Column without matched attribute: each column must have a selected attribute, otherwise the Import products button remains disabled.
- Duplicate attribute: two columns cannot be matched to the same attribute with the same locale. Modify one of the matches or click Ignore on one of the rows.
When all matches are valid and the identifying attribute is present, the Import products button becomes active and you can start the process. The import is executed in the background.
Best Practice
- Verify that each column is correctly mapped.
- If a column is not recognized, manually select the destination attribute from the dropdown menu.
- Ignore Column: If a column should not be imported, select the option to skip it.
- Each column must have a selected attribute, otherwise the Import products button remains disabled.
- Two columns cannot be matched to the same attribute with the same locale. Modify one of the matches or click Ignore on one of the rows.
Monitor Import and Export in the Background
When background operations are running, an icon indicating the status of the activities appears in the top bar.
Click on the icon to view the list of the last 5 operations. Three pieces of information are shown for each task:
Read the Report of an Import
At the end of an import, click on the completed task in the list of background operations to open the execution report.
View error rows
Click on the error rows counter (red) to access the detail page.
View newly created categories
Click on the created categories counter to access the detail page. From here, click Manage to be redirected to Settings → Catalogs and Categories, where you can verify and modify the generated categories.
Technical Limits and Constraints
| Parameter | Limit / Constraint |
|---|---|
| File Name |
|
| File Size |
|
| Column Name |
|
| Multiple Values Separator |
|