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.