Our company integrates with the Shopify POS and we will calculate daily total sales for a customer as part of our dashboard. Customer has found discrepancies in what they see on their own Shopify dashboard and what we calculate - which seems typically be due to refunds. Can I get clarification what …

Hi, @guster-dev-123 Your current method of calculating refund totals seems correct. You are subtracting the refunded amount from the total order price, which should give you the net sales amount for the order. The reason for discrepancies between your calculations and what the customer sees on the…

Thank you for taking time to address the issue. I do not think timing is an issue as the customer seems to come to us after some time has past (at least a week or so). Can you elaborate more on other factors at play (taxes, shipping costs)? Are there other properties on the order resource that sho…

Yes, taxes and shipping costs could be factors that are affecting the total sales amount for an order. Depending on how the customer has set up their Shopify store, taxes and shipping costs may be included in the order total, or they may be added on separately. To account for taxes and shipping cos…

This sounds like the total_price property cannot be reliably used to calculate the TOTAL calculations of an order (excluding refunds). What does it effectively represent then? Are you suggesting that we use the following properties to calculate sales (total_tax, total_shipping_price_set, subtotal_pr…

How do I calculate total sales for an order including refunds?

Retired Boards Appdev Graphql Basics And Troubleshooting

team_supercrew July 19, 2024, 6:24am 6

Hey @guster-dev-123 ,

Could you figure out a reliable formula to calculate “Total Sales”?

Also, curious why you didn’t take “kind = void” into account while calculating the returns.

Topic		Replies	Views
Discrepancy Between API Calls and Shopify Dashboard Total Sales Calculation Graphql Basics And Troubleshooting optimization , troubleshooting	0	143	October 9, 2024
Retrieving Return Order Amounts via Shopify Admin REST API Technical Q&A sales-channels	1	318	May 20, 2025
How to calculate refunds properly from an order? Use transactions amount or refund_line_items? Customers Discounts And Orders order-management , troubleshooting , Setting-Up	1	94	July 7, 2024
Mismatch in Sales Generated via API when compared to Shopify Reports Graphql Basics And Troubleshooting	1	155	December 22, 2023
Total sales and graphql API Custom Storefronts	3	147	December 3, 2019

How do I calculate total sales for an order including refunds?

Related topics