CH Robinson LTL Integration
Users now have the ability to access live LTL rates from CH Robinson via a direct integration with the Shipwell platform. This integration supports the ability to get contracted rates if they exist or spot market rates, receive tracking updates automatically, and receive associated shipment documents including Proof of Deliveries and Invoices.
Enabling this integration is quick and easy. First go to Manage, Carriers, then locate your CH Robinson carrier profile. Once in the carrier profile, select the Accounts menu on the left side of the screen. The accounts tab will appear where you can then select the Add Accounts button. For CH Robinson you will need to enter an Account Name, Billing Address, and your CH Robinson C code.
Optionally, if you have multiple accounts for different shipping or receiving locations you can add locations in the Origin or Destination fields. If you only use one account these fields can be left blank.
Once the required fields are populated click the Connect button. If you have completed the setup properly you will see a green indicator showing you have successfully connected to CH Robinson.
If you have an account that is used for both FTL and LTL shipments, you can add both of the modes when setting up the account.
To access the CH Robinson rates, from the shipment details screen for an LTL shipment click the Rates tab, Edit Quote, then click the Get Quotes button. This will start the process to get all of your standard LTL rates along with the CH Robinson LTL rates. Once the rates appear you can expand the rate to see the detailed line item costs by clicking the v next to the rate.
You can now click the Select button next to the rate to begin the dispatch process. After clicking the Select button you will be taken to the confirmation page. Once confirmed the system will dispatch the shipment to CH Robinson and the shipment status will change to Tendered.
The system will receive tracking updates automatically, and these updates will appear in the Shipment timeline on the Shipment Tracking tab.
The system will also automatically receive any associated shipment documents, including invoices which will appear in the documents window.
Contracts Support Freight Classes and Dimensional Weights
Contracts can now support freight class rating, via adding these rates in the Contract Importer. If a contract includes freight classes, the system will rate the shipment using the appropriate freight class associated with each shipment line item. Once all of the freight class groups on the shipment have been rated, the sum total of all the freight class charges will provide the total shipment rate.
Generally, Freight Class rating incorporates the use of hundred weight (CWT) rating as well as minimum charges.
Example Scenario
We have the following five items in our shipment:
Item 1: Freight Class 50, Weight 150 lbs
Item 2: Freight Class 100, Weight 250 lbs
Item 3: Freight Class 50, Weight 175 lbs
Item 4: Freight Class 100, Weight 400 lbs
Item 5: Freight Class 50, Weight 225 lbs
Assume the base rates per class (per 100 lbs) are:
Class 50: $10.00
Class 100: $20.00
Calculation Steps
Sum the Weights by Freight Class:
Total Weight for Class 50 = 550 lbs
Total Weight for Class 100 = 650 lbs
Calculate the Rate for Each Class:
Rate for Class 50 = (Total Weight for Class 50 / 100) * Base Rate for Class 50
550 lbs (6 CWT) x $10 = $60
Rate for Class 100 = (Total Weight for Class 100 / 100) * Base Rate for Class 100
650 lbs (7 CWT) x 20 = $140
Combine the Rates:
Total Rate = Rate for Class 50 + Rate for Class 100
Total Rate = $60 + $140 = $200
The Contract Importer has been updated to support the Freight Class columns, as well as the importer instructions located here.
Dimensional Weights
A Dimensional Factor has been added to the contract importer to apply dimensional weights to shipments when calculating rates. Dimensional weights are used, if negotiated with the carrier, to adjust the rating weight for bulky items that do not weigh very much.
The formula for calculating the dimensional weight of a shipment line item is (length x width x height) / the Dimensional Factor. The dimensional factor is a negotiated number between the shipper and the carrier and is typically around 166, 200, etc depending on the carrier. In addition, some carriers may use the freight class of the shipment line item as the dimensional factor. In this case, setting the dimensional factor to FC instead of a numeric value will use the line item freight classes when calculating the dimensional weight.
If a Dimensional Factor exists in a contract, when weight based rates are calculated, the system will compare the dimensional weight versus the actual shipment line item weight, and will use whichever weight is greater when calculating the shipment rate.
Accessorial Charge Types and Minimums
Accessorials have been updated to include multiple charge type options that can be calculated based on shipment attributes, as well as including a minimum charge to compare to calculated charges. The following accessorial charge types have been added:
Flat Rate - Default value where the Rate is applied to the shipment (current functionality)
QTY - Multiply shipment total Quantity x Rate for accessorial charge
CWT - Determine the CWT based on the total shipment weight, then multiply the CWT value by the Rate for accessorial charge
345 lbs would equal 3.45 CWT, so always rounding up = 4 CWT
LB - Multiply shipment total Weight x Rate for accessorial charge
KG - Multiply shipment total Weight x Rate for accessorial charge
TON - Determine the TON based on the total shipment weight, then multiply the TON value by the Rate for accessorial charge
2500 lbs would equal 1.25 TON, so always rounding up = 2 TON
Minimum Charge (optional)
When Rate Type is anything other than Flat Rate, the Minimum Charge is compared with the calculated accessorial charge, and will apply which ever charge is larger as the accessorial charge to the shipment.
The Accessorial Importer has been updated to include the new charge types and minimums. The updated importer with instructions is located Here.
In addition, if accessorials are loaded directly onto a contract, users are able to define the charge type and minimum.
Data Science
Define max LTL pallet count/weight as minimum FTL in configuration
Pickup and dropoff times supported rigorously
Order pallet count rounded up per order (previously per item)
Handling unit support in optimization
Driven distance estimation for initial solution
Datashare:
non-order related line items added
total_(declared_value, currency, volume, density)
EDI JSON package ingestion
Container On Water metrics are changing. Logic is going
from:
Vessel Departed IS NOT NULL
ANDVessel Arrived IS NULL
to:
Vessel Departed IS NOT NULL
ANDVessel Berthed IS NULL
API Changes
Contracts
Added ability for shipment line items to have freight classes at the
Contract Lane
table
level and dimensionalContract Lane
factors like dimensional weight and freight class.Added new
freight_class_rates
property toContract Lane
Added new
dimensional_factor
property toContract Lane
Added new
freight_class_dimensional_factor
property toContract Lane
Orders (Modern/Next Gen)
Added new objects and properties to the
Shipping Requirements
(shipping_requirements) of anOrder
:temperature
references
Added new properties that
Orders
may be filtered by in the Get/List Orders API endpoint:temperature_maximum
temperature_maximum__lte
temperature_maximum__gte
temperature_minimum
temperature_minimum__gte
temperature_minimum__lte
SFTP
SFTP has an addition
outbound shipment financials / freight invoice
.csv
file format type ofINVOICE_SHIPWELL
. When a freight invoice isAPPROVED
a.csv
file is generated and placed in the customer’s/outbound/invoices
directory.
Mobile
Nothing of note for release
Other Minor Bugs and Enhancements
Description |
Update Swifty Error Messaging Email for Use Case Where Shipment Cannot Be Found in Uploading a Document |
Add Freight Invoice to Star Schema |
Fix Same day delivery window causing constraints to be ignored |
Swifty - Update the Order / Shipment Update email to include date for ETA |
Replace Haversine with driven distance function |
Error when running optimization job |
Support decimal level pallets |
Implement remaining logical category constraints |
Update load optimization and shipment assembly to leverage the address book/location for optimization and resulting shipment creation |
Update Load Optimization to Leverage Dock Scheduling Facility Hours |
Update financial reporting to use new charge codes and incorporate into analytic reporting |
Add Fields to Star Schema |
Add Stop Reasons to Star Schema |
MacroPoint - Shipment status alignment |
Highway Self Service Integration |
Dashboard enhancements |
Improved EDI 214 handling |
Air mode equipment adjustment, default to “Aircraft” |
Carrier Mobile App |
Unable to archive v2 order |
Add Shipment Accessorials, Stop Accessorials, Stop Instructions, and Additional BOL Recipients to the New Shipment Creation Form |
BOL on Previous Shipment Shows Up on Current Shipment Selection |
order.updated event payload is incomplete and missing data |
Customers Are Not Able to Update Orders Parent Orders After Release |
Calender generating error once opened |
BOL number not getting generated on tender accept or when a bid is accepted |
Custom Data Filter is being removed from saved |
Unable to create order to shipment- orders stay unassigned |
Implement ‘Only With’ logical constraint in load optimization in FE |
New Order Importer Columns Returning Errors |
Undo selected state after Archive action on v3 Orders Dashboard |
Take existing SFTP Settlement Output File and make updates |
Carrier Profile, Generate Pro # from Shipwell gets checked when user saves unrelated data |
Need to be able to view the full imported Mins/Discounts table within the Carrier Profile. |
P44 Tracking failing- Pick up times sent invalid |
Unable to enter State Codes for Carrier Exclusion Rules. |
Unable to dispatch to any carrier |