The work/ Operations

Order Bridge

Marketplace exports in, the exact workbook your system already reads out.

Report

What we do

We replace the one manual step in an otherwise automatic chain and touch nothing downstream. What it cannot price confidently it holds back and names.

The problem

Orders arrive on three marketplaces. Every morning one person keys them into a spreadsheet by hand. The point-of-sale import, the stock movement and the accounting behind it were already automatic. The only manual link was a human.

The fix

A tool that takes the export files the marketplaces already produce and writes the exact workbook the rest of the system already reads. Nothing downstream was touched. No new software for anyone to learn.

How it was built

It applies promotional prices by date, breaks bundles into components, numbers the documents and keeps an append-only ledger so nothing is counted twice. Anything it cannot price with confidence it holds back and names, rather than guessing.

What it left behind

Building it surfaced 174 promotional product codes referenced in their pricing sheet that do not exist in their product list. The errors were already in their own file, visible as #N/A. Nobody had ever looked.