- 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 parent child mapping dataset defining parent-child relationships between products, used by the Rebuy & Replenishment capability of the Merchandising solution for substitution and hierarchy modelling.
The products parent child mapping dataset defines parent-child relationships between products. It is used by the Rebuy & Replenishment capability of the Merchandising solution to model product hierarchies and substitutions, such as grouping product variants under a common parent.
Purpose
The Rebuy & Replenishment capability uses parent-child relationships to aggregate demand and inventory across related products and to model substitution behaviour. This supports more accurate planning where products share a hierarchy, such as size or colour variants of a parent style.
Required fields
| Field | Description | Type | Use | Notes |
|---|---|---|---|---|
parent_id | Unique identifier of the parent product in the hierarchy. | string | Application | Must reference a product in the Products dataset. |
child_id | Unique identifier of the child product mapped to the parent. | string | Application | Must reference a product in the Products dataset. Each child maps to one parent. |
child_label | Human-readable label describing the child product's role or variant. | string | Application | N/A |
child_rank | Ordering rank of the child within the parent's hierarchy. | integer | Application | Lower ranks are typically presented first. |
Usage notes
- Every
parent_idandchild_idmust align with identifiers in the Products dataset. - Each child product should map to a single parent.
child_rankorders sibling children under the same parent.