In-house productGrocery retail
A retail business running stock, orders, point of sale and books in one system
A grocery business selling through five channels at once, where the real cost was not selling — it was the nightly reconciliation between a register, a spreadsheet, a phone and an online store that never quite agreed.
Who did this workBuilt and run in-house by our team. Shown here with demonstration data.
The result
5
sales channels in one order queue
Technologies & disciplines
- PHP
- Laravel
- Livewire
- MySQL
- Tailwind CSS
- Role-based access control
- Inventory movement ledger
- Point of sale
The situation
A shop selling in five places at once — a website, Facebook, WhatsApp, the phone, and the counter itself. Each channel had its own record of what had been sold, and none of them talked to the stock count. The result was the familiar small-business tax: an hour every night reconciling a register against a spreadsheet against an online store, stock figures that were wrong by the time they were written down, and no reliable answer to the two questions that matter — what did we actually make this month, and what are we owed.
What we did
Put every channel into one order queue, so a WhatsApp order and a counter sale are the same kind of record and the stock count moves once, at the moment of sale.
Built inventory as a movement ledger rather than a running number, so any stock figure can be traced back to the purchase, sale or adjustment that produced it.
Added point of sale with an open-shift model — opening cash in, sales through, cash counted out — because a register that does not reconcile is where small retail loses money quietly.
Wired purchasing, vendor balances and expenses into the same books, so cost of goods is real rather than estimated, and gross margin is a fact rather than a guess.
Built reporting last and on top of the ledgers, not beside them, so the profit-and-loss statement is derived from the same records the shop runs on.
The result
- Five sales channels handled in a single order queue, with stock decremented once per sale.
- Inventory, cash and payables that reconcile without a nightly spreadsheet pass.
- A profit-and-loss statement produced from the operating records themselves, available for any date range.
Why we show our own product
This one is ours. We build it, run it and maintain it, which means we carry the consequences of every design decision in it — a slow screen wastes operator time, and a wrong stock figure costs money.
That is the same system we build for clients whose operations have outgrown spreadsheets. The advantage of showing it here is that we can open any part of it and explain why it works the way it does.
More of the system
Keep reading
More work
~1.3×operational efficiency after launch
Sagawa Express. A national courier's pickup requests arrived by phone and were tracked in spreadsheets. Our team designed the online booking platform and driver application that replaced both.
48,000+parking lots managed on the platform
Tokup. A reservation product covering tens of thousands of parking lots nationwide, where the design problem was density — finding one usable space quickly, on a phone, in a hurry.
~1Mrequests per day handled by the Go services
Platform-as-a-service product, Dubai. Core backend, microservices, billing and the internal tooling that let an entire engineering team run the production stack locally — plus Go services elsewhere handling roughly one million requests a day.
2portals — customer and operations — from one codebase
In-house product. A recurring-delivery business where the operational load is not the deliveries themselves but the arithmetic around them — who gets what today, who paused, who owes, and what changes when one customer skips a week.
6service lines, each with its own page
A facility-management company. Its buyers are procurement teams comparing vendors on paper, so the site has to make the single-vendor argument itself — and then make the inquiry effortless.
3practices under one custom admin
An e-commerce agency. Three distinct practices and a service catalog too large for a static site, where the requirement was that the client could restructure their own offering without a developer.
Tell us what you are trying to build.
A 30-minute call with the people who would do the work — not a sales team. We will tell you honestly whether we are the right team for it.
- On the call
- Your goals, what exists today and the first steps. No account manager in between.
- Afterwards
- A written scope and a price within days — or a straight answer that we are not the right team.
- No obligation
- Nothing is committed until a scope is signed, and anything we send you is yours to keep.
We reply to every inquiry within one business day. Prefer email? info@sparqweb.com