eCart Object Shipping Rules - flat rate for sepecific states
Using eCart 4.5.2 and am working with php. I have the shipping rates automatically pulling from UPS with my basic configuration. Then I created a rule to provide customers a flat $10 shipping fee for specific States when they select the "Standard/Ground" service. In my db the states that qualify for this flat rate are given a value=1 in a flatShipRate column.
Unfortuatly, with both rules (as defined below) the vaules are combined. That is the customers shipping charges are equal to the sum of $10 plus the UPS shipping fees. The good news is that it works.
How do I configure the rules so that if the flat rate rule applies to that shipment then the UPS shipping fees are not added/calculated? Would I also need another session variable so that if: eCartChecoutForm_Carrier_Service+flatShipRate != 12 ? Or do I need a "Custom Expression Evalueates to True" selection with formula? It is my first time working with the object rules.
**UPS SHIPPING RULE - in eCart Object**
Conditions: UPS shipping quote !=0
Separator:
Condition: Based on UPS shipping quote value
UPS Shipping quote is: !=
a value of 0
Calculation: Based on UPS shipping quote Value
UPS Shipping quote plus
0
**MY FLAT RATE RULE FOR SPECIFIC STATES**
Condition: Subtotal for any column
If the subtotal of column TotalWeight
is >
a value of 0
Separator AND
Condition: Based on session variable value
If the subtotal of column eCartChecoutForm_Carrier_Service
is =
a value of 11
Separator AND
Condition: Based on session variable value
If the subtotal of column flatShipRate
is =
a value of 1
Calculation: Flat Rate
$ 10.00