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.

IDTypeDescription
product_idstringUnique ID for the product.

Example value: 6804674412617
product_titlestringThe name or title of the product.

Example values: Green Soft Socks 3-Pack, Paring Knife Travel Case, Gift Subscription
vendorstringThe vendor of the product.

Example values: Route, Canon, Corso
product_statusstringThe current status of the product.

Example values: active, draft, archived
product_tagsrepeated stringTags associated with the product for categorization.

Example values: 3-pack, Sale, discount_eligible
product_typestringThe category or type of product.

Example values: Merch, Subscription, Publication
variantsrecord repeatedInformation about the different variants of the product.
variants.variant_idstringUnique ID for the product variant.

Example value: 47095335813393
variants.variant_titlestringThe name or title of the variant.

Example values: 36 S, Titanium / Mild, Black Leather
variants.variant_pricestringThe price of the variant.

Example values: 69.99, 10, 1200
variants.skustringThe stock keeping unit associated with the variant.

Example values: GP-BACK-02, A02630, POP200NAVY