Products Table

products_table

The Products table offers a comprehensive overview of products listed within your e-commerce platform, detailing attributes such as ID, title, vendor, status, and type. By querying this table, users can gain insights into product performance, inventory management, and sales trends, enabling strategic decisions around product listings, promotions, and stock levels.

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

Updated 5 days ago