Excel Add-In for BigCommerce

Build 23.0.8839


Returns data from Products table.

Table Specific Information


SELECT * FROM ProductOptionValues 


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')


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


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.8839