Incorrect TotalPrice in Order

Hello Shopify

We are integrating Shopify with Shopify REST Apis.

When we are downloading the order using the rest API we are getting the incorrect order total price in the order response total_price=1248.59 whereas on the store it’s showing $1714.00.

Kindly Please check it and let us know why we are getting this discrepancy in the API order response and store UI and due to this discrepancy our customer is impacted so please resolve this issue as soon as possible.

Order Response and store UI screenshots are attached

Order on store UI


Order In API response

Hey @Webgility1 , it looks like the total price of $1248.59 is in USD, and the $1714.00 price that is being displayed to the customer is in CAD (Canadian Dollars). The merchant’s primary store currency appears to be USD. This is why it shows the conversion rate on the bottom left of the payment section of the order screen in the image you shared. The API response will also display the currency value in the store’s primary currency.

It appears that there may just be a bit of confusion since the customer had the charge displayed in CAD, but the merchant may usually see payments in USD. I have also removed the original image you shared as it contains identifiable personal information belonging to the merchant’s customer. No worries this time, but please be careful sharing screenshots in the future by blurring/painting out identifiable customer information.

Hope this helps - let us know if we can clarify anything further.

Thanks for your reply.

I would like to rephrase my question once again

Problem Statement : We are getting different amount on shopify UI and API after conversion

Please check the image again

Here CAD amount = $1714.00 CAD

And exchange rate = $1.36633

So, if I calculate the USD amount it is coming = 1714/1.36633 = 1,254.45 USD

But if you look at the API response , Shopify is providing = 1248.59 USD

Could you confirm , are we doing some wrong calculations or is there any issue in API response.

Around 4-5 customers has already reported the issue in last 3 days.

Waiting for your reply

Thanks & Regards

Webgility Team

Thanks for your reply.

I would like to rephrase my question once again

Problem Statement : We are getting different amount on shopify UI and API after conversion

Please check the image again

Here CAD amount = $1714.00 CAD

And exchange rate = $1.36633

So, if I calculate the USD amount it is coming = 1714/1.36633 = 1,254.45 USD

But if you look at the API response , Shopify is providing = 1248.59 USD

Could you confirm , are we doing some wrong calculations or is there any issue in API response.

Around 4-5 customers has already reported the issue in last 3 days.

Waiting for your reply

Thanks & Regards

Webgility Team

Hi

Thanks for your reply.

I would like to reframe my question

Problem Statement - Not getting the same USD amount on Shopify UI and API

Please check the below image again

Here CAD amount = 1714 CAD

and exchange rate = 1 USD = 1.36633 CAD

So USD amount would be = 1/1.36633 = 1,254.45 USD → This is same amount we can see on UI

But if you cross check the amount in API response , it is coming as 1248.59 USD.

Could you please help us here to understand why total amount is coming different ?

Waiting for your reply.

In that case, I’d recommend contacting us here using an account with permissions to this merchant store, order and app. It would be helpful to know if you have seen this discrepancy in any other stores, since the issue maybe a setting specific to this particular store. Please be sure to provide the team with the below details so that they can investigate further:

  • app ID

  • store ID

  • at least 2 order IDs with a discrepancy between Admin UI and Admin API