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