All importsFree
Inventory Items
Import ingredients, supplies, and stock items. Supports tracked and expense behaviors.
Column Reference
ColumnRequiredDescription
nameItem name (e.g. Beef Tenderloin, Fish Sauce)
category—Category for grouping (e.g. Protein, Vegetables, Condiments)
unit—Unit of measure (e.g. kg, bottle, liter, bunch)
inventoryBehavior—
- How the system tracks this item when purchased, used, or wasted. Determines stock movements and which journal entries are auto-generated.
- TRACKED_INVENTORY — tracks stock balance (default)
- EXPENSE_ON_PURCHASE — expense on buy, no stock
productCode—Product code / internal reference
minStock—Minimum stock level — triggers reorder alert when stock drops below this
maxStock—Maximum stock level — helps plan purchase quantities
How It Works
- Duplicates skipped by name (case-insensitive)
- Default behavior: TRACKED_INVENTORY — auto-sets journal templates for purchase, waste, and recipe use
- Each behavior generates different auto-journal entries — see /auto-journal for the full mapping
Inventory Behavior
Each behavior determines how purchases, waste, and recipe usage are recorded in the books. Learn more about Auto-Journal
Tracked Inventory
TRACKED_INVENTORY
Purchase
Dr Inventory Asset
Cr Cash / Bank
Waste
Dr Waste Expense
Cr Inventory Asset
Recipe Use
Dr COGS
Cr Inventory Asset
e.g. Beef, rice, beer, cooking oil
Expense on Purchase
EXPENSE_ON_PURCHASE
Purchase
Dr Expense
Cr Cash / Bank
e.g. Cleaning supplies, disposables, rent, utilities
API Endpoint
POST/api/items/import