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 or inactive? — filter where product_inventory_quantity = 0 or variants.variant_inventory_quantity = 0, 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 Use This Join To
Product Analytics product_id Measure catalog product performance over time with revenue, orders, and units sold

When to Use a Different Table

Use Product Analytics table when you need product sales performance over time, such as revenue, units sold, or orders by product. The Products table is for catalog attributes.

Use Orders table when you need product data in the context of individual orders. The Products table is for the product catalog, not order-line detail.

View the full Triple Whale Data Ontology →

Table	Join Key	Use This Join To
Product Analytics	`product_id`	Measure catalog product performance over time with revenue, orders, and units sold

Dimensions

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

Title	ID	Type	Description
Amazon Marketplace ID	`amazon_marketplace_id`	string	The Amazon marketplace ID for the marketplace associated with the product. See list of marketplace IDs. Example values: `ATVPDKIKX0DER`, `A2EUQ1WTGCTBG2`, `A1F83G8C2ARO7P`
Amazon Marketplace Name	`amazon_marketplace_name`	string	The human-readable name of the Amazon marketplace associated with the product. Example values: `United States of America`, `United Kingdom`, `Germany`
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.
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 Compare At Price	`variants.variant_compare_at_price`	numeric	The original price of the product variant before a discount or sale was applied. When set, the main sales platform displays this as a strikethrough price alongside the current selling price (`variants.variant_price`), allowing buyers to see the markdown. NULL if no sale is active. Example values: `99.99`, `200`, `49`
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

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`

product_inventory_quantity

numeric

The number of items in stock for the product.

Example values: 100, 50, 0