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
}
}
}
}