Case Study: Bespoke Inventory & Order Management for Lightz

Modern manufacturing demands more than just a spreadsheet. For Lightz, a high-end lighting solution provider, the complexity of managing thousands of individual electrical components, lenses, and housings required a system that was as precise as their engineering.

I recently designed and deployed a custom-built, cloud-native Stock & Order Management System tailored specifically to their manufacturing workflow.

The Challenge

Lightz handles a wide variety of products, each consisting of a complex Bill of Materials (BOM). Their existing manual tracking was becoming a bottleneck:

• Difficulty in calculating "buildability" (how many finished units can we make with current parts?).
• Lack of real-time alerts for critical stock thresholds.
• No centralized audit trail for part movements or order status changes.

The Solution: A High-Performance Management Engine

I built the system using a modern, serverless architecture on Cloudflare Workers, leveraging D1 (SQL) for relational data integrity and a "Glassmorphism" frontend for a premium user experience.

📊 Real-Time Dashboard

Stock Dashboard

The system provides an immediate overview of stock health, highlighting total units across the warehouse and surfacing items that need urgent attention via an intelligent alerting system.

🛠️ Bill of Materials (BOM) & Build Logic

Products Overview

One of the most powerful features is the Product Definition engine. Administrators can define "Finished Products" by selecting the necessary parts and quantities. The system then automatically calculates:

• Current buildable capacity.
• Missing components for a specific order.
• One-click "Confirm Build" which deducts all sub-components from inventory in a single ACID transaction.

📦 Seamless Order Tracking

The platform manages the entire lifecycle of both Customer Orders and Parts Orders (PO).

• Customer Side: Tracking from Planning -> Build Progress -> Paid -> Sent.
• Parts Side: Tracking ETAs and auto-incrementing stock levels the moment a shipment arrives.

🛡️ Enterprise-Grade Audit Logging

Accountability is key. Every action—from password changes to individual stock adjustments—is captured in a detailed activity log, providing a full audit trail of who did what and when.

Tech Stack

To ensure maximum speed and zero maintenance overhead, I chose a lean, high-performance stack:

• Frontend: Vanilla JavaScript (ES6+), Tailwind CSS for styling, and Lucide Icons for a crisp UI.
• Backend: Cloudflare Workers (Edge Computing platform).
• Database: Cloudflare D1 (SQLite at the edge), providing relational power with ultra-low latency.
• Security: Role-Based Access Control (RBAC) and encrypted session management.

The Results

By moving from fragmented spreadsheets to a centralized engine, Lightz has seen:

• Zero unexpected stockouts on critical manufacturing components.
• 60% faster order processing by automating the build-check logic.
• Improved production planning through accurate ETA tracking on incoming parts.

Looking to modernize your operations? Whether it's Intune automation or bespoke business systems, I build tools that scale.

Contact me to discuss your next project.