ProductVariants

Query and delete product listings.

Table-Specific Information

Select

The adapter uses the Shopify API to process search criteria that refer to the Id and ProductId column. The adapter processes other filters client-side within the adapter.

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.