I am facing problem in order reconcillation on quickbook whenever we are applying a discount after an order was paid.
Shopify is updating the order total with the discount amount and also providing the refund result in incorrect posting in accounting.
For example- Order total was 100$ and shopify has also captured the payment of 100$. Noe seller has edited the order and applied 10$ discount , refunded this 10$ to customer.
Now, in shopify order response , you will get the order total as 90$ and also get refund of 10$.
It is creating a problem because I need to somehow ignore the discount update from order.
Ideally , shopify has not updated the order and still have provided the order total as original which is 100$ just as they are not doing when we are decreasing the inventory.
Can someone please help here
1 Like
Hey @Webgility_Inc
The originalTotalPriceSet field is going to be what you need for your reconciliation problem. This field specifically returns the total price of the order at the time of creation, before any modifications like the discount you mentioned.
You can access this field through the Admin GraphQL API: