Hi everyone, I’m working on a project where I need to fetch Gross Sales and Net Sales data with 100% accuracy as a developer. Right now, I know I can use the Admin API (REST/GraphQL) to fetch order data and calculate sales, discounts, returns, and taxes on my side. But I’ve also read that sometime…

Hey @Gridline_Dev , The orders API is going to be the best source of truth here. An example of the following should give you the Gross and Net data you are after. currentTotalPriceSet : The total price of the order, after returns, in shop and presentment currencies. This includes taxes and discoun…

Hey @Gridline_Dev , did the above work for you?

Hi @KyleG-Shopify , any tips for replicating the net/gross sales view over time, shown in Shopify Analytics? I’ve been building out my analytics app, retailQ, and found its very hard to use the API for: removing gift cards (not counted in analytics), but are included in the totalPriceSet/currentTo…

Hey @David-RetailQ , glad you tagged me here. There’s a new shopifyqlQuery field in Graphql which should help simplify some of your analytics queries. [image] ShopifyQL now available as shopifyqlQuery within the GraphQL Admin API -... Shopify’s developer changelog documents all changes t…

Thanks @KyleG-Shopify , that looks great. Do you have any guidance on limits to the data we can put through shopifyQL? I saw this thread which may be a more relevant place to move the discussion shopifyqlQuery with large datasets ? Thanks!

Thanks David. I’m looking in to this and will update that topic you’ve linked once I know more :slight_smile:

Hey @David-RetailQ , I was able to get an answer for you. Posted it in this thread here: [image] shopifyqlQuery with large datasets GraphQL Admin API Troubleshooting Hey @tdavies , following up on your other two questions: 1. Maximum rows: If you don’t specify a…

Hey @KyleG-Shopify , the problem with this approach is that you can’t allocate the refunds to the refund dates like you do in accounting. Do you know how to get things to match, both revenue and refunds (including taxes) when using the refund object? All the best,

Can you share a little more context on a specific order scenario where you’re unable to get things to match? Specifically the steps I can take to replicate the inconsistency you see so I can then work back to find a way to get this to match (if possible) using the refund object.

How to Get Gross sale & Net sales 100% accurate data as a Developer?

GraphQL Admin API Troubleshooting

KyleG-Shopify October 21, 2025, 7:42pm 8

Hey @David-RetailQ, I was able to get an answer for you. Posted it in this thread here:

Topic		Replies	Views
Get Shopify Analytics Data or Reports by API GraphQL Admin API Troubleshooting general-gql-troubles	4	997	April 8, 2025
Need advice on ShopifyQL latency and refund handling (sales dataset) GraphQL Admin API Troubleshooting general-gql-troubles	1	64	April 7, 2026
How to get total sales as per analytics GraphQL Admin API Troubleshooting general-gql-troubles	5	816	December 19, 2024
Issue with Refunds and Sales Totals Using Shopify REST API Products and Orders APIs admin-api-orders	2	232	November 20, 2024
Unable to retrieve lineitem GrossSales from Graphql GraphQL Admin API Troubleshooting general-gql-troubles	4	121	March 9, 2025

How to Get Gross sale & Net sales 100% accurate data as a Developer?

Related topics