the ecart checkout page already has a foprm element for entering the shipping zip code named "shipping_postcode":
<input type="text" name="shipping_postcode" id="shipping_postcode" value="" />
when you replace this with the select list, make sure to use the same name for the select list.
The selected zip code will be stored in a session variable named:
eCartCheckoutForm_shipping_postcode
create a recordset on the confirm page to look up the selected post code. set the filtering section to filter the postalZone column equal to the Session variable eCartCheckoutForm_shipping_postcode
still on the confirm page, add a set session value server behavior (on the server behaviors panel, click the plus button and select eCart -> General -> Set Session Value). for the trigger and value, click the lightning bolt icon and select the deliveryMinimum column from the recordset. set the name of the session to "deliveryMinimum"
Repeat that step to create another session, this time select the deliveryRate column and name the session "deliveryRate"
now create the shipping change in the eCart object, set the triggers as:
"Session Variable Exists"
Session Variable Name 'deliveryMinimum'
AND
"Session Variable Exists"
Session Variable Name 'deliveryRate'
AND
"Subtotal For the entire Cart Contents"
If the Subtotal price for the cart is '<' a value of '$_SESSION['deliveryRate']'
Calculation:
Flat rate change of '$_SESSION['deliveryRate']'
