The Store Manager Who Cried Over Expired Batteries

I met Rizwan Ahmed, MartPlus's Operations Head, on a Sunday afternoon. He was standing in the back room of their main store, surrounded by boxes of expired products.

"Look at this," he said, holding up a pack of AA batteries. "These expired 3 months ago. We paid Rs. 2,500 for them. And there are hundreds of items like this across our 3 stores."

Rizwan was frustrated. He was also exhausted. Every Sunday, he and his team spent 5+ hours doing manual stock counts. They'd walk through the store, count everything on the shelves, write it down in notebooks, then enter it into Excel.

And for what? So they could be wrong.

"We had a customer come in last week looking for a specific phone charger," Rizwan told me. "Our system said we had 15 in stock. But when I checked the shelf, there were none. Turns out, 12 were in the back room, and 3 had been sold last week but never updated in the system. The customer left. We lost a sale. And we had no idea it happened."

MartPlus was a successful electronics retailer with 3 stores in Karachi. They sold everything from smartphones to chargers to batteries to accessories. But their inventory management was a mess. Like a big huge mess.

The Retail Inventory Problem Nobody Sees

MartPlus had grown from 1 store to 3 stores in 2 years. But their inventory systems hadn't grown with them. Not even close.

The Manual Count Problem

Every Sunday, store managers would:

Close the store for 2 hours
Count every item on the shelves
Write it down in notebooks
Enter it into Excel
Email it to Rizwan
Rizwan would consolidate all 3 stores into one spreadsheet

This took 5+ hours per store. 15+ hours total per week. And it was always wrong. Like always.

Rizwan told me: "People make mistakes when they're counting 10,000 items. They miss things. They write the wrong number. They forget to update the spreadsheet. By the time we realize there's a problem, we've already lost sales."

The Stockout Problem

Stockouts were common. Popular items like phone chargers and earphones would run out, and Rizwan wouldn't know until a customer complained.

"We lost a customer last month because we didn't have the iPhone charger they needed," Rizwan said. "They went to our competitor down the street. They spent Rs. 15,000 with them. And they never came back."

The Overstocking Problem

The flip side was overstocking. MartPlus would order too much of something, and it would sit on the shelf for months.

Rizwan showed me a shelf full of old phone cases. "These were popular 6 months ago. Now nobody buys them. We have 200 units sitting here, taking up space, and we can't sell them. We lost Rs. 50,000 on this alone."

Building the Solution

We designed a comprehensive inventory management system with three main components: mobile app for scanning, admin dashboard, and smart features.

Barcode Scanning: Staff scan products using their phone camera. No more manual counting. No more writing numbers in notebooks.

Stock Management: Staff can update stock with one tap — add new stock, remove stock, transfer between stores, mark items as expired. All synced to the cloud in real-time.

Low Stock Alerts: The app sends notifications when stock is low. "You have 5 units left of iPhone charger. Consider reordering."

Offline Mode: The app works offline. If there's no internet connection, staff can still scan and update stock. The data syncs when they're back online.

Real-Time Dashboard: Rizwan could see everything across all 3 stores. Current stock levels, low stock alerts, expired products, stock movements. All in real-time.

Automated Reordering: The system automatically generates purchase orders when stock is low. Set minimum stock levels and the system alerts you when stock falls below.

Demand Forecasting: The system predicts how much stock to order based on past sales data, seasonal trends, and current stock levels.

The Results

Six months after launch, the numbers were in:

Stockouts: Weekly → Rare. That's a 75% reduction.

Overstocking costs: Rs. 200,000/month → Rs. 120,000/month. That's a 40% reduction.

Inventory time: 15 hours/week → 3 hours/week. That's 80% less time.

Revenue growth: +25%. Better stock availability meant more sales.

Stock accuracy: 75% → 98%. Barcode scanning eliminated manual counting errors.

The Human Impact

Rizwan told me: "I used to work 6 days a week. Sundays were for inventory. I missed family gatherings. I missed friends' weddings. I was always tired.

Now, I finish inventory in 1 hour. I go home. I have lunch with my family. I take my kids to the park. I actually have a life again."

A store manager named Hassan told me: "Before the app, I dreaded Sundays. Rizwan would yell at me if the count was wrong. Now, I scan everything with the app. It's accurate. Rizwan is happy. I'm happy."

A customer named Mrs. Fatima came in looking for a specific hearing aid battery. Store A didn't have it. But the staff checked the system and saw that Store B had 20 units. They transferred one unit. Mrs. Fatima got her battery in 10 minutes.

"I've been looking for this battery for 2 weeks," she told them. "Every store I went to didn't have it. You guys actually had it. Thank you so much."

What This Project Taught Me

Retail is about people. When you're managing inventory, you're not just managing products. You're managing customer expectations. You're managing staff morale. You're managing a business.

Rizwan said it best: "You didn't just build us an inventory system. You gave me back my Sundays. You gave my staff their dignity. You gave our customers the products they need. That's everything."

Final Thoughts

MartPlus is now planning to open a 4th store. Rizwan told me: "I couldn't have done this before. The inventory system was holding me back. I was too busy counting to think about growth. Now, I can focus on expanding."

Every time a customer finds what they need, every time a staff member goes home on time, every time Rizwan spends a Sunday with his family instead of counting batteries — that's what this project is all about.

Technology should make retail invisible. With MartPlus, I think we achieved that.