← Back to Projects SiteStock dashboard showing live stats, weather, and site overview
Full Stack PWA Live Construction

SiteStock

Site Stock Management Platform · Progressive Web App · Adelaide, AU

820+
Catalogue Items
50+
API Endpoints
27
Product Categories
5
User Roles

// the problem

Electrical construction sites rely on manual processes for tracking stock levels, tool locations, material orders, and compliance records. There's no visibility into real-time stock levels on site, leading to project delays when materials run out unexpectedly. Material requests are managed through text messages and spreadsheets with no audit trail. Tool and equipment tracking relies on paper registers that go missing. Test & Tag compliance records live in disconnected systems. Timesheets are submitted on paper, causing payroll delays.

// the solution

I built SiteStock, a mobile-first Progressive Web App that puts all site management tools in one place, accessible from any phone or device on site. No app store download required, it works as an installable PWA with offline-capable features. The platform is currently live and in active use, managing 820+ catalogue items across multiple active construction projects.

// key features

📊
Dashboard & Analytics
Real-time stats, weather forecasts for the job site, low stock alerts, pending order notifications, and team activity analytics. Auto-refreshes every 60 seconds with visibility-based updates.
📦
Stock Catalogue
820+ items across 27 categories with search, filtering, per-project stock levels, product codes, manufacturer data, and cost tracking. Supports archive and permanent deletion.
📋
Material Requests
Full lifecycle management: Pending, Ordered, Received, Stocked. Tracks who requested, who ordered, and who received each item. Delivery scan links incoming deliveries to open requests.
🔧
Tools & Plant Register
Digital register for all tools and equipment. Tracks serial numbers, team member assignment, project allocation, and status (On Site, Checked Out, In Workshop, For Repair, Lost).
⚡
Test & Tag Compliance
Electrical testing and tagging module with individual and batch testing, configurable test intervals, pass/fail recording, and overdue test alerts on the dashboard.
⏱️
Timesheets
Weekly entry with daily start/finish times, break durations, and day types (Work, RDO, Public Holiday, Annual Leave, Trade School). Supports draft, submit, and approve workflow.
🌤️
Weather Integration
Live weather data using each project's GPS coordinates. Shows current conditions, 7-day forecast, and nearest weather station comparison for outdoor work planning.
🔐
Role-Based Access
Five user roles (Apprentice, Team Member, Leading Hand, Supervisor, Project Manager) with configurable feature access via a dedicated settings screen.

// architecture

SiteStock is a single-page application with client-side routing via React state management. The backend is a RESTful API with 50+ endpoints handling CRUD operations, authentication, and analytics. Session persistence uses localStorage with server-side data verification on restore. The database runs a 28-step idempotent migration system for safe schema evolution, ensuring the database can be rebuilt from scratch without breaking existing data.

Deployed on an Oracle Cloud ARM instance with Nginx as a reverse proxy, SSL via Let's Encrypt, and PM2 for process management. The PWA includes a service worker for installability on mobile devices, giving field workers a native-app feel without going through an app store. Every data mutation is logged with timestamp, user, action type, entity, and before/after snapshots, providing full audit trail traceability for stock movements, request changes, and administrative actions.

// screenshots

SiteStock login page with company branding Dashboard with live stats, weather, and activity feed Stock take interface showing item counts and categories Multi-tenant dashboard view with project overview Timesheet entry with daily rows and day types

// future roadmap

SiteStock is actively being developed with planned features including 13 AS/NZS-compliant electrical calculators (cable sizing, voltage drop, max demand), an AI-powered assistant for standards guidance using Claude API, expanded supplier product catalogues (EzyStrut, Clipsal, Schneider), and PDF and Excel report generation for compliance documentation.

// tech stack

React Node.js Express PostgreSQL PWA / Service Worker Oracle Cloud ARM Nginx PM2 Let's Encrypt SSL Open-Meteo API REST API (50+ endpoints) Role-Based Access Control
Get In Touch Back to Projects