Distributor: Seller Price Import

Introduction

This article explains how Distributors can bulk import pricing for their Sellers (partners) using spreadsheet files. The bulk import feature significantly accelerates the process of configuring granular pricing across multiple Seller catalogs, especially when managing numerous Vendor and Offer-specific price settings.

In this article:

• When to use price import
• Accessing the import functionality
• Preparing the import file
• Required fields and formatting
• Importing the file

When to use price import

If your pricing for Sellers is granular, importing from a spreadsheet is significantly faster than manual configuration. This feature is particularly valuable when managing complex pricing structures.

Example scenario: If you have 50+ Vendor and Offer-specific price settings for each of your 5 Seller catalogs, a single import operation can complete the entire configuration in minutes rather than hours of manual data entry.

Accessing the import functionality

To import Seller prices as a Distributor :

1. Navigate to Catalog → Partner Prices in the Platform.
   
2. Select the Price tier you want to configure from the list.
   
3. On the price tier detail page, locate the "Create new price tier" button.
   
4. Select the dropdown arrow next to "Create new" and choose "Import prices."
   
5. The Import prices popup window will appear.

Preparing the import file

The Import prices popup provides a template spreadsheet to ensure correct formatting:

Download the template: Select the "(download sample)" link to obtain the import template. The template includes all required columns and formatting examples.

File format support: Both .xls and .csv file formats are supported for price imports.

Import structure: Each row in the spreadsheet represents one price setting. To apply the same setting to multiple Seller catalogs, duplicate the row and specify a different Catalog ID in each copy.

Required fields and formatting

For each price setting row, you must provide the following information:

Catalog ID (mandatory): This determines which Seller catalog the setting will be saved for. To find Catalog IDs, use the Dictionary report embedded in the Platform. The report can be exported for convenience.

Offer ID or Vendor ID (at least one mandatory):

• Offer ID: The setting will affect only the selected Offer
• Vendor ID: The setting will affect all Offers of the selected Vendor, unless a specific Offer has its own Offer-level setting
• Indicate one or the other; leave the unused field blank
• Find all IDs in the Dictionary report

Adjustment % (mandatory): The Markup or markdown value to apply. Enter as a percentage (for example, 10 for 10%).

Apply to (mandatory): The base Price that your Adjustment will apply to. Options are:

• Cost (applies to Cost Price)
• Suggested Retail Price (applies to retail pricing)

From (mandatory): The start date for the price setting. Must be any future date, starting with tomorrow. Format: yyyy-mm-dd.

Till (mandatory): The end date for the price setting. Must be any future date larger than the From date. Set to '9999-12-31' if the setting should not expire. Format: yyyy-mm-dd.

Date formatting: Date fields must use the format yyyy-mm-dd (for example, 2024-12-31). In spreadsheet applications, this can be set by selecting "Format Cells... > Date > Type = 2012-03-14."

Importing the file

Once your spreadsheet is complete:

1. In the Import prices popup, select "Select file" to choose your prepared file.
2. The Platform will validate and process the file.
3. If error messages appear, review the error details, correct the issues in your spreadsheet, and import again.
4. Upon successful import, the price settings will be applied to the specified Seller catalogs.

Troubleshooting: Common errors include:

• Missing mandatory fields
• Incorrect date formatting
• Invalid Catalog, Offer, or Vendor IDs
• From dates earlier than tomorrow
• Till dates earlier than From dates

If you need assistance with your import file or error messages, contact Platform Support for help.

Summary

Bulk price import enables Distributor Admins to efficiently configure granular pricing for multiple Seller catalogs using spreadsheet files. By downloading the template, filling in required fields (Catalog ID, Offer ID or Vendor ID, Adjustment %, Apply to, From, and Till dates), and importing the file, Distributors can configure hundreds of price settings in a single operation. The Dictionary report provides all necessary IDs, and the Platform validates the import to ensure accurate pricing configuration.