Stock Report
The Stock Report lists product availability, stock levels, planogram assignments, foreign-product flags, case sizes, and prices across outlets. Use it to review stock and product placement.
Example
Sample Stock Report Entry:
Client: Premium Retail Chain (ID: CLI-2025-001)
Outlet: NETTO 2.0 - ODENSE SØ (Code: 10066820)
Asset: 807317
Product: Green Fresh (SKU: 8711327511248)
Stock: 24 units
Facings in Planogram: 3
In Planogram: Yes
Foreign Unit: No
Case Size: 12 units
Unit Price: $2.50
Date: 2025-07-02
Note
- Absolute stock counts provide precise inventory visibility.
- Planogram compliance ensures proper product placement and presentation.
Sample Excel Report
A sample Stock report Excel template is provided here: Download Stock_Report.xlsx
Note
This template includes enhanced inventory fields and sample entries for reference.
Delivery and Configuration
- Format: Excel spreadsheet with detailed inventory data
- Delivery Method: Automated email distribution
- File Naming: Stock Report.xlsx
- Frequency: Weekly or monthly (configurable)
Key Elements
| Element | Description |
|---|---|
| Client ID | Unique client organization identifier |
| Client Name | Company or organization name |
| Outlet Code | Unique outlet identifier |
| Outlet Name | Store or location name |
| Asset Number | Equipment or display unit identifier |
| Date | Report generation timestamp |
| Product Name | Full product description |
| SKU | Stock Keeping Unit identifier |
| Short EAN Code | Abbreviated barcode reference |
| Stock | Absolute unit count available |
| Facings in Planogram | Expected product facings |
| In Planogram | Planogram compliance indicator |
| Is Foreign Unit | Unauthorized product flag |
| Case Size | Units per shipping case |
| Unit Price | Individual product price |
| Product Images | Visual references for verification |
Target Users
- Inventory Managers - Monitor stock levels and compliance
- Store Owners - Track product availability and pricing
- Supply Chain Teams - Coordinate replenishment and planning
Benefits
- Precise Inventory: Absolute counts for accurate planning
- Compliance Monitoring: Ensure planogram adherence
- Pricing Visibility: Track unit costs and profitability
- Foreign Detection: Identify unauthorized products
- Visual Verification: Image support for remote monitoring