Table of Contents
Download a Sample Rates File (optional)
ShipWorks version 5.14 or later allows you to optionally import your UPS account's rates from an Excel file and store those rates locally in the ShipWorks database. With this feature enabled, ShipWorks displays the imported rates on screen when you configure UPS shipments. This can help to improve performance when processing UPS shipments and also gives you the ability to compare rates across your shipping providers (including UPS) when using ShipWorks’ Best Rate feature. Your actual cost for processing a UPS shipment is not affected by using this feature.
There are a few steps in configuring UPS Local Rates with ShipWorks:
- Gathering your rates, zones and other needed UPS documents
- Creating and importing the ShipWorks rate and zone files
- Enabling UPS Local Rating
This article will guide you through how to obtain your UPS account's specific rates, how to download your UPS Zone file and direct you to other UPS guides and files that you will need. This includes:
- UPS DASZips file
- UPS Rate and Service Guide
- UPS Value Added Services Guide
- UPS Other Charges Guide
First Things First
There are a few things you will need prior to importing your UPS rates into ShipWorks:
- Please be sure that you have ShipWorks version 5.14 or later installed. You can check your version of ShipWorks by clicking on the Help tab and then on the About ShipWorks button. For assistance with upgrading your version of ShipWorks, please see this article.
- You will need to be logged into your online UPS account. You can log into your account here. If you do not already have an account, please follow the steps on UPS.com to create one.
- You will need to download your UPS account's zone file. (Instructions below)
- You will need to download the current UPS DASZips file. (Instructions below)
- Please reach out to your UPS rep and ask for your UPS account's rate file. This will ensure that you have rates specific to your UPS account. You can download a retail rates file from within your UPS account (and we will show you how below). However, this file will contain only the UPS retail rates and will not contain your UPS account's rates.
- You will need to be logged into the ShipWorks software as a user with administrator rights.
Your UPS Account Specific Rates
Please reach out to your UPS account representative and request that he/she send you a file of your UPS account's specific rates. Typically, you will be supplied with a spreadsheet formatted as a Microsoft Excel document. Reaching out to your representative for your rates will ensure that you have accurate rates specific to your account. Your UPS account rate file is required before you can create the ShipWorks import rate file.
Download Your UPS Account Zone File
UPS rates are based upon the postal code from which the shipment originates and the zone to which the shipment is being shipped. The UPS Zone file, when imported into ShipWorks, defines for ShipWorks your specific zones based upon your origin postal code.
Regarding more than one UPS account in ShipWorks: If you ship from more than one originating Zip Code, please repeat the steps below to generate a zone file for each of your UPS origin Zip Codes. An example may be that you have one UPS origin Zip Code for your warehouse in Los Angeles and another origin Zip Code for your warehouse in New York. In this case, you will download two Zone files; one for your Zip Code originating from Los Angeles and one for the origin Zip Code from New York.
To download your zone file from UPS:
1. If you have not already done so, log into your online UPS account. Go to www.ups.com and click on the Log In link located at the top-right of the UPS home page.
2. Once you are logged into your UPS account, click on the Shipping menu and then on the Explore All Shipping link.
3. Scroll down on the Shipping page and click on the Zones and Rates link.
4. On the Zones and Rates page, click on the 48 Contiguous States link.
5. Scroll down to the Download Zone Charts box. Enter your UPS account's Origin Postal Code, then click the Download Charts button to download your zone file.
6. Save the downloaded file to a folder on your computer. You will need this file when creating the import files for ShipWorks.
Download the Current DASZip File
1. You should still be logged into your online UPS account. If you are not, please log into your UPS account here.
2. Once you are logged into your account, click this link. This will automatically take you to the UPS Host File Download page.
3. Click the link for 2017 UPS Published Daily Rates and Zones - US. This will download a .zip file named 2017_US_Rate_and_Zone_Files.zip
4. Double click on the downloaded 2017_US_Rate_and_Zone_Files.zip file to open it. Then, double click on the US Zones Files.zip folder. Then, double click the 17DASZips.xls file to open it.
5. Save the file to a folder on your computer. You will need this file when creating the ShipWorks import files.
Download a Sample Rates File (optional)
Be sure to each out to your UPS rep and request that he/she send you your UPS account specific rates in an Excel file format. You will need to obtain your UPS account specific rates from your representative. This will ensure that you are importing your UPS account's rates in ShipWorks.
Regarding more than one UPS account in ShipWorks: If you have more than one UPS account attached to ShipWorks and intend to use Local Rates with each of your UPS accounts, please be sure to obtain your UPS account specific rates for each of the UPS accounts.
You do have the option to download a sample Daily Rate file from UPS. This file can be used, if you do not have your specific UPS account's rate file, to go through the steps involved in creating the ShipWorks import file. However, please remember that these rates are not specific to your UPS account. Please be sure to obtain your UPS account rates from your UPS rep.
1. You should still be on the Zones and Rates for the 48 Contiguous States page. If not, please follow steps 1-4 in the above section.
2. Scroll down on the page to the Obtain Your Rates section. Then, click on the View Daily Rate and Services Guide link.
3. Click the Download link for 2017 Daily Rates.
4. This will download an Excel (.xls) file of the UPS Daily Rates. Save the file to a folder on your computer.
Other Needed UPS Guides
Click each of the below links to open the associated UPS Guide. Save each of the following UPS guides to an easily accessible location on your computer. You will need to reference each of them when creating the ShipWorks import files.
Now that you have downloaded your zone file, have obtained your UPS account's rates file from your UPS rep (or have the UPS sample daily rates file), downloaded the DASZip file and the additional UPS pricing guides it is time to create the ShipWorks import file. We will guide you, step-by-step, through creating your ShipWorks rate and zone import files including what information is needed from each of the files you gathered in this article.
Still Need Help?
Please feel free to reach out to one of our awesome Customer Care Representatives in St. Louis. We are happy to help.