Create Pricing Master Scheme and Customer Group

Create Pricing Master Scheme and Customer Group

Info
Software Plan: Startup, Growth & Enterprise
Info
Account Type: Seller Account 
Info
Inventory Type: Non Serialize & Serialize

Overview

The Pricing Master feature empowers you to define custom pricing schemes for your wholesale customers. This allows you to offer personalized and negotiable pricing, fostering stronger relationships with your valued clients.  With Pricing Master, businesses can easily create and manage custom pricing rules, leading to increased sales, improved customer loyalty, and overall business growth.

Use Case

1.  Ajay has a long-standing wholesale customer, ABC Pvt Ltd.  They have been purchasing significant quantities of his products for the past five years.

Using Pricing Master, Ajay can:
  1. Create a custom pricing tier: Define a special pricing tier specifically for ABC Wholesale.
  2. Set product-specific discounts: Offer discounts on certain products that are particularly popular with ABC Wholesale.
  3. Implement volume-based pricing: Provide additional discounts based on the quantity of products purchased by ABC Wholesale.
  4. Offer exclusive promotions: Offer limited-time promotions or early access to new products to ABC Wholesale as a token of appreciation for their loyalty.

Pricing Scheme Workflow

Step 1:  Go to Masters (main menu) > Pricing Master > Create New Pricing Scheme



Step 2:  Mention the List Name. The list name can be used to identify the pricing scheme.


Step 3: Select the Pricing Type.


Pricing Type can be set into 5 types-
  1. SKU Wise Price List
  2. Flat Discount on MRP
  3. Net of Taxes (NOT)
  4. Net Realization Value (NRV)
  5. Cost as Price

1. SKU Wise Price List

SKU-wise price list allows the sellers to use tailored pricing on specific SKUs


Download the Template.



Fill in the details.



Upload the sheet and click on Submit


2. Flat Discount on MRP

Flat Discount on MRP allows sellers to set a discount percentage on their listing or specific SKUs


If you choose "Discount", you can specify the discount percentage, and the discount will apply to the entire listing.

Click on Submit to finalize.


OR

If you select "Upload Sheet", click on "Download Template"



Fill in the details. The discount value will be considered in percentage. This will apply the discount on those specific SKUs which are mentioned in this sheet.


Upload the sheet and click on Submit

3. Net of Taxes (NOT)

In Net of Taxes, the seller can define a Margin Percentage.


If you select "Margin", you can mention the margin percentage and the margin will apply to the whole listing.

Click on Submit to finalize.


If you select "Upload Sheet", click on "Download Template"


Fill in the details. The margin value will be considered in percentage. This will apply the margin on those specific SKUs mentioned in this sheet.

How to calculate Invoice Value based on Net of Taxes (NOT) Pricing Scheme:

4. Net Realization Value (NRV)

In NRV pricing, sellers can set the margin for retailers and stockists. This margin plays a crucial role in determining the revenue generated from the sale of products. By setting the margin, sellers can have better control over the profitability of their products.


  1. Enter the List Name.
  2. From Select Pricing Type, select Net Realization Value (NRV).
  3. Select the required option:
    1. Margin - Enter the margin percentage.
    2. Upload Sheet - Download the template, enter the SKU-wise margin, and upload the sheet.
Click on Submit to finalize.


If you select "Upload Sheet", click on "Download Template"


Fill in the details. The margin value will be considered in percentage. This will apply the margin on those specific SKUs mentioned in this sheet.


5. Cost As Price

In this type of pricing list, no discount will be maintained. The cost maintained in the Product Master will be considered as the price against the SKU. Cost As Price does not require any discount or margin configuration. The cost maintained against the SKU in Product Master is used as the SKU price.
Notes
Note: This pricing list will be applicable only for STN customers.

Step 1: Enter the List Name, select Cost As Price from Select Pricing Type, and click Submit.

Pricing Scheme Mapping with Customer Group Workflow

Step 1:  Go to Masters (main menu) > Pricing Master > Create Customer Group


Step 2: Enter Customer Group Details:
  1. Customer Group Name
  2. Select the required Price List

  3. Enter the Retailer Discount (%), if applicable
    Enter the discount percentage to be applied to the price calculated based on the selected pricing scheme. Retailer Discount (%) is an additional discount applied to the price calculated using the selected Pricing Scheme. Retailer Discount is optional. A seller can configure only the Retailer Discount (%) if required.
  4. Enter the Stockist Discount (%), if applicable
    Enter the discount percentage to be applied after the Retailer Discount. If no Retailer Discount is specified, this discount will not be applicable.

  5. Under Map Price List To, select either Sales Channel or Customers / Locations and select the required mapping
Click Submit.
Info
If Stockist Discount (%) is entered without Retailer Discount (%), the system displays:
“Stockist Discount (%) cannot be defined unless Retailer Discount (%) is defined.”
A customer group will be created. When creating an order for a mapped customer using Pricing Master calculation, the selected pricing scheme and applicable Customer Group-level discounts will be applied automatically.

Customer Group Data

The Customer Group data can be downloaded from Download Existing Customer Group. The downloaded file includes the configured Retailer Discount (%) and Stockist Discount (%), along with the existing Customer Group details.

Pricing Calculation

The discounts configured at the Customer Group level are applied after the price is calculated using the selected Pricing Scheme.
Calculation sequence: Selected Pricing Scheme → Retailer Discount → Stockist Discount → Applicable Selling Price

Example

Assume:

  • MRP = ₹100
  • Pricing Scheme = Flat Discount on MRP – 20%
  • Retailer Discount = 10%
  • Stockist Discount = 5%

Step 1 — Pricing Scheme

₹100 − 20% = ₹80

Step 2 — Retailer Discount

₹80 − 10% = ₹72

Step 3 — Stockist Discount

₹72 − 5% = ₹68.40

Final Applicable Selling Price

₹68.40

Important Notes:

  1. The new pricing master will not work for international customers.
  2. The prices listed on the sheet will be including GST.
  3. Pricing Master can only be defined/updated in the primary location. However, it will still be viewable in the Child Location.
  4. Pricing Master can be defined against the SKU. It will not be defined against EAN or Accounting SKU.
  5. The new pricing master works in the Old & New B2B Module.
  6. NOT & NRV pricing schemes are only applicable for B2B Customers
  7. In case a specific SKU has a discount percentage defined through the UI, and later a different discount percentage is defined for that SKU in the sheet, then the sheet's data will override the UI's data.
  8. Cost As Price pricing lists are applicable only to STN customers.
  9. Retailer Discount (%) is optional and can be configured without Stockist Discount (%).
  10. Stockist Discount (%) can be configured only when Retailer Discount (%) is defined.