industry-department-solutions
latest
false
- Overview
- Platform setup and administration
- Platform setup and administration
- Platform architecture
- Data Bridge onboarding overview
- Connecting a Peak-managed data lake
- Connecting a customer-managed data lake
- Creating an AWS IAM role for Data Bridge
- Connecting a Snowflake data warehouse
- Connecting a Redshift data warehouse (public connectivity)
- Connecting a Redshift data warehouse (private connectivity)
- Reauthorizing a Snowflake OAuth connection
- Using Snowflake with Peak
- SQL Explorer overview
- Roles and permissions
- User management
- Inventory management solution
- Commercial pricing solution
- Merchandising solution
Supply Chain & Retail Solutions user guide
Last updated Apr 16, 2026
Stock dataset
The stock dataset contains aggregated historical inventory levels for each product at each location. It represents how inventory has been held over time and is used by the inventory management solution to understand stock behavior and exposure.
This dataset should provide a daily view of inventory levels, where possible, to support accurate historical analysis.
Purpose
The inventory management solution uses stock data to analyze historical inventory performance and assess the impact of inventory decisions over time.
By comparing historical stock levels with recommended inventory parameters, the solution can help estimate:
- Capital tied up in overstocked inventory
- Risk and impact of understocked goods
- Opportunities to improve inventory efficiency and availability
During presales, the stock dataset is also used to evaluate potential value and improvement opportunities.
Required fields
| Field | Description | Type | Use | Notes |
|---|---|---|---|---|
product_id | Unique identifier for the product SKU. | string | Application / Presales | N/A |
location_id | Unique identifier for the store or distribution centre. | string | Application / Presales | Can be NULL or blank if only one location is considered. |
day_date | Date corresponding to the reported inventory level. | datetime | Application / Presales | N/A |
available_stock | Number of units of inventory available for the given product, location, and date. | float | Application / Presales | N/A |
Usage notes
- A daily historical record of stock levels is recommended to support accurate analysis.
- Stock quantities should use the same unit of measure as related datasets (for example, Customer orders and Products).
- Product and location identifiers must align with the corresponding Products and Locations datasets.
- If historical data is incomplete, analysis and recommendations may be less accurate.