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
Enter the shipment
Pick origin and destination airports and add each piece with its dimensions.
- 2
Search
The app sends the shipment to the engine with the units and date window it expects.
- 3
Engine prices routes
The engine builds routes from the current leg and node rate cards.
- 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
More work
More case studies
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