If this is in the wrong sub forum I oppologise, but I need some help with an issue my client is having. I've taken over maintenance of my clients store and there are pricing/discount discrepencies. Please see the following image.
There is a discount being applied by the Wholsesale Hero app of 30% on e.g. the order for 24 packs of English Breakfast tea on line 1.
Original Price: 10.75 x 24 = 258 Discount Per Item: 10.75 x 0.7 = 7.525 Theoretical Total Discount: 258 x 0.7 = 180.6 Applied Discount: 7.53 x 24 = 180.72
On an order of 24 items the discrepency is 12p, 0.5p per item. Shopify has rounded up 7.525 to 7.3 and used that to multiply the total cost instead of the more accurate and correct 7.525.
All these little discrepencies add up over time of course and then throw off tax calcualtions for businesses when claiming that back.
Any advice on this issue? Is this expeccted behaviour of Shopify?
Double checking your math, everything does seem correct, so it does seem strange that the system is rounding up vs keeping the amount as is. I went ahead and created a draft order with an item cost of $10.75, with a discount of 30% which did bring me to a total of $180.60:
Since I'm not seeing our systems rounding the discounted amount up on my end, I have a feeling it could be how your Wholesale app discounts the orders. Have you had a chance to reach out to their support (email@example.com) to see if they have any insight into this? I ask because their API integration is providing the line item discounts you see within your screenshot which may be the reason behind it being rounded up.
That said, I'd be happy to look into the account, however, I would need to authenticate the account first. From what I can see, the email you have tied to your forums account doesn't connect with a Shopify store. If you could post the store name, I can reach out via email to an email listed on the account to gain approval to look into this further.
So just to clarify, the default behaviour of Shopify is to handle the numbers more accurately, correctly using more than 2 decimal places when required? And we believe the problem is that maybe Wholesale Hero round those numbers in their API before returning a value?
We have contacted Booster Apps, a ticket was made last week and they've yet to respond 😞 I'm going to reach out again.
The shop in question is Canton Tea https://cantontea.com/
Based on my testing, I would like to say yes, however as I dig deeper it appears that there's no information that would say our systems don't round up. Due to this, I'm not able to give a definite yes, however, our technical support team would be happy to review the orders to find out.
I'll go ahead and reach out to the account owner listed for the store, and should they approve the escalation, then we can get the ball rolling to determining whether this is our system or something caused within Wholesale Heros API. If it turns out to be their API, then I'm happy to reach out to them on your behalf to help get a quicker response.
Hey Peter, I don't suppose you could get in contact with Wholesale Hero on our behalf? They've yet to respond to all the different ways I contact them.
You bet! I'll get a ticket created here momentarily to reach out to them on your behalf to help push for a quicker response.
We did hear back from Booster App support, and this is what they had to say:
Due to the discount being to two decimal places - when you click into the discount percentage box - it will recalculate the price.
Here is how to input the prices without this happening - the trick is to not click into the discount percent box.
I hope that helps!