- 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
Products dataset for the Markdown & Promotions module, containing the product reference metadata joined to sales, stock, pricing, and tax datasets.
The Products dataset contains metadata for the products managed by the Markdown & Promotions module. It defines the items included in analysis and provides the descriptive and categorical information used across markdown and promotion decisions.
This dataset acts as a reference dataset and is joined to other datasets, such as Sales, Stock, and Product pricing daily, using the product_id.
Purpose
The Markdown & Promotions module uses the Products dataset to:
- Identify the products included in markdown and promotion analysis
- Enable analysis at both individual product and category levels
- Ensure consistent product identifiers across all related datasets
Required fields
| Field | Description | Type | Use | Notes |
|---|---|---|---|---|
product_id | Unique identifier for the product SKU. | string | Application / Presales | Required. Primary key. |
created_at | Timestamp when the record was created. | timestamp | Application | Optional. |
description | Description of the product. | string | Application / Presales | Optional. |
lowest_product_category_id | Reference to the most specific (leaf) category the product belongs to. | string | Application / Presales | Required. Foreign key to product_category. |
name | Name of the product. | string | Application / Presales | Required. |
updated_at | Timestamp when the record was last updated. | timestamp | Application | Optional. |
Usage notes
- Every product referenced in other datasets (for example, Sales, Stock, or Product pricing daily) must exist in the Products dataset.
- The
product_idmust be consistent across all datasets. - Category information supports higher-level analysis and reporting.
Why this dataset matters
The Products dataset defines the scope of the Markdown & Promotions module. Without a consistent product reference, the solution cannot reliably join sales, stock, and pricing data or generate meaningful recommendations.