JDBC Driver for Adobe Commerce

Build 24.0.9060

BundleProductOption

BundleProductOption is an auto generated table. The supported operations are Delete, and Querying data from this table.

Table Specific Information

Select

The driver uses the AdobeCommerce API to filter the results by Sku or OptionId while the rest of the filter is executed client side within the driver.

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060