ProductAttributeOptions
ProductAttributeOptions is an auto generated table. The supported operations are Insert, Delete, and Querying data from this table.
Table Specific Information
Select
The provider uses the AdobeCommerce API to filter the results by AttributeCode while the rest of the filter is executed client side within the provider.
The AttributeCode column must be specified in the WHERE clause to retrieve results from ProductAttributeOptions. AttributeCode can be used only with the equals (=) operator.
For example:
SELECT * FROM [ProductAttributeOptions] WHERE AttributeCode = '123'
INSERT
To create a new ProductAttributeOption, AttributeCode, and Label are required.
INSERT INTO ProductAttributeOptions(AttributeCode, Label) VALUES(83,'asdw')
Columns
Name | Type | ReadOnly | Description |
IsDefault | Bool | False |
Default |
AttributeCode | String | False |
attributeCode |
Label [KEY] | String | False |
Option label |
SortOrder | Int | False |
Option order |
StoreLabels | String | False |
Option label for store scopes |
Value | String | False |
Option value |