bulkOperationRunQuery - quantityPriceBreaks error "Connection fields without 'id': prices"

Retired Boards Appdev Graphql Basics And Troubleshooting

Topic summary

A user encounters an error when attempting to use bulkOperationRunQuery to retrieve quantityPriceBreaks data for price lists. The error message states: “Connection fields without ‘id’: prices” and indicates that the parent ‘node’ field must select an ‘id’ field.

Root Cause:
Shopify support explains that bulk operations have a 3-level nesting limit for queries. The user’s query exceeds this by nesting quantityPriceBreaks under prices, which itself is already nested multiple levels deep.

Current Status:
Removing the quantityPriceBreaks field would resolve the error, but this defeats the user’s purpose. The user asks whether an alternative method exists to bulk query all variant quantityPriceBreaks for a given priceList.

Unresolved Question:
No workaround or alternative approach has been provided yet for retrieving this nested data via bulk operations within the API’s structural constraints.

Summarized with AI on November 11. AI used: claude-sonnet-4-5-20250929.
1

The following query fails with error “The parent ‘node’ field for a nested connection must select the ‘id’ field without an alias and must be of ‘ID’ return type. Connection fields without ‘id’: prices.”

According to the documentation “prices” does not have an “id” field. Is this an implementation error? Is there another way to run a bulk operation to list quantityPriceBreaks for priceLists ?

mutation GetPriceListPriceBreaks {
bulkOperationRunQuery(
query: “”"
{
priceLists(sortKey: NAME) {
edges {
node {
id name
catalog {
title
}
prices (first: 5) {
edges {
node {
variant {
product {
id handle title
}
id sku
}
price {
amount
}
quantityPriceBreaks(first: 10, sortKey: MINIMUM_QUANTITY) {
edges {
node {
minimumQuantity
price {
amount
}
}
}
}
}
}
}
}
}
}
}
“”"
) {
bulkOperation {
id
status
}
userErrors {
field
message
}
}
}

2

Hey @krhall21 ,

Just looking at your query here, this would work as a normal graphQL query. The issue you’re running in to here is your query is nexted 3 levels deep.

The quantityPriceBreaks nested under prices is what’s causing the error. If you remove that field it will go through properly.

For clarity, this limitation is documented here: https://shopify.dev/docs/api/usage/bulk-operations/queries#operation-restrictions

Hope that helps

  • Kyle G.
3

Thanks Kyle, but the question remains: Is there a way to run a bulk operation to list all the variant quantityPriceBreaks for a priceList?