Jump to content

Product price sort decimal not works in 1.7.6

Recommended Posts

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



Share this post

Link to post
Share on other sites
12 hours ago, JBW said:


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


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 by pujionodk (see edit history)

Share this post

Link to post
Share on other sites
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 by pujionodk (see edit history)

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More