ProductVariants

Returns data from Products table.

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

Pseudo column fields are used to enable the user to INSERT Fields that are non-readable but required during creation of new records.

Name

Type

Description

LinkedOptionValues

String

Column for the aggregate table name holding option values.

Last updated