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

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.

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

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

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

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.

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

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.

I figured part of it out :)