All projects
Business & ERP Ironline Supply Co. 2025

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
app.ironline.ca/inventoryLive

Inventory · Edmonton North

4,812 SKUs
SKUs live4,812
Below reorder23
Open POs41
SKUItemBranchOn handStatus
IL-1042Copper elbow 3/4"Edmonton N412In stock
IL-2318PEX crimp ring 1/2"Calgary SE38Reorder
IL-7741Ball valve 1" brassRed Deer0In transfer
IL-3390Flex connector 18"Edmonton N126In stock
IL-5126Press fitting 3/4"Grande Prairie61Low
Outcome
−38% Admin hours per week Measured across 22 counter staff
6.4× Faster quote turnaround 4h 10m → 39m average
$1.2M Dead stock identified First 90 days of live reporting
The challenge

Branch 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.

Stack
  • Next.js
  • PostgreSQL
  • Prisma
  • AWS
How we did it

Four decisions that made it work.

  1. 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.

  2. 02

    Quote from live stock

    Quotes now pull price, availability and lead time per branch, and reserve stock the moment they are sent.

  3. 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.

  4. 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.”

Dana Whitfield Operations Director, Ironline Supply Co.
Take the First Step

Tell us where the work slows down.

Tell us what is slowing your team down. We’ll analyze your process and outline a practical architecture.