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.
Related Articles
The Best Seller sorting option doesn’t seem to work properly. What should I check?
If you encounter issues with the Best Seller sorting option, follow the below steps to troubleshoot the problem. ⇾ When utilizing default Magento statistics for bestseller results: Step 1. Confirm the existence of placed orders on your instance. ...
Improved Sorting | GraphQL methods
Queries amfeaturedWidget (sortBy: String!, amsortingSortOrder: String!, productsCount: Int!, conditions: String!, showPager: Boolean, productsPerPage: Int, currentPage: Int) description: get information about Sorting Featured Products widget ...
How to add/hide particular sorting options from the entire list of available sorting options offered by the extension?
The Improved Sorting extension enhances the product sorting functionality by introducing additional options, offering customers a wide range of choices. If there's a necessity to deactivate particular sorting options, kindly proceed to Stores → ...
Is there a possibility to always show ascending/descending results for particular sorting options?
With the help of the Improved Sorting extension, it's possible to configure sorting results for any option to be set in descending order. To do this, kindly proceed to Stores → Configuration → Amasty Extensions → Improved Sorting → General tab. In ...
How to set custom sorting on brand pages?
Brand pages are essentially the Default category filtered by the 'brand' attribute. Therefore, any sorting logic assigned to the Default category in default Magento also applies to Amasty brand pages. To confirm or modify the sorting order for the ...