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

[KyleG-Shopify]

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

shopifyqlQuery with large datasets

Hey @tdavies, following up on your other two questions: 1. Maximum rows: If you don’t specify a LIMIT in your query, it defaults to 1000 rows. You can set a different limit explicitly using the LIMIT keyword. 2. Pagination: This is supported through LIMIT combined with OFFSET. For context, this works the same way as the LIMIT/OFFSET pattern in the Shopify Analytics query editor. The OFFSET parameter skips a specified number of rows before returning results. https://help.shopify.com/en/manual…