Multi-Warehouse Inventory Control System for Flower Station

A fully custom-built Inventory Control System for real-time stock tracking, automated reporting, and smooth warehouse operations across three key locations — eliminating manual errors and increasing efficiency.

Flower Station required a centralised inventory management solution to manage perishable stock across multiple locations.

We built a fully custom-integrated inventory control platform connecting stock levels, transfers, logs, and automated reporting into one secure portal reducing wastage, preventing oversells, and ensuring operational accountability.

Technology Stack & Architecture

Built on a modern, full-stack architecture to ensure speed, scalability, and seamless multi-location inventory control.

React 18

Mantine

MUI

React Router DOM

React Query

Zustand

Node.js

Express.js

MongoDB

Mongoose

Joi

Day.js

JWT Authentication

Node-Cron

PDF Kit

SendGrid

ExcelJS

Railway

Core Inventory Features & Smart Stock Handling

Item Management: Add, edit, and delete items manually or via bulk Excel imports with built-in validation.
Stock Handling: Add stock manually or in bulk using Excel templates, with automatic count updates for accuracy.
Upper & Lower Limit Alerts: System flags SKUs crossing stock limits, generating automated daily PDF reports at 5 PM UK time.
ogs & Daily Tracking:L Noon & Evening log system captures inventory changes at specific times, ensuring time-stamped accountability.
Error Prevention: Built-in validation (Yup, Celebrate, Joi) prevents incorrect data entries during manual or bulk uploads.

Logs, Team Activity & Real-Time Analytics

Daily Log System: Add or edit Noon/Evening/Midday logs with automated time checks entries outside time slots are blocked.
Data Analysis Views: Timeline views show hourly changes to stock, logs, transfers, and edits across all locations.
Team Activity Tab: Centralised history of all inventory actions add stock, bulk imports, transfers, logs with filters for date, user, and location.
Printable & Downloadable Reports: Managers can instantly download PDF reports for logs, stock changes, and transfers.

Admin Dashboard, Role-Based Access & Automation

Role Permissions: User roles (Admin, Manager, Staff) restrict access based on responsibilities.
Secure Authentication: JWT-based login ensures only authorised users can manage inventory data.
Automated Daily Reports: At 5 PM UK time, system generates PDF reports for low/high stock alerts and emails them to registered managers.
Error & Issue Reporting: Users can instantly report glitches or usability issues for quick resolution.

Results Delivered

100% Real-Time Accuracy

Stock levels auto-sync across all three locations with instant updates.

Reduced Wastage

Automated stock alerts and log tracking cut expired stock losses.

Time Savings

Bulk imports, auto-reports, and transfers reduced manual data entry by hours per week.

Operational Transparency

Full team activity logs and transfer history improved accountability and auditing.

The Challenge – Why Standard Inventory Tools Weren’t Enough

Multiple Locations, No Central System: Manual spreadsheets and fragmented tracking caused frequent oversells and stock discrepancies between the three locations.
Perishable Stock Management Issues: Flowers have a limited shelf life — overstocking led to wastage while understocking caused missed sales opportunities.
Lack of Real-Time Data & Accountability: Managers had no live view of stock movements, transfer status, or user activity, making audits and decision-making difficult.
No Automated Reporting: Daily stock reports, high/low stock alerts, and transfer records had to be compiled manually, wasting time and causing delays.

Looking to Replace Manual Stock Tracking with Automation?

We built a fully customised inventory management platform for Flower Station — reducing costs, errors, and manual work while improving efficiency across multiple warehouse locations. We can do the same for your business.

Our process is simple

We’d love to hear from you and arrange a free consultation and quote.

Request Quote

Submit Requirements

Review Delivery

Launch