Converting Carrier spreadsheet to Custom Carrier Table

Purpose

When you use a carrier that isn’t supported by ShipperHQ yet but need to have rates show that may depend on Zone, Shipping Group, Weight, Price, Quantity then you will need to convert the carriers spreadsheet or shipping documentation to fit our custom carrier table in order to provide rates for that carrier.

Prerequisites

Make sure you have read over our Table Rates document and have created Shipping Methods for your Custom Carrier that way you can specify those methods in your Custom Table or you wont be able to create or import any rows.

Steps

  1. Request a rate definition spreadsheet or documentation from your carrier that will state how the shipping prices vary. It should be formatted like the one below:
    Screen Shot 2016-07-26 at 2.37.46 PM
  2.  For the Table above, you will need to establish your conditions that will alter the shipping rate. In this case they would be the following:
    -5 Zones (Zone 2, Zone 3 etc..)
    -Weight Ranges (> 0.00 lbs – ≤ 2.00 lbs, >2.00 lbs – ≤ 4.00 lbs)
  3. Now you will need to request a Zone Guide from your carrier so you can define the zones listed by your carrier and describe where you want to ship your products to. Once you get this document you can create the zones in ShipperHQ which can be classified by Country, State, Province, City, or Zip Code (Supporting ranges and comma separated postal codes) You can find more information on creating zones in ShipperHQ here .  In the above graph you will notice that the “Rate – Zones” list 5 zones: 2, 3, 4, 5, 6 so zone 2 might contain 12 states in the west for example to which you would need to define this in the Zones area of ShipperHQ until all zones have been defined.
  4. Then you will specify Shipping method, weight range, and the zones you created in the “Manage Table Rates” section of your Custom Carrier. It should look something like below:
    Screen Shot 2016-07-26 at 3.39.53 PM

Conclusion

Once you save your carrier then you can start testing out the weights and rates on the front end. Keep in mind the Weight > and Weight ≤ ranges are greater than and greater than or equal to. This is a common mistake that we see to often and is explained better at the bottom of our Table Rates document here.