Corahvel
Concept ProjectBusiness Systems

Inventory Control Platform

One stock figure every branch can trust

Industry
Retail & Distribution
Indicative build
8–10 weeks
Stack
Next.js, PostgreSQL, Node.js

Inventory Control Platform — hero

1920×1080px (16:9) · JPG

A stock system for a business running several branches off one warehouse. The point of the build is a single source of truth: one number per item per location, updated as goods move, visible to head office and to the branch at the same moment.

Why spreadsheets break at this size

A spreadsheet works until two people need to change it at once. With several branches, the file is either locked or forked, and within a week nobody knows which copy is current. The symptom a business notices is not the file — it is ordering stock it already has, and selling stock it does not. Both come from the same root cause, so both are fixed by the same thing: one record, one owner, written once.

How the system is built

Stock lives in PostgreSQL with movements recorded as an append-only ledger rather than as edits to a running total. Every change — a receipt, a sale, a transfer, a correction — is a row, and the current level is derived from them. That costs a little more to query and makes the system auditable: any figure can be traced back to the movements that produced it, which matters when a branch and head office disagree. Role-based access means a branch sees and edits its own stock, while head office sees all of it.

What it does day to day

Branch staff receive deliveries and record sales against a barcode or a search. The system holds a reorder threshold per item per branch and raises a low-stock alert when a level crosses it, so ordering is driven by the data rather than by somebody noticing an empty shelf. Purchase orders carry through to suppliers, and the reporting view breaks movement down by branch, by item, and by period, exportable for whoever needs it outside the system.

Inside the build

Stock dashboard showing levels across several branches

1200×900px (4:3) · JPG

Every branch's stock on one screen, with the items below threshold surfaced first.

Item detail view with its movement history

1200×900px (4:3) · JPG

Each item's current level traces back to the movements that produced it.

Purchase order and supplier management screen

1200×900px (4:3) · JPG

Reorder thresholds turn low stock into a drafted purchase order.

Let's Build a Better System for Your Business.

Tell us what is slowing your business down, what you want to improve, or what you want to build. We will help you define the right next step.