A free-shipping threshold should encourage a reachable extra purchase while leaving enough incremental contribution to fund delivery. This calculator makes that trade-off visible.
Define the behaviour and economics of the threshold
A free-shipping threshold asks the customer to reach a minimum basket in exchange for the business paying some or all delivery cost. The target behaviour is an incremental, relevant purchase, not simply a higher displayed order total. The business needs enough extra contribution to fund the subsidy.
Shopify’s current guide recommends considering AOV, shipping cost, gross profit margin and a proposed cart value. Extend that logic with order distribution, parcel weight and incremental contribution from the added items. Use the unit economics guide as the base.
| Threshold question | Required input | Decision |
|---|---|---|
| Can customers reach it? | Median and common order bands | Choose a realistic gap |
| Can the business fund it? | Shipping cost and extra contribution | Set subsidy ceiling |
| Will parcel cost change? | Packed weight and destination mix | Model the new shipment |
| Does it create profit? | Contribution per visitor and order | Test against baseline |
Collect six inputs before calculating
Use recent fulfilled orders outside an unusual promotion. Calculate net merchandise value, order count, median and common order bands, average shipping cost paid by the business, contribution margin on likely add-on products and destination or weight distribution.
| Input | Definition | Source |
|---|---|---|
| Common order value | Median or high-frequency basket band | Order export |
| Current AOV | Order revenue ÷ completed orders | Commerce report |
| Shipping cost | Actual carrier plus sales-linked handling | Carrier invoices |
| Add-on contribution margin | Contribution ÷ net revenue for likely additions | Product economics |
| Qualification rate | Orders already above proposed threshold | Historical simulation |
| Parcel step-up risk | Added cost from weight or dimensions | Packed-rate test |
Use the contribution margin calculator for the likely added products, not a store-wide average that may hide low-margin categories.
Calculate the uncovered shipping subsidy
For a proposed threshold, calculate the gap above the baseline basket and multiply it by the contribution margin on the incremental items. Subtract that incremental contribution from the expected shipping subsidy. The remainder is the amount the original order contribution still needs to fund.
Uncovered subsidy = expected shipping cost − (threshold − baseline basket) × incremental contribution margin. A negative result means the estimated incremental contribution exceeds the shipping cost, before other behavioural effects and profit requirements.
| Line | Example only | Calculation |
|---|---|---|
| Baseline basket | ₹1,000 | Median or common band |
| Proposed threshold | ₹1,300 | Gap of ₹300 |
| Add-on contribution margin | 40% | ₹120 incremental contribution |
| Expected shipping cost | ₹100 | Historical weighted average |
| Uncovered subsidy | −₹20 | ₹100 − ₹120 |
The example does not guarantee profit. It assumes the customer would otherwise place the baseline order and that the added item does not increase shipping cost.
Simulate the threshold across real order bands
A single average hides who already qualifies and who is too far away. Group historical orders into bands, calculate the gap to the threshold and identify relevant products in each gap. Orders already above the threshold receive a subsidy without an AOV change, so include that cost.
| Order band | Distance to ₹1,300 threshold | Likely response | Economic question |
|---|---|---|---|
| Below ₹700 | More than ₹600 | Low likelihood | Threshold may feel irrelevant |
| ₹700 to ₹999 | ₹301 to ₹600 | Selective | Are useful add-ons available? |
| ₹1,000 to ₹1,299 | ₹1 to ₹300 | Highest test group | Does extra contribution fund shipping? |
| ₹1,300 and above | Already qualified | No basket change required | How much automatic subsidy is created? |
Shopify also cautions that mean, median and mode can tell different stories. Inspect all three before deciding.
Model destination, weight and COD effects
Average shipping cost may be misleading when national deliveries, remote areas, volumetric weight or COD charges vary widely. Calculate a weighted cost by zone and parcel type or create separate thresholds when the customer experience remains understandable.
| Cost driver | Threshold effect | Control |
|---|---|---|
| Extra weight | May increase rate band | Pack a realistic qualifying cart |
| Volumetric size | Light products may still cost more | Use carrier dimensions |
| Destination zone | Subsidy varies by region | Weighted model or zoned policy |
| COD fee and refusal | Raises expected cost | Channel-specific calculation |
| Split shipment | Can double fulfilment cost | Inventory and fulfilment rule |
Do not promise a universal threshold if the checkout cannot enforce exclusions or display the correct delivery condition.
Protect contribution on the products that bridge the gap
Customers may add the cheapest item, not the item assumed in the model. Review which products are likely to bridge common gaps and whether their contribution remains healthy after pick, pack and return risk. Recommend relevant additions rather than creating a junk drawer near checkout.
- Create gap-based recommendations from compatible products.
- Exclude products whose size sharply increases parcel cost when justified.
- Prevent uncontrolled stacking with discount codes or gifts.
- Calculate contribution after both the product discount and shipping subsidy.
- Keep the customer free to pay shipping instead of adding an unwanted item.
Use the margin-safe discount system when shipping and a price promotion could apply together.
Run a controlled threshold experiment
Define the primary metric as contribution per visitor or eligible checkout, not threshold uptake. Guard conversion, cancellation, return rate, delivery promise and support contacts. A high qualification rate can be expensive if it mainly subsidises orders that would already have happened.
- Simulate several thresholds on historical completed orders.
- Choose one with a reachable gap and positive expected economics.
- Configure checkout messaging and exclusions accurately.
- Run against a stable baseline for enough order volume and a full return window.
- Compare conversion, AOV, contribution, shipping cost and returns.
- Keep, revise or remove the threshold from combined evidence.
Connect the experiment to the ecommerce launch checklist so checkout, mobile display and fulfilment are tested together.
Use a decision table for proposed thresholds
| Candidate | Historical qualification | Estimated extra contribution | Shipping subsidy | Initial decision |
|---|---|---|---|---|
| Threshold A | High | Low | High | Likely too generous |
| Threshold B | Moderate | Covers most subsidy | Moderate | Good test candidate |
| Threshold C | Low | High if reached | Low | May be psychologically distant |
| No threshold | None | None | Customer-paid or current policy | Baseline |
Do not choose the candidate with the highest theoretical contribution if few customers can reasonably reach it. The purpose is a useful trade, not a hidden minimum purchase.
Review the threshold when economics move
Carrier rates, product mix, packing, prices and customer geography change. Keep a dated input sheet and recalculate after a material change. Reconcile expected shipping with carrier invoices and expected add-on contribution with actual qualifying carts.
Monitor threshold messaging as carefully as the number. The product page, cart drawer, checkout and support team should describe qualification on the same merchandise-value basis and apply the same exclusions. Record customer complaints about unexpected shipping because they often reveal configuration drift.
If the threshold is displayed on product pages, cart, WhatsApp and ads, use one source of truth. The channel strategy guide helps prevent different promises across channels.
Frequently asked questions
How do I calculate a free-shipping threshold?
Start with a common order value, average shipping cost and contribution margin on the extra basket. Test a threshold where incremental contribution covers the shipping subsidy and required profit.
How far above AOV should free shipping be?
There is no universal percentage. Use the median and common order bands, then choose a reachable gap that customers can fill with relevant products without harming contribution.
Should I use average or median order value?
Use both and inspect order bands. A few large orders can raise the average, while the median and mode better show what a typical customer may be able to add.
Is free shipping really free for the business?
No. The business funds delivery through product contribution, prices, a threshold or another commercial decision. The calculator should show the subsidy explicitly.
Can a free-shipping threshold reduce profit?
Yes. It can subsidise orders that were already large enough, encourage low-margin additions or move parcels into a more expensive weight band. Measure contribution per visitor and order.
How often should a shipping threshold be reviewed?
Review after material carrier, fuel, packaging, product-price, margin or order-mix changes, and at least on a regular operating cadence. Keep a dated input sheet.
Leave a Reply