Bundle Mapping

Table name (referenced in Insights SQL queries): marts_mdc__bundle_mapping

Mapping of bundle SKUs to their component physical products in ShipMonk. Each row represents one physical product within a bundle. Join this mart to marts_mdc__order_item on bundle_id to resolve which physical products are contained in a bundle order item.

Columns

Column	Type	Description
bundle_id	number	Identifier of the bundle this item belongs to, or null if the item is not a bundle.
account_id	number	Identifier for the account that placed the order.
bundle_name	varchar	Display name of the bundle this item belongs to, as configured in ShipMonk. Null for non-bundle items.
bundle_virtual_sku	varchar	Virtual SKU assigned to the bundle in ShipMonk. Null for non-bundle items.
bundle_item_quantity	number	Number of units of this product included per bundle unit. For example, if a bundle contains 2 units of this product, this value is 2. Null for non-bundle items.
product_sku	varchar	The ShipMonk SKU of the individual physical product mapped to this order line. For bundle orders, each component product appears as a separate row with its own product SKU.
product_name	varchar	Name of the physical product as defined in ShipMonk's product catalog.