Month: July 2020

06 Jul 2020

The FTL Dilemma

A client of ours required an integration with a 3rd party logistic service to fulfil LTL & FTL shipments.

Background: While we customized the logic to automatically determine LTL or FTL needs for an order, little did we realize that the 3rd party logistics service that the client choose to integrate did not support providing an instant quote via an API call for FTL shipments. Rather, it required to go through an internal manual process to get the best rates from different carriers.

This posed a problem since the business rules within checkout mandated to indicate the shipping cost to the customer prior to placing the order, whereas for FTL shipments we couldn’t get the rates instantly. We had to rule out the possibility of calculating and charging shipping costs post order placement as the client’s line of business meant shipping rates could be more expensive than the items themselves, therefore likely a huge variation between authorized and capture amounts. Hence it wasn’t an alternative, we simply had to let the end customer know the costs prior to them confirming the order.

Thus, came into being the FTL Dilemma.

The Problem Statement

We needed a checkout solution that supported FTL shipments and is also able to indicate cost of shipment prior to order placement.

How did we go about solving the problem?
We brainstormed various approaches with the 3PL provider and client.

Option 1: Default FTL rates

We looked at defaulting FTL rates to a standard $value prior to placing the order. This way, we can have the end customer place the order with standard FTL rates and calculate the actual rates during fulfilment. But we found that there were too many variables that can cause big fluctuations in the actual cost of shipment, hence zeroing on the default rate that seemed fair for every order was impossible.

Option 2: 1 FTL = multiple LTLs

We also evaluated splitting an FTL order into multiple LTLs to obtain costs and calculating FTL rates at the time of shipment. This option did not work for this solution, since the possible variations in post order scenarios meant a very complex and expensive customization. The client wasn’t very keen in an expensive solution for a problem perceived to be a rare occurrence.

Option 3: Leave it to the CS Agent

We discussed about simply recording the end customer’s request for an FTL order and notify the customer service team to assist the customer place the order. It required the CS agent to telecall or email the end customer and coordinate an offline ordering process. This was rejected by the client who quoted that they wanted some of the activities to be automated to reduce the overhead on Customer Service organization. Nevertheless, this option paved the way to finalize the eventual solution.

Option 4: Inform the customer

The option we finally zeroed is an extension of Option 3 and it was to simply notify the end customer in case of an FTL scenario and request them to await an email confirmation for costs before they could proceed with the order. As soon as the customer requests for an FTL order, notifications are sent to the CS organization and the 3PL service provider for determining shipment costs. The costs were then manually posted to the order via Backoffice which automatically triggered an email notification to the customer allowing them to proceed with the order.

FTL Dilemma – Solution Details

We built the solution, wherein for FTL orders – the end customer would be notified about it being a special order at the start of the checkout process. The system would save the cart so as it can be pulled back at a later time.

Internally, the system would send alert notifications to the client’s CS organization and the 3PL service provider about the order requiring an FTL quote. The service provider would then revert back with the shipping quote to the CS team, who diligently updates the specially created shipping charges attribute for this order via the Backoffice. This action by the CS agent, would automatically trigger a pre-configured email to the customer notifying the updated cost of the order due to the inclusion of FTL shipping costs. The customer can then proceed to retrieve the saved cart (which now has the shipping cost associated) and place the order. We also proactively put checks in place to reset the quote process in-case of any modifications to the cart items during order placement.

To conclude, this wasn’t the most elegant solution that we built, but was a compromise that ensured a win-win for all parties involved. At the end of it, that is what mattered.

Our solutions to challenges do not stop here, stay tuned for Refund Ramifications