List of tables for ShopifyQL

Retired Boards Appdev Graphql Basics And Troubleshooting

Topic summary

Users are seeking comprehensive documentation listing all available tables and schemas for querying with ShopifyQL, beyond the basic examples provided in official documentation.

Key Points:

  • The initial question asks for a complete reference of tables/fields usable with ShopifyQL, similar to the sales table schema example
  • Early confusion arose between ShopifyQL (for aggregate analytics data) and GraphQL API (for individual record queries)
  • Current Status: ShopifyQL is in early release with limited table availability
  • Sales Table Removed: Previously accessible sales table no longer exists in ShopifyQL, causing disruption for existing users

Available Resources:

Unresolved Issues:

  • No timeline provided for when additional tables (visits, pageViews, sessions, payments) will become available
  • No alternative solution offered for accessing sales data by customer type, previously available in the deprecated sales table
  • Users recommend monitoring the Shopify changelog for updates
Summarized with AI on November 23. AI used: claude-sonnet-4-5-20250929.
13

Hi, data sets might be your finding “table names” actually.

The examples on this page use the orders and products datasets in Shopify stores. For information about available metrics, dimensions, and aggregates, please refer to the orders dataset, products dataset, or benchmark dataset.

https://shopify.dev/api/shopifyql/datasets/orders-dataset