Distributor: Partner Prices Bulk Import

Introduction

This article is a complete guide for Distributors on how to import Markup configurations into Partner Prices on the Platform. The import functionality allows Distributors to upload Markup rules in bulk from an .xlsx file, review any conflicts with existing configurations, and apply changes in a single step. The article covers the import modal, the Price Configuration Summary, conflict detection and resolution, the sample .xlsx template, and error handling.

In this article:

• Opening the Import prices modal
• Uploading a file
• Price Configuration Summary
• Resolving conflicts
• Confirming the import
• Error handling
• Sample .xlsx template

Opening the Import prices modal

The import functionality is available inside any Price Tier on the Prices tab. Select Import above the grid to open the Import prices modal.

Uploading a file

To import a file:

1. Select (Download sample) to download the sample .xlsx template file. Use it as a reference to ensure your data is formatted correctly before uploading.
2. Select Select file and choose your .xlsx file. Only .xlsx format is supported.
3. Once uploaded, the file name, file size, and an Uploaded status indicator are displayed. Select the X button to remove the file and upload a different one.
4. Select Import to process the file.

Price Configuration Summary

After the file is processed, a collapsible Price Configuration Summary panel appears inside the modal. It shows:

• The number of entries that will be applied automatically, marked with a green NO CONFLICTS badge. These are Markup configurations without overlapping validity periods and are processed immediately upon confirmation.
• The number of entries requiring manual review, marked with an amber PERIOD OVERLAP badge. These are imported entries whose validity periods overlap with existing configurations.

Resolving conflicts

A conflict is detected when an imported entry matches an existing configuration on both of the following criteria:

• Same entity hierarchy path (Seller, Customer, Vendor, Offer)
• Overlapping validity period (Date From to Date Till)

Conflicting entries are listed in a table below the summary. Each conflict pair shows:

• The imported entry — marked with a red IMPORTED badge and an entity level badge (Vendor, Offer, or Component). Dates that differ from the existing entry are highlighted in red. The checkbox is selected by default.
• The existing entry — displayed below it with a CONFLICTS WITH: label and a gray CURRENT badge. This row has no checkbox and cannot be selected.

The conflict table also shows the Seller and Customer context for each entry. When a rule applies to all sellers or all customers, the label reads All Sellers or All Customers with a dashed border.

For each conflicting entry you can decide whether to overwrite the existing configuration or keep it:

• Select the checkbox on an imported entry to overwrite the existing configuration with it.
• Deselect the checkbox to retain the existing configuration and discard the imported entry.

Use the bulk action buttons to manage all conflicts at once:

• Select All — selects all imported entries for overwrite.
• Keep All Existing — deselects all imported entries to retain existing values.

The modal footer shows the count of auto-applied entries (in green) and the count of selected conflicts out of total conflicts, so you always have a clear picture of what will be applied before confirming.

Confirming the import

Select Confirm to apply the changes, or Cancel to close the modal without making any changes. The modal can also be closed by selecting the X button in the top-right corner or by clicking outside the modal.

Upon confirmation:

• All non-conflicting entries are applied automatically.
• For selected conflicting entries, the previous validity period is closed and the imported entry is created as a new configuration.
• Unselected conflicting entries are left unchanged.
• A success notification is displayed with the counts of applied entries.

Error handling

If the uploaded file cannot be processed, an error message is displayed in the modal. Common causes include:

• File format is not .xlsx
• File is empty or corrupted
• Required columns are missing

Additionally, the Platform validates each row of the uploaded file and returns detailed error messages when issues are found. The error message specifies the row number and the reason for failure. Below are the validation error types and examples.

Incorrect date format

The Date From and Date Till columns must use the yyyy-MM-dd format (for example, 2026-10-11). If a date is entered in a different format, such as 11.10.2026 or 12/08/2026, the Platform returns an error indicating the expected format.

Date From must be later than today

The Date From value must be at least one day after the current date (tomorrow at 00:00 UTC). If a past or current date is provided, the Platform returns an error showing the provided date.

Duplicate entries in the file

Each row in the file must have a unique combination of Vendor, Offer, Seller, and Customer scope with non-overlapping Date From/Date Till periods. If two or more rows share the same scope and have overlapping validity periods, the Platform flags the later row as a duplicate of the earlier one.

Inconsistent data

All ID columns (Price Tier ID, Vendor ID, Offer ID, Customer ID, Seller ID) must contain valid GUIDs. If a cell contains extra spaces, non-printable characters, or any other formatting issues, the Platform cannot parse the value and returns an error.

Multiple errors in a single file

If the uploaded file contains several issues across different rows, the Platform validates all rows and returns all detected errors at once. Each error message references its specific row number, allowing you to correct all issues in a single pass before re-uploading.

Sample .xlsx template

The downloadable sample file contains the following columns:

Summary

The Import prices modal allows Distributors to upload Markup configurations in bulk from an .xlsx file. After upload, the Price Configuration Summary shows how many entries will be applied automatically and how many require conflict resolution. Conflicting entries can be managed individually or in bulk using Select All and Keep All Existing. Upon confirmation, non-conflicting entries are applied immediately; for selected conflicts, the previous validity period is closed and the imported entry takes effect. Use the downloadable sample template to ensure your file is correctly formatted before uploading.