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