Shopify Average Order Value Estimator

1. Choose a reporting period
Use the same day, week, month, or quarter for every input.

2. Enter gross sales
Use the revenue definition you want to analyze before subtracting the entered refunds and discounts.

3. Enter order count
Use completed orders under the same reporting definition as the sales figure.

4. Add refunds and discounts
Enter the amounts you want removed to create the adjusted revenue measure.

5. Compare gross and adjusted AOV
Review how promotions and refunds reduce average value per order.

6. Track changes over time
Repeat the calculation with consistent report settings to evaluate merchandising and retention initiatives.

Gross AOV = Gross sales ÷ Orders
Adjusted revenue = Gross sales − Refunds − Discounts
Adjusted AOV = Adjusted revenue ÷ Orders

This model treats refunds and discounts as separate reductions. Make sure they are not already netted from the gross sales input.

What the result means

The adjusted AOV shows the average revenue retained per order after the entered refund and discount reductions.

Shopify report definitions, taxes, shipping income, canceled orders, returns timing, and currency conversion can change the reported value.

Given: Gross sales are $85,000 from 1,250 orders, with $3,200 in refunds and $4,800 in discounts.

Calculation: Adjusted revenue = $85,000 − $3,200 − $4,800 = $77,000. Adjusted AOV = $77,000 ÷ 1,250 = $61.60. Gross AOV = $68.00.

Result: Adjusted average order value is $61.60, which is $6.40 lower per order than the gross figure.