Filter by order # range

[NickNovo]

It would be VERY helpful for a new feature on the order page to be able to search by a range of order #s, like search range #3000-#3500. It helps because of certain events we do, it allows us to pick all orders between the order before and after the event. Sometimes dates aren't very clear because there are so many kinds... order date, fulfillment date, payout date, transaction date, etc. Also, for the search feature, being able to search via those dates would help too. Right now it seems you can only search via order date which has a lot of limitations when you want to pull different types of data. 

[DaisyVo]

Hi @NickNovo 

I totally get why having a "Search by Order # Range" feature would be a game-changer for managing orders efficiently, especially when dealing with events. Right now, Shopify's built-in search is pretty limited—it mainly filters by order date, and as you pointed out, that’s not always reliable when you have multiple date types (fulfillment, payout, transaction, etc.).

Workarounds Until Shopify Adds This Feature

While Shopify doesn’t currently offer a direct way to filter by order number range, here are some practical alternatives:

1. Export Orders to CSV & Filter in Excel/Google Sheets

• Go to Orders → Click Export
• Choose “All Orders” or set a custom date range
• Open the file in Excel/Google Sheets
• Use the SORT & FILTER feature to pull orders within your preferred range (e.g., #3000 - #3500)

This is a manual method, but it works if you need quick access.

2. Use Shopify Apps

There are some third-party apps that offer advanced filtering, including by order number:

• Better Reports
• Data Export Reports
• EZ Exporter

These tools allow more flexible order filtering, including searching by different date types.

3. Use Shopify's API (If You're Comfortable with Code)

If you or your developer are open to API solutions, Shopify's Admin API lets you query orders by ID range. You can use something like:

/orders.json?since_id=2999&limit=500

This pulls orders starting from #3000 up to #3500 (Shopify orders are sequential, so you can use since_id and limit to work around this limitation).

Feature Request Suggestion

You're absolutely right that Shopify should introduce an Order # Range Search natively. If you haven’t already, consider submitting a feature request via Shopify's Community Forum or contacting support. The more merchants ask for this, the higher the chance Shopify implements it.

If you need any other assistance, feel free to reply and I will try my best to help.
Best regards,
Daisy