Why Do My Numbers Not Match With Shopify?
Confused about why your Shopify sales and FunnelShoot numbers aren't exactly the same?
In this article we'll cover:
- Why your numbers aren't matching?
- How different can FunnelShoot and Shopify numbers be?
Why Your Numbers Aren't Matching?
In most cases, your numbers aren't matching because of one main reason...
Shopify hasn't yet launched API support for Order Editing (as of writing this article).
That means that if you, your staff, or an app you're using edits an order, Shopify doesn't tell FunnelShoot (or any other app):
- When the order was edited.
- What changes were made in the edit.
This means that FunnelShoot has to attribute certain numbers (like Gross Sales) to the date the order was placed. Whereas Shopify attributes those numbers to the date the order was edited (more in the example below).
If you wish to explore this further, here are two popular articles on the Shopify community that cover order editing API support:
- Order Editing API - Missing Edited_At Timestamp
- Get a version of an edited order, or get previous edit data
Order Editing Example
Let's say that:
- James placed an order on your website on the 2nd of October for $100.
- James contacted your customer support on the 3rd of October and requested to add an extra widget that costs $25.
- Your customer support agent adds the additional widget to the order using the order editing feature on the 3rd of October.
- James pays for this addition through an invoice sent by your customer support agent through Shopify.
- The gross sales value is now $125 ($100 on the 2nd of October and $25 on the 3rd of October).
Shopify will attribute $100 to the 2nd of October and $25 to the 3rd of October. However, FunnelShoot will attribute $125 to the 2nd of October.
Because Shopify's API (what FunnelShoot uses to integrate with Shopify) doesn't actually have any record of when the order was edited.
How Different Can FunnelShoot and Shopify Numbers Be?
If you, your staff, or the apps you're using don't use Shopify's order editing feature, the numbers should match 100%.
If you are (directly or indirectly) using the order editing feature, the margin of error (how far off your numbers are) depends on how many orders have been edited.
- Fewer orders edited = lower margin of error.
- Larger date range selected = lower margin of error.
From what we've seen, the margin of error is almost always under 1% (mostly between 0.02% and 0.3%). However, this will vary on your store setup, apps, and usage of the order edit feature.
Longer Date Range Selected
If you select a longer time period, the margin of error goes down. In the example above, if you selected 1-31st October (instead of only 2nd October), James' gross order value would $125 on both, Shopify and FunnelShoot.
For a short time period (such as 1 day or 1 week)
- If your Gross Sales are $300 USD, then your numbers will be off by around $3 USD at most.
- If your Gross Sales are $200,000 USD, then your numbers will be off by around $2000 USD at most
For a larger time period, the margin of error should be considerably lower.
We're always striving for the highest level of accuracy. As soon as Shopify releases support for Order Editing, we'll update our algorithm to match.
You can stay posted on updates by joining our newsletter, subscribing to FunnelShoot, or joining our Facebook support group.