How to get past the 1000 limit and to fetch past order data?

[aravindsundar]

Hi,

While we try to fetch the order details via API we are receiving only a limited no. of recent orders data. We can't able to find the past orders. How to rectify this? How to fetch past 6 months order data? And is it possible to fetch the data and store in our database?

[jazz-jay]

Hi,

You need the read_all_orders scope activated for your app to retrieve older orders.

[aravindsundar]

Yes, I requested for that and Shopify has granted access for that. Even though I am receiving the recent orders only. Is there any way to increase the 1000 limit?

[jazz-jay]

Are you making paginated requests to get next page orders?

[aravindsundar]

No, Right now I am fetching only 40 orders using Shopify Ql. If I increase this limit it says the query limit has been exceeded.

[jazz-jay · Accepted solution]

Switch to Rest Api and add limit=250 to retrieve the orders, then make paginated requests to get next page orders. Or use bulk operations.