In short, I have a catalog price rule with following condition:
If ANY of these conditions are TRUE:
Category is not one of 1, 2, 3
And in the actions I have set the Action to By Percentage of the Original and Discount Amount to 10.0000 and Stop Further Rules Processing set to Yes
So what this rule is suppose to do is to apply the rule to all other products except for the ones in categories 1, 2 and 3.
Instead the rule is still applied to all of the products that are assigned to before mentioned categories as well, while they should not.
Magento version is 22.214.171.124
What could cause this issue / how to solve it?
It's also worth to note, that I have tested this rule with a clean v. 126.96.36.199 installation.
It works as it should with flat tables disabled (Use Flat Catalog Category and Use Flat Catalog Product set to No) but the exact same rule does not work with flat tables enabled (Use Flat Catalog Category and Use Flat Catalog Product set to Yes).
So this seems to be a core bug.