Post by Nolimits » Mon Mar 11, 2019 7:49 pm

Hi, having a problem with opencart tax calculation, my tax is 21% for example I put 100 pcs of a product that cost 0.5 eu, it calculates that from 50 eu the price without tax is 41 ant the tax is 9 eu, but if correct it shoud be 41.32 eu without tax plus 8.68 eu tax, total 50 eu, the problem it doesn't show cents and the bug apears only when the same product is 10pcs or more, with 10-20 different products there is no problem... Any help?
Image

Newbie

Posts

Joined
Mon Mar 11, 2019 7:17 pm

Post by victorj » Wed Mar 13, 2019 4:57 am

Thats what happening when ordering larger quantities.
It is caused by oc storing ex vat price with 4 decimals.

by altering product price in database locaed in table products and changing field from 15.4 to 15.8 (number after dot is number of decimals) and entering price exc tax calculated to 8 decimals you wont get those mathematic rouninding errors.

there are some mods that will allow you to enter price including tax and will calculate correct price excl tax, saving a lot of time.

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Eigen productie en snelle levering.
https://123-deurrubbers.com


User avatar
Expert Member

Posts

Joined
Sat Jun 25, 2011 4:09 am
Location - Alkmaar Holland

Post by Nolimits » Thu Mar 14, 2019 4:58 am

Now the VAT is ok, but the sum total is all wrong...

Image
Image

Newbie

Posts

Joined
Mon Mar 11, 2019 7:17 pm

Post by victorj » Thu Mar 14, 2019 5:01 am

Strange.
Wonder what is going wrong.
can you make a screenshot of product page where price is set ?

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Eigen productie en snelle levering.
https://123-deurrubbers.com


User avatar
Expert Member

Posts

Joined
Sat Jun 25, 2011 4:09 am
Location - Alkmaar Holland

Post by Nolimits » Thu Mar 14, 2019 5:28 pm

Image

Newbie

Posts

Joined
Mon Mar 11, 2019 7:17 pm
Who is online

Users browsing this forum: No registered users and 4 guests