cancel
Showing results for 
Search instead for 
Did you mean: 

Catalog price rule using an "is not one of" condition returns incorrect results

Catalog price rule using an "is not one of" condition returns incorrect results

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 1.14.2.4

 

What could cause this issue / how to solve it?

1 REPLY 1

Re: Catalog price rule using an "is not one of" condition returns incorrect results

It's also worth to note, that I have tested this rule with a clean v. 1.14.3.8 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.