Custom Warehouse Management System for Multi-Location Operations

Vernox is a custom warehouse management system built for a family-owned warehouse operation in California that had outgrown spreadsheet-based inventory management. The business manages multiple warehouses with complex operational requirements - inventory tracking, customer management, order fulfillment, and dispatching - all of which were being handled in Excel. The result was data mismatches, lost visibility across locations, and operational errors that were costing time and money. Enterprise alternatives like SAP were evaluated but dismissed due to cost - minimum $10,000 per year in licensing alone, with significant implementation overhead on top. The client needed a system that was purpose-built for their specific warehouse workflows, affordable to own, and simple enough for their team to use from day one.

1. 01

   The client managed multiple warehouses in California using spreadsheets. As operations scaled, Excel-based tracking became unreliable - inventory counts did not match reality, cross-warehouse visibility was nonexistent, and order management required manual coordination between locations. Enterprise WMS solutions like SAP were evaluated but dismissed due to cost ($10,000+/year minimum) and implementation complexity.

2. 02

   Designing a system that warehouse staff with limited technical experience could adopt immediately. The interface needed to support QR scanning for dispatching, multi-warehouse inventory views, and order management - all without training sessions or thick user manuals. Each warehouse had slightly different processes that the system needed to accommodate.

3. 03

   Building a multi-warehouse architecture where each location maintains its own inventory while rolling up into a unified real-time view. QR code scanning needed to work reliably in warehouse environments (varying lighting, distance). The system needed to handle concurrent operations across locations without data conflicts.

• Custom web-based warehouse management platform

  Browser-based platform reachable from every warehouse, replacing the multi-spreadsheet setup that did not scale across locations.

• Customer and product management modules

  First-class records for customers and products, separate from inventory — so orders, returns, and fulfillment all reference the same canonical data.

• Deployed on AWS with production monitoring

  AWS hosting with monitoring and alerting in place — critical for an operation where downtime stops dispatching across multiple sites.

• Email authentication

  Email and password sign-in with admin-managed provisioning, kept simple for a warehouse team adopting digital tools for the first time.

• Multi-warehouse inventory management

  Each warehouse tracks its own inventory, with cross-location visibility and rollups so the owner sees the full picture without phone calls.

• Order management and fulfillment tracking

  Orders flow from creation through pick, pack, and dispatch with status visible across teams — replacing spreadsheet-and-email handoffs.

• QR code scanning for dispatching and receiving

  QR scanning at receiving and dispatch reduces manual entry and the error rate that came with Excel-based tracking.

• Role-based access control

  Owners, warehouse managers, and floor staff each see only the data and actions they need — enforced server-side.

• 100%

  On-time delivery of the web platform with QR scanning, multi-warehouse views, and order management from day one

• 90%

  Reduction in time spent on inventory tracking compared to spreadsheet-based management

• $10K+/yr

  Saved compared to SAP licensing alone - before counting implementation and customization costs

• Real-time

  Unified inventory visibility across all warehouse locations - replacing daily phone calls and emailed spreadsheet updates

1. 1
   Step 1 / 4

   Mapped the complete warehouse workflow across all locations - receiving, storage, picking, dispatching, and customer delivery. Documented the specific pain points where spreadsheet management was breaking down and identified the highest-impact features for the MVP.

2. 2
   Step 2 / 4

   Designed the warehouse interface for speed and simplicity - large touch targets for QR scanning, clear inventory views per location and across locations, and an order management flow that matched how the team actually works on the warehouse floor.

3. 3
   Step 3 / 4

   Built the multi-warehouse system with React.js frontend, Nest.js backend, and MongoDB for flexible document-based inventory storage. Implemented QR code generation and scanning, real-time inventory updates across locations, and role-based access for warehouse staff, managers, and admins.

4. 4
   Step 4 / 4

   Deployed to AWS, loaded initial inventory data, trained the warehouse team on the new system, and monitored the first weeks of production usage to catch and resolve any operational issues.