[ic] UPSI shipping problem to Alaska / Hawaii

Nora Heuer - Baytides Management Inc. interchange-users@icdevgroup.org
Thu Sep 12 13:13:00 2002


using IC 4.8.6

UPS Internal lookup works great until shipping to zips in Alaska or 
Hawaii. For some reason IC cannot determin the correct zones for the 
above zip codes. Where else in the system are those zones referenced? 
What am I missing? The 450.csv file (or in my case 463.csv - see below) 
seems to assume that IC already knows which zones to go to for the cost 
lookup?

Please reply even if it is an obvious error on my part.

I always get the ship error "Zero cost returned for mode NextDayAir, geo 
code 997"

In my 463.csv I have
<snip>
967-968,-,-,[2],-,-,[2]
969,-,-,[1],-,-,[1]
970-994,7,307,207,247,137,107
995-999,-,-,[3],-,-,[3]
,,,,,,


"[1] For Virgin Islands, Guam, Marshall Islands, etc., please refer to the 
Worldwide Rate and Zone information."

"[2] For Hawaii, the following Postal Codes are Zone 124 for Next Day 
Air and Zone 224 for 2nd Day Air:"
96701,96706,96707,96709,96712,96717,96730,96731,96734,96744,967
59,96762,96782,96786,96789,96791,96792,96795,96797,96801,96802,
96803,96804,96805,96806,96807,96808,96809,96810,96811,96812,968
13,96814,96815,96816,96817,96818,96819,96820,96821,96822,96823,
96824,96825,96826,96827,96828,96830,96835,96836,96837,96838,968
39,96840,96841,96842,96843,96844,96845,96846,96847,96848,96849,
96850,96853,96854,96857,96858,96859,96860,96861,96862,96863,968
98
"For Hawaii, the following Postal Codes are Zone 126 for Next Day Air 
and Zone 226 for 2nd Day Air:"
96703,96704,96705,96708,96710,96713,96714,96715,96716,96718,967
19,96720,96721,96722,96725,96726,96727,96728,96729,96732,96733,
96737,96738,96739,96740,96741,96742,96743,96745,96746,96747,967
48,96749,96750,96751,96752,96753,96754,96755,96756,96757,96760,
96761,96763,96764,96765,96766,96767,96768,96769,96770,96771,967
72,96773,96774,96775,96776,96777,96778,96779,96780,96781,96783,
96784,96785,96788,96790,96793,96796

"[3] For Alaska, the following Postal Codes are Zone 124 for Next Day 
Air and Zone 224 for 2nd Day Air:"
99501,99502,99503,99504,99505,99506,99507,99508,99509,99510,995
11,99512,99513,99514,99515,99516,99517,99518,99519,99520,99521,
99522,99523,99524,99540,99556,99567,99568,99572,99577,99587,996
03,99605,99610,99611,99631,99635,99639,99645,99654,99664,99669,
99672,99687,99701,99702,99703,99705,99706,99707,99708,99709,997
10,99711,99712,99775
"For Alaska, the following Postal Codes are Zone 126 for Next Day Air 
and Zone 226 for 2nd Day Air:"
99547,99548,99549,99550,99551,99552,99553,99554,99555,99557,995
58,99559,99561,99563,99564,99565,99566,99569,99571,99573,99574,
99575,99576,99
<snip>

Thanks
Nora