ProductVariants
List of the product variants.
Table-Specific Information
Select
The driver uses the Shopify API to process search criteria that refer to the Id and ProductId column. The driver processes other filters client-side within the driver.For example, the following queries are processed server-side.
SELECT * FROM ProductVariants WHERE Id = '123'
SELECT * FROM ProductVariants WHERE Id IN ('123', '456')
SELECT * FROM ProductVariants WHERE ProductId = '456'
Insert
You must specify the ProductId to insert a product variant.
INSERT INTO ProductVariants (ProductId, Option1, Price) VALUES ('123', 'Yellow', 3.5)
Update
You must specify the Id of the variant to edit a product variant.
-
Update the title and price of an existing variant.
UPDATE ProductVariants SET Option1 = 'Pink', Price = 99.99 WHERE Id = '123'
Delete
You must specify the ProductId and the Id of the variant to delete a product variant.
DELETE FROM ProductVariants WHERE Id = '123' AND ProductId = '456'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | True |
A unique numeric identifier for the product variant. | |
ProductId | Long | False |
A unique numeric identifier for the product this variant belongs to. | |
InventoryItemId | Long | False |
The unique identifier for the inventory item, which is used in the Inventory API to query for inventory information. | |
ImageId | Long | False |
A unique numeric identifier for the image this variant belongs to. | |
Price | Decimal | False |
The price of the product variant. | |
CompareAtPrice | String | False |
The competitors prices for the same item. | |
Title | String | False |
The name of the product. | |
Grams | Int | False |
The weight of the product variant in grams. | |
Barcode | String | False |
A human-friendly unique string for the Product automatically generated from its title. | |
Weight | Double | False |
The weight of the product variant in the unit system specified. | |
WeightUnit | String | True |
The unit of measurement that applies to the product's variant weight. | |
FulfillmentService | String | False |
Service which is doing the fulfillment. | |
InventoryManagement | String | False |
Specifies whether or not Shopify tracks the number of items in stock for this product variant. | |
InventoryPolicy | String | True |
Specifies whether or not customers are allowed to place an order for a product variant when it's out of stock. Valid values are deny or continue. | |
InventoryQuantity | Int | True |
The number of items in stock for this product variant. Default value 1. | |
Option1 | String | False |
Custom properties that a shop owner can use to define product variants. | |
Option2 | String | False |
Custom properties that a shop owner can use to define product variants. | |
Option3 | String | False |
Custom properties that a shop owner can use to define product variants. | |
Position | Int | False |
The order of the product variant in the list of product variants. | |
RequiresShipping | Bool | False |
Specifies whether or not a customer needs to provide a shipping address when placing an order for this product variant. | |
Sku | String | False |
A unique identifier for the product in the shop. | |
Taxable | Bool | False |
Specifies whether or not a tax is charged when the product variant is sold. | |
CreatedAt | Datetime | True |
The date and time when the product variant was created. | |
UpdatedAt | Datetime | True |
The date and time when the product was last modified. |