d
Topic
mmiller-thef Member
Posts:
3
22 days ago

Incorrect application of discounts

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.

https://imgur.com/a/tdeYbFg

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?

 

i
Replies
Peter Shopify Employee
Posts:
272
22 days ago
g
1
upvotes

Hey, there. 

Peter here from Shopify Support!

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 (help+wh@boosterapps.net) 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. 

All the best, 

Peter 
Shopify Support 

mmiller-thef Member
Posts:
3
21 days ago

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/

 

Peter Shopify Employee
Posts:
272
21 days ago

Hey, again!

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. 

All the best, 

Peter 
Shopify Support

mmiller-thef Member
Posts:
3
15 days ago

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.

Peter Shopify Employee
Posts:
272
13 days ago

Hey, there. 

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. 

All the best, 

Peter 
Shopify Support