Freight Rate Importer is designed to take Zones and Rates from commercial shipping companies such as UPS, FedEx, USPS and upload them into iMIS. In addition, Freight Rate Importer has the ability to update Fuel Surcharges on the fly. Fuel surcharges can change monthly and it is important they stay up to date. Prior to Freight Rate Importer, you had to re-import your data monthly.

Basic System Requirements

The following system specifications are required to successfully run Freight Rate Importer:

• Windows 7 or higher
• SQL Server 2008 or higher
• Microsoft .NET Framework version 3.5
• iMIS 15.2 or higher

Installing Freight Rate Importer

1. Download the app from the Support Portal.
2. Unzip the folder, and navigate to the unzipped folder.
3. Right mouse click on the Setup.exe and run as administrator
4. The Setup Wizard will open.
5. Click Next.
6. The license Agreement will display. Select "I accept..." and Click Next.
7. Verify the default installation folder.
8. Click Next.
9. Click Install to start the installation. A screen will then show, displaying the progress of the install.
10. A screen will confirm that Freight Rate Importer has been successfully installed.
11. Click Finish.

About the License Key

When you first log into FRI, the license process will attempt to register your license key automatically by calling back to CSI to get your iMIS information. If the information that CSI has on record is accurate then you will not be prompted with any license key information. It will update your license information automatically.
If the process cannot call CSI or the license key information does not check out with what CSI has on record, then you will be prompted to enter a license key manually. You will need to obtain this key by contacting support. After the license key has been validated and entered, you will be able to use FRI on your iMIS database. Since the license key is stored in your iMIS database, you will only need to enter this key once per database. Installing FRI on a new computer will not require you to re-enter your license key.

1. Log into iMIS as an administrator (manager)
2. Click on File > System Setup in the top toolbar
3. Copy and send to support.

Setup iMIS with Zone Tables and Shipping Methods

A Zone Table is required for each ship method (normally) as well as for each country (although they will share the same names). Each shipping method requires a zone table.

Create a General Lookup validation table called SHIP_METHOD

1. In iMIS, go to Customers > Setup Tables > General Lookup Validation.
2. Click on the drop down arrow and select (New Table).
3. Type SHIP_METHOD as the table name.
4. Type in the desired ship methods. Do not put spaces in the codes. The following are sample codes you may wish to use:

• UPS_GRND UPS Ground
• UPS_NDSVR UPS Next Day Saver
• UPS_NDY UPS Next Day
• UPS_2DY UPS 2ND Day
• UPS_3DY UPS 3rd Day
• UPS_NDAM UPS Next Day AM
• UPS_2DYAM UPS 2nd Day AM
• UPS_WWEXPR UPS World Wide Express
• UPS_WWSVR UPS World Wide Express Saver
• UPS_WWEXPT UPS World Wide Expedited
• UPS_STDCA UPS Standard Canada
• UPS_STDMX UPS Standard Mexico
• FX_STD FedEx Standard Overnight
• FX_2DAY FedEx 2nd Day
• FX_SVR FedEx Saver
• FX_GRND FedEx Ground
• FX_INT_E FedEx International Economy
• FX_INT_P FedEx International Priority
• FX_INT_F FedEx International First
• FX_INT_C FedEx International Canada
• FX_HOME FedEx Home Delivery
• FX_PO FedEx Priority Overnight
• FX_FO FedEx First Overnight
• USPS_PM USPS Priority Mail
• USPS_EM USPS Express Mail
• USPS_PM_I USPS Priority Mail International
• USPS_EM_I USPS Express Mail International
• USPS_GE_I USPS Global Express International

The above codes are in SHIP_METHODS.txt which is part of the Rate Sheet Downloads that CSI makes available – you can alternatively import them into the General Lookup/Validation table (use the import button on the bottom of the SHIP_METHOD table).

5. Restart iMIS.

Setup Zone Tables

Zone tables may be set up in advance, but it is not necessary. Freight Rate Importer will create the necessary tables.

Download Latest Zone Charts from your shipper

1. The easiest way to find the zone charts specific to your shipping location is to use Google. For example:
   • download ups zones
   • download fedex zones
   • download usps zones

2. • FedEx: http://www.fedex.com/ratetools/RateToolsMain.do
   • UPS: https://www.ups.com/content/us/en/shipping/cost/zones/continental_us.html
   • USPS: https://postcalc.usps.com/domesticzonechart

3. Enter the Zip Code of where the shipments will be originating.

4. Click on Download.

   

5. Save the file on your computer or network.

6. The file contains extraneous information that is not needed for FRI. Therefore, open the saved file with Excel and Remove the un-needed information (see steps 6 & 7 below). The following example uses UPS one charts.

7. Remove all lines above the headers of Dest. Zip | Ground | 3 Day Select | etc.

   1. Delete the following rows:

   

   2. The top of your spreadsheet should look like this now:

   

8. Now scroll to the bottom of the spreadsheet and remove all lines after the final zip code range (988-994).

   1. Delete every row after 153 in this example:

   

   2. In the example above, rows 153- 208 had to be deleted. There should be only blank rows after your final row and it should look something like this.

   

