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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Shipping Options

Thread began 5/27/2009 6:03 pm by eric284736 | Last modified 6/26/2009 5:27 pm by eric284736 | 1596 views | 8 replies |

eric284736

Shipping Options

I want to setup two options for shipping. The first would be UPS setup with eCart. THe second method would be for local delivery.

If a purchase is made for local delivery it would show the delivery costs, which would be based on the zip codes in the LA area.

Could this be setup using something like If the cart contains an item from Category A then the local delivery charge would apply comparing the customers zip code to the table with local delivery charges?

thx
EJ

Sign in to reply to this post

Ray BorduinWebAssist

Yes it could be set up that way.

You would probably look up the rate in a table and set a session variable. Then use that session variable to determine whether to use the local rate or the rate from ups by creating two shipping charges that key off the session variable value.

Sign in to reply to this post

eric284736

Follow up

Hi Ray,

Here is what I have done:

I have a table with cities and rates to delivery to that city. So the viewer logins in and if they are in the LA area they can select from the list of dropwdown cities in LA. I take that make make it a session. So if the session is anything other than 0 it can pull that charge into the cart.

Now where do I put that charge to show up in the cart total?

thanks,
Eric

Sign in to reply to this post

Ray BorduinWebAssist

Edit the cart object and go the shipping tab. It should be pretty easy to add the shippiing charge to the cart from there.

Sign in to reply to this post

eric284736

still trying ....

Hi Ray,

Okay here are two issues I am still trying to figure out. If possible I can grasp this if explained step by step, then I can understand the big pciture :)

The setup: Someone goes to the site and they can purchase from the following categories -flowers, furniture, accessories

Flowers are for the local LA area only and delivered by a private service ONLY.
Furniture and Accessories are delivered by UPS only.

The user must register/login to purchase.

In the registration form there is a drop down for the local LA cities if they live in that area. I set that as a session of FlowerDeliveryArea and it is a numeric value pulling from a FlowerDeliveryCharge table. That table also contains the Fee for the delivery charge.

So they are a LA resident and they purchase flowers and they live in Venice and the fee for delivery is $15.00.

When they add this to the cart I want it to be a CHARGE instead of shipping so in the cart object under CHARGES I have the name FlowerCharge. The first condition is

Based on Session variable value.
If the value of the session variable FlowerDeliveryCharge is > than a value of 0

Now how do I pull the fee from the Delivery Charge table? Depending on the city the fee could be different.

Also, how do I prevent UPS from getting a shipping quote for the flowers category? I only want UPS to quote for Furniture and Accessories.

Thanks and I appreciate your efforts on this. I will get it sooner or later!

Eric

Sign in to reply to this post

Ray BorduinWebAssist

1) there is no difference between charges and shipping... you can just change the label I don't think you need to worrry about this at all.

2) You should create a recordset to return the correct charge from the Delivery Charges table and store it into a session variable. Then you can use that session variable in your charge.

3) If you set the weight to zero for those items it will be "ignored" in the UPS quote since it is based on weight.

Sign in to reply to this post

eric284736

Thanks! I think I am getting it.

To store the Fee in a session on the registration form I have the local delivery cities in a drop down which pulls from the city delivery table.

I can use the eCart Set session variable and in the fields:

Trigger: select the city name column from the table (recordset)
Session name: flowerfee
Value: select the fee column from the table (recordset)

Is that correct?

thanks!!

Sign in to reply to this post

Ray BorduinWebAssist

Sounds right to me. Just make sure your recordset code appears before the code that sets the session variable on the page and move one up or down as necessary.

Sign in to reply to this post

eric284736

I figured part of it out :)

Sign in to reply to this post

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