Case study · Air freight & logistics

An admin app for an air freight pricing and routing engine

This company runs an engine that prices and routes air freight shipments. The engine depends on a lot of rate data: airports, operators, flight legs and the handling points between them, each with its own prices and rules. We built a Retool app on the engine’s REST API where staff keep that data current and run route searches that come back as priced, ranked offers.

The challenge

What wasn’t working

A single flight leg carries a lot of detail: airports, operator, partner, validity dates, aircraft type, size and weight limits, a minimum price, price breaks at 100, 300, 500 and 1,000 kg, fuel and security surcharges, and the days it operates.

Handling points between legs have their own rate cards, and large rate changes arrive as files, not one row at a time.

Staff also needed to test the engine: enter a shipment, see which routes it offers and understand exactly where each part of the price comes from.

The solution

What we built

Rate card management

Screens for airports, operators, legs and nodes, each with add, edit, inline table editing and filters.

Bulk upload

Legs and nodes import from files, with the results shown so staff can check what loaded.

Shipment entry component

A custom Retool component that collects origin, destination and any number of pieces with their dimensions.

Route search

The shipment is sent to the routing engine, which returns ranked routing offers for the chosen currency and number of paths.

Readable results

Each offer shows total price, price per kilo and duration, then opens into its legs and nodes with the air freight, fuel, security and other charges broken out.

Secure access

A login page, with every API call authenticated and clear handling when a session expires.

How it works

How a route search works

  1. 1

    Enter the shipment

    Pick origin and destination airports and add each piece with its dimensions.

  2. 2

    Search

    The app sends the shipment to the engine with the units and date window it expects.

  3. 3

    Engine prices routes

    The engine builds routes from the current leg and node rate cards.

  4. 4

    Review offers

    Ranked offers come back and open into a full cost breakdown per leg and node.

The result

What changed

  • Airports, operators, legs and nodes kept current in one app
  • Large rate changes loaded from files instead of by hand
  • Priced multi-leg offers for a shipment in one search, with every charge visible
  • Pricing logic stays in the engine, so the app can change without touching it

Have a project like this?

Tell us what you need to build. In 30 minutes we’ll map what to build first and follow up with a fixed-scope estimate.

Official Retool Agency Partner5.0 on Clutch, 9 reviewsBuilding software since 2015Reply within one business day