The Inventory module gives kitchen and purchasing staff a live view of every ingredient and supply item (insumo) in the restaurant. Each row in the table shows the current stock level alongside the configured minimum threshold, and any item whose stock has fallen to or below that threshold is immediately flagged with a Stock Bajo alert—both on the individual row and as a summary count in the page header. Staff can add new items, adjust quantities, and remove discontinued supplies without leaving the view.Documentation Index
Fetch the complete documentation index at: https://mintlify.com/teofilobetancourt/Tradiciones-y-Sabores/llms.txt
Use this file to discover all available pages before exploring further.
Insumo Fields
Every supply record stored in theInventario.Insumos PostgreSQL table is composed of the following fields:
| Field | Type | Description |
|---|---|---|
ID_Insumos | bigint (PK, auto) | Unique identifier for the supply item |
Nombre_Insumo | varchar(100) | Name of the ingredient or supply (unique) |
Unidad_Medida | varchar(20) | Unit of measurement (e.g., Kg, Litro, Paquete, Unidad) |
Stock_Actual | numeric(12,4) | Current quantity on hand |
Stock_Minimo | numeric(12,4) | Minimum acceptable stock level before an alert is raised |
Punto_Reorden | numeric(12,4) | Quantity at which a reorder should be placed |
FK_IDCategoria | bigint (FK, optional) | Category reference from Inventario.Categoria |
The Inventory tables (
Insumos, Proveedores, Categoria) live in the dedicated Inventario PostgreSQL schema, separate from the main restaurant tables (pedido, factura, plato, etc.) which use the default public schema. Ensure your database user has USAGE and SELECT/INSERT/UPDATE/DELETE privileges on the Inventario schema.Low-Stock Alerts
The system comparesStock_Actual against Stock_Minimo for every item on every page load. When Stock_Actual <= Stock_Minimo:
- The table row is highlighted in a red-tinted background.
- The stock value is rendered in red instead of the primary color.
- A Stock Bajo badge (with a warning icon) appears in the Status column.
- The page header displays a banner showing the total count of low-stock items.
Managing Inventory Items
Add a new item
Click Agregar Ítem in the top-right of the Inventory page. Fill in the item name, current stock quantity, unit of measure, cost price, and minimum stock level in the modal form, then click Guardar. The
Punto_Reorden is automatically set to Stock_Minimo × 1.5 if not supplied explicitly.Edit an existing item
Click the pencil icon (✏️) on any row to open the edit modal pre-populated with the item’s current values. Adjust any field and click Guardar to persist the changes.
Supported Units of Measure
The form dropdown includes the following units out of the box:kg, g, L, mL, unidad, paquete, caja, bolsa, litro. Selecting the correct unit at creation time ensures that stock comparisons and reorder triggers remain meaningful.
API Reference
| Method | Endpoint | Description |
|---|---|---|
GET | /api/inventario | Return all insumos ordered by name |
POST | /api/inventario | Create a new insumo |
PUT | /api/inventario/{id} | Update one or more fields of an existing insumo |
DELETE | /api/inventario/{id} | Permanently delete an insumo |
POST and PUT endpoints accept both camelCase frontend keys (nombre, stock, unidad, stock_minimo) and the canonical database column names (Nombre_Insumo, Stock_Actual, Unidad_Medida, Stock_Minimo) interchangeably.