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
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
| Field | Description | Type | Use | Notes |
|---|---|---|---|---|
product_id | Unique identifier for the product. | string | Application | N/A |
location_id | Unique identifier for the location. | string | Application | N/A |
start_date | Date the product becomes active at the location. | date | Application | Optional. |
end_date | Date the product is discontinued at the location. | date | Application | Optional. Required for discontinued products. |
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.