The UPS Data Import screen enables you to import files for the following functionality in Parcel:

•Worldwide Validation

•Billable Weight Determination

•Peak Surcharge

The following sections describe these functions and how to import the files to support them.

WorldWide Validation Import

UPS provides a monthly distribution called "WorldWide Distribution Validation" in the form of a Zip file containing a set of CSV validation files for accessorials, billing, and services. Parcel enables you to import these files into your Parcel system using the WW Validation Import screen.

To import UPS WorldWide Validation files...

1.Extract the files from the UPS WorldWide Validation Zip file into a directory on your Parcel server.

Caution: The directory to which you unzip the WorldWide Validation files must be on the same computer as the Parcel server.

2.In the Parcel Web Admin tool, select a UPS carrier, and then select the WW Validation Import screen.

3.In the Import Date box, type the World Wide Validation Effective Date in YYYYMMDD format; for example: July 9, 2010, is rendered as "20100709" (without quotation marks). This is mandatory field for World Wide Validation import.

4.In the World Wide Validation Data Directory box, enter the full (absolute) path to the folder to which you extracted the WorldWide validation Zip file; for example: C:\Program Files\Kewill\Flagship\wvdata\

5.To retain WorldWide validation data that you have previously imported, select (check) the check box labeled Keep previous World Wide Validation Data.

Caution: If you leave this check box unselected (the default), previous WorldWide validation data is automatically purged when you download the new data. Additionally, if you specify a future effective date, you need to select this option to retain a copy of your previously imported WorldWide Validation Data if you wish to have it available until the effective date of the new data.

Note: Selecting this option retains one copy of the most recent WorldWide validation data that you imported.

6.Click [SAVE] to save your settings.

Note: When you specify the location for the UPS WorldWide Validation files under one UPS carrier, Parcel uses these files globally to validate accessorials, billing, and services for all UPS carriers.

Billable Weight Determination Import

Parcel performs a Minimum Billable Weight calculation for international multi-piece shipments.

If an account or destination country is not exempt from package-level billable weight rules, billable weight is determined using package level data. If the destination status is exempt, shipment-level billable weight is used. Shipment billable weight is based on shipment-level data and does not require determining the billable weight for each package in the shipment.

When package billable weight is used, the following process is carried out. First the Package Billable Weight is determined for each package in the shipment. This weight is compared to the minimum billable weight for a package as defined by UPS, and the greater of the two values is taken as the package billable weight. This process is repeated for each package in the shipment and the sum of the package billable weights determined by this method is the shipment billable weight.

For a Shipper Account or Third Party Account, use UPS Online Tool to determine whether the account has an exempt status. UPS provides a file listing which countries are exempt and which countries are not. This is the file that you need to import using this screen.

To import the UPS Billable Weight data file:

1.In the Billable Weight Determination Data Directory box, enter the full (absolute) path to the folder to which you extracted the UPS file; for example: C:\Program Files\Kewill\Flagship\bwdata\

2.Click [SAVE] to save your settings.

UPS Peak Surcharge Import

UPS provides a weekly distribution called "Object Distribution" in the form of a Zip file containing a comma-separated format (text file with the extension "txt") for peak surcharge rates, effective dates, accessorials, and specified domestic and international services. Parcel enables you to import these files into your Parcel system using the UPS Data Import screen.

To import UPS Peak Surcharge Data Import files...

1. Extract the files from the UPS Peak Surcharge Data Import Zip file into a directory on your Parcel server.

Caution: The directory to which you unzip the UPS Data Import files must be on the same system as the Parcel server.

2. In the Parcel Web Admin tool, select a UPS carrier, and then select the Data Import screen.

3. In the Import Date box, type the Peak Surcharge Import date in YYYYMMDD format; for example: July 30, 2020, is rendered as "20200730" (without quotation marks). This is optional field.

4. In the Peak Surcharge Data Directory box, enter the path to the folder to which you extracted the UPS Peak Surcharge Zip file; for example: C:\Program Files\Kewill\Flagship\psdata\

5. Click [SAVE] to save your settings.

Note: When you specify the location for the UPS Peak Surcharge Data Import files under one UPS carrier, Parcel uses these files globally to import peak surcharge rates, effective dates, accessorials and services for all UPS carriers.