[ic] UPSI shipping problem to Alaska / Hawaii

[Mike Heins]

Quoting Nora Heuer - Baytides Management Inc. (nora@baytides.ca):
> 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"


Interchange doesn't handle the [N] pointing to the list thing.

In the data you show, zips 97000 to 99499 should work, but the
others will not. 


> 
> 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
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike@perusion.com>

Experience is what allows you to recognize a mistake the second
time you make it. -- unknown