Product price sort decimal not works in 1.7.6

[pujionodk]

Hi, I just update my prestashop 1.7.5.x to 1.7.6

My product sort price gone wrong with decimal, price low to high or price high to low.
I did clear performance cache ; faceted search : ndex missing price, rebuild entire price index ; clear browser cache

1) price low to high
- 21,388.51 then 21,388.50 (wrong)
- 25,753.52 then 21,753.50 (wrong)

2) Price High to Low
- 25,753.00 then 25,753.52 (wrong)
- 21,388.51 then 21,388.50 (true)

 

My decimal setting in backoffice :
- round mode : round up away from zero, when it is half way there (recommended)
- round type : round each item
- decimal number : 2

 

 

[JBW]

Hi,

this is a known 1.7.6. bug. Check out the details here - you can correct it in database table ps_currency

https://github.com/PrestaShop/PrestaShop/issues/14608

[pujionodk]

12 hours ago, JBW said:

Hi,

this is a known 1.7.6. bug. Check out the details here - you can correct it in database table ps_currency

https://github.com/PrestaShop/PrestaShop/issues/14608

I changed the precision from 6 to 2.
But the price order still not works correctly with decimal precision

I did change numeric_iso_code from 0 to my currency code based on  https://en.wikipedia.org/wiki/ISO_4217
Still decimal order not works

Edited August 13, 2019 by pujionodk (see edit history)

[jeanluc.12]

Have you cleared the cache after updating the price in the DB?

 

[pujionodk]

On 8/13/2019 at 4:44 PM, jeanluc.12 said:

Have you cleared the cache after updating the price in the DB?

 

Yes, I reindex all missing prices, rebuild entire price index in faceted search. Clear cache in performance.
And delete prod directory in \var\cache and delete browser cache

 

I think because in layered_price_index table, price_min and price_max is integer that make the sort order with decimal not works

Edited August 15, 2019 by pujionodk (see edit history)

[Hart]

PS v1.7.6.7 the problem of price calculation (rounding) persist and give trouble when passed to paypal for payment because in return the payment receive an error.

for example here is very evident that the total order is wrong:

Edited September 10, 2020 by Hart (see edit history)