Post by naabsk » Sat Dec 08, 2018 9:30 pm

I have a product that costs €0,05 including VAT (21%).
The price in the product setting is 0.0413 (excl VAT).

When I place 1000 pieces of this product in the cart the price should be €50,00.
But the price in the cart is: € 49,97. I can not add more numbers then 0.0413.

How to solve this problem?

Newbie

Posts

Joined
Tue Sep 25, 2018 1:33 am

Active Member

Posts

Joined
Mon Mar 12, 2012 11:21 am


Post by ADD Creative » Sun Dec 09, 2018 7:31 am

I don't think there is a easy solution to this.

I've seen attempts to add rounding to 2 decimal places before multiplying by the quantity. But there would be a lot of place this needs changing.

Another way I've seen suggested is to increase the number of decimal places the database uses for all prices. This would be in the product, totals, etc. then you could have your price as 0.041322.

Could you sell your product in packs of 10 priced at 0.4132?

www.add-creative.co.uk


Active Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom
Who is online

Users browsing this forum: edwardr and 24 guests