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

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.