Zone for Continental USA only?

24 Jun 2009, 6:46 PM

#1

stuff4toys

Totally Zenned

Join Date:: May 2007
Location:: SW Florida
Posts:: 1,062
Plugin Contributions:: 1

Zone for Continental USA only?

Has someone set up an SQL query to create a
Zone for Continental USA only?

to save having to insert each state one-by-one into a zone definition?

Need 48 states excluding Alaska and Hawaii

Thanks
JOhn ><>

Newest Site: ChargerPros - Stuff4Toys

26 Jun 2009, 6:48 PM

#2

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Zone for Continental USA only?

You might try a search for it:
48 states

And this is one that comes up that is handy ...

https://www.zen-cart.com/forum/showthread.php?t=83677&highlight=48+states

NOTE: be sure to backup your database before using this ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

26 Jun 2009, 9:27 PM

#3

stuff4toys

Totally Zenned

Join Date:: May 2007
Location:: SW Florida
Posts:: 1,062
Plugin Contributions:: 1

Re: Zone for Continental USA only?

Thanks, sometimes it's just search terminology that messes you up. I went through about 100 posts, but used a different search term.

Thanks
JOhn ><>

Newest Site: ChargerPros - Stuff4Toys

27 Jun 2009, 3:17 AM

#4

ajeh

Oba-san

Join Date:: Sep 2003
Location:: Ohio
Posts:: 62,757
Plugin Contributions:: 1

Re: Zone for Continental USA only?

A lot of the time, look at the Similar Threads at the bottom of the page on a thread ... it will often help lead you to what you are looking for ... :smile:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!