How can I show products with special price (or discounted products) in a separate page in Magento 2 ?
Thanks.!
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.
Sign up to join this communityI achieved it using the following:
$collection->addFinalPrice()
->addMinimalPrice()
->getSelect()
->where('price_index.final_price < price_index.price');