Uploaded image for project: 'PrestaShop 1.7'
  1. PrestaShop 1.7
  2. BOOM-4665

[SORT] Pagination when sorting by prices does not take the discount into account

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 1.7.2.4
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • How to reproduce the issue ?:
      It is easy to reproduce in the default installation, just give the most expensive dress a discount of 90% and the number of product per page to 3. This dress should be on the first page (it is the cheapest of all) but it ends up at the second page.
    • Tests & Expected Results:
      N/A
    • Documentation Change:
      N/A

      Description

      This bug has been in Prestashop for as long as I can remember. 

      The problem is the pagination when sorting on price is done based upon the base price, not the actual price (discounted/specific pricing), causing expensive products with high discounts not to be on the first page if you have a lot of products.

      The solution would be changing the SQL statement for the pagination to take the specific price into account, instead of just the base price. 

      It looks like the same function is used in PS 1.6 (http://forge.prestashop.com/browse/PSCSX-7452

        Attachments

        1. page1.jpg
          page1.jpg
          46 kB
        2. page2.jpg
          page2.jpg
          39 kB

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                x-us Martijn Schrama
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: