industry-department-solutions
latest
false
Supply Chain & Retail Solutions user guide
- 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 extra dataset for the Markdown & Promotions module, breaking down daily inventory levels by product variant.
The Stock extra dataset provides daily inventory levels broken down by product variant, for cases where a single product is stocked in multiple variants.
Purpose
The Markdown & Promotions module uses the Stock extra dataset to:
- Capture variant-level stock where a product has multiple variants
- Support availability analysis at a finer grain than the product-level Stock dataset
Required fields
| Field | Description | Type | Use | Notes |
|---|---|---|---|---|
product_id | Unique identifier for the product SKU. | string | Application / Presales | Required. Primary key. Foreign key to product. |
location_id | Unique identifier for the store or location. | string | Application / Presales | Required. Primary key. Foreign key to location. |
product_variant | Identifier for the specific product variant (for example, size or colour). | string | Application / Presales | Required. Primary key. |
stock_date_at | Date of the stock snapshot. | date | Application / Presales | Required. Primary key. |
created_at | Timestamp when the record was created. | timestamp | Application | Optional. |
stock_id | Source-system identifier for the stock record. | string | Application / Presales | Optional. |
stock_units | Number of units in stock on the given date. | integer | Application / Presales | Required. |
updated_at | Timestamp when the record was last updated. | timestamp | Application | Optional. |
Usage notes
- Provide this dataset only where variant-level detail is required.
- Product and location identifiers must align with the Products and Locations datasets.
- Values should reconcile with the product-level Stock dataset.
Why this dataset matters
Variant-level stock lets the solution assess availability for sized or variant-based ranges that a single product-level record cannot represent.