Conditional free shipping: if subtotal >= X and category != Y

Question

I am trying to set conditional free shipping in our store.

We are on CE1.9.1.

WHAT I EXPECT:

1. If subtotal is over $80, and there are no items from Category 44 or 45 in the basket, shipping is free.
2. If subtotal is under $80, and there are no items from Category 44 or 45 in the basket, shipping is uses Aus Post (Fontis Australia extension).
3. If there are items from category 44 or 45 in the basket, shipping is not free at all.

Category 44 is Hats, Cat 45 is Akubra which is a sub category of Hats.

Here's how it looks:

Anyway, I cannot get this to trigger.

We are using Fontis Australia's extension for Aus Post shipping. Table/flat rates are turned off. Free shipping (Mage native) is on, with an $80 threshold.

I would appreciate any advice in getting this working!

Tim

Answer 1

"Is one of" condition is broken in 1.9.1

Under your not found condition change to:

category is 44

and under that

category is 45.

Separate them and the rule should work.

Solutions for part 1 and 3.

You should turn on magento free shipping and set your minimum high, like 10000 at the shipping method config. That will keep your free shipping deactivated in general until a shopping cart rule tells it otherwise. I believe this is ONE of your problems. If you have 80 set there, it doesn't care about your rule, because the minimum 80 is already met.

** OVERALL SOLUTION ***

SOLVED.

My target category was a sub cat. i.e. Akubra (cat 44) was a sub-cat of Hats (cat 45).

I simply set it up like this.

Mage native Free shipping: threshold 10000 Rule: Conditions

If ALL  of these conditions are TRUE :
 Subtotal  equals or greater than  80  
 If an item is NOT FOUND  in the cart with ALL  of these conditions true: 
  Category  is  44 

Actions

If ALL  of these conditions are TRUE :
  Category  is not  44 

Apply to shipping amount: no Free shipping: for shipment with matching items Stop further rules processing: no

Now: a) if shipment is over $80, with no Akubra hats, shipping free b) if shipping is under $80, use Aus Post (via API) c) if Akubra in basket, use Aus Post, regardless of sub total

Answer 2

SOLVED.

My target category was a sub cat. i.e. Akubra (cat 44) was a sub-cat of Hats (cat 45).

I simply set it up like this.

Mage native Free shipping: threshold 10000 Rule: Conditions

If ALL  of these conditions are TRUE :
 Subtotal  equals or greater than  80  
 If an item is NOT FOUND  in the cart with ALL  of these conditions true: 
  Category  is  44  

Actions

If ALL  of these conditions are TRUE :
  Category  is not  44 

Apply to shipping amount: no Free shipping: for shipment with matching items Stop further rules processing: no

Now, a) if shipment is over $80, with no Akubra hats, shipping free b) if shipping is under $80, use Aus Post (via API) c) if Akubra in basket, use Aus Post, regardless of sub total

THANKS @ladel3000