A tiered offer can lift average order value and still reduce profit. That happens when the extra merchandise in the cart does not cover the larger discount, product cost, payment fees, fulfillment, and any shipping subsidy.

The fix is to calculate each tier from your order economics—not copy a competitor’s “10% / 15% / 20%” ladder. This guide shows how to calculate Shopify discount tiers with contribution-margin formulas, a worked example, and practical guardrails you can use before configuring the offer.

How to calculate Shopify discount tiers: the short answer

For each proposed tier, estimate the order’s revenue after discount, subtract the cost of goods sold (COGS) and every variable order cost, then compare the result with your current order.

Contribution profit = threshold × (1 − discount rate) − COGS − variable order costs

Keep a tier only when its contribution profit clears your minimum target and improves on the behavior you expect it to replace. A higher order value is not enough by itself.

Why percentage-off tiers can fool you

Consider a store with an $80 average order value (AOV) and a proposed first tier of “Spend $100, save 10%.” The promotion appears to add $20 to the cart, but the store collects only $90 after the discount. Revenue rises by $10, not $20, while the extra product still has a cost.

Three common mistakes make the result worse:

  • Applying the headline percentage to revenue without subtracting product cost.
  • Ignoring payment fees, pick and pack, packaging, returns, and shipping subsidies.
  • Evaluating a threshold cart in isolation instead of comparing it with the order it is meant to replace.

Shopify defines gross margin as the portion of net sales left after COGS. Contribution margin goes a step further by subtracting the other variable costs created by the sale. That makes contribution profit the more useful guardrail for a promotion.

Gather six inputs before you set Shopify discount tiers

Use recent Shopify reporting and your accounting data to collect:

  1. Current AOV. Use the audience and sales channel that will receive the promotion.
  2. Typical cart composition. Identify the products customers commonly add at each proposed threshold.
  3. COGS for that cart. Use current product or variant costs, not a storewide estimate when margins vary widely.
  4. Variable order costs. Include payment fees, packaging, pick and pack, per-order app or marketplace fees, and expected return costs.
  5. Shipping subsidy. Add any amount your business pays because the order unlocks free or discounted shipping.
  6. Minimum contribution profit. Decide the dollar profit an order must retain after the discount and variable costs.

Shopify profit reports can calculate gross profit only when the relevant product or variant had an accurate Cost per item value when it was sold. Update missing costs before using those reports as your baseline.

The four formulas you need

Use decimals in the formulas: 10% becomes 0.10.

1. Revenue after discount

Net revenue = threshold × (1 − discount rate)

At a $150 threshold with 15% off:

$150 × (1 − 0.15) = $127.50

2. Contribution profit

Contribution profit = net revenue − COGS − variable order costs − shipping subsidy

If the $150 cart has $60 in COGS, $8 in other variable costs, and no shipping subsidy:

$127.50 − $60 − $8 = $59.50

3. Contribution margin rate

Contribution margin rate = contribution profit ÷ net revenue

For the same order:

$59.50 ÷ $127.50 = 46.7%

Track both dollars and rate. The rate can fall while the order still produces more profit dollars, and the reverse can also happen.

4. Maximum discount at a required profit floor

Maximum discount rate = 1 − (COGS + variable costs + shipping subsidy + required contribution profit) ÷ threshold

Suppose the $150 cart must retain at least $55, with $60 COGS and $8 of variable costs:

1 − ($60 + $8 + $55) ÷ $150 = 18%

An 18% discount is the mathematical ceiling for that assumed cart. Use a lower offer to leave room for returns, product-mix changes, and cost estimates that are not exact.

This version treats variable costs as a fixed dollar estimate. If payment fees vary with net revenue, calculate them from the discounted total or use Goal Seek or Solver in your spreadsheet; then round the result down to preserve a safety buffer.

Worked example: test a three-tier Shopify discount ladder

Assume this store has:

  • Current AOV: $80.
  • Baseline COGS: $32.
  • Baseline variable costs: $7.
  • Baseline contribution profit: $80 − $32 − $7 = $41.
  • Proposed thresholds: $100, $150, and $200.
  • Expected COGS: 40% of the threshold cart.
  • Other variable costs: $8, $9, and $10 as order size rises.
  • No additional shipping subsidy.
