SKU calendar dataset

SKU calendar dataset containing active date ranges for products at locations, including discontinuation end dates, used by Inventory Management.

The SKU calendar dataset contains the active date ranges for products at locations, including discontinuation end dates. It defines when a product is available for sale at a given location.

Purpose

The inventory management solution uses the SKU calendar dataset to understand when products are active at each location. This allows the solution to exclude periods when a product was not yet active or has been discontinued, improving the accuracy of demand analysis and recommendations.

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.	string	Primary key
location_id	Unique identifier for the location.	string	Primary key
start_date	Date the product becomes active at the location.	date	Nullable
end_date	Date the product is discontinued at the location. Required for discontinued products.	date	Nullable

Usage notes

• This dataset is optional and helps refine analysis by identifying active and discontinued periods.
• Provide end_date for discontinued products so they can be excluded from forward-looking recommendations.
• Product and location identifiers must align with the corresponding Products and Locations datasets.
• Active date ranges should reflect actual product availability at each location.