ProductAttributeOptions
ProductAttributeOptions is an auto generated table. The supported operations are Insert, Delete, and Querying data from this table.
Table Specific Information
Select
The add-in uses the AdobeCommerce API to filter the results by AttributeCode while the rest of the filter is executed client side within the add-in.
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 |