BundleProductOption
BundleProductOption is an auto generated table. The supported operations are Delete, and Querying data from this table.
Table Specific Information
Select
The cmdlet uses the AdobeCommerce API to filter the results by Sku or OptionId while the rest of the filter is executed client side within the cmdlet.
You must specify the Sku column or the Sku and OptionId columns in the WHERE clause to retrieve results from BundleProductOption. Sku and OptionId can be used only with the equals (=) operator.
For example:
SELECT * FROM [BundleProductOption] WHERE Sku = '123'
SELECT * FROM [BundleProductOption] WHERE Sku = '123' AND OptionId = '1'
Delete
You can delete Bundle options by providing the Sku and OptionId columns.
DELETE FROM BundleProductOption WHERE Sku = 'sjl-1999' AND OptionId = '1'
Columns
Name | Type | ReadOnly | Description |
ExtensionAttributes | String | False |
This is an auto-generated column |
OptionId [KEY] | Int | False |
Option id |
Position | Int | False |
Option position |
ProductLinks | String | False |
Product links |
Required | Bool | False |
Is required option |
Sku [KEY] | String | False |
Product sku |
Title | String | False |
Option title |
Type | String | False |
Input type |