9. Save the file.

10. Repeat for your other shipping methods, note FedEx is similar (we recommend using Firefox for this).

    1. 
    2. 

11. Just as with the UPS example above, clean up all rows above the header.

    1. Delete these rows:

    

12. Also delete all rows after the final Zip Range.

    1. Delete every row after 250 in this example:

    

Obtain current shipping rates

The current shipping rates for FedEx, UPS, and USPS are available in Excel format on the CSI website with the product download at https://customer.csiinc.com/ 
The rates will be updated every year (typically after January 1).

Obtain Current Fuel Surcharge Rates

Make a note of the current Fuel Surcharge Rate while in the website of your freight provider. Once again, the fastest most reliable way to do this is to use Google. The example below is for UPS. Please remember each shipper has their own Fuel Surcharges.

Running Freight Rate Importer

1. Click on the shortcut menu Freight Rate Importer under: Start > All Programs > CSI Programs
2. You will be prompted for an iMIS user name and password. Enter your credentials:
   1. For 10.6, Select iMIS 10 – Data Source Name and then choose the DSN in the dropdown (it will match what iMIS has).
   2. For iMIS 15, Choose iMIS 15 – Web Server URL and then select your IMIS 15 URL (it will match your login screen in iMIS).

Updating US_Canada Codes

1. Click on the button Update US/Canada Zones from the main screen:

2. Select the Ship Method from the drop down menu:

3. Select the Country (leave blank for US, otherwise Select Canada – these are the only two entries you would ever select here).
4. Enter a Description (optional).
5. Select the Browse button to find the Zone chart downloaded from your shipper's website (e.g. 600.xls)
6. Click Open to insert the table into Freight Rate Importer.

7. Select the column (on the bottom) that matches the Ship Method you are importing.

8. Click Import.
9. A message will display stating the number of zones to be added to the iMIS table.
10. Click Yes.
11. A message will display stating the process has completed.
12. Click OK.
13. Now repeat for each Ship Method (US Only) that your organization supports.

14. Stay in this screen to import the Canadian Zones (US Customers Only). Note that the Canadian Zones are not provided and they are based on the State you are shipping from. You can download these here: https://www.csiinc.com/dashboard. You will need to select the column specific to your state where the shipments will be originating from.

15. Select the Canadian Shipment Method

16. Select Canada as the Country

17. Browse to the UPS International Zones.xls (https://www.csiinc.com/dashboard)

18. Choose UPS Canada from the list of Worksheets

5. Select the appropriate column for your shipment method. In the example below, we are bringing in UPS Standard Canadian Rates so we choose the column that has our state in it. This will only apply for UPS Standard Shipping. Other Canadian shipping methods include UPS Saver Canada, UPS Expedited, and UPS Express. For these shipping methods, you will choose the appropriate column from the Spreadsheet as they are NOT based on the State you are shipping from.

6. Click Import.
7. Click Finished when done.

Updating Country Zones

Freight Rate Importer allows importing and updating zones for different countries in one operation. This is required if your organization ships outside of the United States. 
Follow the instructions below to import country zones in mass:

1. Click on the Update Country Zones button.

2. Select the International Ship Method from the drop down control.

3. Click on the Browse... button and select a file to import (use the provided International Zones Table for UPS).

4. Select the appropriate Column to match the Ship Method. In the example below, we are importing the Worldwide Express Zones. If you are unsure of which shipping method your organization uses, please check with your shipping department. Also, note, there are specific entries if you are shipping from Dade and Broward Counties in Florida as well as for if you are located in the Western US or the Eastern US for UPS Worldwide Expedited shipping method. Check the UPS website to determine if you are in the East or West.

5. Optionally, click on the Preview button to validate how the data will be imported:

6. Click on the Import button when ready to import the country zones.
7. Click YES on the confirmation dialog to start the import.
8. A successful confirmation message will be displayed upon completion. Click OK.

9. Click Finished when done with your International Zones.

Updating Freight Tables

1. Click on the button Update Freight Tables from the main screen.

2. Select the Ship Method from the drop down.
3. Browse to the freight tables that were provided to you.

4. Choose the appropriate Worksheet for your Ship Method. In the example below we are bringing in UPS Ground and therefore are selecting the UPS Ground Worksheet.

5. Click Import.
6. A message will display stating the number of records which will be added to the iMIS Rate table.
7. Click Yes.
8. Repeat for each additional Ship Method. Remember, change the Worksheet (located just to the right of the Browse button) each time.
9. Click Finished.

Updating Fuel Surcharges

1. Click on the button Update Fuel Surcharges from the main screen.

2. Enter the Fuel Surcharge Percent which you made note of from your shipper's website – note that International and Overnight Shipping will normally be higher than Ground US.

3. Click Save.
4. Once the initial setup has been completed you can choose to update the Freight Rate Tables, Zone Tables or Surcharges on an individual basis by selecting the appropriate button.

FRI Troubleshooting

If you have any issues with Freight Rate Importer, please contact support. Tickets are normally responded to within 1 to 2 business days after they are submitted.

FRI Release Notes