Inventario

Search and inspect current perishable stock by barcode, with lot-level expiry alerts and recommended actions.

The Inventario module lets you look up any perishable product by its barcode and see every lot currently in stock, ordered from the soonest to the latest expiry date. It is the primary tool for floor associates and supervisors who need to verify stock status or investigate an alert from the Dashboard.

Barcode search

Find all active lots for a product using its UPC barcode.

Lot-level detail

Each lot shows quantity, expiry date, days remaining, and automated alerts.

Stock summary

Total units across all lots are summed at the top of the results.

Deep-link from Dashboard

Alerts on the Dashboard link directly to the per-product detail view.

Searching for a product

1. Enter the barcode

   Type or scan the product’s UPC barcode into the Código de barras field.

2. Press Buscar

   Click the Buscar button to retrieve all lots registered for that barcode.

3. Review results

   The product name and total stock count appear at the top of the results. Each lot is shown as a separate card sorted by expiry date (soonest first).

If the barcode is not registered in the system, the search returns the message “UPC no registrado en inventario”. This can happen if the product has not yet been received or if the barcode was entered incorrectly.

What each inventory record shows

Every lot card displays the following fields:

Field	Description
codigoBarras	Universal Product Code (UPC) used to identify the product
descripcion	Human-readable product name
cantidad	Number of units in this lot
fechaCaducidad	Expiry date in YYYY-MM-DD format
diasRestantes	Days until expiry, calculated at the time of the search
lote	Lot identifier assigned at reception
fechaLlegada	Date the lot was received into inventory
division	High-level inventory division (see below)
departamento	Department within the division (see below)

Division and Departamento values

Products are organized into a two-level taxonomy.

Division — the top-level category:

Value	Description
PERECEDEROS	Perishable products subject to expiry tracking
NO_PERECEDEROS	Non-perishable products

Departamento — the department within a division:

Value	Examples
FRUTAS	Fresh fruits
VERDURAS	Vegetables
LACTEOS	Dairy and refrigerated products
CARNES	Meat and poultry
EMBUTIDOS	Processed meats and cold cuts
FARMACIA	Over-the-counter medications
MULTIPLE	Mixed or unspecified department (used for full-truck CEDIS receptions)

Division and Departamento are assigned automatically during reception (either from the supplier order or from the CEDIS truck manifest) and cannot be changed through the Inventario screen.

Expiry alert levels

Each lot generates one or more alerts based on the days remaining until expiry.

Alert	Severity	Condition	Recommended action
Product expired	error	diasRestantes < 0	Remove from shelf immediately
Expiring within 7 days	warning	0 ≤ diasRestantes ≤ 7	Rotate to front of shelf, apply markdown if policy allows
Product in good standing	success	diasRestantes > 7	No action required
Low stock	info	cantidad < 10	Consider reordering
Surte inmediatamente	warning	Non-pharmacy product with 4 ≤ diasRestantes ≤ 10	Stock to floor immediately to maximize sell-through

The “Surte inmediatamente” alert does not apply to pharmacy products (those containing “paracetamol” or “farmacia” in the description). Pharmacy items follow a separate pull policy managed through the Dashboard and are not subject to immediate stocking recommendations.

Viewing the per-product detail page

The detail page at /inventario/{codigoBarras} is accessible from any Ver detalle link on the Dashboard. It works identically to the barcode search but is pre-loaded for a specific product and shows only the lots that have active alerts.

On the detail page:

• Lots are deduplicated by fechaCaducidad + cantidad.
• Lots are sorted from soonest to latest expiry date.
• The same alert rules apply as in the inline search view.

Filtering by division or department (API)

The underlying API supports filtering inventory by division or department. These filters are available for integrations and reporting tools:

GET /api/inventario/division?division=PERECEDEROS
GET /api/inventario/departamento?departamento=CARNES
GET /api/inventario/buscar?codigoBarras=<UPC>
GET /api/inventario/alertas

The /api/inventario/alertas endpoint returns pre-computed alert objects with diasRestantes and an alerta text field already populated. This is the same data source used by both the Dashboard and the detail view.