Cart Discount Net revenue COGS Other variable costs Contribution profit Lift vs. $41 baseline
$100 10% $90.00 $40 $8 $42.00 +$1.00
$150 15% $127.50 $60 $9 $58.50 +$17.50
$200 20% $160.00 $80 $10 $70.00 +$29.00

All three orders remain profitable in this simplified model, but the first tier is weak: the customer receives $10 off while contribution profit improves by only $1. A small increase in return cost, fees, or low-margin product mix could erase the gain.

A safer first test might be one of these:

  • Move the first threshold higher so the customer must add a meaningful item.
  • Reduce the first reward to 5% or a fixed dollar amount.
  • Exclude low-margin products from the promotion.
  • Replace the first percentage discount with a low-cost gift that has high perceived value.

The correct choice depends on the products shoppers are likely to add, not just the average margin across the catalog.

Check the threshold gap against real product prices

A threshold should be above current AOV but still bridgeable with a natural add-on. Shopify’s discount-strategy guidance surfaces a third-party recommendation from ConvertCart to start roughly 10% to 20% above AOV for the first tier. Treat that as a hypothesis, not a universal rule.

Use this calculation:

Threshold gap = proposed threshold − current AOV

If AOV is $80:

  • A $90 tier creates a $10 gap.
  • A $100 tier creates a $20 gap.
  • A $120 tier creates a $40 gap.

Now inspect your catalog. If common add-ons cost $18 to $25, the $100 tier is easier to act on than the $90 tier, which may reward orders that would already occur, or the $120 tier, which may feel unreachable.

Compare incremental profit, not only tier profit

The most useful question is not “Does a $150 order make money?” It is “Does the tier produce more contribution profit than the order the shopper would have placed without it?”

Incremental contribution profit = tier contribution profit − expected contribution profit without the offer

In the worked example, the $100 tier produces $42 versus a $41 baseline: only $1 of incremental contribution profit. The $150 tier produces $17.50 more. If the incentive also lowers conversion or pulls forward purchases customers would have made later, the real incremental result can be smaller.

Run the calculation for at least three scenarios:

  • Conservative: low-margin products, full shipping subsidy, and higher return allowance.
  • Expected: the most likely product mix and cost assumptions.
  • Best case: higher-margin add-ons and no extra shipping cost.

Do not launch a storewide tier that works only in the best case.

Watch for the percentage-discount cliff

When a larger percentage applies to the whole cart at a threshold, the customer’s payable total can fall as soon as the next tier unlocks.

For example:

  • $149.99 at 10% off costs the customer about $134.99.
  • $150 at 15% off costs the customer $127.50.

The $150 cart contains slightly more merchandise but collects about $7.49 less revenue. This is not automatically wrong—the jump is the reward—but you must model it deliberately.

Measure the cliff with:

Threshold cliff = amount paid just below the tier − amount paid at the tier

Reduce a damaging cliff by narrowing the percentage jump, increasing the distance between thresholds, using fixed-dollar rewards, or applying the deeper discount only to eligible products. Then test the exact boundary carts in the storefront and checkout.

Add stacking and free-shipping costs to the same model

Do not calculate a tier as if it will always run alone.

Shopify can combine eligible product, order, and shipping discounts when the combination settings on the discounts permit it. Product discounts apply first, order discounts apply to the revised subtotal, and shipping discounts apply last. If discounts cannot combine, Shopify selects the best eligible discount or combination for the cart.

Create a separate row in your model for each common combination:

  • Tiered discount only.
  • Tier plus welcome or loyalty code.
  • Tier plus sale-priced products.
  • Tier plus free shipping.
  • Tier plus any market-specific pricing or promotion.

If a $150 tier produces $58.50 contribution profit alone but free shipping costs another $12, the combined result is $46.50. A second order-level discount can reduce it further. Either disable the risky combination or lower the tier reward.

A practical spreadsheet layout

Create one row per tier and use these columns:

Column What to enter or calculate
Threshold Cart value needed to unlock the tier
Discount rate Proposed percentage or fixed reward
Net revenue Threshold minus the discount
Expected COGS Cost of the likely product mix
Payment fees Percentage calculated on post-discount revenue, plus any fixed fee
Pick, pack, packaging Variable fulfillment cost
Return allowance Expected return cost per order
Shipping subsidy Amount paid by the business
Contribution profit Net revenue minus all variable costs
Contribution margin Contribution profit divided by net revenue
Baseline profit Expected profit without the offer
Incremental profit Tier profit minus baseline profit
Pass/fail Whether the tier clears your profit floor

