Hey. Not sure if this is a technical issue or I’m just not understanding how the sales reporting works, but I’m seeing major discrepancies between my Shopify Analytics dashboard, depending on where I look.
Let’s take the 17th of September as an example. Inside the dashboard, I see 5,958.06$ in total sales.
The same number of 6,648.60$ is shown when I export all my orders from the 17th of September and add up the total sales.
Same goes for order count. When I look at the orders list, I had 281 individual orders, but in the sales report dashboard I see 251 orders. I had no refunds that could mess up the numbers, yet I’m still missing 30 actual orders from the sales report.
Am I just being stupid in reading the numbers or is there a reason for this discrepancy?
This is really important, as we’re pulling Shopify data from the reports via Supermetrics and often take business decisions based on these numbers.
Those two reports come from completely different data sources, soo sometimes it can be tricky to make an apples to apples comparison. Since you have such a high order count discrepancy, you are likely dealing with a date range difference, like maybe with timezones.
The best way to troubleshoot this is to export both sources at the order level and find an order or two that dhow on one report and not the other. Then you can look at those orders to find the reason for the discrepancy.
Thank you for the response. I think the time zone difference between orders might be the culprit.
I’ve recently added Australia, New Zealand, Ireland and UK to my ads targeting, whereas I only had US before. So orders coming in from different time zones might indeed cause these issues.
I can’t really verify the $ net with my payment processors either, since both Stripe and Paypal use different time zones.
Conclusion: bleep timezones (from a data analysis perspective).
