Feature request: Add in_stock filter to catalog price rules?

[seansan]

Description (*)

Price rules always costs a lot of time and resources; to improve its speed we thought about adding an in_stock filter (for us 80% of all products are out of stock and old products)

Expected behavior (*)

Add filter option to catalog price rules products in_stock = yes/no
Difficulty here is that the rules work for parent products ... and also has an option to change child products, so stock should be checked at the correct level (salable product level)

Benefits

Speed, reduces load by X% - 80% - at least in our case

Additional information

[Flyingmana]

so it would be an additional condition which could be added to rules to improve performance?
or would this be something which is done in the background?

First would be great, because its complete backwards compatible

[seansan]

I would aim at 1st solution .... bg not smart, because there is always the odd situation where stock levels can fluctuate during the day and the sore owner needs the products that come back into stock to be discounted too

…

On Thu, Aug 27, 2020 at 5:34 PM Daniel Fahlke ***@***.***> wrote: so it would be an additional condition which could be added to rules to improve performance? or would this be something which is done in the background? First would be great, because its complete backwards compatible — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#1171 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAE7I237EYQJTECCQSKEALTSCZ4HXANCNFSM4QNCLZEQ> .