Filter and sort by price ignores tier prices and discounts

[AndreiMaz]

We have to update [ProductLoadAllPaged] stored procedure. But it can significantly decrease performance. Maybe, we should do it configurable (pass as a SP parameter, disabled by default).

Anyway this stored procedure also ignores discounts. And it's just not possible to implement them in the stored procedure because we can have discount requirement plugins that cannot be moved to the stored procedure.

So the question is what should we do here? Implement tier prices only?

also see: http://www.nopcommerce.com/boards/t/45996/price-range-for-special-customers.aspx

[AndreiMaz]

After some consideration we've decided not to implement this functionality out of the box because it's a too specific requirement. As per the description it's not possible to implement