What's your biggest current challenge? Have your say in Community Polls along the right column.

What account do I need to be able to pull product and order analytics from an app using ShopifyQL?

What account do I need to be able to pull product and order analytics from an app using ShopifyQL?

basima25z
Shopify Partner
6 0 0

Hello,

I am trying to pull these metrics from an app: net_sales, net_product_quantity, & gross_sales from the Product Dataset. On the Product Dataset page, it says you need to have a Plus Merchant account to use it. However, on the 
Admin GraphQl shopifyqlQuery - there's not an account listed, and it seems free to me. I was able to run this query with my Development Store on postman and got data returned.

 

 

query {
shopifyqlQuery(query: "FROM products SHOW sum(view_cart_sessions)") {
__typename
... on TableResponse {
tableData {
unformattedData
rowData
columns {
name
dataType
displayName
}
}
}
parseErrors {
code
message
range {
start {
line
character
}
end {
line
character
}
}
}
}
}

 


I asked an advisor and she said, with an Advanced account you have access to Shopify Analytics within the Shopify Admin while with a plus account I can pull the data from an App. However she said to double check here as she wasn't a developer and not an expert.

As you can see this is very confusing as I was able to make requests with my development account with Postman for free. 

Just to reiterate, I want to use the Product and Order Dataset to pull metrics from an app - not within the Shopify Admin. 

Thank you in advance!

Replies 0 (0)