Inventory control for small teams

Every unit accounted for.

StockPilot brings products, suppliers, and stock movements into one focused workspace. Adjustments run as database transactions, so the quantity on hand and the ledger always agree.

  • Server-side validation on every form
  • Auditable, append-only ledger
  • CSV exports with real data

Stock adjustment

One transaction, four guarantees

postgres
  1. 1

    Authenticate the request

    Session verified on the server and in the database.

  2. 2

    Lock the product row

    Concurrent adjustments cannot overwrite each other.

  3. 3

    Validate the result

    Stock can never be driven below zero.

  4. 4

    Commit the ledger

    Quantity change and movement entry written together.

record_stock_movement()atomic
stock_instock_outadjustment
01Products
02Categories & suppliers
03Movement ledger
04Reports

Capabilities

Built for the way inventory actually moves

A focused set of workflows — not a sprawling ERP. Everything you need to keep stock accurate and prove how it got that way.

A catalog that stays clean

Unique SKUs, money stored as exact numerics, and soft archiving that preserves history instead of deleting it.

Every movement is auditable

Stock-in, stock-out, and adjustments record signed deltas with the quantity before and after the change.

Numbers you can act on

Inventory value at cost, low-stock and out-of-stock views, and date-ranged movement reports, all from live data.

Security at the database

Policies enforce ownership. Column grants block direct quantity edits, so the ledger cannot be bypassed from the client.

Organized around your business

Categories and suppliers are optional where they should be, and enforced as your own records when they are used.

Built for real operations

Server-validated forms, confirmation dialogs, empty states, and responsive screens for the stockroom or the desk.

Workflow

From an empty workspace to an accurate ledger

StockPilot is arranged around the three things that matter: what you stock, when to reorder, and every change you make.

Quantity can only change through a recorded movement.
  1. 1

    Add products

    Create products with pricing, units, and optional category and supplier links. Every new product starts at zero — quantity only changes through the ledger.

  2. 2

    Set reorder levels

    Choose the threshold that should trigger attention. StockPilot flags anything at or below it and keeps out-of-stock items distinct.

  3. 3

    Record stock movements

    Receive, issue, or adjust stock with a reason. Review the ledger, watch the dashboard update, and export reports when you need them.

Security

The rules live in the database

Hiding a button is not authorization. StockPilot enforces ownership, quantity integrity, and ledger immutability at the database layer — then mirrors those rules in the interface.

  • Row-level security on every user-owned table
  • Column privileges block direct quantity updates
  • SECURITY DEFINER function with a pinned search path
  • Movements are select-only for client roles
protect_product_quantity
if new.quantity_on_hand is distinct from
   old.quantity_on_hand
   and current_setting(
     'stockpilot.stock_adjustment', true
   ) <> 'on' then
  raise exception
    'Quantity updates must use
     record_stock_movement';
end if;
Direct quantity edits are rejected

Bring your inventory into focus

Create a workspace, add your first products, and record a movement. The dashboard is built entirely from your data — no sample metrics, no guesswork.