close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Adding Delivery Charges

Thread began 1/02/2011 2:28 pm by elewis93815 | Last modified 1/11/2011 10:36 am by elewis93815 | 3389 views | 34 replies

Jason ByrnesWebAssist

the value passed from the checkout page is note the selected city, it looks like it is the actual delivery fee?

<select name="DeliveryCity" id="DeliveryCity">
<option value="15.00">Downtown Mpls</option>
<option value="15.00">Downtown Saint Paul</option>
<option value="15.00">Roseville</option>
<option value="15.00">Falcon Heights</option>
<option value="25.00">West Saint Paul</option>
<option value="25.00">South Saint Paul</option>
<option value="25.00">Maplewood</option>
<option value="25.00">New Brighton</option>
<option value="25.00">Shoreview</option>
<option value="25.00">Fridley</option>
<option value="25.00">Golden Valley</option>
<option value="25.00">Mendota Heights</option>
<option value="25.00">Robbinsdale</option>
<option value="25.00">Hopkins</option>
<option value="25.00">Edina</option>
<option value="25.00">Saint Louis Park</option>
<option value="25.00">Richfield</option>
<option value="35.00">New Hope</option>
<option value="35.00">Mahtomedi</option>
<option value="35.00">Woodbury</option>
<option value="35.00">Plymouth</option>
<option value="35.00">Brooklyn Park</option>
<option value="35.00">Brooklyn Center</option>
<option value="35.00">Bloomington</option>
<option value="35.00">Circle Pines</option>
<option value="35.00">White Bear Lake</option>
<option value="35.00">Hugo</option>
<option value="40.00">Maple Grove</option>
<option value="40.00">Anoka</option>
<option value="40.00">Blaine</option>
<option value="40.00">Coon Rapids</option>
<option value="40.00">Ham Lake</option>
<option value="40.00">Eagan</option>
<option value="40.00">Burnsville</option>
<option value="40.00">Eden Prairie</option>
<option value="40.00">Minnetonka</option>
<option value="40.00">Wayzata</option>
<option value="40.00">Inver Grove Heights</option>
<option value="40.00">Minnetrista</option>
<option value="50.00">Cottage Grove </option>
<option value="50.00">Apple Valley</option>
<option value="50.00">Hastings</option>
<option value="50.00">Stillwater</option>
<option value="50.00">Chanhassen</option>
<option value="50.00">Chaska</option>
<option value="50.00">Shakopee</option>
<option value="50.00">Forest Lake</option>
</select>


rays initial advice was to use the data base to populate the list, then use a recordset to lookup the delivery rate

  I'd probably create a database table (if you don't already have one) of all of the cities and rates.

You could then use that table to populate the list. When the list is submitted, you can add a recordset to tha action page of the form to filter a recordset based on the submitted value from the list to return the associated rate.

Store that returned rate as a session variable and add a shipping charge rule to the cart to charge a flat rate of the value of that session variable.  




the reason for doing it this way is that you probably want to show the selected delivery city, right? if the valuer in the select list is the delivery fee, there is no way to show what the delivery city selected is.

the delivery fee is not working because the recordset is filtering on the value posted by the select list. In this case the delivery fee, it s comparing the fee "15" to the city name column in the database. In other words, comparing apples to oranges.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...