Formulas used by this calculator
- AOV = included order revenue ÷ matching order count
- Combined AOV = sum of compatible order revenue ÷ sum of matching orders
Worked example
Illustrative revenue from 120 orders is $9,600. AOV is 9,600 ÷ 120 = $80.
If those orders belong to 100 customers, dividing by 100 gives $96 of revenue per customer instead. That is a different metric, not a higher version of the same AOV.
Choose the revenue and order scope
Shopify explains the basic AOV formula as revenue divided by order count within a matching period. Shopify: average order value formula.
Define eligible orders before exporting. Decide how test orders, cancellations, discounts, partial refunds, shipping charges, and pass-through taxes enter the calculation. This tool follows your inputs; it does not reproduce a platform report unless those definitions also match.
Do not confuse basket size with customer economics
One customer can place several orders, and one order can contain several products. AOV averages the order total. It does not measure the number of new customers, units per basket, repeat-purchase frequency, or lifetime contribution.
A promotion that raises order value can also raise product cost or shipping subsidy. Check contribution after those costs before increasing the acquisition budget. Higher revenue per order does not automatically create a larger amount available for advertising.
Read averages with the underlying mix
A few unusually large baskets can change an average. Review important cohorts, such as first orders versus repeat orders or bundles versus single items, when their economics differ. The total-only inputs cannot reveal the distribution of individual basket values.
For a combined period, sum compatible revenue and order counts rather than averaging daily AOV values. A quiet day and a busy promotion day should not receive equal weight. Retain the totals and adjustments with the downloaded worksheet.
Common questions
Should I subtract refunds?
Use the refund treatment required by your reporting question and keep the matching order cohort clear. Do not subtract the same adjustment twice. A refund-adjusted AOV may differ from a platform's standard sales report.
Can this calculate median order value?
No. Median requires individual order values or their distribution. Two aggregate totals provide the arithmetic mean only. The tool does not infer a median or the most common basket from them.