Stockouts Every Week, Spreadsheets Overflowing
A mid-sized FMCG wholesaler based in Tuas operated across four warehouses, supplying packaged food and beverages to convenience stores and independent retailers across Singapore. Their inventory tracking relied entirely on shared Excel files passed between warehouse supervisors and the sales team. Orders were logged manually, stock movements were updated in batches, and discrepancies were routine. When a popular energy drink sold out at peak hours, the system often showed available stock because the latest dispatch hadn’t been recorded. Conversely, overstock of slower-moving items tied up working capital, with some products expiring on shelves. The operations manager began receiving weekly complaints from retail clients about delayed deliveries or partial fulfilments. With no real-time visibility, every stock count required a full day of warehouse downtime. The business was growing, but its inventory process was not scaling.
Multiple Files, No Single Source of Truth
When we first reviewed their workflow, we found not one central spreadsheet but 17 interlinked Excel files—each tied to a warehouse or product category, updated independently and merged weekly in a manual consolidation process. There was no audit trail, no access control, and frequent version conflicts. A physical count in Warehouse 3 might not reflect in the master file for 48 hours. The team had no way to track who changed what, and errors often went unnoticed until a delivery truck arrived with the wrong items. Worse, they lacked integration between inventory and sales data—so forecasts were based on outdated figures. The root issue wasn’t just the tool; it was the absence of a live, centralised data environment. They were running a modern logistics operation on a system designed for single-user recordkeeping.
Deploying a Cloud-Based Inventory System with Real-Time Sync
We implemented a cloud-native inventory management platform hosted on Google Cloud Platform, using a microservices architecture to support distributed operations. Each warehouse was equipped with Android-based handheld scanners running Zebra technology, feeding stock movements directly into the central system. The platform was built on Firebase for real-time database updates, ensuring that when a pallet was moved in Jurong, the change appeared instantly in the dashboard viewed by the sales team in head office. We integrated the system with their existing accounting software via RESTful APIs, enabling automatic updates to stock levels upon invoice generation. User roles were configured in Google Workspace, enforcing access controls so warehouse staff could only log movements, while managers could adjust thresholds and generate reports. Historical data from the spreadsheets was cleansed and migrated using automated scripts, with validation checks to ensure accuracy. The entire deployment, including staff training and dry-run cycles, took eight weeks.
Ninety-Five Percent Reduction in Fulfilment Errors
Within three weeks of going live, stockout incidents dropped by 87%. The real-time visibility allowed warehouse supervisors to trigger replenishment alerts before low-stock thresholds were breached. Overstock of perishable goods decreased by 68% in the first quarter, reducing write-offs by SGD 2,560 per month. Order fulfilment accuracy rose from 72% to 98%, and the weekly stock reconciliation that once took two days now completes automatically every night. The sales team gained access to live inventory dashboards, allowing them to promise accurate delivery dates to clients. Two years after implementation, the system has scaled seamlessly to include a fifth warehouse, and the client has since added predictive restocking using historical usage patterns processed through Google Cloud’s BigQuery analytics engine.
Real-Time Data Is Not a Luxury—It’s a Baseline
For Singapore SMEs managing physical goods, the shift from spreadsheets to cloud systems isn’t just about automation—it’s about eliminating blind spots that directly impact revenue and customer trust. Many small wholesalers assume cloud solutions are costly or complex, but modern platforms allow phased, cost-effective transitions that pay back within months through reduced waste and improved service levels. The key is not to replicate spreadsheet logic in software, but to redesign workflows around live data.
When your warehouse team and sales team are working from different versions of reality, no amount of overtime fixes the gap — explore how cloud inventory systems can align your operations at TYPENT’s cloud solutions page.