A free, open-source inventory management system for a small warehouse or shop, built with Next.js, TypeScript and PostgreSQL. It covers products with SKUs, barcodes and variants across several locations with bins and reorder points, a stock movement audit trail, purchase orders with part deliveries and backorders, stock counts with variances, barcode scanning, reports and CSV import and export.
by Light CloudInventory and operations, Invoicing and finance


The app is built on the Next.js SaaS starter: workspaces, owner, admin and member roles, Better Auth sign-in and an admin panel, with the stock rules in src/lib/inventory. On hand always equals the sum of the movement trail, because movements are only ever added. Stock value is on hand times the current cost price; there is no FIFO or average costing. Camera scanning needs HTTPS or localhost, which a Light Cloud deploy has, and a USB or Bluetooth scanner or typing the code always works. npm start applies the migrations and seeds the Leeds Coffee Equipment Supplies demo once, the first person to sign up owns it, and Settings, Workspace removes it while keeping what you added.
Yes. This Next.js and PostgreSQL template is MIT licensed and runs on any Node.js host with PostgreSQL, or on Light Cloud in one click. Without Stripe keys every feature is on and there is no seat limit.
Either. The Scan page and the count sheet read barcodes with the camera through ZXing in the browser, which needs HTTPS or localhost. A USB or Bluetooth scanner types the code and presses Enter, so it works in the same box with no setup.
Save the sheet as CSV and use Products, Import CSV. It needs a SKU column, reads Name, Variant, Barcode, Category, Supplier, Unit, Cost and Price with the usual Shopify, Square and spreadsheet spellings, and columns named On hand: <location> set stock there as a count movement.
Receive what came on the purchase order. The order shows as part received and the rest stays on backorder until it arrives, or you close the order short; each receipt is a movement with the delivery note number.
Stock value is the quantity on hand times each product's current cost price, by location and by category. There is no FIFO or average costing, so changing a cost price revalues the stock you already hold.