dim_product_variants

Product variant dimension for enriching line items with stable keys and attributes.

Grain: One row per sm_product_variant_key.
Date field: product_variant_created_at.
Filters to start with: source_system for platform coverage. Shopify, WooCommerce, Magento and BigCommerce variants retain their native identities when the SKU is blank; use sm_product_variant_key for joins rather than SKU. Key join: dim_order_lines via sm_product_variant_key (1:many).

Columns

Column	Type	Description
`sm_product_key`	STRING	Stable SourceMedium join key for products to related tables.
`sm_product_variant_key`	STRING	Stable SourceMedium join key for product variants to related tables.
`sm_store_id`	STRING	SourceMedium’s unique store identifier. For Shopify stores, derived from the myshopify.com domain; for other platforms (Amazon, TikTok Shop, Walmart.com), uses platform-specific identifiers.
`inventory_item_id`	STRING	The unique identifier for the inventory item.
`is_product_gift_card`	BOOL	Whether the product is a gift card.
`marketplace_id`	STRING	The Amazon marketplace the listing belongs to, as Amazon’s marketplace ID (for example `ATVPDKIKX0DER` for Amazon US). It names the marketplace, not the product: an Amazon variant’s ASIN is `product_id`. NULL for sources other than Amazon and on placeholder rows.
`primary_product_image_url`	STRING	Primary product image URL (display).
`product_collection_handles_csv`	STRING	Unique, human-readable strings for the collections a product belongs to automatically generated from their titles.
`product_collection_titles_csv`	STRING	The titles of collections the product belongs to. Collections are groupings of products that merchants can create to make their stores easier to browse.
`product_created_at`	TIMESTAMP	The date and time when the product was created.
`product_id`	STRING	A unique identifier for the product generated by the source system. For Amazon (`source_system = 'Amazon'`) it is the product’s ASIN.
`product_tags_csv`	STRING	Tags that the shop owner has attached to the product, comma-and-space separated and sorted alphabetically. Values are the exact tag strings as set in Shopify, with the source list literal’s brackets, quote wrapper and padding removed (a bracket or quote that is part of the tag itself is preserved). Null when the product has no tags, note that product_tags_array is `[]` rather than null in that case, so this is the column to test for. Use product_tags_array to match on individual tags rather than substring-matching this column.
`product_title`	STRING	The title of the product.
`product_type`	STRING	A categorization for the product used for filtering and searching for products.
`product_updated_at`	TIMESTAMP	The date and time when the product was last modified.
`product_variant_compare_at_price`	NUMERIC	The original/compare-at price for this product variant (typically MSRP or pre-sale price). Used to show savings/discounts to customers; NULL if no compare-at price is set.
`product_variant_created_at`	TIMESTAMP	The date and time when the product variant was created.
`product_variant_id`	STRING	A unique identifier for the product variant generated by the source system.
`product_variant_price`	FLOAT64	The current retail price for this product variant (per unit). Used for pricing analysis and comparison with order line prices.
`product_variant_title`	STRING	The title of the product variant.
`product_variant_updated_at`	TIMESTAMP	The date and time when the product variant was last modified.
`product_vendor`	STRING	The name of the vendor of the product.
`sku`	STRING	The stock keeping unit (SKU) of the product variant.
`source_system`	STRING	Originating platform for the record (e.g., Shopify, Amazon, TikTok Shop, Chargebee). Used for platform‑specific behavior and coverage.

Get into BigQuery

Activate

SQL Query Library

Common analyses (SQL)

Tables

Schema Standards

Columns

​Columns

Columns