in the eCart object, you will need to create a new column to capture the shipping status value from the database. For the sake of example, lets name the column "shippingStatus".
In the Add to cart button server behavior, on the bindings tab, select the new cart column and bind it to the database column that contains the shipping status value.
On the shipping tab of the eCart object we need to create 3 shipping charges using the trigger "Number Of Items With A Specific Column Value".
Charge 1) 1 Or 2 shipping Status 2, no shippingStatus 3:
Triggers:
"Number Of Items With A Specific Column Value"
If the Total Number of Items where [shippingStatus] has a value of [2] is [<=] a value of [2]
AND:
"Number Of Items With A Specific Column Value"
If the Total Number of Items where [shippingStatus] has a value of [3] is [=] a value of [0]
Calculation:
Based on Items With A Specific Column Value:
Total of [Quantity] where [shippingStatus] has a value of [2] [times] [10]
Charge 2) 3 or more shipping Status 2, no shippingStatus 3
Triggers:
"Number Of Items With A Specific Column Value"
If the Total Number of Items where [shippingStatus] has a value of [2] is [>=] a value of [3]
AND:
"Number Of Items With A Specific Column Value"
If the Total Number of Items where [shippingStatus] has a value of [3] is [=] a value of [0]
Charge:
Flat rate charge of [25]
Charge 3) a shippingStatus 3:
Triggers:
"Number Of Items With A Specific Column Value"
If the Total Number of Items where [shippingStatus] has a value of [3] is [>=] a value of [1]
Charge:
Flat rate charge of [25]