Vend::Ship::QueryUPS(3) calculate UPS costs via www

SYNOPSIS


(catalog.cfg)
Shipping QueryUPS default_geo 45056
(shipping.asc)
ground: UPS Ground Commercial
origin 45056
service GNDCOM
min 0
max 0
cost e Nothing to ship!
min 0
max 150
cost s QueryUPS
min 150
max 99999999
cost e Too heavy for UPS.

DESCRIPTION

Calculates UPS costs via the WWW using Business::UPS.

To activate, configure any parameter in catalog.cfg. A good choice is the default origin zip.

Options:

weight
Weight in pounds. Required --- normally passed via CRIT parameter.
service
Any valid Business::UPS mode (required). Example: 1DA,2DA,GNDCOM. Defaults to the mode name.
geo
Location of field containing zip code. Default is 'zip'.
country_field
Location of field containing country code. Default is 'country'.
default_geo
The ZIP code to use if none supplied --- for defaulting shipping to some value in absence of ZIP. No default --- will return 0 and error if no zip.
default_country
The country code to use if none supplied --- for defaulting shipping to some value in absence of country. Default US.
aggregate
If 1, aggregates by a call to weight=150 (or $Variable->{UPS_QUERY_MODULO}). Multiplies that times number necessary, then runs a call for the remainder. In other words:

        [ups-query weight=400 mode=GNDCOM aggregate=1]

is equivalent to:

        [calc]
                [ups-query weight=150 mode=GNDCOM] + 
                [ups-query weight=150 mode=GNDCOM] + 
                [ups-query weight=100 mode=GNDCOM];
        [/calc]

If set to a number above 1, will be the modulo to do repeated calls by. So:

        [ups-query weight=400 mode=GNDCOM aggregate=100]

is equivalent to:

        [calc]
                [ups-query weight=100 mode=GNDCOM] + 
                [ups-query weight=100 mode=GNDCOM] + 
                [ups-query weight=100 mode=GNDCOM] + 
                [ups-query weight=100 mode=GNDCOM];
        [/calc]

To aggregate by 1, use .999999.

cache_table
Set to the name of a table (default ups_cache) which can cache the calls so repeated calls for the same values will not require repeated calls to UPS.

Table needs to be set up with:

        Database   ups_cache        ship/ups_cache.txt         __SQLDSN__
        Database   ups_cache        AUTO_SEQUENCE  ups_cache_seq
        Database   ups_cache        DEFAULT_TYPE varchar(12)
        Database   ups_cache        INDEX  weight origin zip shipmode country

And have the fields:

         code weight origin zip country shipmode cost updated

Typical cached data will be like:

        code    weight  origin  zip     country shipmode        cost    updated
        14      11      45056   99501   US      2DA     35.14   1052704130
        15      11      45056   99501   US      1DA     57.78   1052704130
        16      11      45056   99501   US      2DA     35.14   1052704132
        17      11      45056   99501   US      1DA     57.78   1052704133

Cache expires in one day.