Skip to main content

​
Overview

Pro Stock Tool’s inventory reporting system provides detailed insights into your stock levels, product distribution across warehouses, and inventory performance metrics. Generate customizable reports to make data-driven decisions about your inventory management.
Inventory reports can be filtered by date range, warehouse, category, and product parameters to focus on specific aspects of your inventory.

​
Report Types

Stock Level Reports

Monitor current inventory levels, identify low-stock items, and track products approaching reorder points.

Warehouse Distribution

View how inventory is distributed across different warehouses and storage locations.

Category Analysis

Analyze inventory composition by categories and subcategories to understand product mix.

Value Reports

Calculate total inventory value and track investment across different product segments.

​
Generating Inventory Reports

​
Basic Report Generation

To generate a standard inventory report:
  1. Navigate to Reportes > Informes de Productos in the sidebar
  2. Select the report type from the dropdown menu
  3. Choose your date range using the date picker
  4. Apply filters (optional):
    • Warehouse: Filter by specific storage location
    • Category: Focus on particular product categories
    • Parameter: Filter by product parameters (status, type, etc.)
  5. Click Generar Reporte to create the report
Save frequently used filter combinations as templates to speed up recurring report generation.

​
Advanced Filtering

Refine your inventory reports with advanced filtering options:
Choose from predefined ranges or set custom dates:
  • Hoy (Today): Current day snapshot
  • Esta Semana (This Week): Last 7 days
  • Este Mes (This Month): Current month
  • Último Trimestre (Last Quarter): Previous 90 days
  • Personalizado (Custom): Specify exact start and end dates
Select one or multiple warehouses to compare inventory across locations:
{
  "warehouses": ["Bodega Principal", "Bodega Secundaria"],
  "includeEmpty": false,
  "sortBy": "stock_level"
}
Enable “Show Empty Warehouses” to include locations with zero stock.
Filter by hierarchical category structure:
  • Select parent category to include all subcategories
  • Choose specific subcategories for granular analysis
  • Apply color-coded parameter filters for additional segmentation
Focus on specific stock conditions:
  • Stock Bajo (Low Stock): Items below minimum threshold
  • Stock Normal (Normal Stock): Items within optimal range
  • Sobre Stock (Overstock): Items exceeding maximum threshold
  • Sin Stock (Out of Stock): Items with zero quantity

​
Stock Level Analysis

​
Current Stock Report

The current stock report provides a real-time snapshot of your inventory:
​
Product Information
  • Product code and name
  • Category and subcategory classification
  • Assigned parameter (color-coded)
  • Supplier information
​
Stock Metrics
  • Current quantity in stock
  • Minimum stock level (reorder point)
  • Maximum stock level (capacity)
  • Stock status indicator (low/normal/high)
​
Location Details
  • Primary warehouse assignment
  • Distribution across multiple warehouses
  • Available vs. reserved quantities

​
Low Stock Alert Report

Identify products requiring immediate attention:
1

Access Low Stock Report

Navigate to Reportes > Informes de Productos > Stock Bajo
2

Review Critical Items

The report displays products where current stock is below the minimum threshold, sorted by urgency:
  • Critical (0-25% of minimum): Immediate reorder required
  • Low (26-50% of minimum): Reorder soon
  • Warning (51-75% of minimum): Monitor closely
3

Take Action

For each low-stock item:
  • Contact supplier directly from the report
  • Create purchase order
  • Adjust minimum stock levels if needed
  • Transfer stock from other warehouses
Products marked as Critical require immediate attention to avoid stockouts and potential business disruption.

​
Warehouse Distribution Reports

​
Multi-Warehouse Inventory View

Analyze how inventory is distributed across your warehouse network: 
-- Example query structure (reference only)
SELECT 
  p.nombre AS producto,
  b.nombre AS bodega,
  COUNT(p.id) AS cantidad,
  p.stock_minimo,
  p.stock_maximo
FROM productos p
LEFT JOIN bodegas b ON p.bodega_id = b.id
GROUP BY p.id, b.id
ORDER BY b.nombre, p.nombre
Report Includes:
  • Product count per warehouse
  • Stock distribution percentages
  • Warehouse capacity utilization
  • Transfer recommendations for balanced distribution

​
Warehouse Performance Metrics

Capacity Usage

75% average capacity utilization across all warehouses

Stock Balance

Good distribution with minimal concentration risk

Empty Locations

12 storage locations currently available

​
Category Analysis Reports

​
Inventory Composition

Understand your product mix through category-based analysis:
View top-level category breakdown:
CategoryProductsTotal Units% of Inventory
Electrónicos1453,24042%
Alimentación982,15028%
Textiles761,89024%
Otros344806%

​
Export and Sharing

​
Export Formats

Inventory reports can be exported in multiple formats: 
# Generate PDF report with charts and formatting
POST /api/reportes/inventario/export
{
  "format": "pdf",
  "includeCharts": true,
  "filters": {...}
}

​
Scheduled Reports

Automate report generation and distribution:
  1. Click Programar Reporte in the report interface
  2. Set the schedule:
    • Frequency: Daily, Weekly, Monthly, Quarterly
    • Time: Specific time for report generation
    • Recipients: Email addresses for automatic delivery
  3. Configure report parameters and filters
  4. Save the scheduled report
Schedule weekly low-stock reports to be sent every Monday morning to ensure proactive inventory management.

​
Best Practices

Establish a consistent reporting rhythm:
  • Daily: Stock level checks for fast-moving items
  • Weekly: Low stock alerts and reorder planning
  • Monthly: Comprehensive inventory analysis and trends
  • Quarterly: Strategic inventory composition review
Regularly review and adjust stock thresholds:
  • Monitor products that frequently trigger low-stock alerts
  • Adjust minimum levels based on lead times and demand patterns
  • Set maximum levels to optimize warehouse space utilization
  • Use seasonal data to modify thresholds throughout the year
Optimize inventory across locations:
  • Balance stock to minimize concentration risk
  • Position inventory closer to demand centers
  • Use distribution reports to identify transfer opportunities
  • Maintain safety stock at critical locations
Track category performance and trends:
  • Identify growing vs. declining categories
  • Rebalance inventory mix based on demand
  • Consolidate slow-moving subcategories
  • Allocate warehouse space proportionally to category importance

Movement Tracking

Track product entries, exits, and transfers across warehouses

Product Rotation

Monitor product rotation and expiration tracking

Warehouse Management

Learn about warehouse setup and configuration

Category Management

Understand category and subcategory organization

Build docs developers (and LLMs) love

Get started for freeTalk to us