How does the “Biggest Saving” sorting option work?

How does the “Biggest Saving” sorting option work?

The Biggest Saving sorting option arranges items with the most significant price reduction at the top of the product listing. To highlight the contrast between the regular and special prices, sorting can be based on either discount percentage or absolute price values.

How it works:

For example, let's take products A and B. Product A is priced at $100 with a 10% discount, resulting in a special price of $90 (a $10 reduction). On the other hand, product B is priced at $10 with a 30% discount, leading to a special price of $7 (a $3 reduction).
⇾ When sorting by percentage, product B would be placed above product A since its discount percentage value is higher (30% > 10%).
⇾ When sorting by absolute price values, product A is given priority over product B on the list because its price reduction value is higher ($10 > $3).

In case of any issues with sorting products by Biggest Saving, please make sure to select the option that aligns with your specific needs. Navigate to Stores → Configuration → Amasty extensions → Improved Sorting → Biggest Saving. Set the Use Percentage for Biggest Saving Sorting setting to either Yes or No.





It's also worth noting that to calculate the discount amount, Improved Sorting utilizes data from the table 'catalog_product_index_price'. It involves comparing the values from the 'price' table with 'min_price' or 'tier_price'. The extension works both with special price and catalog price rules. If you encounter any issues with the extension's behavior during sorting by 'Biggest Saving,' please verify that the tables mentioned have accurate values.

If the problem persists, don't hesitate to reach out to our support team for assistance.