[ic] Trouble with UPS lookup for worldwide shipping by weight

Curt Hauge interchange-users@icdevgroup.org
Thu Jul 25 01:48:01 2002


Hi List,

IC 4.8.5

I have the UPS Internal lookup working for the USA. I am now trying to
create an Internal UPS Lookup for shipping Worldwide by weight, named
XDM. When I select a country covered by XDM, like Albania, I get this
error on checkout.html-"No zone found for geo code AL, type Worldwide"
where 'AL' seems to be the code from country.txt.

I traced this to Interpolate.pm and found only this:

if (! defined $zone) {
                $Vend::Session->{ship_message} .=
                        "No zone found for geo code $zip, type $type.
";
                return undef;

It's over my head but if I had to guess, I would say I have not
defined 'zone' somewhere.

My country.txt is standard:
code sorder region selector shipmodes name        iso isonum tax
AF   9      Other  AF       XDM       Afghanistan AFG 004
AL   9      Other  AL       XDM       Albania     ALB 008
etc.

000.csv is the name of the zone chart and looks like:
Dest. COUNTRY,,Worldwide,,,,

Albania,,907,907,,,
Algeria,,907,907,,,
etc.

The table for lookups is Worldwide.csv:
Exceed,80,84,900,901,902,903,904,905,906,907,908
1,36.5,36.5,34,43.25,43.5,51.5,48.75,48.75,56.75,80,81.75
2,43,43,41.25,50.25,50,59.5,55.5,55.5,71.5,94.25,97.25
etc.

I changed 'field that chooses UPS destination' to country in
'Shipping' in the Admin.
I have included Worldwide.dbm in dbconf/default_db as such:
Database            Worldwide       Worldwide.csv     CSV
Database            Worldwide       GUESS_NUMERIC     1

My shipping.asc is:
XDM UPS Worldwide weight 0   0       e Nothing to ship!
{'ui_ship_type' => "UPSI",'table' => "Worldwide",'zone' => "000",'ups'
=> "1",'at_least' => "29",'adder' => "10.00",'geo' => "country",}
XDM UPS Worldwide weight 0   150     u [value name=country]
{'PriceDivide' => "1",}
XDM UPS Worldwide weight 150 9999999 e @@TOTAL@@ lbs is too heavy for
UPS!  {'PriceDivide' => "1",}

The shipping method DOES display on checkout.html, but its $0.00. The
archives gave many leads but nothing I have tried helped. Thanks to
you if you can offer any advice!

Curt Hauge

//////////////////////////////////////////////////////////////////
// Web Design - Interchange Hosting - Small Business Consulting //
// 1525 Meadowwood Drive                    www.mnwebdesign.com //
// Brooklyn Park, MN 55444             www.iwantaconsultant.com //
// Phone 612-598-5530                      info@mnwebdesign.com //
//////////////////////////////////////////////////////////////////