ERP / CRM System

Scope

Around 100 screens covering:

• Customers, suppliers, quotes, opportunities and orders end-to-end
• Inventory, stock takes, serial number tracking and materials/trims
• Production tracking: cutting logs, job sheets, pattern sheets, engineering records
• Packing lists, shipments, parcel/pallet nesting and export compliance paperwork
• Costings, pricing, and sales dashboards
• Role-based logins (PIN-based) for admin, sales, warehouse and production staff

Architecture

Express backend on Node.js against a MySQL database (121 tables), with a server-rendered/vanilla-JS frontend — no framework build step, deliberately kept simple to run and deploy. Every write action is attributed to the signed-in user for an audit trail. A handful of pages (compliance certificates, packing labels, CIPL exports) render data straight into PDFs.

The production system runs on a small on-prem server reachable only through a Cloudflare Tunnel — no inbound ports open to the internet. This demo runs on a separate, isolated server with the same application code against an empty schema filled entirely with fictional data — no real customers, orders, or business data are used anywhere in the demo.

Try it

No sign-in needed — the demo opens on a role picker, and each option drops you straight 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

The demo resets to clean fictional data every hour, so feel free to change things.