My sales data doesn't match what I see in Shopify

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:

  1. You've selected a timespan longer than the number of days' worth of imported data
  2. Geckoboard accounts for refunds on the order processed date, not refund processed date

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. 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 performs those calculations ourselves. Due to the way Shopify's API is set up which affects how we import and store data, we need to write a much more complex SQL query to match the behaviour of this metric in Shopify.

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.
Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.