Catalog Price Rules "SKU is not one of"

Question

Magento Version 1.9.3.7

The scenario is:

I need to set up a Catalog Price Rule for specific brand's products. So i set up condition "Manufacturer is BrandName".

Now I need to exclude some product from thet rule.

If i set up "SKU is not one of" with just one sku it works fine, but if is an array of skus the rule will be applied to all catalog.

The follow is applied to all catalog:

If ALL  of these conditions are TRUE :

    Manufacturer  is  BrandName
    SKU  is not one of  sku1, sku2

the follow works as expected:

If ALL  of these conditions are TRUE :

    Manufacturer  is  BrandName
    SKU  is not one of  sku1

the follow works as expected:

If ALL  of these conditions are TRUE :

    Manufacturer  is  BrandName
    SKU  is one of  sku1, sku2

Guess the array will break the condition set so that it will result "empty condition" than good for all products.

Answer 1

the issue is in Mage_Rule_Model_Resource_Rule_Condition_SqlBuilder class in

public function getOperatorCondition()

need to change on line 109

$result = implode(in_array($operator, array('()', '!()')) ? ' OR ' : ' AND ', $results);

with

$result = implode(in_array($operator, array('()', '[]')) ? ' OR ' : ' AND ', $results);

than everythig works as expected