← All posts

QR Code Warehouse Management in NocoBase: Build a Scanning App from Zero, with Real-Time Stock and Low-Stock Alerts

by BAMFLOW • • 5 min read • Updated 9 Nov 2026

QR code warehouse management in NocoBase, built from zero: a four-table data model, printed QR labels, phone scanning for goods-in and goods-out, real-time stock and automatic low-stock alerts — with a free import-ready template.

cover-final

QR Code Warehouse Management in NocoBase: Build a Scanning App from Zero, with Real-Time Stock and Low-Stock Alerts

Quick summary: A step-by-step guide to building QR code warehouse management in NocoBase from scratch: the four-table data model, printing and sticking QR labels, scanning with a phone for goods-in and goods-out, real-time stock levels, and a workflow that warns you before an item runs out. A free import-ready template is included.

If you followed our guide to moving your Excel warehouse into NocoBase, your data is clean and your goods-in / goods-out / stock pages work. A few weeks in, a new bottleneck appears: the keeper still types item codes by hand. Twelve-character codes, peak-hour deliveries, one wrong character and stock is deducted from the wrong item. The fix is the next rung of the ladder — a QR label on every item, and every warehouse movement starting with a phone scan.

What the finished system looks like

Each shelf and carton carries a QR label. Scan it and you see the item: name, specification, current stock, storage location. Goods-in and goods-out documents are built by scanning labels in sequence — like a supermarket checkout — with almost no typing and no wrong codes. Stock is real-time: confirm a document and every screen updates, including the director's dashboard. When an item falls to its minimum stock level (định mức tồn tối thiểu), a workflow alerts the warehouse lead and purchasing — before the item runs out, not after a customer is already waiting. And every movement records who did it, when, and for which order.

QR code warehouse management in NocoBase: scan labels for goods-in and goods-out, real-time stock
QR code warehouse management in NocoBase: scan labels for goods-in and goods-out, real-time stock

The data model: Items / Goods-in / Goods-out / Stock

Four core tables carry the whole system. Items — one row per SKU: item code (the primary key, and the content of the QR label), name, specification, base unit, category, default location, minimum stock level, reference cost. Goods-in documents — a header (number, date, supplier, receiver, status) plus detail lines (item, quantity, price); separating document and lines is the key difference from a flat spreadsheet. Goods-out documents — the mirror image, adding the customer/order reference and the issue reason (sale, transfer, production, supplier return). Stock — a calculated ledger per item per warehouse: Stock = total in − total out, updated only by confirmed documents. Nobody edits stock directly; errors are corrected with a signed adjustment document, never by hand-editing a number.

Get these four tables right and the interfaces almost build themselves — catalogue from Items, document forms from the two document tables, the stock dashboard from Stock. That is the data model-driven approach explained in What is NocoBase.

The QR content only needs the item code (or a serial number, if you track individual units). NocoBase can render the code as a QR on the item page and on printed catalogue sheets — export the labels to PDF and print on decal paper. Stick labels in two places: on the shelf/location (durable, best for stock lookups) and on the carton (travels with the goods, best for picking). Print spares; labels tear.

On the goods-in and goods-out forms, a scan button opens the phone camera: scan a label and the item code fills the current line, focus jumps to quantity, scan the next label and the document grows. A 20-line receipt that took minutes of error-prone typing takes under a minute of scanning. Staff use their own phones in the browser — no separate app to install, just their own account. One operating rule matters: agree the confirmation moment (for example, "confirm on the phone as goods cross the warehouse door"), or real-time stock will lag reality by exactly your data-entry delay.

Warehouse documents in NocoBase: every stock movement is a document with creator and timestamp
Warehouse documents in NocoBase: every stock movement is a document with creator and timestamp

Low-stock alerts that run themselves

A workflow watches every stock change. After any document is confirmed, it checks the affected items; if stock is at or below the item's minimum level, it notifies the warehouse lead and purchasing with the item name, current stock and threshold. One tap takes them to the item page and its recent movement history. A simple starting formula for the threshold: average weekly issues × supplier lead time in weeks, plus a safety margin — then refine after a month using real issue data. The daily "watch the stock" job, which used to depend on one person's memory, now runs automatically, every day.

Permissions — and what comes next

Role-based permissions complete the picture: keepers only operate their own warehouse; accounting sees documents and cost prices but cannot edit confirmed documents; sales can check stock but never see cost. The natural sequel is multi-warehouse operation with transfers and FIFO valuation — see multi-branch warehouse management with FIFO in NocoBase.

Free template: the import-ready Kho QR template (four tables, scanning forms, low-stock workflow) accompanies this article — import it and follow the steps.


About BAMFLOW — BAMFLOW is the official NocoBase partner in Vietnam, implementing and teaching AppSheet, NocoBase and AI for businesses (300+ applications built, 150+ business clients, 1,000+ students trained).

Đọc bản tiếng Việt RSS