Shopify order export doesn’t match analytics even after adjusting for future orders

Shopify Discussion
,
1

I’ve been trying to reconcile my Shopify data, and I can’t get my order export to match the Analytics “Gross Sales by Order” numbers, even when I adjust for order date differences or future-dated changes.

Here’s what I found so far (based on my reconciliation report):

  • Extra “ghost” orders appear in the Analytics report, but they all have $0 gross value (probably test or cancelled orders).

  • No missing paid orders - all real transactions exist in the export.

  • Around 10% of order have value mismatches (usually off by shipping, rounding, or refund adjustments).

I’ve tried:

:white_check_mark: Aligning both reports on Paid at date instead of Created at

:white_check_mark: Including shipping, taxes, and discounts in my sum formula

:white_check_mark: Excluding test/zero-value orders

Still off =/

Has anyone figured out a clean way to make the order export and analytics reports match 1:1?

Or maybe a better formula to reconcile gross sales accurately?

Any insight, scripts, or workflows that helped you fix this would be gold.

Thanks in advance :folded_hands:

2

Don’t forget about taxes and currency conversions (sometimes). We recently softly launched our Mixtable Analytics app and had to do a lot of this matching work as we calculate the figures that we show on our spreadsheet vs. just use the Shopify analytics numbers (which is what most other reporting apps in the app store do). We are currently free to install and use while we gather feedback, and if you have a second to give us a spin and provide us with feedback (good or bad), we’ll put you on our free plan for the next 12 months.