RetailPro Cincinnati – Multi-Location Inventory System

Project Overview

RetailPro, a 12-store Cincinnati retail chain with over 8,000 active SKUs, was suffering from the costly consequences of manual, disconnected inventory management across all their locations.

The Challenge

Annual stock shrinkage of $180,000, constant stockouts hurting customer experience, and no real-time visibility between stores were the compounding problems that demanded a custom technology solution.

Our Solution

We built a unified, multi-location inventory intelligence platform:

• Centralized real-time stock dashboard with location-by-location drill-down reporting
• Mobile barcode scanning app for iOS and Android enabling instant stock counts and transfers
• Automated purchase order generation triggered by configurable reorder point thresholds
• Demand forecasting engine analysing seasonality and sales velocity per SKU
• Inter-store transfer management with route-optimised delivery scheduling

Key Results

• Annual stock shrinkage reduced by $140,000 — a 78% reduction from the $180K baseline
• Stockout incidents decreased by 78% improving in-store customer satisfaction scores
• Purchase order accuracy reached 96%, eliminating costly over-ordering
• Staff saved 120 collective hours per week previously spent on manual stocktaking

Technologies Used

PHP 8, MySQL, React.js Dashboard, Barcode Scanner API, Chart.js Analytics, REST API, Mobile-Responsive