One stock list for eight branches.
A distributor running eight branches on three spreadsheets and a legacy AS400 replaced the lot with one operations system — live stock, branch transfers, and quotes that price themselves.
- Client
- Ironline Supply Co.
- Industry
- Industrial distribution
- Location
- Edmonton, Alberta
- Timeline
- 16 weeks
- Team
- 3 engineers, 1 designer
Inventory · Edmonton North
4,812 SKUsBranch Inventory & Quote-to-Cash Platform
Eight branches each kept their own stock file. Counter staff quoted from memory and confirmed availability by phone, so the same fitting was sold twice in one morning and reordered three weeks later.
The legacy system could not be extended, exports ran nightly, and month-end reconciliation consumed a full week of the controller’s time.
- Next.js
- PostgreSQL
- Prisma
- AWS
What it looks like in use.
Counter throughput
BeforeAfterQuote to cash
-
01
Quote builtLive price + branch stockDone
-
02
Stock reservedHeld 72 hoursDone
-
03
Picked & shippedTransfer or deliveryIn progress
-
04
InvoicedPushed to accountingNext
Four decisions that made it work.
-
01
Model the real catalogue
We consolidated 41,000 SKUs and 1,900 supplier price lists into one schema, with branch-level stock as a ledger rather than a number.
-
02
Quote from live stock
Quotes now pull price, availability and lead time per branch, and reserve stock the moment they are sent.
-
03
Migrate without a freeze
A dual-write window let branches move one at a time over six weeks, with the old system read-only for audit.
-
04
Train the counter, not the office
Every branch got a two-hour session with their own data; the manual is eleven screenshots long.
“We stopped phoning branches to ask what was on the shelf. That one change gave us back most of a day, every day.”