1,800 SKUs, one store, and a 32% reduction in stockouts — here's how Flores Hardware turned inventory chaos into a competitive advantage using real-time reorder alerts.
Noong simula ng 2026, ang Flores Hardware sa Cebu City ay may isang malaking problema: hindi sila sigurado kung anong items ang mababa na ang stock — hanggang mag-miss na sila ng sale. Sa loob ng isang quarter, nabago ang lahat.
Flores Hardware carries over 1,800 active SKUs — fasteners, electrical materials, plumbing supplies, paint, hand tools, power tools, and construction accessories. Like most Philippine hardware stores, they tracked inventory in a mix of handwritten bin cards and a spreadsheet that was "usually current."
The result: stockouts that nobody knew about until a customer asked. By the time the reorder was placed, the customer had already bought from a competitor — and in many cases, didn't come back. The owner, Mang Danny Flores, estimated they were losing 8–12 sales per week to stockouts on high-velocity items alone.
Within the first two weeks of using NexusStock, the system surfaced something Mang Danny hadn't expected: of the roughly 1,800 SKUs in the store, just 12 items were responsible for 38% of all "item not available" customer complaints.
These weren't exotic items — they were common high-velocity products: 1/2" x 3" wood screws, Romex 12/2 wire, PVC couplings in two sizes, and a specific SKU of DeWalt drill bits that construction site regulars bought in bulk. Items that moved fast, weren't being reordered fast enough.
After the initial SKU velocity analysis, Flores Hardware configured minimum stock levels on their top 340 high-turnover items. NexusStock now automatically flags these when stock drops to the reorder threshold — before the shelf goes empty, not after.
In the first 7 days after setting reorder alerts, the system flagged 3 items that were about to hit zero — all of which would have been missed entirely under the old spreadsheet system. Each one was restocked before a single customer was turned away.
Using NexusBuy, purchase orders for Mang Danny's key suppliers are now tied directly to his stock levels. When a reorder alert fires, he can create a PO for that exact SKU in under 2 minutes — no more handwritten order sheets faxed to the distributor.
By the end of Q1 2026, Flores Hardware had reduced stockout incidents by 32% compared to the same quarter the previous year. More importantly, repeat customer visits — tracked via their loyalty records — increased in the same period.
"Hindi na ko natatawagan ng mga customer para itanong kung may stock pa kami. Dahil alam na namin bago pa man maubusan. Yun ang pinaka-importanteng pagbabago."
The Flores Hardware outcome isn't unique to hardware — it's the result of replacing reactive inventory management (waiting until the shelf is empty) with proactive inventory management (knowing what's about to run out before it does).
The setup takes about 2 hours. The impact starts in the first week. If your store carries more than 200 SKUs and you've ever had a customer leave because you were out of stock, this is worth looking at.
See what's slipping through the cracks in your inventory. 60 minutes, no sales pitch. We map your current process, identify your highest-risk stockout SKUs, and give you a custom rollout plan.
Book a free audit →Most hardware stores manage supplier credit in a notebook or in someone's head. Here's a better way — and what happens when you can see every peso owed, per supplier, in real time.
Running a Philippine pharmacy means carrying two compliance burdens — BIR receipts and FDA batch/expiry tracking. Here's how to handle both without a second system.
The BIR e-invoicing rollout is expanding. Here's the plain-language checklist for sari-sari stores, cafes, and retail shops — what you need, what's optional, and what carries a penalty.
BIR-compliant receipts, offline-first POS, GCash/Maya reconciliation, inventory tracking, and owner dashboards — all connected. Same-day onboarding. Training under 2 hours.