Sales: and/or condition for categories

[billmn]

What are you trying to do?
I have, for instance, two categories: "Brands" and "Gender".
I would apply a sale on "Nike / Men" (e.g. 10% discount) and a different sale on "Nike / Women" (e.g. 20% discount).

Now is not possible because it uses an OR condition between categories.

What's your proposed solution?
What about add a field in "Sale -> Matching Items" section that allow to choose the and/or condition?

"OR" condition: limit the discount to one or more categories (as default, like now)
"AND" condition: limit the discount to the combination of all specified categories

Could be enough change the relatedTo call here?

commerce/src/services/Sales.php

Line 500 in 692211a

$relatedCategories = Category::find()->id($saleCategories)->relatedTo($relatedTo)->ids();

[lukeholder]

Thanks for the request. We do have plans to add features like this to sales, but it is not as simple as just modifying that query as we also support the hasSales variant query param which is more complex.

[billmn]

Thank you @lukeholder for the answer!
Hope this feature arrives soon 🤞 😉

[mcclaskiem]

+1 this, this is a pretty critical feature for a few of my Commerce clients. Almost every ecommerce site has multiple category groups for their products and to be able to fine tune sales to multiple categories would be extremely helpful.