Calculator Inputs
Example Data Table
| Scenario | Mode | Quantity | Base Price | Tier Logic | Discounted Subtotal | Grand Total |
|---|---|---|---|---|---|---|
| Starter bulk order | All units | 20 | $45.00 | 10-24 units at 5% off | $855.00 | $992.10 |
| Growth order | All units | 60 | $45.00 | 50-99 units at 15% off | $2,295.00 | $2,822.26 |
| Graduated offer | Progressive | 60 | $45.00 | 1-9 at 0%, 10-24 at 5%, 25-49 at 10%, 50-60 at 15% | $2,473.50 | $3,015.85 |
Example assumes unit cost of $18.00, shipping per unit of $2.50, fixed order fee of $8.00, and tax rate of 8.5%.
Formula Used
Unit price after discount = Base list price × (1 − Discount % ÷ 100)
Tier revenue = Units in band × Discounted unit price
Discounted subtotal = Sum of all tier revenues
Savings vs list = (Order quantity × Base list price) − Discounted subtotal
Shipping total = (Order quantity × Shipping per unit) + Fixed order fee
Tax total = (Discounted subtotal + Shipping total) × Tax rate
Grand total = Discounted subtotal + Shipping total + Tax total
Gross profit = Discounted subtotal − (Order quantity × Unit cost)
Net profit after shipping = Discounted subtotal − COGS − Shipping total
Net margin % = Net profit after shipping ÷ Discounted subtotal × 100
Break-even unit price = (COGS + Shipping total) ÷ Order quantity
Price needed for target margin = Unit expense ÷ (1 − Target margin % ÷ 100)
How to Use This Calculator
- Enter your selling currency, pricing mode, and order quantity.
- Fill in the base list price, unit cost, shipping values, tax rate, and target margin.
- Define each quantity tier and its discount percentage.
- Choose All units when one matched tier prices the whole order.
- Choose Progressive when each quantity band gets its own discount.
- Press Calculate Pricing to display results above the form.
- Review profitability, effective price, savings, and the chart.
- Download the CSV or PDF report for sharing or records.
FAQs
1. What is tiered pricing in ecommerce?
Tiered pricing changes the unit price according to ordered quantity. Small orders pay more, while larger orders unlock discounts. It helps improve conversion, average order value, and predictable revenue planning.
2. What is the difference between all-units and progressive pricing?
All-units pricing applies one matched tier to the full order. Progressive pricing applies each band separately. Progressive structures are useful when you want smoother discount transitions across larger quantities.
3. Why does margin matter in a pricing calculator?
Margin shows how much revenue remains after product and shipping costs. It helps you confirm that attractive customer discounts still protect profitability and support operating goals.
4. Does this calculator include tax in profit?
No. Tax is shown in the customer total, but profit calculations exclude tax. That approach is common because sales tax is usually collected and remitted, not kept as business income.
5. Can I leave gaps between tiers?
Yes. Any uncovered quantity range is priced at the base list price. This lets you create selective promotions without forcing every possible order size into a discount band.
6. What happens if the last tier has no maximum?
Leaving the maximum blank creates an open-ended tier. That tier handles all higher quantities beyond its minimum, which is useful for wholesale or enterprise-sized orders.
7. How should I choose discount percentages?
Start from your cost structure and target margin. Then test several discount ladders until the blended price stays competitive while the break-even and target-margin values remain acceptable.
8. Why does the chart help with pricing decisions?
The chart makes discount behavior visible across order sizes. You can quickly spot price drops, total payable growth, and whether a tier schedule creates smooth or aggressive pricing steps.