ProductVariants
Returns data from Products table.
Table Specific Information
Select
SELECT * FROM ProductVariants
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');
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). | |
SKU_ID | 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 | Integer | False |
The variant’s calculated price on the storefront. | |
SalePrice | Integer | False |
The variant’s sale price on the storefront. | |
RetailPrice | Integer | False |
The variant’s retail price on the storefront. | |
MapPrice | Integer | False |
The Minimum Advertised Price. | |
Weight | String | 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. | |
Calculated_Weight | Integer | False |
The variant’s calculated weight on the storefront. | |
Width | Long | False |
Width of the variant, which can be used when calculating shipping costs. | |
Height | Long | False |
The Height of the variant, which can be used when calculating shipping costs. | |
Depth | Long | False |
The Depth of the variant, which can be used when calculating shipping costs. | |
Is_Free_Shipping | 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 | Integer | False |
The fixed shipping cost for the variant. If defined, this value will be used during checkout instead of normal shipping-cost calculation. | |
Purchasing_Disabled | String | False |
Accepts AvaTax System Tax Codes, which identify products and services that fall into special sales-tax categories. | |
Purchasing_Disabled_Message | String | False |
Accepts AvaTax System Tax Codes, which identify products and services that fall into special sales-tax categories. | |
Image_Url | String | False |
The Image url for the variant. | |
CostPrice | Integer | 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. |