# Rounding errors in price calculation

**URL:** <https://forum.oxid-esales.com/t/rounding-errors-in-price-calculation/40382>\
**Category:** English forums\
**Tags:** administration\
**Created:** [November 21, 2009, 1:45pm UTC](https://forum.oxid-esales.com/t/rounding-errors-in-price-calculation/40382 "2009-11-21T13:45:41Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sandor.adi1](https://forum.oxid-esales.com/letter_avatar_proxy/v4/letter/s/8e8cbc/32.png) [@sandor.adi1](https://forum.oxid-esales.com/u/sandor.adi1)\
**Post date:** [November 21, 2009, 1:45pm UTC](https://forum.oxid-esales.com/t/rounding-errors-in-price-calculation/40382/1 "2009-11-21T13:45:41Z")

</div>

Have a look at this basket: (I have added translations for the slovak text)

![](http://dl.dropbox.com/u/2479032/basket.png)

As you can see the sum of products with VAT field shows 39.27 while the final price is 39.03. This is because the final price is 32.8\*1.19 while the first field is the sum of all the product’s prices which already contain VAT.

In theory both values are ok more or less (one is more precise), but legally I think this could cause problems (also financially as the the client pays the lower price). Basically final price doesn’t match the sum of all the products, which is a problem.

---

<div class="post-metadata">

**Author:** ![marco.steinhaeuser](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/marco.steinhaeuser/32/1832_2.png) [@marco.steinhaeuser](https://forum.oxid-esales.com/u/marco.steinhaeuser)\
**Post date:** [November 21, 2009, 10:15pm UTC](https://forum.oxid-esales.com/t/rounding-errors-in-price-calculation/40382/2 "2009-11-21T22:15:44Z")

</div>

Hello Sandor.

I see your point.  
Do you know how and where to enter a bug?

Regards

---

<div class="post-metadata">

**Author:** ![avenger](https://forum.oxid-esales.com/letter_avatar_proxy/v4/letter/a/9de0a6/32.png) [@avenger](https://forum.oxid-esales.com/u/avenger)\
**Post date:** [November 22, 2009, 6:12am UTC](https://forum.oxid-esales.com/t/rounding-errors-in-price-calculation/40382/3 "2009-11-22T06:12:05Z")

</div>

[QUOTE=sandor.adi@gmail.com;19167]Have a look at this basket: (I have added translations for the slovak text)

![](http://dl.dropbox.com/u/2479032/basket.png)

As you can see the sum of products with VAT field shows 39.27 while the final price is 39.03. This is because the final price is 32.8\*1.19 while the first field is the sum of all the product’s prices which already contain VAT.

In theory both values are ok more or less (one is more precise), but legally I think this could cause problems (also financially as the the client pays the lower price). Basically final price doesn’t match the sum of all the products, which is a problem.[/QUOTE]  
A quick and dirty solution would be, to display in the template the [B]same [/B]data-field for “sum of products (with VAT)” and “Final price”…

It will internally still be wrong (and must be fixed), but at least you get your correct money, and the client is not confused…

Most likely this needs to be changed also in the order confirmation eMail.

---

<div class="post-metadata">

**Author:** ![sandor.adi1](https://forum.oxid-esales.com/letter_avatar_proxy/v4/letter/s/8e8cbc/32.png) [@sandor.adi1](https://forum.oxid-esales.com/u/sandor.adi1)\
**Post date:** [November 23, 2009, 5:47pm UTC](https://forum.oxid-esales.com/t/rounding-errors-in-price-calculation/40382/4 "2009-11-23T17:47:02Z")

</div>

No, please point me to page

---

<div class="post-metadata">

**Author:** ![system](https://forum.oxid-esales.com/user_avatar/forum.oxid-esales.com/system/32/4245_2.png) [@system](https://forum.oxid-esales.com/u/system)\
**Post date:** [July 13, 2026, 7:31pm UTC](https://forum.oxid-esales.com/t/rounding-errors-in-price-calculation/40382/5 "2026-07-13T19:31:36Z")

</div>


