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

Billll
Tourist
6 0 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

RequestRequest

Response

ResponseResponse

 

Looping in @jcsantos for all correspondence.

Thanks,
Bill

Replies 3 (3)

jcsantos
Shopify Partner
4 0 0

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/859... 

Best Regards

Billll
Tourist
6 0 1

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-c...

Are you able to assist at all with this problem?

Best,
Bill

Billll
Tourist
6 0 1

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