Payment requests are often 1 cent off

Resolved fermentationcultureeu
(@fermentationcultureeu)

4 years, 8 months ago

It often happens to me that the plugin is requesting an amount that’s not the order total due to rounding errors.

As an example, I have one product that costs 9,60€ incl. 10% Tax. Now, I have set tax rounding to per-line, not on the subtotal. The net amount is 9,60 / 1,10 = 8,727272… and Woocommerce will round this to 8,73.
So the order total is the following: 8,73 *3 *1,1 = 28,81€, but the plugin is requesting 8,727272 *3 *1,1 = 28,80€.

The latter is what I would prefer for the orders anyway, however, when I set round to be done on the subtotal, I also get rounding errors in relation to how the woocommerce seems to calculate the price.

In either case, it’d be great if the requested amount and the order total would match up.

This is on version 5.2.3, and Woocommerce 5.5.1

Viewing 5 replies - 1 through 5 (of 5 total)

Plugin Support slash1andy
(@slash1andy)

Automattic Happiness Engineer

4 years, 8 months ago

Hey there!

Can you send me a screenshot of the product set up ( the edit product page on the backend) with the product price, and then the product tax rate setting that is applying to this product?

Also please send a link to the product so we can see this in action.

Thanks!

Thread Starter fermentationcultureeu
(@fermentationcultureeu)

4 years, 8 months ago

Hi Andy,

it looks like that sometimes you need open a bug report to realize what the real problem was.

It’s in fact not a problem with woocommerce or the stripe plugin, it was a plugin that manages lot numbers. It removed the products after checkout, and added them again, but with the prices rounded, instead of the original price (the plugin is there to support lot numbers).

I’ve been grappling with this rounding problem for quite a while, and this must have been the problem all along.

Thanks for the quick support!

Plugin Support Ryan Ray, a11n
(@ryanr14)

4 years, 8 months ago

Hi @fermentationcultureeu,

Thanks so much for the follow up letting us know you’d found the cause of the issue. Good work figuring out the trouble maker and getting it sorted.

Let us know if you’ve got further questions or issues. Thanks!

Thread Starter fermentationcultureeu
(@fermentationcultureeu)

4 years, 8 months ago

That is all, thanks 🙂

Plugin Support nathvi V. a11n
(@nathvi)

4 years, 8 months ago

You are most welcome! @fermentationcultureeu

Should you have any other question, feel free to let us know.

Wish you a great day ahead!