Originally Said By: Jason Byrnes
this one was a head scratcher, but i think I have it:

This is assuming you have a column that marks the product category. In my example, I using a column named "category", in the add to cart buttons, I'm giving it the value "cd" or "lp"

you need to create 4 rules using the Number Of Items with a specific column value trigger:

Name: 1 LP
Triggers:
Number of items where 'category' has a value of 'lp' is '>=' a value of '1'

Calculation:
Flat Rate: 13.99

Name: more than 1 LP
Triggers:
Number of items where 'category' has a value of 'lp' is '>' a value of '1'

Calculation:
Flat Rate:
php:
``(\$this->ConditionalTotal("Quantity", "category", "lp")-1) * 6.99``

Name: 1 CD:
Triggers:
Number of items where 'category' has a value of 'cd' is '>=' a value of '1'

AND
Number of items where 'category' has a value of 'lp' is '<=' a value of '1'

Calculation:
Flat Rate: 8.99

Name: More than 1 CD
Triggers:
Number of items where 'category' has a value of 'cd' is '>' a value of '1'

Calculation:
Flat Rate:
php:
``(\$this->ConditionalTotal("Quantity", "category", "cd")-1) * 4.99 + ((\$this->ConditionalTotal("Quantity", "category", "lp") >=2)?4.99:0)``

Jason you are the light at the end of the tunnel, my friend.

BTW: the amount is \$4.50, instead of \$4.99 for the increment, my mistake (it really doesn't matter it is just because I'm sending the images and I don't want you to get confused). I'm sending images of the shopping cart so you can see what is happening, the rest is perfect if a LP is added the calculation is correct when 1 LP and 2CD are in the cart (image attached).

1 problem is when only 2 CD are in the cart the shipping is only 4.50 instead of 8.99 + 4.50 (image attached)
2 problem when the cart has 1cd and 1lp it should pick the LP freight and add the CD increment it should (13.99 + 4.50) and it is calculate (13.99 + 8.99) (image attached)
I know you will get because you are in the right track, I gave up trying to find the solution 3 days ago.

Thanks