ProductBundleComponents
Lists component products that make up a bundle and their constraints.
View-Specific Information
Select
The driver uses the Shopify API to process WHERE clause conditions built with the following column and operators. The driver processes other filters client-side within the driver.
- 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 | A globally unique Id of the product. | |
| ComponentProductId [KEY] | String | A globally unique Id of the component product. | |
| ComponentVariantsCount | Int | The total number of component variants in the bundle. | |
| ComponentVariantsCountPrecision | String | The precision of the component variant count, indicating the exactness of the value. | |
| OptionSelections | String | The parent and component options they are connected to, along with the chosen option values that appear in the bundle. | |
| Quantity | Int | The quantity of the component product set for this bundle line. Contains null if a quantity option is present. | |
| QuantityOptionName | String | The name of the quantity option. | |
| QuantityOptionValues | String | The values of the quantity option. | |
| QuantityOptionParentOptionId | String | A globally unique Id of the parent option for the quantity setting. |