Free Shipping Threshold: The Formula

Most advice on a free shipping threshold is a rule of thumb: take your average order value and add some percentage. That rule ignores the two numbers that decide whether the offer makes money, what a parcel actually costs you to send and what you earn on the extra dollars a shopper adds to reach the line. This page replaces the rule of thumb with a formula you can fill in from your own carrier invoices and your own margin, then walks one example from start to finish.

The formula

Free shipping means you pay the shipping cost, S, on every order that clears the threshold, T. The order at the threshold earns you a gross margin of m × T, where m is your gross margin as a decimal on the products sold. A threshold is sound when the shipping you absorb is a small enough share of the margin that order earns. Call that share k, the part of margin you are willing to hand to the carrier. Then:

T = S ÷ (k × m)

Read it in words: the threshold is the shipping cost divided by the margin you are willing to give up, expressed in order dollars. A heavier or farther parcel raises S and pushes the threshold up. A fatter margin lowers it. A larger k, meaning you tolerate a bigger bite, lowers it too. None of these inputs is a benchmark. k is a decision, and 25 percent below is only an assumption used to make the arithmetic concrete.

This is the same logic as break-even discounting: shipping you absorb is a discount on the order, and the extra spend has to pay for it. If you want that math in general form, see Break-Even Discount: Extra Volume You Need.

Your real shipping cost: zones and weight

S is not one number. For a US parcel carrier it depends on weight, package size and how far the box travels. USPS expresses distance as a zone, and its Domestic Zone Chart page states that "the first 3-digits of your destination ZIP Code determine the zone." A separate tool on the same service takes an origin and destination ZIP Code pair and returns the zone. So the way to get your own zones is mechanical: enter your warehouse ZIP code as the origin and a destination ZIP for each region you ship to.

That gives you a ladder. Orders to nearby ZIP codes land in low zones; orders across the country land in high ones. Your carrier rate card, whether USPS, UPS or FedEx, then prices each zone and weight step. The prices change, so this page quotes none. Pull your last 90 days of invoices instead and compute the average cost per parcel by zone for your typical package weight.

Three practical notes:

• Include everything that rides on the label: the postage, any surcharge your account is billed, and the box and filler you pay for.
• Use the weight of the orders that will cross the threshold, not of your lightest product. Higher carts are usually heavier.
• If a few destinations cost far more than the rest, you can handle them without raising the line for everyone (see the setup section).

Worked example: one warehouse, three zones, one threshold

Everything below is an assumption chosen for arithmetic, not a market figure. Replace each number with yours.

A store ships from one warehouse. Grouping destinations by zone, assume this mix of orders and average absorbed shipping cost per parcel for a 1 to 2 pound box:

The blended cost is 0.30 × 6 + 0.40 × 8 + 0.30 × 11 = 1.80 + 3.20 + 3.30 = 8.30 dollars.

Assume a 55 percent gross margin on the products (m = 0.55) and a decision to give at most a quarter of margin to shipping (k = 0.25). Then:

• Blended threshold: 8.30 ÷ (0.25 × 0.55) = 8.30 ÷ 0.1375 = 60.36, so about 60 dollars.
• Threshold if you priced for the farthest zones only: 11 ÷ 0.1375 = 80.00 dollars.
• Threshold if you priced for the nearest zones only: 6 ÷ 0.1375 = 43.64, so about 44 dollars.

Now check the 60 dollar line against each group, because the blend hides the far orders. A 60 dollar cart earns 0.55 × 60 = 33 dollars of margin. Shipping takes 6 ÷ 33 = 18 percent of it in zones 1 to 4, 8 ÷ 33 = 24 percent in zones 5 and 6, and 11 ÷ 33 = 33 percent in zones 7 to 9. The far group runs above your 25 percent tolerance at exactly the threshold, and gets better as the cart grows: at 80 dollars the margin is 44 dollars and zone 7 to 9 shipping is 25 percent. So the single line of 60 dollars is a compromise, and you can see its price: far orders at the threshold are the thin ones.

Threshold vs order value spread

The formula gives a line. Your order history tells you what the line does. Export your orders and count how many fall into bands below it, for example 30 to 45, 45 to 60, 60 to 75 and above. What you want to see:

• Many orders just under the line. Those shoppers are one small add-on away. The offer gives you an upsell target, and the cost falls only on the ones who cross.
• Few orders just under the line. The threshold sits far above what most shoppers spend. It will either do little or push a big jump in basket size, which is harder.
• Most orders already above the line. You are giving free shipping to people who would have paid. Raise the line, or limit the offer to a subset of rates.

Write the result as a count, not a feeling: how many orders last month were between 80 percent and 100 percent of the proposed line, and how many were above it. The first group is what the offer can move. The second is its cost.

One more cost sits outside your carrier bill. Colorado's Department of Revenue says its retail delivery fee applies even when shipping is free, so a "free shipping" promise does not remove a state fee line for some deliveries. The mechanics are in the Colorado retail delivery fee guide.

Alaska, Hawaii and territories

The formula does not change for destinations outside the contiguous states, but the S in it does, and often by a lot. Compute S for those destinations separately from your own carrier invoices and decide whether the threshold covers them. If it does not, exclude them from the offer rather than raising the line for everyone. Shopify's free shipping discount lets you pick specific countries, and the next section covers the other control you have.

Setting it up

Shopify gives you two ways to set a threshold, and they behave differently.

Order-amount shipping rates. Shopify's Help Center describes rates based on order amount with Minimum, Maximum and Price fields. You enter the minimum order value for the rate, leave Maximum empty if you want no upper limit, and set Price to blank or 0 to make that tier free. The page warns that orders above your highest tier's maximum get no matching rate, which causes a shipping error at checkout, so leave Maximum empty on your top tier. There is also a plain "Offer free shipping" option with an order minimum.

A free shipping discount. Shopify's free shipping discount help says the minimum purchase amount counts product prices only: "Products are counted towards a minimum purchase amount at their discounted price", and only discounts that can be combined with the free shipping discount lower the counted price. Taxes do not count. You can also check "Exclude shipping rates over a certain amount", which stops the discount from covering expensive rates. For a far-zone problem, that single setting does the job a higher threshold would do, without punishing nearby shoppers.

That second point is the difference to plan around: with a discount-based threshold, a shopper who stacks a combinable promotion can drop below the line, because the discounted price is what counts.

If you want tiers instead of a single line, for example discounted shipping at one cart value and free shipping at a higher one, the Shipping discount tiers template in Freebies Engine by Log Studio Lab is described as discounted or free shipping above a cart value. Plan details are on the pricing page.

Check the result

After a month, recompute three numbers: shipping absorbed as a share of margin on free-shipping orders, the share of orders landing within 10 percent above the line, and the average order value before and after. If the first is above your k, raise the line or exclude the costly rates. If the second is empty, the line is out of reach. A holiday season is a poor month to judge a new line, so give yourself a normal month first, then use the Black Friday Cyber Monday offer plan for the peak.