Shopify AOV calculator
Enter gross sales, discounts and the number of orders from a Shopify report, and the calculator returns your average order value by Shopify's own formula. Add a goal to see the gap and what it is worth.
How Shopify defines average order value
Average order value, or AOV, is the average value of the orders placed in a period. Shopify's Help Center lists it in its analytics fields as the average value of orders placed, excluding post-order adjustments, with the formula gross sales minus discounts, divided by orders. This calculator follows that definition, so the number it prints should match the report you copied the inputs from.
Two things sit outside it. Taxes and shipping are not in gross sales, and anything that happens after the order, such as a refund or an edit, does not reduce it. If you compare it with a figure from another tool, check that tool's definition first, because many include shipping or net out refunds.
A worked example
Say a store has 12,000 dollars of gross sales, 900 dollars of discounts and 150 orders in a month. Gross sales minus discounts is 11,100 dollars, and divided by 150 orders the AOV is 74 dollars. Discounts took 7.5 percent of gross sales, which is worth seeing next to the average: a store that holds AOV by discounting more is buying it.
Now set a goal of 85 dollars. The gap is 11 dollars, a rise of about 14.9 percent, and if all 150 orders reached it the month would add 1,650 dollars in sales. That is the scale of the prize for a spend-and-get offer, a bundle or a free shipping line. It is a ceiling, since not every shopper moves.
What AOV does not tell you
AOV counts sales, not profit. Anything that adds sales raises it, including a deep discount on a second item, so it can rise while earnings per order fall. The mean is also easy to distort: one large order can lift it far above what a typical shopper spends, which matters if you set a threshold from it. Read the median and the spread next to the average, and pair it with profit per order.
Once you have the number, the guide linked below covers the 12 levers that move it and how to measure a change fairly. A common first step is a gift or free shipping line set above your median order, tested against a same-length window.
How the math works
Average order value = (gross sales − discounts) ÷ orders, the formula in Shopify's analytics fields. Gap to goal = goal − average order value; added sales = gap × orders.
- Gross sales are product price times quantity, before taxes, shipping and discounts. Taxes and shipping are not part of the figure.
- Shopify excludes post-order adjustments, so refunds and edits made after the order do not lower the number. A store with many returns can show a healthy average on sales that later shrink.
- The goal line assumes the same number of orders. Real lifts shift order counts too, so treat the added sales as a size check, not a forecast.
The derivation, with worked examples, is in Average Order Value: Formula and 12 Levers. Every figure the calculator shows comes from the numbers you type; nothing is a benchmark.
Questions about this calculator
How does Shopify calculate average order value?
Shopify's analytics fields define average order value as the average value of orders placed, excluding post-order adjustments, calculated as (gross sales − discounts) ÷ orders. Taxes and shipping are not part of gross sales.
Does AOV include shipping and taxes?
Not in Shopify's definition. Gross sales are product price times quantity before taxes, shipping and discounts, and the AOV formula subtracts discounts from that. Other tools may count shipping, so check their definition before comparing.
What is a good average order value?
There is no universal number, and we do not quote one. A good AOV is one that rises while profit per order holds. Compare your own periods of the same length, and read the median and profit per order next to the mean.
How do I raise AOV without cutting margin?
Add items to the cart at a healthy margin rather than discounting what is already there. A spend-and-get gift, a bundle, a frequently bought together suggestion or a free shipping line set above your median order are the usual first tests. Measure one at a time against a same-length window.
Why is my AOV different from my accountant's number?
Shopify's figure excludes post-order adjustments such as refunds and subtracts discounts, but not taxes or shipping. A report that nets out refunds, or adds shipping, will print a different average for the same orders.
Related reading
Sources
- Shopify Help Center: Analytics fields (accessed November 1, 2026)