- 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
SKU calendar dataset
SKU calendar dataset containing active date ranges for products at locations, including discontinuation end dates, used by Rebuy & Replenishment.
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 Rebuy & Replenishment capability 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_datefor 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.