ProductVariants

Returns data from Products table.

Table Specific Information

Select

SELECT * FROM ProductVariants

Insert

To insert a product variant, a set of option values must also be inserted. 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-column 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');

Update

UPDATE ProductVariants SET Weight = '23' WHERE Id = 64

Delete

DELETE FROM ProductVariants WHERE Id = 3

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The ID of the product variant.
ProductId [KEY]	Integer	True	Products.Id	The ID of the product.
SKU	String	False		User defined product code/stock keeping unit (SKU).
SkuID	String	False		The ID for User defined product code/stock keeping unit (SKU).
Price	Decimal	False		The price of the product variant. The price should include or exclude tax, based on the store settings.
CalculatedPrice	Decimal	False		The variant’s calculated price on the storefront.
SalePrice	Decimal	False		The variant’s sale price on the storefront.
RetailPrice	Decimal	False		The variant’s retail price on the storefront.
MapPrice	Integer	False		The Minimum Advertised Price.
Weight	Decimal	False		This variant’s base weight on the storefront. If this value is null, the product’s default weight (set in the Product resource’s weight field) will be used as the base weight.
CalculatedWeight	Decimal	False		The variant’s calculated weight on the storefront.
Width	Decimal	False		Width of the variant, which can be used when calculating shipping costs.
Height	Decimal	False		The Height of the variant, which can be used when calculating shipping costs.
Depth	Decimal	False		The Depth of the variant, which can be used when calculating shipping costs.
IsFreeShipping	Boolean	False		The Flag used to indicate whether the variant has free shipping. If true, the shipping cost for the variant will be zero.
FixedCostShippingPrice	Decimal	False		The fixed shipping cost for the variant. If defined, this value will be used during checkout instead of normal shipping-cost calculation.
PurchasingDisabled	Boolean	False		Accepts AvaTax System Tax Codes, which identify products and services that fall into special sales-tax categories.
PurchasingDisabledMessage	String	False		Accepts AvaTax System Tax Codes, which identify products and services that fall into special sales-tax categories.
ImageUrl	String	False		The Image url for the variant.
CostPrice	Decimal	False		The cost price of the variant.
Upc	String	False		The UPC code used in feeds for shopping comparison sites and external channel integrations.
Mpn	String	False		The Manufacturer Part Number (MPN) for the variant.
Gtin	String	False		The Global Trade Item Number.
InventoryLevel	Integer	False		The Inventory level for the variant, which is used when the product’s inventory_tracking is set to variant.
InventoryWarningLevel	Integer	False		The Inventory warning level for the product
BinPickingNumber	String	False		Identifies where in a warehouse the variant is located.
LinkedOptionValues	String	False		The Option Value Id.