Average Order Value: Formula and 12 Levers

Average order value is the first number most stores watch and the one most often misread. It tells you how much a typical order is worth in sales, not how much it earns, and it can rise while profit falls. This page gives the formula as Shopify defines it, shows what is and is not inside it, explains why the mean can mislead and what to read next to it, and then lists 12 levers that move it, each tied to the offer template that implements it. There are no uplift percentages here: none of the levers has a number we could source, so each one comes with the question to ask of your own data.

The formula and Shopify's definition

Average order value (AOV) is total order sales divided by the number of orders. Shopify's Help Center defines it in its analytics fields list as the "average value of orders placed, excluding any post-order adjustments," with the formula "(gross sales − discounts) / orders." The sales report page words it nearly the same way: gross sales (excluding adjustments) minus discounts (excluding adjustments), divided by the number of orders.

What that means for what is in and out:

• Discounts are subtracted. A 100 dollar basket with a 10 dollar discount counts as 90 dollars.
• Taxes and shipping are not in it. The sales report defines gross sales as product price times quantity "before taxes, shipping, discounts, and sales reversals."
• Post-order adjustments are excluded. Edits and returns made after the order is placed do not lower the figure. A store with many returns can show a healthy AOV on a number that later shrinks.

Confirm the definition on the report you use before you compare figures across tools. A quick example: three orders with 300 dollars of gross sales and 30 dollars of discounts give (300 − 30) ÷ 3 = 90 dollars.

Median versus mean

The mean is easy to compute and easy to distort. Ten orders, in dollars: 20, 22, 24, 25, 26, 28, 30, 32, 35 and 258. They add to 500, so the mean is 50.00. Nine of the ten orders are 35 or less. The median, the middle of the sorted list, is (26 + 28) ÷ 2 = 27.00. One large order lifted the mean to nearly double what the typical shopper spends.

For a threshold or a tier, the median and the spread matter more than the mean. A free-shipping line at 50 dollars looks reachable against a mean of 50 and is out of reach for nine in ten of these shoppers. To compute your own median, Shopify lets you export orders as a CSV from the Orders page, and the file includes the subtotal before shipping and taxes plus the discount amount. If the file has more than one row per order, collapse it to one row per order before sorting. Then look at percentiles, not one average: where the 25th, 50th and 75th orders sit tells you where a line can go.

Why AOV alone misleads

AOV counts sales, so anything that adds sales raises it, including a deep discount on the second item. Two stores can have the same AOV and very different results. Take Store X with a 60 dollar AOV and a 30 percent product margin, and Store Y with a 50 dollar AOV and a 50 percent margin. Product profit per order is 18 dollars for X and 25 for Y, so the store with the lower AOV earns more per order. Those figures are illustrations, not benchmarks.

So pair AOV with profit per order: sales minus product cost, minus the card fee, minus anything you gave away in a gift or a discount. The cost of discounting works through that arithmetic. A lever that lifts AOV by adding items at a healthy margin is good. A lever that lifts AOV by selling more at a thin margin is not.

The 12 levers

Each lever is tied to the template in Freebies Engine by Log Studio Lab that sets it up. Template names and descriptions are as they appear in the app.

1. A spend-and-get gift. "Spend X, get a gift": shoppers who reach a cart value get a gift added automatically. Set the line above your median, not at it, and use the gift's landed cost in the math. See setting a free gift threshold.
2. Gift tiers. "Gift tiers": more spent, more gifts, in as many steps as you like. A second step gives shoppers who already clear the first line a reason to keep going.
3. Buy X, get Y. The offer where buying certain products earns a different product. It raises AOV by pulling a second item into the basket; buy X get Y offer structures compares the options with their margin per order.
4. Buy one, get one (BOGO). Buy a product, get another copy. This works for consumables and fits stores whose margin can carry the second unit; check it against the break-even math.
5. A classic bundle. Fixed products sold together at a bundle price. The price should come from a floor built on item costs; bundle pricing shows the method. Plan requirements for bundle templates are on the pricing page.
6. Mix and match. Shoppers pick any items from a set for a fixed price, which sets the basket size by itself.
7. Frequently bought together. Suggest matching products on the product page. See frequently bought together on Shopify.
8. A volume discount. The more shoppers buy, the less each costs. It moves quantity per order rather than the cart value.
9. Cart discount tiers. A discount on the whole cart that grows with spend, useful when your catalog has many price points.
10. A shipping discount tier. Discounted or free shipping above a cart value. The free shipping threshold formula shows how to pick the line.
11. A progress bar. Shows how close the cart is to a reward; it makes lines 1, 2 and 10 visible while the shopper is deciding.
12. A checkout upsell. Offers one more product inside checkout. It requires Shopify Plus.

Levers 1, 2, 9 and 10 depend on the shopper reaching a line, so they depend on your median. Levers 3 to 8 work on what is in the cart rather than on a spend line.

Measuring a lever

Compare like with like. Use two windows of the same length that cover the same weekdays, and keep other promotions out of both. Record before and after for orders, AOV, median order value and profit per order, not AOV alone. Run it long enough that one big order cannot decide the result: if an order from a wholesale buyer lands in one window, remove it from both and compare again. If AOV rose while orders per day fell, you moved sales from one place to another and the answer lies in profit per order.

Change one lever at a time. If you launch a shipping line and a gift tier in the same week, you will not know which one did the work.

Start with one

The most direct first test is a spend-and-get gift, because it adds items to the cart without touching the price of anything already in it. The Spend X, get a gift template in Freebies Engine by Log Studio Lab is described as giving shoppers who reach a cart value a gift added automatically. Pick a gift whose landed cost your margin can carry, set the line from your median, and measure it with the windows above.