mismatch Shopify Report and GraphQL & Rest API

[MarcBakker]

Hi my tech team built a data warehouse and tried with GraphQL & Rest API but gross sales, net sales, or all other stats are mismatched with Shopify report data. Anyone have an idea what could go wrong?

[CloudlabSam]

There's a lot of nuance to calculating all of these values and there is no guide to achieve it. Two options that might get you there more quickly:

1. Use the ShopifyQL API

2. Use a reporting app like Better Reports or Report Toaster. They have already done all of the work for you.