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

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.

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!

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

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.

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

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.

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

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