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_id should 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.