ProductVariants

Columns

Name	Type	ReadOnly	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.