Hi there!
I’m trying to retrieve some order level data for my client’s Shopify accounts and I’m having issues with bulk operation query. I’m running the same code and query across 16 different stores, in which all except one work fine. For that one store, almost every time I create a bulk operation it fails with error ‘INTERNAL_SERVICE_ERROR’
This is the query I use:
{
orders(query: “updated_at:>=2025-03-03 updated_at:<=2025-03-04”) {
edges {
cursor
node {
id
createdAt
updatedAt
app {
name
}
agreements {
edges {
node {
happenedAt
id
reason
app {
title
}
sales {
edges {
node {
id
actionType
lineType
quantity
totalDiscountAmountBeforeTaxes {
shopMoney {
amount
}
}
totalDiscountAmountAfterTaxes {
shopMoney {
amount
}
}
totalTaxAmount {
shopMoney {
amount
}
}
totalAmount {
shopMoney {
amount
}
}
… on ProductSale {
lineItem {
id
name
}
}
}
}
}
}
}
}
}
}
}
}
and this is the returned data:
{
data: {
node: {
id: ‘gid://shopify/BulkOperation/3902013702201’,
status: ‘FAILED’,
errorCode: ‘INTERNAL_SERVER_ERROR’,
createdAt: ‘2025-05-12T18:00:24Z’,
completedAt: null,
objectCount: ‘2957’,
fileSize: null,
url: null,
partialDataUrl: ‘https://storage.googleapis.com/shopify-tiers-assets-prod-us-east1/bulk-operation-outputs/…’
}
},
extensions: {
cost: {
requestedQueryCost: 1,
actualQueryCost: 1,
throttleStatus: [Object]
}
}
}
I’ve tried running query with different date ranges, and it works across some but not all. (for example 2025-03-01 to 2025-03-02 returns data as expected, but when I change it then I get error messages again)
I’ve also tried running this query without bulk operation as well and it returns data as expected. I’d prefer to use bulk operations though, so if there’s a fix I’d rather not change this process.
The API version I use is 2025-04, I’ve also tried with 2025-01 and getting the same error in both
Does anyone know how to fix this/has anyone seen a similar error before?
Thank you!