I can't get all orders by API, only 189/6508 [with debug log]

Retired Boards Appdev Customers Discounts And Orders

Topic summary

A developer is unable to retrieve all orders via Shopify’s API, getting only 189 out of 6,508 total orders.

The Problem:

  • The API count endpoint correctly returns 6,508 orders
  • When paginating through orders using page_info, the rel=next link disappears after fetching only 189 orders (3 pages of 50 + 39 orders)
  • The pagination stops prematurely despite thousands of orders remaining

Troubleshooting Attempted:

  • Confirmed the app has “read all orders” permission
  • Added status=any parameter to the request
  • Reviewed similar issues reported by others but found no working solution

Root Cause Identified:
The developer discovered that for public apps, Shopify’s default order fetch time is limited to 60 days. This restriction appears to be causing the pagination to terminate early, preventing access to older orders beyond this timeframe.

The issue remains unresolved with no clear workaround provided for accessing the full order history.

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

now I know what happends, the public app set the default-order-fetch-time is 60days.