Star Electric: Multi-Counter POS & Inventory System
A point of sale system for a four-counter electrical shop in Rawalpindi, with barcode checkout, live stock counts and ledgers that post themselves.
The Challenge
Star Electric runs retail counters and a warehouse off the same stock in Saddar, Rawalpindi, carrying a catalogue that runs to thousands of line items. Cables by the metre, switchgear, fittings, lighting and accessories, much of it near-identical across brands and ratings. The problem was never an absence of software. It was that three systems disagreed with each other and nobody could say which one was right. A counter sale was written in a bill book. Someone entered it into a spreadsheet later that day, or the next day, or not at all if the shop was busy. The accounts entry happened separately, from the bill book, by a different person. By month end the physical stock, the spreadsheet and the ledger told three different stories, and reconciling them was somebody's whole week. The knock-on effects cost more than the admin did. Purchasing decisions were made against stock figures nobody trusted, so the safe move was always to over-order, which is how dead stock accumulates. Counter staff could not answer a simple availability question without walking to the warehouse to look. And gross profit by product line existed only in theory: you knew the business was profitable, but not which lines were carrying it.
What We Built
We built an offline-first desktop application for each counter, backed by a shared cloud database for reconciliation and reporting. Three decisions did most of the work. Offline-first, not cloud-first. Load shedding and patchy connectivity are facts of life in Saddar. A till that stops selling when the internet drops is worse than a bill book, so each counter holds its own local database and keeps trading through an outage, then syncs when the connection returns. The cloud is the reconciliation layer, not the dependency. Barcode scanning at the counter. Electrical stock is difficult to identify by sight, and two cables can look identical while differing by rating and price. Scanning takes the judgement call away from the person at the counter, which is where most stock errors were being introduced. One write, three records. A sale now posts the stock movement, the tax invoice and the ledger entry in a single transaction. That is the whole point of the build. Not speed, not reporting, but removing the gap in which the same event gets recorded three times by three people and drifts apart. Around that sit role-based permissions and automated supplier ledgers. Counter staff can sell and look up stock but cannot adjust stock levels, change prices or edit a completed invoice; adjustments need a supervisor and leave an audit trail. Purchases post against the supplier account as they happen, so what is owed to each vendor is live rather than a month-end exercise.
What Changed for the Client
The system replaced manual paper billing, shortened daily checkout queues and gave management live gross profit figures for every electrical product line in the Saddar, Rawalpindi business. The change that mattered most is harder to put in a number: the stock figure became something the business could act on. Purchasing now works from a quantity the buyer believes, rather than padding every order against a spreadsheet nobody trusted. Counter staff answer availability questions from the screen instead of walking to the warehouse. Month-end reconciliation stopped being a week of somebody's time. We deliberately did not build an e-commerce front end, a customer app or a loyalty scheme. Each was discussed. Each would have added weeks and solved a problem this business did not have. The entire value of the project sat in one place, which was making the stock figure true.
Technology Stack
Have a Similar Project?
Book a free call with the developers who would build it.
More Case Studies
View All Case StudiesAlvi Transport: Car Rental Booking Website
A booking website and fleet app that moved Alvi Transport off phone calls and WhatsApp logs, so customers can see which cars are free and reserve online.
KB GSM: B2B Ecommerce Development for a Phone Parts Wholesaler
A trade store for mobile repair parts and accessories, with quick SKU search and stock levels that update themselves instead of being keyed in by hand.
