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.
| ID | Type | Description | Source |
|---|---|---|---|
product_id | string | Unique ID for the product. Example value: 6804674412617 | Shopify, Amazon |
product_title | string | The name or title of the product. Example values: Green Soft Socks 3-Pack, Paring Knife Travel Case, Gift Subscription | Shopify, Amazon |
vendor | string | The vendor of the product. Example values: Route, Canon, Corso | Shopify, Amazon |
product_status | string | The current status of the product. Example values: active, draft, archived | Shopify, Amazon |
product_tags | repeated string | Tags associated with the product for categorization. Example values: 3-pack, Sale, discount_eligible | Shopify, Amazon |
product_type | string | The category or type of product. Example values: Merch, Subscription, Publication | Shopify, Amazon |
variants | record repeated | Information about the different variants of the product. | Shopify, Amazon |
variants.variant_id | string | Unique ID for the product variant. Example value: 47095335813393 | Shopify, Amazon |
variants.variant_title | string | The name or title of the variant. Example values: 36 S, Titanium / Mild, Black Leather | Shopify, Amazon |
variants.variant_price | string | The price of the variant. Example values: 69.99, 10, 1200 | Shopify, Amazon |
variants.sku | string | The stock keeping unit associated with the variant. Example values: GP-BACK-02, A02630, POP200NAVY | Shopify, Amazon |