- 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
Stock dataset containing aggregated historical inventory levels per product-location, used by Rebuy & Replenishment to understand stock behavior and exposure over time.
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 Rebuy & Replenishment capability 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 Rebuy & Replenishment capability 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 |
opening_stock | Number of units of inventory on hand at the start of the given date, for the specified product and location. | integer | Application / Presales | N/A |
closing_stock | Number of units of inventory on hand at the end of the given date, for the specified product and location. | integer | 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, Sales 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.