If you’re experiencing discrepancies between the values for some metrics in Shopify — like Orders, Customer count, and other sales-related metrics — and what you see in Supermetrics, matching the timezone of your Supermetrics report to the setting in Shopify could help solve the issue.
Instructions
To check for the timezone in Shopify:
- Log in to Shopify.
- Select the correct store from the dropdown menu, if you have access to more than one store.
- Click Settings in the lower left corner.
- Scroll down to Standards and formats and check Time zone.
About Shopify's timezone settings
Here’s an example of how a mismatch in this setting can cause discrepancies between Supermetrics reporting and Shopify’s data.
Let's say Store A on Shopify has been set up to use Los Angeles’ timezone, which is 7 hours behind Coordinated Universal Time (UTC). This is written as UTC-7. If this is the case, then all its reports shown in Shopify will use that same timezone: UTC-7.
But Supermetrics uses UTC-0 in Looker Studio (formerly Data Studio), unless the time zone for the Looker Studio report has been changed to match the timezone of the store. This will cause dates shown in Shopify’s own reports to often differ from the dates that Supermetrics provides for Looker Studio reports.
Example
For example, let’s say 2 different orders, A and B, are made to a Shopify store that is using Los Angeles’ UTC-7 timezone on September 21.
Order A will have:
- The date 21 September in Shopify’s reports
- The date 21 September in Looker Studio reports created with Supermetrics
But order B will have:
- The date 21 September in Shopify’s reports
- The date 22 September in Looker Studio reports created with Supermetrics
So if your Supermetrics report uses 21 September in Looker Studio, it won’t get data for Order B.
