ProductVariants
Query and delete product listings.
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. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
For example, the following queries are processed server side.
SELECT * FROM ProductVariants
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 | String | 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 | Integer | 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 | Integer | 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 | Integer | False |
The order of the product variant in the list of product variants. | |
RequiresShipping | Boolean | 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 | Boolean | 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. |