restrict shipping certain products to certain states?

**airtime** · 28 Mar 2007, 05:20 AM

[FONT=&quot]I have a customer that is shipping gift baskets. Some of the gift baskets contain wine, and the wine baskets can not be shipped to 7 us states. How can I restrict the wine products from being shipped to those 7 states.
thanks....Airtime
[/FONT]

**Ajeh** · 28 Mar 2007, 05:30 AM

You would need to add a flag of some sort to the products table or build a new database for the limited shipping products which indicate where the products cannot ship ...

Then, have a function which tests the products in the cart against either the flag or the new database for if they are in the list of no nos for shipping and if they are then it says sorry ... cannot ship to where ever the customer is shipping ...

The trick is to have this work on the shipping page so a bottle that cannot be shipped to california can be purchased by someone in california but shipping is stopped until the shipping address is changed to allow shipment ...

This gets a little sticky ...

You may wish to really think this out to break this down and make sure all loop holes are covered and you may need to hire someone to write the slick code described ...