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
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
| Field | Description | Type | Use | Notes |
|---|---|---|---|---|
product_category_id | Unique identifier for the product category. | string | Application / Presales | Required. Primary key. |
created_at | Timestamp when the record was created. | timestamp | Application | Optional. |
metadata | Additional attributes or metadata, in JSON format. | string | Application / Presales | Optional. |
name | Display name of the category. | string | Application / Presales | Optional. |
parent_product_category_id | Reference to the parent category, for hierarchical structures. | string | Application / Presales | Optional. |
updated_at | Timestamp when the record was last updated. | timestamp | Application | Optional. |
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.