Jump to content

Sort by lowest price not working on paginated products


ThunderOver

Recommended Posts

I'm viewing a category there my be 20 products and the number of products per page is set to 10. When I view the first page of ten items with the sort set to "lowest price first" this works fine. However when I move on to the second page of products it has this page starting at a lower price than the previous page finished on...

For example:

Page 1

  • Product 1 - £10.00
  • Product 2 - £15.00
  • Product 3 - £18.00

Page 2

  • Product 4 - £14.00
  • Product 5 - £16.00
  • Product 6 - £22.00
Link to comment
Share on other sites

  • 1 month later...
  • 1 year later...

This nasty bug is in Prestashop since 1.6

I assume you have one or more products with a discount? The problem is that the discount is not taking into account when splitting the pages when sorting on price.

If someone can point me to where the sql statement is for creating the pagination when sorting on price we might be able to solve it.

I have created 2 bug reports for this but still it has not been resolved. It exists even in 1.7.2.4

please vote on these bugs to get them resolved. 

page1.jpg

page2.jpg

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...