Average order value (AOV) is the dollar amount your store earns, on average, every time a customer places an order. It is one of the most-watched numbers in ecommerce because lifting AOV is usually faster and cheaper than acquiring new customers: you already have the shopper in the cart, you already paid for the traffic, and the only remaining lever is how much they decide to buy. This calculator computes your current AOV, compares it to the previous period, and projects how much extra revenue an upsell or cross-sell program could add to every order.
Enter your revenue and order counts and every figure updates instantly. Add a previous period to see whether your basket size is growing, shrinking, or flat — and then layer in an upsell offer to model the realistic uplift it could produce over the next month or quarter.
How to Use
- Enter the Current Period Revenue — total sales (gross, before refunds if that is how you track it) for the window you care about, such as the last 30 days.
- Enter the Current Period Orders — the number of completed orders in that same window. Use completed orders, not sessions, visitors, or abandoned carts.
- Optionally fill in the Previous Period Revenue and Previous Period Orders for the matching prior window (e.g., the 30 days before). The calculator then shows the percent change in AOV period over period.
- Optionally set the Upsell Attach Rate — the share of orders that accept an offer, such as 20% for a one-click checkout add-on.
- Optionally set the Average Upsell Value — the typical extra dollars added when an offer is accepted, for example a $10 protection plan or a $15 bundle upgrade.
- Read the result card: your current AOV, the previous AOV, the percent change, the per-order upsell uplift, the projected AOV once the upsell is live, and the total projected revenue uplift over the period.
The AOV Formula
Average order value is one of the simplest formulas in retail analytics:
AOV = Total Revenue ÷ Number of Orders
That is it. If your store did $50,000 in revenue across 2,000 orders last month, your AOV is $25.00. The trap people fall into is dividing revenue by sessions, by visitors, or by product units — those give different metrics (revenue per session and units per order) and they will mislead your decisions. Use completed orders as the denominator.
To measure whether your AOV is moving in the right direction, compare it period over period:
AOV Change % = (AOV_current − AOV_previous) ÷ AOV_previous × 100
If AOV was $20.00 last quarter and is $25.00 now, that is a 25% improvement. Notice this is not the same as total revenue growth: revenue can rise because you got more traffic while AOV stayed flat, or revenue can rise purely because each basket got bigger. Tracking AOV separately tells you which lever you pulled.
Finally, the upsell projection assumes a simple blended uplift:
Projected AOV = Current AOV + (Average Upsell Value × Attach Rate ÷ 100)
A $10 upsell accepted on 20% of orders adds $2.00 to the blended basket. Multiply that by your order count and you get the projected period uplift.
Why AOV Matters More Than Traffic
Marketing teams often fixate on sessions and conversion rate, but AOV is the quiet profit driver. Doubling conversion usually requires new ad spend, a faster checkout, or a CRO overhaul. Doubling AOV — even by 10–20% — can come from a single well-placed bundle, a free-shipping threshold, or a post-purchase one-click offer, all of which cost almost nothing to ship.
Raising the free-shipping threshold just above your current AOV is one of the most reliable moves. If shoppers spend $25 on average and free shipping kicks in at $35, many will add a small item to qualify. That lifts both AOV and margin, because the marginal item usually ships in the same box anyway.
Examples
Example 1 — Baseline AOV. A DTC apparel store reports $50,000 in revenue over 2,000 orders. AOV = 50,000 ÷ 2,000 = $25.00. Comparing to the prior period of $40,000 across 2,000 orders (AOV $20.00), the store grew AOV by 25% while order count was flat — clear evidence that bundling and size-upcrosses are working, not ads.
Example 2 — Adding an upsell. On that same $25.00 AOV, the store tests a $10 garment care spray accepted on 20% of orders. Per-order uplift = 10 × 20% = $2.00, so projected AOV becomes $27.00. Across 2,000 orders, that is $4,000 of incremental revenue in the period — almost entirely margin, because the spray ships in the same package.
Example 3 — High-volume store. A marketplace seller does $10,000,000 in revenue across 250,000 orders, for an AOV of $40.00. A conservative 15% attach rate on a $5 protection plan adds $0.75 per order, lifting projected AOV to $40.75 — and pushing more than $187,000 a year in incremental revenue, without buying a single extra visitor.
FAQ
What is average order value?
Average order value, or AOV, is the average dollar amount spent each time a customer places an order on your store, calculated over a chosen period. It equals total revenue divided by the number of completed orders. It is not the same as revenue per visitor or units per order.
How do I calculate AOV in Excel or Sheets?
Use the simple formula =Revenue/Orders. For example, if column B holds daily revenue and column C holds daily orders, a monthly AOV is =SUM(B1:B30)/SUM(C1:C30). Sum revenue and sum orders first, then divide — do not average the daily AOV values, because that weights small and large days equally.
What is a good AOV for ecommerce?
It depends heavily on your niche. Apparel and convenience stores often sit near $25–$50, while furniture, electronics, and jewelry retailers commonly see $150–$500 or more. The most useful benchmark is your own AOV last quarter: aim for a 5–10% period-over-period improvement rather than chasing an external number.
How can I increase my average order value?
The proven levers are: raise the free-shipping threshold just above your current AOV; offer product bundles with a small discount; add one-click post-purchase upsells; recommend frequently-bought-together items on the product page; and introduce loyalty rewards that reward higher baskets. Each of these lifts AOV without paying for new traffic.
Does AOV change if I add more products?
Not automatically. Adding a cheap accessory can lower AOV if many buyers only purchase that accessory, while adding a premium bundle can raise it. Watch the blended figure over a full 30–60 day window so one-time promotions do not distort the trend.
What is the difference between AOV and CLV?
AOV measures the average dollar of a single order, while customer lifetime value (CLV) measures the total dollars a shopper spends with you across the entire relationship. AOV multiplied by repeat purchase frequency and retention rate is one way to estimate CLV.
Disclaimer
This average order value calculator is provided for informational purposes only and does not constitute financial, accounting, or business advice. Results are based on the revenue and order counts you enter; refunds, taxes, shipping fees, and currency conversions may change your true AOV. Always reconcile against your own ecommerce platform's reporting before making budgeting or merchandising decisions.