E-Commerce Finance
AOV & Free-Shipping Threshold Calculator
The AOV and Free-Shipping Threshold Calculator computes your current average order value and turns it into a tested starting range for a free-shipping threshold set modestly above it. From total revenue and order count it returns your AOV, a suggested threshold range of roughly 15 to 30 percent above AOV, and a single suggested threshold near 20 percent above AOV. The result is a practical starting point for nudging customers to add one more item, not a guaranteed number.
Who it's for: Shopify and DTC operators who want to raise average order value by setting a free-shipping threshold a little above what customers already spend.
How the AOV & Free-Shipping Threshold Calculator works
You enter total revenue and the number of orders for a period, and the tool divides revenue by orders to compute your current average order value. AOV is the foundation for the threshold logic, so use a representative recent window rather than an unusually high or low stretch, and the resulting threshold suggestions will follow directly from it.
The suggested free-shipping threshold range is your AOV multiplied by 1.15 on the low end and 1.30 on the high end, meaning roughly 15 to 30 percent above what customers typically spend. The idea is to place the threshold close enough that many shoppers can reach it by adding a single item, but high enough that hitting it meaningfully lifts the order. Set it too far above AOV and most carts never qualify; set it at or below AOV and you give away shipping without changing behavior.
For a single starting point, the tool suggests a threshold near AOV multiplied by 1.20, rounded to a clean number that reads well on site. Rounding matters because a tidy threshold is easier for shoppers to aim for and looks more deliberate than an odd figure, so a calculated 47.40 is better shown as 50. Treat this single number as the middle of the recommended range, a sensible default to launch with before you test variations up or down.
Every output here is a heuristic, not a promise. The right threshold depends on your category, margin, and how price-sensitive your shoppers are, so the only way to know is to test. Set the suggested threshold, watch how AOV and conversion move together, and adjust within the range, because pushing AOV up only helps if the extra revenue more than covers the shipping you absorb and any drop in conversion.
The formula
AOV = total revenue / number of orders. Suggested free-shipping threshold range = AOV x 1.15 to AOV x 1.30 (about 15 to 30 percent above AOV). Suggested single threshold is approximately AOV x 1.20, rounded to a clean number. These are heuristic starting points to test, not guaranteed figures.
Frequently asked questions
Why set the free-shipping threshold above my current AOV instead of at it?+
If the threshold sits at or below what customers already spend, most orders qualify automatically and you simply absorb shipping cost without changing behavior. Setting it modestly above AOV gives shoppers a reason to add one more item to reach free shipping, which is what lifts the average order. The aim is a threshold close enough to feel attainable but high enough that reaching it actually grows the cart.
Why is the suggestion a range rather than one exact number?+
The best threshold depends on your category, margins, and how price-sensitive your shoppers are, none of which a formula can fully capture. The 15 to 30 percent range gives you a sensible window to test within, and the single suggested value near 20 percent above AOV is just a reasonable midpoint to start from. The range exists precisely because the optimal point is found through testing, not calculation.
How do I know if the threshold is actually working?+
Watch average order value and conversion rate together after you set it. A higher threshold can lift AOV but may dampen conversion if it feels out of reach, so the goal is net more profit, not just a bigger average order. If conversion drops sharply, move the threshold down within the range; if shoppers clear it easily with little lift, test moving it up.
Does a higher AOV from free shipping always mean more profit?+
Not automatically. Free shipping is a cost you absorb, so the extra margin from larger orders has to exceed the shipping you give away plus any conversion you lose. If the added item is low margin or the shipping cost is high, a higher AOV can still leave you worse off. Always weigh the threshold against your contribution margin, not against revenue alone.
What period should I use to calculate AOV for the threshold?+
Use a recent, representative window of total revenue and orders rather than a single day or a major sale period that skews the average. A few weeks to a few months of normal trading usually gives a stable AOV that the threshold logic can build on. If your AOV swings seasonally, recalculate periodically so the threshold stays aligned with how customers are actually buying right now, and consider excluding outliers like a handful of unusually large wholesale or bulk orders that can pull the average well above what typical retail shoppers spend.