Setting a Free Shipping Threshold That Does Not Lose You Money

“Free shipping on orders over Rs X.” The X on your site was probably chosen by looking at a competitor. That is the one method guaranteed to be wrong for you, because the right threshold is a function of three numbers that are yours alone: your shipping cost, your margin and your average order value. Here is the calculation, with a worked example you can copy.

Why the threshold exists

Free shipping is a discount, paid in freight instead of price. A threshold turns it into an incentive: the buyer adds an item to cross the line, and the margin on that extra item pays for the shipping. Set it too low and you give away freight on orders that would have happened anyway. Set it too high and nobody reaches it, so it changes nothing.

The right threshold is the lowest value at which the extra margin from a larger basket covers the freight you are absorbing.

The three numbers you need

Average shipping cost per order (S). Not your cheapest lane; your weighted average across the zones you actually ship to, including the COD fee on the share of orders that are COD, and GST if you cannot claim it. Pull it from the last ninety days of shipments.

Gross margin (M). Price minus product cost minus payment gateway fees minus packaging, as a percentage of price. Do not use the margin on your best product; use the blended figure.

Current average order value (AOV). Again, the last ninety days.

The formula

The extra revenue a buyer needs to add for the margin on it to cover shipping is S / M. The threshold sits at the current AOV plus that amount:

Threshold = AOV + (S / M)

That is the point where an order that crosses the line has paid for its own freight with the margin on the uplift.

Worked example

A home decor seller: AOV Rs 1,100, blended gross margin 42 percent, average shipping cost Rs 78 (Zone C heavy, 40 percent COD, GST registered so tax excluded).

S / M = 78 / 0.42 = Rs 186
Threshold = 1,100 + 186 = Rs 1,286

Round to a number that reads well: Rs 1,299. Any order above it has, on average, added at least Rs 186 to reach it, and 42 percent of Rs 186 is Rs 78, which is the freight.

Then sanity-check it against your price ladder

A threshold of Rs 1,299 on a store where the most common product is Rs 649 is well placed: two items get the buyer there. If the most common product were Rs 1,249, the threshold would sit just above a single-item order, and buyers would either add a cheap item (good) or abandon (bad). Look at the distribution of order values around the threshold and adjust so that a natural “add one more” gets there.

Segment it

One threshold nationally is a compromise. Shipping to Zone A costs half of shipping to Zone D, and Zone E costs double. Sellers who set one threshold nationally either overpay on distant lanes or under-incentivise nearby ones. Options:

• By zone. Rs 999 for Zone A and B pincodes, Rs 1,499 for C and D, no free shipping or Rs 1,999 for E. Checkout can read the pincode before showing the offer.
• By payment mode. Free shipping on prepaid above Rs 999; on COD above Rs 1,499 or not at all. This doubles as a prepaid incentive and cuts RTO exposure.
• By customer. Lower threshold for repeat buyers, whose RTO rate is a fraction of a first-time buyer’s.

Measure it, then move it

After changing the threshold, watch four numbers for a month: AOV, the share of orders crossing the threshold, conversion rate, and total shipping cost as a percentage of revenue. The goal is AOV up and shipping-as-a-share flat or down. If AOV rose but shipping share rose faster, the threshold is too low. If nothing changed, it is too high.

Frequently asked questions

Should free shipping be unconditional instead?

Only if your margin comfortably covers the average freight on every order, which usually means AOV over Rs 2,500 or margin above 60 percent. Below that, a threshold captures most of the conversion benefit at a fraction of the cost.

What if my shipping cost varies a lot by product?

Weight the average by units sold, or set product-level rules: bulky items excluded from free shipping, or carrying their own threshold. A 4 kg parcel should not be free at the same threshold as a 300 g one.

How do I get my real average shipping cost?

Export ninety days of shipments from the dashboard and average the total charged, including COD fees. Courier Uncle records the freight, COD fee and zone on every shipment, so the pivot takes a minute.

Does the threshold need to include GST?

If you are GST registered, use the pre-tax freight; the 18 percent comes back as input credit. If you are not registered, include it, because it is a real cost.

Should the threshold differ for COD orders?

Yes, in most cases. COD orders carry a collection fee and a higher return rate, so the shipping cost you are absorbing is higher. A higher COD threshold, or free shipping on prepaid only, reflects that.

How often should I revisit it?

Whenever your AOV, margin or shipping cost moves meaningfully, and at least every quarter. A threshold set on last year’s rates is a guess again.

Ship smarter with Courier Uncle

Your real average shipping cost is one export away. Sign up, ship a month, and set the threshold on your own numbers.