Skip to content

Live at a client

Lumber wholesaler runs PO to truck release in one app

A lumber wholesaler buys stock for his customers and holds it until they pull it. Now every order runs from purchase order to truck release in one app, and his two main customers get stock reports as PDFs every weekday.

Weekday quality inventory report for 2x4 stock by length, with prices, order numbers, volumes and mill names covered by black boxes.Real screen, names boxed
Trade
Wholesale lumber trader
Team
1 to 10 staff
Client since
Mar 2026
Repeat work
11 contracts and 26+ recorded working calls, Mar to Oct 2026.
Built in
Sheets system first (purchase order to truck release, weekday customer reports), then a web app in daily use since Aug 2026
Built by
Five people: client lead, PM, web developer, Sheets developer, QA
Tools
  • Google Sheets
  • Apps Script
  • React
  • Supabase

Before and after

Every night the wood sits in the yard, it costs him. He needed a cost per MBF he could trust.

Before and after
BeforeAfter
Customer stock reportsBuilt by handGo out on weekdays
Cost per board footChecked by handWorked out in the app, checked against his own math

What we built

  • Weighted cost per MBF. Checked against his own math over 26+ working calls.
  • Order to truck release. Purchase orders, sales orders, reloads and truck releases in one flow.
  • Customer stock reports. A 90-day lookback, sent as PDFs every weekday.
  • Offer PDFs from the sales order. A sales order makes the offer PDF and the confirmation email to the customer.
  • Sheets first, then the app. Built in Google Sheets, then rebuilt as a web app on the same flow.

How it works

  1. A purchase order is enteredReact web app
  2. The sales order makes its offer and confirmation PDFsReact web app, Supabase
  3. Truck releases and reloads are tracked against stockReact web app
  4. Customers' stock reports go out on weekdaysApps Script

What broke and how we fixed it

What broke

His old systems gave cost numbers he could not trust.

How we fixed it

We checked every cost formula against his own math, on the call with him, until cost and profit per MBF matched.

Building customer stock reports by hand?

Tell us which report you build by hand each week. We will show you what can go out on a schedule.

Or send one sample file on WhatsApp (opens WhatsApp). Fake names are fine.

Tell us about your reports

We reply within one business day. No card, no contract.

More builds like this

More on Internal Web AppsSee all case studies