THROTTLED on ShopifyqlQuery graphql endpoint despite headroom

Hi friends!

Started seeing a THROTTLED message on many of our graphql queries today, despite plenty of headroom:

For example, this is a simple query on a Plus store, replicated in postman for clarity:

Is ShopifyqlQuery throttled by some other mechanism?

Hi @bailey

It does seem that ShopifyqlQuery has different rules around rate limiting - can you share the query you’re making, removing any sensitive info?

hey @Liam-Shopify !

We use ShopifyqlQuery to help merchants understand their data and interpret how are app is impacting key metrics. It’s crucial for us to have a reliable baseline.

For example, this query started giving us issues lately:

"FROM sales SHOW returning_customer_rate GROUP BY customer_sms_subscription_status WITH TOTALS VISUALIZE returning_customer_rate”

We are getting the same exact issue here. This was working properly through 1/30/2026 on an out-of-band batch process.

It has nothing to do with rate limiting, as running a single call to shopifyqlQuery is failing

Our call:

query RunShopifyQL($query: String!) {
shopifyqlQuery(query: $query) {
__typename
parseErrors
tableData {
columns {
name
dataType
displayName
}
rows
}
}
}

Body:

{
“query”: "\n query RunShopifyQL($query: String!) {\n shopifyqlQuery(query: $query) {\n __typename\n parseErrors\n tableData {\n columns {\n name\n dataType\n displayName\n }\n rows\n }\n }\n }\n ",
“variables”: {
“query”: “\nFROM inventory_adjustment_history\n SHOW inventory_adjustment_change\n WHERE product_variant_sku = ‘PUT-SKU-HERE’\n AND inventory_location_name = ‘LOCATION NAME’\n AND inventory_change_reason = ‘purchase’\n AND inventory_state = ‘committed’\n GROUP BY product_variant_sku, inventory_app_name, inventory_change_reason,\n inventory_state, day WITH TOTALS\n HAVING inventory_adjustment_change != 0\n SINCE startOfDay(-365d) UNTIL today\n ORDER BY day ASC\n LIMIT 1000\n”
}

This is the query, and it works fine within the Reporting console:

FROM inventory_adjustment_history
SHOW inventory_adjustment_change
WHERE product_variant_sku = ‘SKU-HERE’
AND inventory_location_name = ‘LOCATION-HERE’
AND inventory_change_reason = ‘purchase’
AND inventory_state = ‘committed’
GROUP BY product_variant_sku, inventory_app_name, inventory_change_reason,
inventory_state, day WITH TOTALS
HAVING inventory_adjustment_change != 0
SINCE startOfDay(-365d) UNTIL today
ORDER BY day ASC
LIMIT 1000

The response payload (ALWAYS returns a rate limit)

{
“errors”: [
{
“message”: “Rate limited. Please retry later.”,
“locations”: [
{
“line”: 3,
“column”: 7
}
],
“extensions”: {
“code”: “THROTTLED”,
“requestId”: “6bfb632f-2e2e-4ed6-a9a0-7756730afbce-1770393362”
},
“path”: [
“shopifyqlQuery”
]
}
],
“data”: {
“shopifyqlQuery”: null
},
“extensions”: {
“cost”: {
“requestedQueryCost”: 3,
“actualQueryCost”: 1,
“throttleStatus”: {
“maximumAvailable”: 20000.0,
“currentlyAvailable”: 19999,
“restoreRate”: 1000.0
}
}
}
}

yes, sorry if I wasn’t clear in the original post, we’re not doing this on any sort of interval where we would be rate limiting. we see this as throttling on a single request.

Has something changed around the limits for shopifyQL because I am also getting THROTTLED / rate limited for queries that were working a couple of days ago

I heard back from Shopify developer support. This was their exact response: ”This limit is based on time and other factors like number of fields included. Although the specifics of this limiting isn’t currently exposed or documented, there are future plans to do so although they aren’t currently scheduled and we don’t have a timeline we’re able to share.”

Translation: “There’s a limit. We won’t tell you what it is. We might document it eventually. No promises. Good luck.”

@NickP-Shopify can you provide any more information on this please?

1 Like

Also seeing THROTTLED issues all of the sudden, for the exact same stores & queries that have been working just fine for months. I’m not using ShopifyqlQuery though, these are on inventorySetOnHandQuantities mutation calls.

Bumping this up for visibility.

Hi folks - we’re still working on improving the current experience. Our team will post here when there’s more to share.

Hi @Liam-Shopify thanks for the update, I thought that the throttling was a bug that would be fixed but are you saying that this is expected behaviour? Because it’s broken functionality in my app that was working last week

us too - causing issues for merchants using our app!