Stock dataset

Stock dataset for the Markdown & Promotions module, containing daily inventory levels per product and location.

The Stock dataset contains daily inventory levels for each product at each location. It provides the availability context used to ensure markdown and promotion actions are operationally feasible.

Purpose

The Markdown & Promotions module uses the Stock dataset to:

• Provide current and historical inventory levels by product and location
• Assess availability and exposure for ageing or excess stock
• Support clearance and markdown decisions

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
location_id	Unique identifier for the store or location.	string	Primary key Foreign key to location
product_id	Unique identifier for the product SKU.	string	Primary key Foreign key to product
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

• A daily 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).
• Product and location identifiers must align with the Products and Locations datasets.

Why this dataset matters

Stock levels determine which products carry clearance or markdown risk. Without accurate stock data, recommendations may target the wrong products.