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 ID

product_id

string

The unique ID of the product as set within the main sales platform.

Example value: 3891505496131

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 Title

product_title

string

The 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 Type

product_type

string

The product type as set within the main sales platform.

Example values: Jackets, Coffee Mugs, Books

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 Title

variants.variant_title

string

The name of the product variant as set within the main sales platform.

Example values: 36 S, Titanium / Mild, Black Leather

Variant Price

variants.variant_price

string

The price of a single product variant (to the buyer).

Example values: 69.99, 10, 1200

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

Vendor

vendor

string

The vendor of the product variant.

Example values: Route, Canon, Corso, MyShop