Shopify Confusing a decimal for a thousand separator, affecting order values and financial reporting

Retired Boards Appdev Customers Discounts And Orders
1

Hi,

We are using a private API, we have had a couple of incidents where within the request from the API and response from Shopify the decimal place in the price is confusing it for an integer of a thousand separator. For example a £629.00 jacket has sold for £629,000.00, see screenshots below

Request

Request
Request889×826 61.6 KB

Response

Response
Response460×302 41 KB

Looping in @jcsantos for all correspondence.

Thanks,
Bill

2

HI @Billll

From what we are able to see the item with value 652.654 is the only one with three decimal numbers, with this the dot is being processed has thousands separator the other ones have four numbers, that is preventing this mismatch for the other values.

From an integrations point of view, we are pushing the values shared by the back offices without any change.

Is there any configuration on your Shopify store that can affect the way the values are being matched?.

I found this other topic that can help to evaluate this. https://community.shopify.com/c/Technical-Q-A/Global-price-format-without-thousand-separator/m-p/859688

Best Regards

3

Hi @CalD ,

You helped us resolve a previous issue within the thread below and you were extremely helpful:

https://community.shopify.com/c/Shopify-APIs-and-SDKs/Order-API-running-into-a-500-error-but-still-creating-order-on/m-p/1258860#M70210%3Futm_source=communitymembers&utm_medium=email&utm_campaign=immediate_general

Are you able to assist at all with this problem?

Best,
Bill

4

Hi @Dirk ,

Are you able to add any insight to this? You’ve solved a similar issue within a separate thread quoted above.

Best,
Bill