Novus
Custom manufacturing ERP · 2 locations
A bespoke operations platform for a made-to-order window-covering
manufacturer — quote to production to install to cash, in one system.
The problem
Every order is custom-measured, so pricing, cut lists and fabric
consumption were all re-derived by hand at each stage. Discounting
had no enforced limits, installers worked from ad-hoc printouts, and
payments were split across disconnected records — so "how much has
this customer paid" had no single answer.
What was built
- Live-pricing quote builder with enforced discount ceilings and per-profile cut logic
- Production tracking from cut list through packing, tied to a single measurement record
- Installer load-out views and a printable per-job field sheet
- One unified payment ledger — every screen derives balance from a single source of truth
- Multi-location reporting: revenue, conversion, commissions, tax basis
The catch
Cross-checking the reporting against raw data caught a revenue figure
overstated by $17,211 (12%) from soft-deleted quotes
being counted, and an earlier 39% inflation in
collected revenue from deleted jobs. Separately, a public API
exposure across 6 tables — including payroll — was found and closed,
taking security advisories to zero.
By the numbers
13+
unit / integration tests
Stack
Node.jsExpressPostgreSQL
Row-Level SecurityJWTPDFKit
Vanilla JS SPA
Argus
Custom ERP · print & signage
A multi-role operations platform for a print and signage business —
replacing handwritten quotes and a whiteboard job tracker with one
role-scoped system.
The problem
Pricing in this trade stacks material rates, quantity breaks,
discounts, overrides, minimums, rush fees and dual taxes on every
line — done by hand, on paper, for every quote. That produced
arithmetic errors, stale pricing, and no way to answer basic
questions like which jobs were unpaid or how each rep was
performing.
What was built / hardened
- A single pricing engine handling four models (area, per-piece with tiers, fixed, labour), re-validated server-side on every save
- Row-Level Security scoping each sales rep to their own customers at the database layer
- A Stripe payments integration with database-enforced webhook idempotency
- A customer-facing discount-visibility feature and a public payment page with no authenticated session
- A full pricing and catalog integrity audit across the live system
The catch
The pricing audit found 47% of all discount value was
invisible to reporting because manual overrides zero the
recorded discount, 12 live quote lines pricing at $0
from unconfigured tiers, and one catalog entry that would have
billed $129,800 instead of $236 for the same order —
none of which were visible in the UI before the audit.
Stack
TypeScriptNext.js 16React 19
Supabase / PostgreSQLRow-Level Security
StripeVercelVitest
More case studies in progress — this page is built to grow.