Solved

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

aravindsundar
Shopify Partner
9 0 0

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?

Accepted Solution (1)
jazz-jay
Shopify Expert
96 14 18

This is an 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.

banned

View solution in original post

Replies 5 (5)

jazz-jay
Shopify Expert
96 14 18

Hi,

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

banned
aravindsundar
Shopify Partner
9 0 0

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
Shopify Expert
96 14 18

Are you making paginated requests to get next page orders?

banned
aravindsundar
Shopify Partner
9 0 0

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
Shopify Expert
96 14 18

This is an 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.

banned