REST to GraphQL order timezone issue

Shopify Plus
1

Hello,

We have been facing an issue with timezones since we migrated from REST to GraphQL (as strongly advised by Shopify).

While REST API used to return customer timezone in orders (created_at field), for some reason GraphQL now returns a UTC date (createdAt). This is very bothersome as we want our analytics app to reflect Shopify reports which use customer’s timezone to calculate daily sales.

While before we could perfectly align our results to Shopify’s reports, we now have timezone gaps and data is desync.

We tried to:

  • Use Shop’s timezone: not usefull as some countries have multiple timezones (ex: USA)

  • Use Customer shipping address timeZone: seems to not always be aligned with REST customer timezone

  • Calculate timezone with longitude and latitude values: prone to error because of some geographical singularities.

So now we have been stuck for months with analytics gaps which make our data correctness controls very hard.

Why wouldn’t GraphQL provide the customer timezone as REST used to? I don’t see any trouble with sending two fields, something like “createdAt” and “createdAtLocal” would do the job.

If you have any insights on this, thank you.

2

Does somebody have a solution for this? Thank you!