ProductOptionValues
Returns data from Products table.
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 | References | Description |
| Id [KEY] | Integer | True |
The ID of the option value. | |
| OptionId [KEY] | Integer | True |
The ID of the option. | |
| ProductId [KEY] | Integer | True |
Products.Id |
The ID of the product. |
| Label | String | False |
The label of the option value shown on the storefront. | |
| IsDefault | Boolean | False |
Whether this option value is the default for this option. | |
| SortOrder | Integer | False |
The order in which the option value will be displayed on the product page. | |
| ValueDataColors | String | False |
The colors contained in the value data. | |
| ValueDataImgUrl | String | False |
The image url contained in the value data. |