Price Lists

Intermediate · 7 min · Inventory

Set up advanced price tiers for products, such as lower rates for bigger quantities or for particular customer groups, and test what price the system will actually charge.

Open this screen in Stockivio →

Price Lists

Screen layout sketch — the screenshot will appear here once it is added.

Why and when you use it

Wholesalers and distributors rarely sell at one price. A retailer buying 5 cartons expects a better rate than one buying a single carton. Price Lists hold these rules in one place so every salesman bills the same agreed price, and the resolver lets you check a price before a customer sees it on an invoice.

Before you start

Add the products with base unit and sale price in Inventory
Decide your price rules (for example, quantity breaks) in writing

Step by step

Open Price ListsOpen Price Lists. The Advanced Price Lists screen shows existing tiers with ID, Product, Tier Name, Min Qty, Price / Base Unit and Discount.
Create a price tierUnder Create Price Tier, choose the product, give the tier a name, and enter the minimum quantity at which it applies.
Set the price or discountEnter the price per base unit, or choose a Discount Type: None, Percent or Fixed, and type the Discount Value.
Save the tierPress Create Tier. It appears in the list.
Add more breaksAdd one tier for each quantity break, for example 48 and 240 units, each with its own price or discount.
Test with the resolverUnder Resolve a Price (test the live resolver), pick the product, enter a Quantity and press Resolve. It shows the price that will be used for that quantity.

Worked example

Sharma Traders sells Masala Tea 250 g at ₹110 per packet. It wants 3% off for a full carton (48 packets) and 5% off for 5 cartons (240 packets).

Open Price Lists. Create Price Tier: product Masala Tea 250 g, Tier Name Carton rate, Min Qty 48, Discount Type Percent, Discount Value 3. Press Create Tier.
Create another: Tier Name Bulk 5 cartons, Min Qty 240, Discount Type Percent, Discount Value 5. Press Create Tier.
Resolve a Price: Quantity 30, press Resolve: ₹110 (no tier applies).
Quantity 48, Resolve: ₹106.70 per packet.
Quantity 240, Resolve: ₹104.50 per packet.

Result: When Ravi bills Gupta Kirana Store for 240 packets, the rate is ₹104.50 per packet instead of ₹110, without him having to remember the scheme.

💡 Tips

Always test new tiers with Resolve before telling salesmen about them.
Give tiers clear names like "Carton rate" so anyone reading an invoice query understands them.
Remember that GST is charged on the price after the discount.

⚠️ Common mistakes

Entering Min Qty in cartons when the product's base unit is pieces. Min Qty counts base units.
Creating overlapping tiers with conflicting prices. Check with Resolve at each break quantity.

सवाल

How is this different from + Add Tier in Inventory?

Both set quantity breaks. Price Lists gives a full view of all tiers and a resolver to test them, which helps when you have many products and rules.

🎬 Video walkthrough (script — recording coming soon)

Scene 1: The Advanced Price Lists table.
Scene 2: Create a Carton rate tier at Min Qty 48 with 3% off.
Scene 3: Create a Bulk tier at 240 with 5% off.
Scene 4: Use Resolve a Price for 30, 48 and 240 packets.
Scene 5: Show the tier price on an invoice.