Stock extra dataset

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

About the Constraint column: every field listed must be provided in your data. Non-null means its value cannot be null; Nullable means the value may be sent as null (or left blank in your source). Primary key, Unique, and Foreign key describe the field's role in the data model; a Primary key is always non-null.

Field	Description	Type	Constraint
product_id	Unique identifier for the product SKU.	string	Primary key Foreign key to product
location_id	Unique identifier for the store or location.	string	Primary key Foreign key to location
product_variant	Identifier for the specific product variant (for example, size or colour).	string	Primary key
stock_date_at	Date of the stock snapshot.	date	Primary key
created_at	Timestamp when the record was created.	timestamp	Nullable
stock_id	Source-system identifier for the stock record.	string	Nullable
stock_units	Number of units in stock on the given date.	integer	Non-null
updated_at	Timestamp when the record was last updated.	timestamp	Nullable

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.