Forums / Built-in Shipping and Payment Modules / Client wants Zones set up via Central Time, Mountain Time etc

Client wants Zones set up via Central Time, Mountain Time etc

Views: 725

Results 1 to 4 of 4
25 Jan 2013, 9:15 PM
#1
tcarden avatar

tcarden

Zen Follower

Join Date:
Oct 2012
Posts:
282
Plugin Contributions:
0

Client wants Zones set up via Central Time, Mountain Time etc

For shipping calculation purposes, my Client wants me to create Zones based on US time zones.
ie, Eastern, Central, Mountain and Pacific.

Doesn't look to be possible w/ out some plugin, right?
Can someone advise on how this can be done?, and is this an unusual request?

huge thanks in advance,

btw - i did a search on TimeZone terms but nothing came up, thanks

25 Jan 2013, 10:08 PM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Client wants Zones set up via Central Time, Mountain Time etc

What problem/issue is this to solve??

Zen-Venom Get Bitten

26 Jan 2013, 12:10 AM
#3
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: Client wants Zones set up via Central Time, Mountain Time etc

Like Kobra, I am interested to know just why a timezone influences shipping charges.

But let's assume that in your case it does.

You can indeed set up "time" zones - even though zencart will not see this as having anything to do with time itself.

It is a little tricky - because some states have more than one time-zone, so in your STATES field in the database, you are going to have to split up certain states to match the split in time zoning.

In the database, you have one state called Arizona, but if you want to invoke time zone differentials, then you will need to ADD a "state" called Arizona Navajo - because Arizona Najavo has a different time zone than the rest of Arizona.

Use the table below to see what states need "splitting". Then create your new "split" states in the database.

So, you have the following "states" with their GMT differences. The GMT differences and be translated into the time zones commonly used (Eastern, Central, Mountain, Pacific, Alaska, Hawaii)

State Standard Time Daylight-Saving
Time
Alabama GMT-6 GMT-5
Alaska## GMT-9 GMT-8
Alaska (Aleutian Islands) GMT-10 NA
Arizona## GMT-7 NA
Arizona (Navajo) GMT-7 GMT-6
Arkansas GMT-6 GMT-5
California GMT-8 GMT-7
Colorado GMT-7 GMT-6
Connecticut GMT-5 GMT-4
District of Columbia GMT-5 GMT-4
Delaware GMT-5 GMT-4
Florida GMT-5 GMT-4
Florida (W) GMT-6 GMT-5
Georgia GMT-5 GMT-4
Hawaii GMT-10 NA
Idaho (N) GMT-8 GMT-7
Idaho (S) GMT-7 GMT-6
Illinois GMT-6 GMT-5
Indiana GMT-5 GMT-4
Indiana (NW) GMT-6 GMT-5
Iowa GMT-6 GMT-5
Kansas GMT-6 GMT-5
Kansas (W) GMT-7 GMT-6
Kentucky (E) GMT-5 GMT-4
Kentucky (W) GMT-6 GMT-5
Louisiana GMT-6 GMT-5
Maine GMT-5 GMT-4
Maryland GMT-5 GMT-4
Massachusetts GMT-5 GMT-4
Michigan GMT-5 GMT-4
Michigan (W) GMT-6 GMT-5
Minnesota GMT-6 GMT-5
Mississippi GMT-6 GMT-5
Missouri GMT-6 GMT-5
Montana GMT-7 GMT-6
Nebraska GMT-6 GMT-5
Nebraska (W) GMT-7 GMT-6
Nevada GMT-8 GMT-7
New Hampshire GMT-5 GMT-4
New Jersey GMT-5 GMT-4
New Mexico GMT-7 GMT-6
New York GMT-5 GMT-4
North Carolina GMT-5 GMT-4
North Dakota GMT-6 GMT-5
North Dakota (W) GMT-7 GMT-6
Ohio GMT-5 GMT-4
Oklahoma GMT-6 GMT-5
Oregon GMT-8 GMT-7
Oregon (E) GMT-7 GMT-6
Pennsylvania GMT-5 GMT-4
Rhode Island GMT-5 GMT-4
South Carolina GMT-5 GMT-4
South Dakota (E) GMT-6 GMT-5
South Dakota (W) GMT-7 GMT-6
Tennessee (E) GMT-5 GMT-4
Tennessee (W) GMT-6 GMT-5
Texas GMT-6 GMT-5
Texas (W) GMT-7 GMT-6
Utah GMT-7 GMT-6
Vermont GMT-5 GMT-4
Virginia GMT-5 GMT-4
Washington GMT-8 GMT-7
West Virginia GMT-5 GMT-4
Wisconsin GMT-6 GMT-5
Wyoming GMT-7 GMT-6

Then... in ZENCART... create ZONE DEFINITIONS named as each time zone, and then assign the relevant states to each of those definitions.

You will then have a zone called Eastern Time, which will contain all the states (and split states) that fall into that zone....

Etc...

20 years a Zencart User

26 Jan 2013, 7:37 PM
#4
tcarden avatar

tcarden

Zen Follower

Join Date:
Oct 2012
Posts:
282
Plugin Contributions:
0

Re: Client wants Zones set up via Central Time, Mountain Time etc

aww thanks for your help. very helpful.

the problem was i did not how to split up a state.

i try reading the manual but at times get impatient.