All Collections
Connect to pre-built integrations
Sales data sources
Sales data discrepancies between Shopify and Geckoboard
Sales data discrepancies between Shopify and Geckoboard
Why sales numbers on your Shopify widgets don't always match up with values you see in Shopify.
Updated over a week ago

If you've noticed discrepancies between the numbers displaying on your Shopify widgets and within Shopify it's likely to be one of two reasons:

Selected timespan longer than the accumulated imported data

When you first connect your Shopify data to Geckoboard we'll import the last 31 days of data. Then, over time, we accumulate more of your data. You can select any time period in the config, but how far back Geckoboard can go is always limited by when you connected to your Shopify and we imported your data. Shopify's API limits us to a 60 days' worth of imported data.

This means if you were to select a timespan of 'Past 90 days' and you've only recently connected your data, it's not going to match what you see if you compare 3 months of sales in Shopify.

If you're not sure how far back your imported data goes in Geckoboard, try switching your visualization type to a Line chart and, if needed, increasing the timespan to see the date your data starts.

switch to a line chart with a long timespan to see when your import date began

Geckoboard and Shopify account for refunds on different dates

Geckoboard accounts for refunds on the order processed date, not the refund processed date. This is because Shopify's API doesn't pre-calculate any metrics, which means we have to perform those calculations ourselves.

Due to the way Shopify's API is set up, which affects how we import and store data, there isn't currently a way to replicate Shopify's behaviour for sales related data.

In Shopify:

  • If an order is processed (made) on Monday and refunded on Wednesday (today for the purpose of this example), that order counts as a positive amount on Monday and a negative amount on Wednesday.

  • So if you have a line chart by day, you'd see that order attributed on Monday and removed from the totals on Wednesday.

  • Or if you select "Sales today", bearing in mind that today is that Wednesday, then the refunded order would be deducted from whatever the sales total is.

In Geckoboard, however:

  • If you have a line chart by day, that order basically wouldn't exist because Geckoboard will have logged it as processed and refunded on the same day. Geckoboard still factors it into its calculation but it would effectively return 0.

  • Or if you select "Sales today" on the Wednesday when the order was refunded, Geckoboard wouldn't deduct that refund from today's orders. So your Net or Total Sales number for today would be higher than what you see in Shopify today. And it would be lower than what you see in Shopify for the Monday.

Did this answer your question?