Minimum Fields to Map

Overview

When working with batches in Excel, each type of transaction requires a different set of information. You can always provide more than is necessary. See below for details about each transaction. If you would like to see the information returned to Excel from UPS, see: Batch Data Returned.

Address Validation

The following information is required to successfully validate an address:

City (Ship_To::City_or_Town)
Zip (Ship_To::Postal_Code)
Street Address (Ship_To::Address_1)

To validate a full street level address you must turn street level on in OzLINK, then provide a street address in your Excel file. To turn on street level validation in OzLINK, click the Setup menu in OzLINK for UPS, select Address Validation, then check the Enable street level validation box.

Rating

The following information is required to successfully rate a shipment:

Ship To State (Ship_To::StateProvinceCountry) 2 letters, capitalized in the spreadsheet
Ship To Zip (Ship_To::Postal_Code)
Service (Shipment_Information::Service_Type) Must match a service name found in UPS Worldship
Weight (Package::Weight)

Shipping

The following information is required to successfully ship a package:

Company Name (Ship_To::Company_or_Name)
Street Address (Ship_To::Address_1)
City (Ship_To::City_or_Town)
Ship To State (Ship_To::StateProvinceCountry)
Zip (Ship_To::Postal_Code)
Service (Shipment_Information::Service_Type)
Weight (Package::Weight)

Tracking

The following information is required to successfully track a shipment: