- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
$collection->addFinalPrice()
->addMinimalPrice()
->getSelect()
->where('price_index.final_price < price_index.price');
Thanks
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Special price product in product collection magento2
Hello.
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
$collection->addFinalPrice()
->addMinimalPrice()
->getSelect()
->where('price_index.final_price < price_index.price');
Thanks