← All work

Inventory and operations system · Live

Steel tracked across eight trucks.

A growing foundation-repair crew was tracking steel, jacks and pier stock across eight trucks on paper and in someone’s head. Material walked off jobsites, and estimates went out without knowing what was on the shelf. I built their inventory and operations system. Their public website is someone else’s work.

Upstate Structural Repair: the desktop and phone screens, rendered in 3D
01 · Operations dashboardThe dashboard on a phone

The problem

Stock lived on paper and in memory across eight trucks. Material walked off jobsites, estimates went out blind, and the office never knew the real count. The fix was first planned as a $15,000 custom software project, then rescoped to a one-week build.

The operations dashboard: workflow pipeline, stock counts, recent jobs and purchase orders, with customer names and dollar figures blurred
02 · The dashboard on a phoneWarehouse inventory on a phone

What I built

A jobsite-first inventory system: the field crew logs material from a phone on site, and the office sees the count update the same minute. It’s tied to manufacturers, vendors and per-truck stock. Scoped down to a focused $300/hr one-week build that shipped exactly what they needed and nothing they didn’t, and went live in under two weeks.

The operations dashboard on a phone
03 · Warehouse inventoryOperations dashboard

The result

Running in production since March 2026; it launched with 136 items across 8 trucks and 30 manufacturers. The crew owns the code and the database, and it runs on a hosting account in the business’s own name, with no monthly platform fee on a tool they depend on daily.

Warehouse inventory: items, vendors, categories, quantity on hand and reorder points, with costs blurred
04 · Job detail and materialsPurchase order

The numbers

136Items at launch
8Trucks stocked
30Manufacturers
<2 wkBrief to live
A job's detail page and the materials used on it, with the customer and address blurred
05 · Purchase orderJob detail and materials

Built with

NodeMySQLPHPApache
A purchase order with line items received against it, with costs blurred