Incorrect TotalPrice in Order

Incorrect TotalPrice in Order

Webgility1
Shopify Partner
58 1 9

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 UIOrder In API responseOrder In API responseOrder In API response

Replies 5 (5)

ShopifyDevSup
Shopify Staff
1453 238 512

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.

Developer Support @ Shopify
- Was this reply helpful? Click Like to let us know!
- Was your question answered? Mark it as an Accepted Solution
- To learn more visit Shopify.dev or the Shopify Web Design and Development Blog

Shiv_Raghuwansh
Shopify Partner
22 0 0

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

ShopifyStore.png

 

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

 

 

 

 

 

Shiv_Raghuwansh
Shopify Partner
22 0 0

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

ShopifyStore.png

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.

 

ShopifyDevSup
Shopify Staff
1453 238 512

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

 

 

Developer Support @ Shopify
- Was this reply helpful? Click Like to let us know!
- Was your question answered? Mark it as an Accepted Solution
- To learn more visit Shopify.dev or the Shopify Web Design and Development Blog

Shiv_Raghuwansh
Shopify Partner
22 0 0

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

ShopifyStore.png

 

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