- 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
Product categories dataset
Product categories dataset for the Markdown & Promotions module, defining the hierarchical category structure used to group products for analysis.
The Product categories dataset defines the hierarchical classification used to group products in the Markdown & Promotions module. It supports category-level analysis and reporting across the product range.
This dataset acts as a reference dataset and is joined to the Products dataset using the product_category_id.
Purpose
The Markdown & Promotions module uses the Product categories dataset to:
- Group products into categories for aggregated analysis
- Represent parent-child relationships between categories
- Support reporting across product hierarchies
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_category_id | Unique identifier for the product category. | string | Primary key |
created_at | Timestamp when the record was created. | timestamp | Nullable |
metadata | Additional attributes or metadata, in JSON format. | string | Nullable |
name | Display name of the category. | string | Nullable |
parent_product_category_id | Reference to the parent category, for hierarchical structures. | string | Nullable |
updated_at | Timestamp when the record was last updated. | timestamp | Nullable |
Usage notes
- Every category referenced by the Products dataset must exist in this dataset.
- The
parent_product_category_idshould reference an existing category to form a valid hierarchy.
Why this dataset matters
Consistent category definitions let the solution analyse markdown and promotion performance at the group level, not only for individual products.