Why Your Shopify Sales Reports Don't Match (And How to Fix It)
If you've ever compared the Total Sales number in your Shopify Analytics dashboard with the Sales by Product report and found they don't match, you're not alone. This is one of the most common frustrations Shopify merchants face, and the reasons behind it are not obvious.
Why Do Shopify Sales Reports Show Different Numbers?
Shopify has multiple reporting views that calculate "total sales" in slightly different ways. Understanding what each one includes (and excludes) is the key to making sense of the discrepancies.
1. The Shopify Analytics Dashboard
The main dashboard shows gross sales minus discounts, returns, and shipping. It aggregates orders at the order level and uses the order's created_at date for attribution. It can also apply rounding at the order level.
2. The Sales by Product Report
The Sales by Product report calculates sales at the line-item level, summing across individual products within each order. When you add up all the product line totals, the result can differ from the order-level total because of how Shopify handles discounts, shipping allocations, and order-level adjustments.
3. Custom Sales and POS Transactions
If your store uses Shopify POS or has custom sale line items ("Custom_Sale" or "_shopify_item_type" entries), these may not map cleanly to a specific product. As a result, they can appear in one report but not another, or show up with no product attribution at all.
4. Refunds and Returns Timing
Refunds are sometimes applied to the original order date, and sometimes to the refund date, depending on which report you use. This can cause the same money to appear differently across reports when you filter by date.
5. Deleted or Archived Products
When a product is deleted from Shopify, its historical sales data becomes orphaned. The orders still exist, but the product attribution is lost. These sales may still appear in your total dashboard numbers but will vanish from the Sales by Product breakdown, creating a gap.
Common Scenarios That Cause Mismatches
Here are the most frequently reported causes of sales report discrepancies on Shopify:
- Order-level discounts not evenly distributed across products
- Shipping charges included in total but not product-level reports
- Custom POS sale items with no product SKU or variant ID
- Deleted products whose sales are no longer attributed to any product
- Date filter differences between reports (order date vs. payment date vs. fulfillment date)
- Currency rounding when selling in multiple currencies
How to Reconcile Your Numbers
The simplest approach is to pick one report and stick with it for business decisions, since consistency matters more than absolute precision. That said, here are some steps to narrow the gap:
Export your orders from the Orders section and add up the totals manually. This gives you the ground truth. Compare this to the Sales by Product export. The difference will tell you how much is coming from non-product line items such as shipping, tips, custom sales, or deleted products.
If you're pulling Shopify data into external tools like Supermetrics, Google Sheets, or a BI dashboard, make sure you understand which API endpoints each tool queries and how they handle order-level adjustments. Many integrations use the orders API and sum line items, which will not match the Shopify dashboard exactly.
Getting Accurate Product-Level Sales Data
For merchants who need reliable product-by-product sales data, especially when making inventory, pricing, or marketing decisions, native Shopify reporting often falls short. The 90-day limit on some reports and the attribution gaps for deleted products make it especially difficult.
Tools like Datma are built specifically to address this. Datma tracks sales at the variant and product level with consistent attribution, preserves data for deleted and archived products, and gives you a single source of truth across your store. If you're regularly reconciling Shopify reports and finding gaps, a dedicated product analytics tool is worth looking at.
You can try Datma free for 14 days on the Shopify App Store.
Summary
Shopify sales report discrepancies are almost always explainable once you understand what each report includes. The main culprits are order-level vs. line-item calculations, deleted product attribution, POS custom sales, and date filter differences. For merchants who need consistent, accurate product-level reporting, supplementing Shopify's native analytics with a dedicated tool is the most reliable solution.