Skip to main content
The Inventory system helps you track tattoo supplies, maintain adequate stock levels, and monitor usage over time.

​
Inventory Overview

The inventory system consists of three main areas:
  • Dashboard - Summary metrics and alerts
  • Items - Product catalog with stock levels
  • Movements - History of entries, exits, and adjustments
Inventory tracking requires the inventory module to be enabled and proper permissions.

​
Managing Inventory Items

​
Viewing Items

The Items page displays your complete product catalog:
1
Step 1: Access Items List
2
Navigate to Inventario → Ítems from the main menu.
3
Step 2: Review Item Details
4
The table shows:
5
  • SKU - Stock keeping unit / product code
  • Nombre - Item name
  • Categoría - Product category
  • Unidad - Unit of measure
  • Stock - Current quantity (right-aligned)
  • Mínimo - Minimum stock threshold (right-aligned)
  • Caduca - “Sí” if item has expiration dates
  • Proveedor - Supplier name
  • Acciones - Quick action buttons
    • 6
    Items with stock below minimum are highlighted in red (#b91c1c) to indicate low inventory.

    ​
    Filtering Items

    Use the toolbar to filter your inventory:

    ​
    Search

    Type in Buscar por nombre, SKU o marca to filter by:
    • Product name
    • SKU code
    • Category
    • Supplier name

    ​
    Category Filter

    Select from:
    • Todas (All)
    • Tintas (Inks)
    • Agujas (Needles)
    • EPP (Personal Protective Equipment)
    • Limpieza (Cleaning)
    • Aftercare
    • Consumibles (Consumables)

    ​
    State Filter

    • Activos - Active items only (default)
    • Archivados - Archived items
    • Todos - All items

    ​
    Expiration Filter

    • Todos - All items
    • Con caducidad - Items that expire
    • Sin caducidad - Items that don’t expire
    Filters combine together. For example, view only active needles with expiration dates.

    ​
    Item Actions

    Each item row has three action buttons:
    Opens detailed view of the item with full information and history.
    Records incoming stock - used when receiving new inventory or restocking.
    Makes a manual stock adjustment - used for corrections or physical counts.

    ​
    Pagination

    Browse large inventories with pagination controls:
    • ⟵ - Previous page
    • ⟶ - Next page
    • Página X/Y - Current page indicator
    Default page size is 20 items.

    ​
    Adding New Items

    1
    Step 1: Open New Item Form
    2
    Click Nuevo ítem in the toolbar.
    3
    Step 2: Fill Item Details
    4
    Required Information
    5
  • SKU - Unique product identifier
  • Nombre - Product name
  • Categoría - Select from dropdown
  • Unidad - Unit of measure (pz, ml, caja, etc.)
    • 6
    Stock Control
    7
  • Stock - Initial quantity
  • Mínimo - Low stock alert threshold
    • 8
    Optional Details
    9
  • Caduca - Check if item has expiration dates
  • Proveedor - Supplier name
  • Activo - Check to mark as active
    • 10
    Step 3: Save Item
    11
    Click Guardar to add the item to your inventory.

    ​
    Recording Stock Movements

    Track all changes to inventory with movements:

    ​
    Movement Types

    Entrada (Entry)

    Incoming stock from suppliers or returns

    Salida (Exit)

    Outgoing stock used in sessions or sold

    Ajuste (Adjustment)

    Manual corrections or physical count adjustments

    ​
    Recording Entries

    1
  • From Items list, click Entrada on the desired item
  • Enter quantity received
  • Add notes about the delivery or supplier
  • Click Guardar
    • 2
    The system:
    3
  • Adds quantity to current stock
  • Records positive movement (+50, +100, etc.)
  • Updates last modified timestamp
  • Logs your username as the operator

    • ​
    Recording Adjustments

    1
  • From Items list, click Ajuste on the desired item
  • Enter adjustment amount (positive to add, negative to subtract)
  • Add reason for adjustment
  • Click Guardar
    • 2
    Use adjustments for:
    3
  • Physical inventory counts
  • Corrections of data entry errors
  • Accounting for damaged/expired items
    • Adjustments bypass normal stock tracking. Always include clear notes explaining the reason.

    ​
    Viewing Movement History

    1
    Step 1: Access Movements
    2
    Navigate to Inventario → Movimientos.
    3
    Step 2: Filter History
    4
    Use toolbar filters:
    5
  • Tipo - Movement type (Todos, Entrada, Salida, Ajuste)
  • De / a - Date range (default: last month to today)
    • 6
    Step 3: Review Movements
    7
    The table shows:
    8
  • Fecha - Transaction date
  • Tipo - Entry, Exit, or Adjustment
  • SKU - Product code
  • Nombre - Product name
  • Cantidad - Quantity change (with +/- sign, center-aligned)
  • Usuario - Who performed the transaction
    • The movements page shows up to 30 recent transactions by default. Use filters to find specific records.

    ​
    Stock Alerts

    The system helps prevent stockouts:

    ​
    Low Stock Indicators

    Items are flagged when: 
    if stock < minimo:
    # Display in red

    ​
    Alert Locations

    • Items table - Red text for stock value
    • Dashboard - Low stock items widget (if enabled)
    • Reports - Inventory status summary
    Set realistic minimum thresholds based on:
    • Usage frequency
    • Lead time for reordering
    • Shelf life/expiration

    ​
    Database Structure

    Inventory items are stored in the products table: 
    CREATE TABLE products (
    id INTEGER PRIMARY KEY,
    sku TEXT UNIQUE,
    name TEXT,
    category TEXT,
    unidad TEXT,
    stock INTEGER,
    min_stock INTEGER,
    caduca BOOLEAN,
    proveedor TEXT,
    activo BOOLEAN,
    created_at DATETIME,
    updated_at DATETIME
);

    ​
    Best Practices

    Regular Counts

    Perform physical inventory counts monthly and record adjustments.

    Set Minimums

    Configure minimum stock levels for critical supplies to avoid shortages.

    Track Expirations

    Enable “Caduca” for items with expiration dates and rotate stock (FIFO).

    Organize Categories

    Use consistent category names for easier filtering and reporting.

    Document Adjustments

    Always include detailed notes when making manual adjustments.

    Review History

    Check movement history regularly to identify usage patterns.

    ​
    Troubleshooting

    Review the movement history to identify any unusual entries or adjustments. Perform a physical count and use an adjustment to correct.
    Verify you have the inventory.create permission. Check that the SKU doesn’t already exist in the database.
    Ensure minimum stock thresholds are properly set. Values of 0 won’t trigger alerts.
    Check that the product still exists and is marked as active. Archived items may not accept movements.

    Build docs developers (and LLMs) love

    Get started for freeTalk to us