List of tables for ShopifyQL

[dikeshj]

Is there any reference documentation for tables and fields which can be used to query with ShopifyQL?

I could not find the list anywhere.

[amitsamtani]

Hi Dikeshj,

https://shopify.dev/api/admin-graphql

[dikeshj]

Hi @amitsamtani,

I have seen this documentation but there is no list of table which is supported with ShopifyQL.

For example, here is the schema for sales table which can be queried as mentioned in this reference doc. But what are the other tables and their schemas?

[amitsamtani]

Hi @dikeshj, my apologies, didn't realize there was something called ShopifyQL. I assumed GraphQL. 

I have only played around with GraphQL until now and not ShopifyQL. I didn't see anything in the documentation for the tables you are looking for? 

Not sure if you can do what you want using GraphQL instead? If you are looking for order information, in this link you can see all the fields you want to query: https://shopify.dev/api/admin-graphql/2022-07/queries/orders

[dikeshj]

Hi @amitsamtani 

I have checked the GraphQL API but I am looking for aggregate data e.g. total sales, gross profile etc. date/month wise and ShopifyQL provides these metrics without iterating over each order data.

 Hence, using that ShopifyQL API.

[Umiko]

Hi @dikeshj 👋

You can find reference docs for ShopifyQL here and schema for aggregates data here as well. Hope that helps!

[dikeshj]

HI @Umiko

Thank you for the reply.

I have already checked sales schema as mentioned in my previous comment. My question is what about the other tables and their schemas. Like visits, payments, etc?

[Skrypt]

Hi, I am also looking for this list, have you found anything ? Thanks

[dikeshj]

@Skrypt

Nothing yet.

[Umiko]

With ShopifyQL still in early release, only the sales table is accessible at this time. We're excited to see that there are lots of interested partners, and we recommend keeping an eye out on our changelog for the latest updates to ShopifyQL!

[Skrypt]

Hi, thanks for the reply. Do you have any idea of the period when the visits and pageViews tables will be available through ShopifyQL ? In the meantime, is there any other way to get the information from these tables ? (total_sessions, total_active_sessions, etc) 

[hanawa]

请问你是怎么处理的呢

[junichiokamura]

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

[eivanovue]

Hi, up until recently, I was querying the sales table through ShopifyQL. However, currently, I get errors that the sales table does not exist anymore. Does anyone have more info on this? Is there an alternative, since the orders and product datasets do not provide me with all the information I need? 

[ShopifyDevSup]

Hi @eivanovue

The sales table is no longer available through  ShopifyQL. Our references in the dev documentation outlines what datasets can be queried here.

[shadowlessnotes]

is there any other way to access the sales table through API? I want sales by product and by customer type, which is no longer available in the orders and products dataset.