ProductOptionValues
Returns option values for a product option, including label, display order, and value data details.
Table-Specific Information
Select
SELECT * FROM ProductOptionValues
Insert
To insert a product option value, specify at least the following columns: ProductId, OptionId, Label, SortOrder, along with one of the following: ValueDataImgUrl or ValueDataColors.
Inserting ProductOptionValues with ValueDataImgUrl:
INSERT INTO ProductOptionValues (OptionId, ProductId, Label, SortOrder, ValueDataImgUrl, ValueDataColors) VALUES ('143', '77', 'testingexceptionfornow', '2', 'https://cdn11.bigcommerce.com/s-dr2j9p39ga/product_images/attribute_value_images/357.preview.jpg?t=1696324267','#e35e22')
Inserting ProductOptionValues with ValueDataColors:
INSERT INTO ProductOptionValues (OptionId, ProductId, Label, SortOrder, ValueDataColors) VALUES ('143', '77', 'toasting123', '2', '#e35e20')
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Integer | True |
The Id of the option value. |
| OptionId [KEY] | Integer | False |
The Id of the option. |
| ProductId [KEY] | Integer | False |
The Id of the product. |
| Label | String | False |
The label of the option value shown on the storefront. |
| IsDefault | Boolean | False |
Indicates whether this option value is the default for this option. |
| SortOrder | Integer | False |
The order in which the option value is displayed on the product page. |
| ValueDataColors | String | False |
The colors contained in the option value data. |
| ValueDataImgUrl | String | False |
The image URL contained in the option value data. |