All projects
Business SoftwareCompleted

F&B HQ Platform

Multi-outlet menu, inventory & POS

A central head-office system for a food and beverage chain. HQ owns the master menu and outlet pricing, every outlet runs its own POS and stock, and sales roll up into live revenue and best-seller reports.

ReactNode.jsExpressPostgreSQLPrismaTypeScriptDockerVitest
F&B HQ Platform: HQ sales overview
PlatformWeb console + outlet POS
CategoryBusiness Software
StatusCompleted
EngagementProduct design & engineering

Project Overview

Multi-outlet menu, inventory & POS.

A restaurant group with several outlets needs one source of truth for the menu, while each outlet still controls its own prices, stock and counter. This platform does exactly that: one company, many outlets. HQ assigns the menu, outlets make sales, and HQ sees the reports.

The HQ console manages the master catalogue, assigns items to specific outlets and overrides prices per outlet. Each outlet terminal sees only its assigned items at the effective price. Staff ring up multi-item orders, track stock (restock, wastage, correction) and review every receipt.

The engineering focus was correctness under real-world load. Every sale runs in a single database transaction that locks stock rows in a fixed order (so concurrent sales can't deadlock), validates the whole cart, deducts stock with a guarded update and issues a sequential, gap-free receipt number per outlet. Idempotency keys make network retries and offline replays safe.

This behaviour is backed by 40 integration tests against a real PostgreSQL database. For example, 30 concurrent sales against a stock of 10 produce exactly 10 successes and receipts numbered exactly 1 to 10.

40Integration tests
0Oversold units under load
2Roles: HQ & outlet
1Transaction per sale

Feature Tour

Inside F&B HQ Platform, screen by screen.

Use the arrows, thumbnails, keyboard or swipe to browse. Open any screen full size.

The Challenge

The real operational problem.

Multi-outlet F&B operators lose control when menus, prices and stock live in separate spreadsheets per branch. Under rush-hour concurrency, naive POS systems oversell stock, skip or duplicate receipt numbers, and double-charge on network retries, and HQ never gets a trustworthy revenue picture.

Our Solution

A focused system built around the workflow.

We built a role-separated HQ console and outlet POS on a layered Express and PostgreSQL API. Row-level locking, guarded stock updates, a per-outlet receipt counter and idempotency keys guarantee that sales, stock and receipts always reconcile, even when many terminals sell the same item at the same moment.

Modules in Detail

What the platform covers.

01

Head Office Console

  • Sales overview with Today, 7-day, 30-day and all-time filters
  • Revenue, transactions and average ticket per outlet
  • Top 5 sellers per outlet ranked by quantity, with revenue
  • Master menu with SKUs, categories, base prices and activation
02

Outlet Management

  • Assign master items to individual outlets
  • Outlet price overrides with the effective price shown
  • Per-outlet availability toggles and low-stock badges
  • HQ test POS to verify an outlet's configuration
03

Outlet Terminal

  • Category-filtered POS grid with live stock counts
  • Cart with quantity controls; prices and stock confirmed by the server
  • Inventory adjustments (restock, wastage, correction) with a ledger
  • Sales history with receipt numbers and line details
04

Correctness & Operations

  • Fixed-order row locks (SELECT … FOR UPDATE) to prevent deadlocks
  • Guarded stock decrement plus a CHECK constraint so stock never goes negative
  • Per-outlet counter row for gap-free receipt sequences
  • Docker multi-stage images, nginx, structured logs and health probes

Key Features

The capabilities that make the difference.

HQ master menu & catalogue

Per-outlet assignment & price overrides

Touch-friendly outlet POS

Per-outlet stock with restock/wastage

Sequential, gap-free receipts

Revenue by outlet & top-5 sellers

Idempotent, retry-safe checkout

Role-based HQ & outlet access

Final Outcome

Technology that creates room for the business to move.

A production-grade, fully tested platform where the head office controls the menu and pricing centrally, outlets sell independently, and every receipt, stock movement and revenue figure reconciles exactly, even under concurrent load.

Start a project

Have a challenge that needs a purpose-built product?

Book a Consultation
Message us