Product variants table
Product variants contains current information about each of the product variants in your store. This table contains one row per product variant.
Column | Data type | Description |
---|---|---|
product_variant_id | numeric | The ID of the product variant. This column is the primary key for this table. |
product_id | numeric | The ID of the product. This column is a foreign key reference to the product_id column in products table. |
shop_id | numeric | The ID of the store. This column is a foreign key reference to the shop_id column in the shops table. |
title | varchar | The title of the product variant. |
barcode | varchar | The Barcode, UPC, or ISBN number of the product variant. |
sku | varchar | The SKU of the product variant. |
price | numeric | The price of the product variant, in your store's currency. |
grams | numeric | Number of grams that the product variant weighs. |
created_at | timestamp | The date (ISO 8601) and time (UTC) when the product variant was added to the store. The format is YYYY-MM-DD HH:mm:ss (for example, 2016-02-05 17:04:01). |
deleted_at | timestamp | The date (ISO 8601) and time (UTC) when the product variant was deleted. The format is YYYY-MM-DD HH:mm:ss (for example, 2016-02-05 17:04:01). |
If you change the price of a product variant in Shopify, then that change will appear in this table. For information about joining this table with the sales or orders tables, see sales, orders, and line items.