Is it possible to have all the discounted products displayed on frontend?
Eg: If I set a rule to discount the products that are about to expire in 30 days, how can I set a page for this products?
Not easily, because the discount is calculated dynamically when the product is requested. Therefore it’s not easy to request all the discounted products without a big performance hit.
A solution that could be developed is to run a cron job every 24 hours that collects the discounted products and assigns a category to these products.