Magento Forums
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

‎03-14-2018 05:33 AM
‎03-14-2018 05:33 AM

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?

0 Kudos
Reply
1 REPLY 1
‎03-15-2018 12:59 AM
‎03-15-2018 12:59 AM

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.

0 Kudos
Reply