Totals Off by a Penny!

[carol2848]

Some customers have noticed that their totals are a penny off. I don't charge tax (digital goods). I believe the problem happens when the item is on sale (all my items are discounted 5%), and although it is rounded off for the published customer price, the full, say, four decimal points are used when totalling. And occasionally when several products are ordered, that will make the total a penny higher.

For instance, an item at 5% off is $14.2025. The published price on the store is $14.20. The next product discounts to $15.1525. The customer sees $15.15. But the store totals the full 4 decimal places (unseen to the customer), and their total is $29.36. But from what the customer can see, it should be $29.35.

I am wondering if I should change the number in Admin --> Currencies --> US Dollar to have only 2 decimal places. Would that hurt anything? Would that solve my problem?

I am running 1.3.9h.

Thanks in advance for your help!

[DrByte]

Fixed in v1.5.0

[Website Rob]

I am wondering if I should change the number in Admin --> Currencies --> US Dollar to have only 2 decimal places. Would that hurt anything? Would that solve my problem?

Won't hurt anything and should solve your problem.

[swguy]

I have also seen cases where rounding errors after a price increase cause problems.
To fix them, back up your database and in phpMyAdmin, do this update:

update products set products_price = round(products_price, 2);

[BillyBoyle]

I have also seen cases where rounding errors after a price increase cause problems.
To fix them, back up your database and in phpMyAdmin, do this update:

update products set products_price = round(products_price, 2);

Tried this fix, does not seem to work for me.

issue: one wax tart priced £1.00 = total okay
continue shopping add another wax tart priced £1.00 = total £1.99 ??
Do I now need to update my whole cart to v 1.5 to fix this?
I entered the price in New product as £1.00
when I return to the same screen it reads as

Tax Class: UK V.A.T. 20%
Products Price (Net): 0.83
Products Price (Gross): 0.996

[swguy]

Can you do a test in 1.5 and see if this works? The OP wasn't using embedded taxes the way you are.

[BillyBoyle]

Can you do a test in 1.5 and see if this works? The OP wasn't using embedded taxes the way you are.

If your question is @billy then yes I could I have a test site for trying stuff out I was planning on up-grading to 1.5 I'll give it a go arround mid week. Think I've got a few hours off from day job and setting up the wifes shop.

[BillyBoyle]

I know it took a while to get back on this, but been really busy.

Fact is it's still doing the wrong TAX calculation in Version 1.5

input tax rate 20%

pirice item at £1.00
calcultates TAX at £0.83

I'm no math expert but I think that's not right.

[BillyBoyle]

Hi guys, I had a little issue in v 1.3.9 that I think is carried over to 1.5, in that when using tax rates there seems to be a little discrepancy in the tax calculation. i.e.

Setting a Tax rate of 20% (as it shockingly is here in the UK)
Does not get calculated correctly in the add product page of the admin.

Tax Class: Taxable goods (20%)
Products Price (Net): 0.8333
Products Price (Gross): 1.00

Surely that's not correct?
I know there was an issue with prices being out by a penny in the last version and there was this same tax issue.
I would just love it if someone explained it to me as my Math teacher would have failed me on this one just for showing my workings, even though the answer is right on the product info page and order totals at check out.

I am confussed

[kuroi]

That looks right to me to 4 decimal places. Why do you think it's wrong?