ProductBundleComponents
Lists components that make up product bundles, including associated product and quantity details.
View-Specific Information
Select
The connector uses the Shopify API to process WHERE clause conditions built with the following column and operators. The connector processes other filters client-side within the connector.
- ProductId supports the '=, IN' comparison operators.
For example, the following query is processed server-side:
SELECT * FROM ProductBundleComponents WHERE ProductId = 'Val1'
Columns
| Name | Type | References | Description |
| ProductId [KEY] | String | The globally unique identifier of the parent product that includes this component as part of its bundle configuration. | |
| ComponentProductId [KEY] | String | The globally unique identifier of the product that acts as a component within the bundle. | |
| ComponentVariantsCount | Int | The number of product variants available for the component within this bundle. | |
| ComponentVariantsCountPrecision | String | Indicates the precision or accuracy level of the component variant count, such as 'exact' or 'estimated'. | |
| OptionSelections | String | Defines the mapping between parent product options and component product options, including selected values that determine the bundle composition. | |
| Quantity | Int | The set quantity of the component product included in this bundle line. Returns null if a quantity option is defined instead. | |
| QuantityOptionName | String | The name of the product option that allows merchants or customers to choose the component quantity dynamically. | |
| QuantityOptionValues | String | A comma-separated list of available quantity values for the defined quantity option. | |
| QuantityOptionParentOptionId | String | The globally unique identifier of the parent option that governs quantity selection for this component. |