NAME

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

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.