Add conservative, expected, and best-case tabs. For a catalog with uneven margins, add separate rows for common low-, medium-, and high-margin carts at each threshold.

Choose the right reward structure

The math may show that a different reward protects profit better.

Percentage discount

Easy to communicate and scales with the cart, but the discount cost keeps growing above the threshold. Consider a maximum discount or product exclusions for unusually large orders.

Fixed-amount discount

Caps the reward in dollars. “Spend $150, save $20” costs the same $20 at $150 or $250, so margin improves as the cart grows.

Free gift

Useful when the item has a lower landed cost than its perceived retail value. Model the gift’s landed cost, pick-and-pack cost, and likely return behavior—not its retail price.

Free shipping

Compelling for customers, but the business cost varies by destination, weight, and carrier. Use a conservative subsidy or limit eligibility if shipping economics vary widely.

Turn the approved math into a customer-facing promotion

Once every tier passes its profit floor, configure the ladder as one clear promotion. Multiscount: Tiered Discounts lets Shopify merchants create tiered and stackable incentives, display discount widgets on product and cart pages, and reinforce available rewards at checkout using Shopify’s native discount infrastructure rather than draft orders.

Use Multiscount’s tiered-discount features to show the current reward and the amount remaining to reach the next tier. That message should match your calculation exactly: “Add $18 more to unlock 15% off” is more actionable than “Spend more and save.”

For configuration steps, read How to Create Tiered Discounts on Shopify. For unit-based offers, use the dedicated guide to Shopify quantity breaks and volume discounts.

Test every threshold before launch

For tiers at $100, $150, and $200, test:

Test cart What to verify
$99.99 No tier applies
$100.00 First tier and correct savings apply
$149.99 First tier remains active
$150.00 Second tier replaces or upgrades the first correctly
$199.99 Second tier remains active
$200.00 Third tier applies
Threshold with excluded item Only the intended subtotal or products count
Threshold plus another discount Combination matches the modeled result
Threshold plus free shipping Final contribution still clears the floor

Also remove items after reaching a tier. The discount and progress message should fall back to the correct lower state.

Measure whether the tiers protect profit after launch

Your model is a forecast. Validate it with actual orders.

Track:

  • Conversion rate.
  • AOV and units per transaction.
  • Orders reaching each tier.
  • Discount cost as a percentage of net sales.
  • Gross profit and contribution profit per order.
  • Contribution profit per visitor.
  • Product mix, returns, and cancellations by tier.
  • Redemption and combination rates.

Compare the campaign with a suitable pre-promotion period or control group. If AOV rises while contribution profit per visitor falls, the offer is buying larger carts too expensively.

Build Shopify discount tiers from profit backward

Start with the profit you need to keep, then solve for the reward your economics can support. Use real cart composition, include every variable cost, model discount combinations, and test the boundary where each new tier activates.

When the numbers work, install Multiscount for profitable tiered discounts on Shopify and turn the approved thresholds into a promotion customers can understand and act on.

Frequently asked questions

What is a good first Shopify discount tier?

A practical starting hypothesis is 10% to 20% above current AOV, provided a common add-on can bridge the gap. Validate the threshold with contribution-profit math and order-distribution data before launch.

How do I calculate the maximum discount percentage?

Use: 1 − (COGS + variable costs + shipping subsidy + required contribution profit) ÷ threshold. Treat the result as a ceiling and leave a buffer for returns, mix changes, and uncertain costs.

Should I use gross margin or contribution margin for discount tiers?

Use contribution margin for promotion decisions because it includes COGS plus variable expenses such as payment fees, fulfillment, and shipping subsidies. Gross margin remains useful for product-level pricing and reporting.

Is a higher AOV proof that the discount worked?

No. AOV can rise while contribution profit falls. Evaluate contribution profit per order and per visitor alongside conversion, returns, product mix, and discount cost.

How many discount tiers should I offer?

Use the fewest tiers needed to create meaningful next steps. Three is often easy to understand, but the correct number depends on order distribution, catalog prices, and the profit lift at each threshold.