Cmdlets for BigCommerce

Build 20.0.7654


Returns data from Products table.

Table Specific Information


To insert a new ProductOption, a set of OptionValues are required to be inserted along with it. This can be done by populating a temporary ProductOptionValues table with the desired values for the option you are creating, and later using this table as a value for the LinkedOptionValues Pseudo-Columns during insertion:

INSERT INTO ProductOptionValues#TEMP (Label,SortOrder,IsDefault) VALUES ('Classic',0,true);
INSERT INTO ProductOptionValues#TEMP (Label,SortOrder,IsDefault) VALUES ('Elegance',1,false);
INSERT INTO ProductOptionValues#TEMP (Label,SortOrder,IsDefault) VALUES ('Avantgarde',2,false);
INSERT INTO ProductOptions (ProductId, DisplayName,Type,Name,SortOrder,LinkedOptionValues) VALUES (955,'ModelSeries','dropdown','Series',0,ProductOptionValues#TEMP);


Name Type ReadOnly Description
Id [KEY] Integer True

The ID of the option.

ProductId [KEY] Integer True

The ID of the product.

DisplayName String False

The name of the option shown on the storefront.

Name String False

The unique option name, auto-generated from the display name, a timestamp, and the product ID.

Type String False

The type of option, which determines how it will display on the storefront. Acceptable values: radio_buttons, rectangles, dropdown, product_list, product_list_with_images, swatch.

SortOrder Integer False

The order in which the option will be displayed on the product page.



Name Type Description
LinkedOptionValues String

Column for the aggregate table name holding option values.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654