Case studies

Postcode-to-depot imports for a pallet network

A pallet-network master-data importer for transport operations: drag the file in, and every record gets its depot allocated automatically from the postcode.

A map of delivery routes linking depots across the country

The problem

Pallet-network master data has a problem all of its own. Every record needs the right depot, and the right depot depends on the postcode. Keying that in by hand is slow, and a single slip sends freight to the wrong depot.

What I built

A pallet-network importer.

  • Drag and drop the file in.
  • Each record gets its depot allocated automatically from the postcode.

How it runs now

The importer turns a master-data file into depot-allocated records with a single drag and drop. Nobody looks up a postcode by hand.

It didn't replace a system. It makes the system already there easier to trust. Very often, that's the most useful software a transport office can have.

It came from a habit I keep: when something keeps going wrong, find the exact point where it goes wrong, and put a check there.

More case studies

Sound familiar?

Let's talk about yours.

If you're living with a problem like this one, tell me about it.