Have your say in Community Polls: What was/is your greatest motivation to start your own business?
Our Partner & Developer boards on the community are moving to a brand new home: the .dev community forums! While you can still access past discussions here, for all your future app and storefront building questions, head over to the new forums.

Do bulk operations have limits on how much data is fetched?

Do bulk operations have limits on how much data is fetched?

un-tethered
Shopify Partner
1 0 0

 

I have a custom app that uses a bulk operation GraphQL query to fetch data and it's worked fine until last week. Last week, I noticed it was returning incomplete data. I query for orders and products and it only returns either orders or products but not both.
When I reduce the size of the requested data by reducing the date window for the orders, complete data is returned. Do bulk operations have a limit on requested data size?

 

    mutation {
        bulkOperationRunQuery(
            query: """
                {
                    products(query:"NOT product_type:Sets") {
                        edges {
                            node {
                                id
                                title
                                status
                                featuredImage {
                                    url
                                }
                                variants {
                                    edges {
                                        node {
                                            id
                                            sku
                                            title
                                            availableForSale
                                            sellableOnlineQuantity
                                            inventoryItem {
                                                unitCost {
                                                  amount
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                        }
                    }

                    orders(query: "created_at:>=2022-10-07T00:00:00Z") {
                        edges {
                            node {
                                createdAt
                                id
                                lineItems {
                                    edges {
                                        node {
                                            id
                                            unfulfilledQuantity
                                            variant {
                                                id
                                            }
                                            quantity
                                        }
                                    }
                                }
                            }
                        }
                    }
                }
            """
        ) {
            bulkOperation {
                id
                status
            }
            userErrors {
                field
                message
            }
        }
    }

 

Reply 1 (1)

ShopifyDevSup
Shopify Staff
1453 238 524

Hi un-tethered,

 

Thanks for your post. Bulk queries do have some internal resource limitations which we're working to improve the documentation about. At this time simplifying the query is the best option.

 

It does seem particularly unusual that only part of the results would be returned. If that is a result that can be replicated it would be great if you could report this specific example with a few more details to [Partner Support using the email option] and selecting the 'App Development & API' topic.

 

Some additional info that would be helpful for an investigation is a date, time, and timezone from within the past 7 days that this happened and the store it occurred in.

Developer Support @ Shopify
- Was this reply helpful? Click Like to let us know!
- Was your question answered? Mark it as an Accepted Solution
- To learn more visit Shopify.dev or the Shopify Web Design and Development Blog