Populate the Shipping Rates table

You use the Shipping Rates table to set up the origin-destination-weight-freight class combinations for which you want to calculate rates. The Shipping Rates table can be populated based on information in the Transportation Policies table and the Shipments table. You can also manually enter records directly in the Shipping Rates table.

When populating records in the Shipping Rates table, keep the following in mind:

Column RateWare XL requirement FedEx and UPS requirement
Source Country/
Destination Country		 Required
Enter "USA" for United States		 Not required
Source Postal Code/
Destination Postal Code

Required

5-digit values required for United States locations

Required

5-digit values required for United States locations
Shipment Weight

Required

Must be expressed as LB values

Required

Must be expressed as LB values

Maximum weight of 150 LB
Freight Class Required Not required

 

  1. Open the Shipping Rates table.
  2. Click Generate Data. You see the Generate Shipping Rates Data form.
  3. Select the table to use as the Shipping Rates Data Source. This is one of:
    • Transportation Policies
    • Shipments

    Refer to Data requirements for shipping rates for additional information.

  4. If required, set the “Keep Current Shipping Rates Data” switch:
    • Selected – Records generated are appended to the existing records in the table.
    • Not selected – Existing records are replaced with the new records.
  5. Click Generate. Records for each unique combination as specified by the following values:
    • Origin Country
    • Origin Postal Code
    • Destination Country
    • Destination Postal Code
    • Shipment Weight
    • Freight Class (for RateWare XL only)
Shipment Weight must be expressed in pounds (LB). If the Weight unit of measure in Model Settings is not currently "LB - Pound", you must append the LB unit of measure to the Shipment Weight values.

Data requirements for shipping rates

You can generate shipping rates from the Transportation Policies table and from the Shipments table. In order to get valid Shipping Rates records, you need the following data:

Shipping Rates column Source table Source column Description Required for RateWare XL Required for parcel rates
Source Postal Code Transportation Policies Source Used to determine the Source Postal Code based on values in the Sites or Customers tables. Yes Yes

Sites

Customers

 Postal Code The Postal Code is looked up for the location that is set as the Source in the Transportation Policies record. RateWare will not work with Canadian postal codes if there is an embedded space. For example, you should define the postal code as “G6P6N9” rather than “G6P 6N9”. Yes Yes
Destination Postal Code Transportation Policies Destination Used to determine the Destination Postal Code based on values in the Sites or Customers tables. Yes Yes

Sites

Customers

 Postal Code The Postal Code is looked up for the location that is set as the Destination in the Transportation Policies record. RateWare will not work with Canadian postal codes if there is an embedded space. For example, you should define the postal code as “G6P6N9” rather than “G6P 6N9”. Yes Yes
Shipment Weight Transportation Policies Shipment Size Used to determine the weight of the shipment. If the Shipment Size unit of measure is not weight-based, the value is converted based on the Unit Weight as defined in the Products table. See Determining shipment weight. Yes Yes
Transportation Policies Product When creating shipping rates, if the Transportation Policies record does not have a Shipment Size based on weight, the lookup needs the Unit Weight from the Products table based on the Product specified in Transportation Policies. See Determining shipment weight. Yes Yes
Products Unit Weight If the size of the shipment in Transportation Policies is not expressed in weight, the Unit Weight from the Products table is used to determine the required weight. See Determining shipment weight. Yes Yes
Freight Class Transportation Policies Product Class If Product Class is populated in Transportation Policies, this value is used. Otherwise, the Class value in the Products table is used. Yes No
Products Class If Product Class is populated in Transportation Policies, this value is used. Otherwise, the Class value in the Products table is used. Yes No
Shipping Rates column Source table Source column Description Required for RateWare XL Required for parcel rates
Source Postal Code Shipments Source Used to determine the Source Postal Code based on values in the Sites or Customers tables. Yes Yes

Sites

Customers

 Postal Code The Postal Code is looked up for the location that is set as the Source in the Shipments record. RateWare will not work with Canadian postal codes if there is an embedded space. For example, you should define the postal code as “G6P6N9” rather than “G6P 6N9”. Yes Yes
Destination Postal Code Shipments Destination Used to determine the Destination Postal Code based on values in the Sites or Customers tables. Yes Yes

Sites

Customers

 Postal Code The Postal Code is looked up for the location that is set as the Destination in the Shipments record. RateWare will not work with Canadian postal codes if there is an embedded space. For example, you should define the postal code as “G6P6N9” rather than “G6P 6N9”. Yes Yes
Shipment Weight Shipments Weight, Volume or Quantity The Shipment Weight is determined based on which of these fields are populated in the record. See Determining shipment weight. Yes Yes
Products Unit Weight If the size of the shipment is not expressed in weight, the Unit Weight from the Products table is used to determine the required weight. See Determining shipment weight. Yes Yes
Freight Class Products Class For RateWare lookups, the rate depends on the product Class. Yes No

Last modified: Friday February 28, 2025

Is this useful?