Products parent child mapping dataset

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

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
parent_id	Unique identifier of the parent product in the hierarchy. Must reference a product in the Products dataset.	string	Non-null
child_id	Unique identifier of the child product mapped to the parent. Must reference a product in the Products dataset. Each child maps to one parent.	string	Primary key
child_label	Human-readable label describing the child product's role or variant.	string	Non-null
child_rank	Ordering rank of the child within the parent's hierarchy. Lower ranks are typically presented first.	integer	Non-null

Usage notes

• Every parent_id and child_id must align with identifiers in the Products dataset.
• Each child product should map to a single parent.
• child_rank orders sibling children under the same parent.