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; variants with empty SKU are excluded upstream. Consequently, order lines referencing empty-SKU variants do not resolve. 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	Marketplace-specific identifier for the product variant when sold through third-party marketplaces (e.g., Amazon ASIN). NULL for direct-to-consumer sales; used to track marketplace product listings.
`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.
`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