Shipping missing in Database-driven shipping.
Hi,
I tried to set up database-driven shipping based on Jason's suggestions, however the shipping information is not shown on Confirm Page.
The following is my steps,
In my database, I have the following columns in table ShippingRate:
shipingRateID - Primary Key, Auto Number
shippingRateCountry - 2 letter country code: GB, US, CA etc.
shippingBase - this will store the base rate for the country, $45 for US
on the confirm page, create a shipping rate lookup recordset.
Set the filtering options to filter the shippingRateCountry equal Form Variable 'shipping_country'
Now add a Session Value server behaviors for
shippingBase
Set the trigger to Any Form Post.
Set the name to be the same as the database column
Click the lightning bolt next to value and select the corresponding column from the recordset.
Then,
On the shipping tab create the base rule:
trigger: Total Number of items > 0
calculation: Flat Rate:
$_SESSION['ShippingBase']
Only GrandTotal without shipping is shown on confirm page. Could you help me out with the problem of missing shipping ?
Thank you,
Dave