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

Table Specific Information

Select

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

The Sku column or Sku and OptionId columns must be specified in the WHERE clause to retrieve results from ProductCustomOption. Sku and OptionId can be used only with the equals (=) operator. For example:

SELECT * FROM [ProductCustomOption] WHERE Sku = '334' AND OptionId = '123'

Insert

To create a new product custom option, the IsRequire, ProductSku, SortOrder, Title and Type columns are required.

INSERT INTO ProductCustomOption (IsRequire, ProductSku, SortOrder, Title, Type) VALUES (false, '01', 1, 'Title', 'Type')

Delete

Product custom options can be deleted by providing the Sku and OptionId columns.

DELETE FROM ProductCustomOption WHERE Sku = 'sjl-1999' AND OptionId = '1'

Columns