[Skip to main content](#vessel-content) # How to apply filter on discount price? ## - **[aston2204](/forum/user/21459-aston2204 "View aston2204's Profile")** - [![aston2204's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/21459-aston2204 "View aston2204's Profile") Topic Author - [ Offline](/forum/user/21459-aston2204) - Think different Less More - Posts: 15 - Thank you received: 0 - - - - 13 years 4 months ago [\#110672](#110672) by [aston2204](/forum/user/21459-aston2204 "View aston2204's Profile") *[How to apply filter on discount price?](/forum/4-how-to/84113-how-to-apply-filter-on-discount-price#110672 "I made filter on field "price". Then I made discount for some products. Why filter "price" applies on original price instead of discount price? And how I can configured this?")* was created by *[aston2204](/forum/user/21459-aston2204 "View aston2204's Profile")* I made filter on field "price". Then I made discount for some products. Why filter "price" applies on original price instead of discount price? And how I can configured this? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0MTEzLWhvdy10by1hcHBseS1maWx0ZXItb24tZGlzY291bnQtcHJpY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 4 months ago [\#110690](#110690) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[How to apply filter on discount price?](/forum/4-how-to/84113-how-to-apply-filter-on-discount-price#110690 "I made filter on field "price". Then I made discount for some products. Why filter "price" applies on original price instead of discount price? And how I can configured this?")* Hi there, That's indeed something we didn't handle but it will require some heavy modification since it's a query on the database. We'll try to look at it as soon as possible. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0MTEzLWhvdy10by1hcHBseS1maWx0ZXItb24tZGlzY291bnQtcHJpY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[geogeo](/forum/user/39057-geogeo "View geogeo's Profile")** - [![geogeo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39057-geogeo "View geogeo's Profile") - [ Offline](/forum/user/39057-geogeo) Less More - Posts: 31 - Thank you received: 0 - - 7 years 7 months ago [\#304783](#304783) by [geogeo](/forum/user/39057-geogeo "View geogeo's Profile") Replied by *[geogeo](/forum/user/39057-geogeo "View geogeo's Profile")* on topic *[How to apply filter on discount price?](/forum/4-how-to/84113-how-to-apply-filter-on-discount-price#304783 "I made filter on field "price". Then I made discount for some products. Why filter "price" applies on original price instead of discount price? And how I can configured this?")* Hello, is there finally any way to apply filter on discount price? Unfortunately almost all of my products are with discount and it doesnt work at all. Thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0MTEzLWhvdy10by1hcHBseS1maWx0ZXItb24tZGlzY291bnQtcHJpY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86360 - Thank you received: 14296 - - 7 years 7 months ago [\#304788](#304788) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to apply filter on discount price?](/forum/4-how-to/84113-how-to-apply-filter-on-discount-price#304788 "I made filter on field "price". Then I made discount for some products. Why filter "price" applies on original price instead of discount price? And how I can configured this?")* Hi, In your filter, you can select the column product_sort_price. By default, when you save a product this value is recalculated based on the price of the product. So you could have mass actions to reset the value of that column based on the category of the product and the price_value of the product with a trigger "after a product is saved" and that way, you could have the column_sort_price with a price being a percentage of the base price of the product. And like that, you would achieve what you want. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0MTEzLWhvdy10by1hcHBseS1maWx0ZXItb24tZGlzY291bnQtcHJpY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[geogeo](/forum/user/39057-geogeo "View geogeo's Profile")** - [![geogeo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39057-geogeo "View geogeo's Profile") - [ Offline](/forum/user/39057-geogeo) Less More - Posts: 31 - Thank you received: 0 - - 7 years 7 months ago [\#304815](#304815) by [geogeo](/forum/user/39057-geogeo "View geogeo's Profile") Replied by *[geogeo](/forum/user/39057-geogeo "View geogeo's Profile")* on topic *[How to apply filter on discount price?](/forum/4-how-to/84113-how-to-apply-filter-on-discount-price#304815 "I made filter on field "price". Then I made discount for some products. Why filter "price" applies on original price instead of discount price? And how I can configured this?")* I am sorry but i dont know how to set that. The type of my filter is cursor so what is preset to apply on , according to price is only one selection, the rest selections are in different fields (weight, size, height e.t.c). I dont know where to set what you say. I would be glad if you could be more specific. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0MTEzLWhvdy10by1hcHBseS1maWx0ZXItb24tZGlzY291bnQtcHJpY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86360 - Thank you received: 14296 - - 7 years 7 months ago [\#304820](#304820) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[How to apply filter on discount price?](/forum/4-how-to/84113-how-to-apply-filter-on-discount-price#304820 "I made filter on field "price". Then I made discount for some products. Why filter "price" applies on original price instead of discount price? And how I can configured this?")* Hi, In the "apply on" setting of the filter, instead of "price", you should select "product sort price". Mass actions can be configured via the menu System>Mass actions: [ www.hikashop.com/support/documentation/167-massaction-form.html](https://www.hikashop.com/support/documentation/167-massaction-form.html) Note that I don't know which version of HikaShop you're using. With old versions of HikaShop, you might not be able to do what I am talking about. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzg0MTEzLWhvdy10by1hcHBseS1maWx0ZXItb24tZGlzY291bnQtcHJpY2U/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.055 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)