did you ever find a solution to this? i am faced with same issue
Topic summary
Issue: Retrieving an entire product catalog (~1500 items) via the REST API is blocked by sorting and pagination limitations.
- Results are limited to 250 per request and default to alphabetical sorting by title (A–Z), producing orders like “Product 1, Product 10, Product 100, Product 1000.”
- The since_id parameter (for pagination by ID) would work only if results could be ordered by product ID, but no sort-by-ID or order_by option is documented.
- Practical impact: Fetching one-by-one would take ~40 minutes due to request limits and still be unreliable. Adding a new product (e.g., “A New Product”) would appear first alphabetically but have the latest ID, breaking ID-based pagination and causing products to be missed.
Community feedback: Multiple users ask for an order_by capability; none report a workaround or official solution.
Status: Unresolved. No confirmed method to control sort order or reliably paginate all products using since_id under the current API behavior.