Catalog price rule to exclude some categories

Question

I have to give $100 discount when cart subtotal is greater than $1000 and quantity is greater than 1 and also exclude some categories.

For example, if the cart have the following items from category ids 15, 76, 77, 78, 79, 80, 81, 200 then not give discount. It is working properly when items in cart only from category ids 15, 76, 77 at a time. But when I am adding some product from another category the coupon code is also applied.

In short, if cart contains items from 15, 76, 77, 78, 79, 80, 81, 200 with any other allowed category for discount then coupon code should not applied.

If cart contains items from 15, 76, 77, 78, 79, 80, 81, 200 then coupon code should be invalid.

Answer 1

I think this is one approach that is working in your scenario:

If ALL  of these conditions are TRUE {
    Subtotal  equals or greater than  1000 
    If ALL  of these conditions are FALSE {
        If total quantity  equals or greater than  1  for a subselection of items in cart matching ALL  of these conditions {
            Category  is one of  15, 76, 77, 78, 79, 80, 81, 200
        }
    } 
}

Your rule tells Magento that the coupon is valid if there is at least one category that is not from IDs 15, 76, 77, 78, 79, 80, 81, 200.

The rule however must say that the coupon is not valid if there is at least one category that is from IDs 15, 76, 77, 78, 79, 80, 81, 200.