Order-to-fulfillment sync for a small e-commerce shop
A concept teardown showing how a store, a spreadsheet and a courier can be wired together so stock and status never drift out of sync.
0
manual re-keying between systems
Concept build — design target, not a measured client result
Same day
tracking sent automatically on dispatch
Concept build — design target, not a measured client result
Exceptions
surfaced, not hunted for
Concept build — describes the design, not a metric
Problem
A growing shop tracks stock in a spreadsheet, takes orders on a storefront, and books couriers by hand. The three never quite agree. Oversells happen, customers ask "where is my order?", and someone reconciles it all every evening.
Before — the manual workflow
- 01
Order placed on the storefront
- 02
Stock spreadsheet updated manually (when remembered)
- 03
Courier booked by copying the address by hand
- 04
Tracking number emailed to the customer manually
- 05
Evening spent reconciling mismatches
Intervention
A sync layer that treats the order as the single event: it decrements stock, books the courier, writes the tracking number back, and notifies the customer — with a daily exception report for anything that does not match, instead of a nightly manual reconciliation.
A teardown, not a client story
This is a concept teardown — a public example of how we would approach a
familiar problem. It is clearly labeled as such. When you run a real version of
this, replace the numbers with measured results and change the label to
client.
The idea
Make the order the single source of truth. Everything downstream — stock, courier, customer notification — reacts to it. Reconciliation becomes an exception report, not a nightly chore.