Power BI Connector for BigCommerce

Build 21.0.7930

ProductVariants

Returns data from Products table.

Table Specific Information

Insert

To create a new ProductVariant, a set of OptionValues are required to be inserted along with it. This can be done by populating a temporary ProductVariantValues 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 ProductVariantValues#TEMP (Id,OptionId,Label,DisplayName) VALUES (181,118, 'Elegance', 'Series');
INSERT INTO ProductVariants (ProductId, LinkedOptionValues,SKU) VALUES (955, ProductVariantValues#TEMP, 'DSFMGG');

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

The ID of the product variant.

ProductId [KEY] Integer True

The ID of the product.

SKU String False

User defined product code/stock keeping unit (SKU).

Name String False

The product variant name.

Type String False

The product type. One of: physical - a physical stock unit, digital - a digital download.

InventoryLevel Integer False

Available Inventory.

Weight Double False

Weight of this product variant, which can be used when calculating shipping costs.

Price Decimal False

The price of the product variant. The price should include or exclude tax, based on the store settings.

CostPrice Decimal False

The cost price of the product variant. Stored for reference only; it is not used or displayed anywhere on the store.

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