Wrong Pice Calculation

[Artx]

Hi, could anyone else confirm the wrong price calculation:

 

I use:

21% tax..

Round mode: "...(recommended)"
Round type: "Round on each line"

 

set:

Product1: Pre-tax retail combination price: 9,50
Product2: Retail price with tax: 15.30 -> auto-calculated to Pre-tax retail price 12,644628

 

buy:

Product1 x3
Product2: x2

 

In cart, order and invoice I get the Total 65.10, including the tax of 11.31

 

But it should be Total 65.09 and the tax of 11,2959 ~ 11.30

Full manual price calculation:
Product1: 9,5x3 = 28,5 +21%=34,485
Product2: 12,644628x2 = 25,289256 + 21% = 30,5999
Total products (tax excl.): 28,5+25,289256 = 53,789256 ~ 53,79
Total` : 53,79 + 21%(11,2959) = 65,0859 ~ 65,09
Total``: 34,485+30,5999 = 65,08499976 ~ 65.09

 

In case you also notice wrong calculation, please vote for this issue: http://forge.prestashop.com/browse/PSCSX-7707

[tuk66]

What version?

[doekia]

@m4, it is 1.6.1.4, as stated in the ticket

 

@artx, I am really sorry those bug in calculation have been reported constantly but apparently the math are just too hard since PrestaShop is getting them wrong for ages, and the team while deciding to embrace the cause of fixing such has poorly failed even after nearly 2 years on the case.

[adrianoshr]

 I have a new issue with savijeans.com: When somebody pays in the US for example ( my store is from Mexico), the order gets the price without tax and then perfomes the discount ( if you buy 6 pieces).

the thing is that the calculations should be like this:

JEANS PARA DAMA. MOD NYK5121S

price without tax: $362.068966

Price with tax: $420

 

if you buy more than 6 pieces the order should made a $60 discount ( resulting in $420-$60 = $360), but the calcultions in the order are: $362.068966 -$60=$302.07.

 

So as you can see, this presents a huge problem, since they are not only getting the $60 discount, also they get an 16% of the tax extra!

 

Please advice me as soon as possible how to fix this.

 

regards.

 

[doekia]

What final price did you expect?

I assume 310.34, your discount should be configured w/o taxes (52.72 ich)

 

If you expected 300, sorry but you have to use specific price / per country for such

[tdr170]

Also if I understand you correctly you are in Mexico you should not charge US customers tax.

Edited March 4, 2016 by tdr170 (see edit history)

[Artx]

@doekia Yeah, I tried to trace the calculation glitch myself, but it`s linked within too many files and methods, and also it seems as calculations are being made in different files for different sections where the summary prices are displayed, so I got the few stack overflows in my brain, it`s too hard for me

I believe at least one of Prestashop programmers has to be smarter than me and I also searched the forums and saw many related topics, and, as core functionality, I don`t understand, why it`s not the first priority issue to solve.

It`s crazy situation, when the merchant, during the month, sells products and at the end of the month accountant tells that balance does not match.

[Kerm]

Also one more bug with specific prices: http://forge.prestashop.com/browse/PSCSX-7612

[doekia]

No they are not smart at all, for 2 years the entire team + various Ecole42 trainee has poorly failed
Yes 2 years.

We (I) proposed a framework, a roadmap, to completly address the issue but this implied full rewrite and new API, hence no actual module could work, hence addons will miss sales during the delay needed for devs to adopt the new api. Nobody want addon to risk missing a single penny, so things will stay as it is. Patch, tape, strings, and gum, if it flies fine, if not the community will be there to clean the s***t

[Rui-PS]

Hi, could anyone else confirm the wrong price calculation:

 

I use:

21% tax..

Round mode: "...(recommended)"

Round type: "Round on each line"

 

set:

Product1: Pre-tax retail combination price: 9,50

Product2: Retail price with tax: 15.30 -> auto-calculated to Pre-tax retail price 12,644628

 

buy:

Product1 x3

Product2: x2

 

In cart, order and invoice I get the Total 65.10, including the tax of 11.31

 

But it should be Total 65.09 and the tax of 11,2959 ~ 11.30

Full manual price calculation:

Product1: 9,5x3 = 28,5 +21%=34,485

Product2: 12,644628x2 = 25,289256 + 21% = 30,5999

Total products (tax excl.): 28,5+25,289256 = 53,789256 ~ 53,79

Total` : 53,79 + 21%(11,2959) = 65,0859 ~ 65,09

Total``: 34,485+30,5999 = 65,08499976 ~ 65.09

 

In case you also notice wrong calculation, please vote for this issue: http://forge.prestashop.com/browse/PSCSX-7707

 

Where you able to fix this?

We have the same problem...

Edited July 20, 2017 by Rui-PS (see edit history)