Project

ERP / CRM System

A stock, sales and compliance system for the manufacturing business I coordinate projects for. It replaced a patchwork of spreadsheets with one system covering the order lifecycle from quote to shipment. I'm not a developer by trade. I built it because I was the one living with the problem.

Node.js / Express MySQL Vanilla JS frontend Role-based auth PDF document generation Cloudflare Tunnel

Scope

Around 100 screens covering:

Customers, suppliers, quotes and orders end to end
Inventory, stock takes, serial number tracking, materials and trims
Production tracking: cutting logs, job sheets, pattern sheets
Packing lists, shipments, parcel and pallet nesting
Export compliance paperwork and licence tracking
Costings, pricing and sales dashboards
PIN logins for admin, sales, warehouse and production staff

Architecture

An Express backend on Node.js against a MySQL database of 121 tables, with a plain JavaScript frontend and no build step. Kept deliberately simple so it's easy to run and deploy. Every write is attributed to the signed-in user for an audit trail, and a few pages render straight into PDFs for compliance certificates, packing labels and CIPL exports.

The production system runs on a small on-premises server reachable only through a Cloudflare Tunnel, with no inbound ports open. This demo runs the same application code on a separate server against an empty schema filled with fictional data. No real customers, orders or documents appear anywhere in it.

Try it

No sign-in needed. The demo opens on a role picker, and each option drops you into that part of the system with only its pages available.

Admin. The whole system, end to end.
Cutting station. Shop-floor cutting logs and job sheets.
Warehouse. Stock counts, serials, parcels and despatch.
Sales. Pipeline, quotes and customer records.

It resets to clean fictional data every hour, so change whatever you like.

Launch live demo → Back to portfolio