The Products table provides the product catalog with attributes like name, type, vendor, status, and variants. One row per product. Sourced from the connected sales platform.

📋
Table Guide
What You Can Answer With This Table

Which products or variants are out of stock? — filter where product_inventory_quantity = 0 or variants.variant_inventory_quantity = 0

How many products are active vs draft vs archived? — group by product_status

What products does a specific vendor supply? — filter or group by vendor

Before You Query

This table is not time-series. No event_date filter is needed.

Key Relationships
Table Join Key What the Join Enables
Product Analytics product_id Product performance metrics over time (revenue, orders, units sold)

When to Use a Different Table

Need product sales performance over time (revenue, units sold, orders by product) → Product Analytics table. Product Analytics tracks product metrics over time; Products stores catalog attributes.

Need product data in the context of individual orders → Orders table. The Orders table includes a nested products_info column with product details per order.

View the full Triple Whale Data Ontology →

Table	Join Key	What the Join Enables
Product Analytics	`product_id`	Product performance metrics over time (revenue, orders, units sold)

Dimensions

Dimensions are immutable properties that can be used for grouping data.

Title	ID	Type	Description
Collections	`collections`	repeated string	Collections the product belongs to, as set within the main sales platform. Example values: `Summer Gift Guide`, `Long-Sleeve Packs`, `Christmas Collection`
Product Images	`images`	record repeated	Images associated with the product, with details such as image position, dimensions, and source URL.
Image Position	`images.image_position`	string	The position of the image in the product gallery. Example values: `1`, `5`, `19`, `43`
Image Width	`images.image_width`	string	The width of the image in pixels. Example values: `500`, `1080`, `1500`, `2048`
Image Height	`images.image_height`	string	The height of the image in pixels. Example values: `500`, `1080`, `1500`, `2048`
Image Source	`images.image_src`	string	The URL of the product image. Example values: `https://cdn.shopify.com/.../product1.jpg`, `https://m.media-amazon.com/.../image1.jpg`
Integration ID	`integration_id`	string	The unique identifier for the integration (store connection) that this product belongs to.
Platform	`platform`	string	The platform or marketplace where the product is listed. Example values: `shopify`, `amazon`, `custom`
Product Description	`product_description`	string	The description of the product as written by the seller. Example values: `Classic everyday denim designed for comfort and versatility, featuring premium stretch fabric, durable stitching, and a timeless silhouette suitable for any wardrobe.`
Product ID	`product_id`	string	The unique ID of the product as set within the main sales platform. Example value: `3891505496131`
Primary Product Image	`product_image_url`	string	The URL of the primary product image. Example values: `https://cdn.shopify.com/.../product1.jpg`, `https://m.media-amazon.com/.../image1.jpg`
Product Name	`product_name`	string	The name (or title) of the product as set within the main sales platform. Example values: `Green Soft Socks 3-Pack`, `Paring Knife Travel Case`, `Gift Subscription`
Product Status	`product_status`	string	The status of the product. Example values: `active`, `draft`, `archived`
Product Tags	`product_tags`	repeated string	Tags associated with the product, assigned by the seller in the main sales platform. Example values: `3-pack`, `Sale`, `discount_eligible`
Product Type	`product_type`	string	The product type as set within the main sales platform. Example values: `Jackets`, `Coffee Mugs`, `Books`
Shop ID	`shop_id`	string	The unique ID of the shop (often corresponds to the shop domain). Can be used to group or filter data by shop in multi-store reports. Example values: `example-US.myshopify.com`, `example-EU.myshopify.com`
Shop Name	`shop_name`	string	The name of the shop. Can be used to group or filter data by shop in multi-store reports. Example values: `example-US`, `example-EU`
Product Variants	`variants`	record repeated	Details about the product variants associated with the order.
Variant ID	`variants.variant_id`	string	The unique ID of the product variant as set within the main sales platform. Example value: `47095335813393`
Variant Name	`variants.variant_name`	string	The name (or title) of the product variant as set within the main sales platform. Example values: `36 S`, `Titanium / Mild`, `Black Leather`
Variant Description	`variants.variant_description`	string	The description of the product variant. Only supported for Amazon products. Example values: `High-rise skinny fit in stretch denim, designed to sit at the natural waist for a flattering, sculpted silhouette.`
Variant SKU	`variants.sku`	string	The SKU (Stock Keeping Unit) for the product variant as set within the main sales platform. Example values: `GP-BACK-02`, `A02630`, `POP200NAVY`
Variant Price	`variants.variant_price`	numeric	The price of a single product variant (to the buyer). Example values: `69.99`, `10`, `1200`
Variant Inventory Quantity	`variants.variant_inventory_quantity`	numeric	The number of items in stock for the product variant. Example values: `100`, `50`, `0`
Vendor	`vendor`	string	The vendor of the product variant. Example values: `Route`, `Canon`, `Corso`, `MyShop`

Measures

Measures are numeric fields that can be aggregated and/or combined to calculate new metrics.

Title	ID	Type	Description
Product Inventory Quantity	`product_inventory_quantity`	numeric	The number of items in stock for the product. Example values: `100`, `50`, `0`

Title

Type

Description

Product Inventory Quantity

product_inventory_quantity

numeric

The number of items in stock for the product.

Example values: 100, 50, 0