How do I get products with special price rule (for logged in customer group as well as overall) in product collection?
Solved! Go to Solution.
If you want to offer different pricing per customer group in Magento 2, you can take advantage of Advanced Pricing tab. In Magento 2 tier&group price functionality is merged together, so there you can apply various prices per customer group.
Thanks for the reply but I was trying to setup a separate page contatining list of all products with sepcial prices, I achieved it using the foll:
->where('price_index.final_price < price_index.price');