Power BI Connector for BigCommerce

Build 21.0.7930

ProductOptions

Returns data from Products table.

Table Specific Information

Insert

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

Columns

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.

Pseudo-Columns

疑似カラムフィールドを使用して、ユーザーは新しいレコードの作成時に必要な読み取り不可のフィールドを挿入できます。

Name Type Description
LinkedOptionValues String

Column for the aggregate table name holding option values.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930