This technical guide allows you to create or update the product catalog by uploading an Excel file. The system manages attribute matching and the creation of missing categories.

The process is divided into four guided steps: file upload and validation, import setup, attribute matching, and starting the process.

At the end of processing, an execution report displays the outcome of the operation with details of products created, updated, error rows, and generated categories.

Preparation of the Import File

The system only accepts XLSX files. You have two ways to prepare the document:

1. Export and Modify: Export existing products, modify values, and re-import the file.

2. Creation from scratch: Create a new Excel file specifying an attribute for each column.

Best Practices

• 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 reduced 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

1. Access the Products area.

2. Click on the Import button in the top right.

3. 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 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.

## Additional articles
- 
Guide to Configuring Product Families and Variations

Categories Association

To link products to categories, activate the corresponding option and specify the file column containing the paths.

1. Activate the option Yes, import associations.

2. 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 in the platform;

• if the import of associated products fails, the category is still created;

• created categories can be verified in the execution report and managed from Settings → Catalogs and Categories.

Once all required fields are filled in, click Attribute association to proceed.

Step 3 - Attribute Matching and starting the import

The system proposes a matching between File Columns and Platform Attributes.

For each proposed row, an Ignore button is available to exclude the column from the import without deleting it from the file.

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 runs in the background.

Best Practices

• Verify that each column is mapped correctly.

• 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 appears in the top bar indicating activity status.

Click on the icon to view the list of the last 5 operations. For each task, three pieces of information are shown:

• Status: in progress (loading icon), completed (green checkmark), or failed (red exclamation point).

• Operation type: product import or export.

• Started: how long ago the operation started.

Read the Report of an Import

At the end of an import, click on the completed task in the background operations list 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 edit the generated categories.

Technical Limits and Constraints

Need help?

For technical issues, write to support@thron.com.