cancel
Showing results for 
Search instead for 
Did you mean: 

Special price product in product collection magento2

SOLVED

Special price product in product collection magento2

How do I get products with special price rule (for logged in customer group as well as overall) in product collection?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Special price product in product collection magento2

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

View solution in original post

2 REPLIES 2

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.

 

Store Manager for Magento 1.x and 2.x - inventory management tool to automatically update products, customers, orders, and other data across multiple sales channels and suppliers.

Re: Special price product in product collection magento2

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