close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Adding Delivery Charges

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

elewis93815

Adding Delivery Charges

I am trying to add delivery charges to our shopping cart after the fact. I have created all checkout pages but now our client would like to add delivery charges in the checkout.

How and where would I add this feature? The delivery charges are based upon the city they select e.g. my city is Minnetonka, that city is a $15 delivery charge.

Any guidance on this is greatly appreciated.

Thanks,

Jackie

Sign in to reply to this post

Ray BorduinWebAssist

How many different regions would you be delivering to?

Do they choose the city from a select list or type it in? What would you do about unrecognized cities such as typos and out of area?

There are several ways it could be accomplished and the specific technique I'd use depends on the specific details of the implementation.

Sign in to reply to this post

elewis93815

There are 47 different cities they can choose from via a drop down, please see checkout.php. However, there are only 5 price points, meaning, several cities may have the same delivery fee associated with it. This is the same client you helped us with a couple of weeks ago. Thanks for the help!

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

elewis93815

Originally Said By: Ray Borduin
  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.  



Hi Ray,

We've built the database tables and have started to create the recordset and am curious to know what the filter and sort should be set to? - please see screen shot attachment

Thanks

Jackie

Sign in to reply to this post

Ray BorduinWebAssist

Filter based on location... store a session variable with the value they entered as the location to deliver to.

Then the fee returned from the recordset will be the correct fee for that location.

Sign in to reply to this post

elewis93815

in the Recordset window we have set the filter (from the drop down) as "location". The next section is =. What should the remaining fields be? The next drop down references URL parameter etc, then a blank field and finally the sort drop down. The record sets we've created before have not had any filtering on them so I'm a little green with this.
Thanks

Sign in to reply to this post

Jason ByrnesWebAssist

on the second line of the filter section, the variable type should be set to Form Value, in the second box, enter the name of the location form element.

Sign in to reply to this post

elewis93815

Originally Said By: Ray Borduin
  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.  



Originally Said By: Jason Byrnes
  on the second line of the filter section, the variable type should be set to Form Value, in the second box, enter the name of the location form element.  



I believe that I followed your steps above, but would like clarification based upon my screen print. One thing that was unexpected was an error that we got when we hit ok on creating a new record set. please see attachments.

this is a link to some screen prints of what we're explaining above: cc3.php

Thanks
Jackie

Sign in to reply to this post

Jason ByrnesWebAssist

yes, the recordset looks like it is configured properly.

have you tried deleting the Dreamweaver cache file from the users configuration folder:
common_installation_issues.pdf

Sign in to reply to this post
loading

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...