Shopify Sales Reports: What to Track Beyond the Dashboard

Shopify's built-in analytics tell you what sold. A good Shopify sales report tells you whether it was worth selling: net sales after discounts and returns, gross margin, how many customers came back, and which products and channels actually carry the business. This guide covers the metrics to add, how to calculate them, and a report layout you can reuse every month.

Why the dashboard is not enough

Dashboards are built for watching today. Reports are built for decisions. The dashboard shows a big total sales number and a sessions graph; it rarely puts this month next to the last three, splits new from returning customers in rand terms, or shows how much of your growth came from discounting. Those comparisons are where the insight is, so your report should be built around them.

Get the sales definitions straight

Most arguments about Shopify numbers are really arguments about definitions. Pick one set, write it down and keep it:

In South Africa, VAT matters here: decide whether your report shows figures including or excluding VAT and label every total. Mixing the two is one of the fastest ways to lose a reader's trust. See South African e-commerce reporting for more local detail.

Metrics worth adding beyond total sales

Gross margin

Gross margin = (net sales − cost of goods sold) ÷ net sales. If you store product costs, margin is the single most valuable addition. Say you sold R132,000 net with R79,000 of cost: margin is 40%. A month where sales rose 10% but margin fell from 44% to 38% is not a good month, and only a margin line will show it.

Average order value and units per order

AOV = net sales ÷ number of orders. Pair it with units per order. If AOV rises because customers buy more items, bundles are working. If it rises only because prices went up, conversion may suffer next month.

New versus returning customers

Split both orders and net sales by first-time and returning customers. Repeat purchase rate = customers with 2+ orders ÷ all customers in a window such as the last 12 months. A shop that depends on new customers every month is exposed to advertising costs; a rising returning share is a sign of a healthy brand.

Discount dependence

Discount rate = discounts ÷ gross sales. Also report the share of orders that used a code. If 60% of orders need a code to convert, your real price is the discounted one.

Return rate by product

Overall return rate hides problems. Rank products by return value and return rate; a single product with sizing or quality issues often explains most returns.

Product and channel performance

A product table should rank by net sales and show units, margin and return rate side by side. Add a simple Pareto check: what share of net sales comes from the top 20% of products? If a handful of products carry the business, stock-outs on those items are your biggest risk. Then split sales by channel or source (online store, social, marketplace, point of sale) so you can see where growth is coming from. The e-commerce KPIs guide lists more metrics if you want to extend this.

A monthly Shopify report template

1. Summary: net sales, margin and orders versus last month and the same month last year, in plain sentences.
2. KPI row: net sales, orders, AOV, gross margin, repeat customer share, return rate.
3. Trend chart: net sales by week for the last 13 weeks.
4. Products: top 10 by net sales with margin and return rate; bottom movers.
5. Customers: new vs returning orders and sales.
6. Discounts: discount rate and top codes by usage.
7. Actions: three concrete things to do next month.

Summarix can connect Shopify as a data source and generate this kind of report: every KPI and chart is computed from your data by code, and the AI writes the summary, insights and recommendations around those figures. You can also ask follow-up questions in plain English on paid plans, such as which products drove the drop in margin.

Pitfalls to avoid

• Comparing a 31-day month with a 30-day month without noting it, or comparing across a big sale event.
• Counting cancelled or test orders.
• Reporting VAT-inclusive sales next to VAT-exclusive costs.
• Leaving shipping income inside net sales, which inflates AOV.
• Only looking at totals: always compare with the previous period and the same period last year.

Start with net sales, margin and repeat customers. Once those three are reliable every month, add the product and discount detail. That order gets you useful decisions quickly without drowning in data.