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?
Topic summary
Issue: A team’s data warehouse built on Shopify’s GraphQL and REST APIs shows mismatched gross sales, net sales, and other stats versus Shopify’s native reports.
Context: Calculating these values is nuanced, and there’s no official, comprehensive guide for reproducing Shopify’s report metrics from raw API data.
Recommendations:
- Use the ShopifyQL API to access reporting-oriented queries that may align more closely with Shopify’s reports.
- Consider third-party reporting apps (e.g., Better Reports, Report Toaster) that have implemented the necessary logic to match Shopify’s calculations.
Status: No root cause or specific miscalculation identified; only practical paths forward were proposed.
Open items: Exact formulas/logic behind Shopify’s reported metrics remain unspecified; reconciliation steps and validation approach were not provided. Discussion remains open without a confirmed resolution.
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:
-
Use the ShopifyQL API
-
Use a reporting app like Better Reports or Report Toaster. They have already done all of the work for you.