ADO.NET Provider for BigCommerce

Build 23.0.8770

ProductOptionValues

Returns data from Products table.

Table Specific Information

Select


SELECT * FROM ProductOptionValues 

Insert

To insert a new ProductOptionValues, you need to specify at least the following columns: ProductId, OptionId, Label, SortOrder, and any one among ValueDataImgUrl and 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

ProductOptions.Id

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8770