Filtering orders based on an email list

[Wunderlink]

Hi, we frequently need to lookup / tag orders based on an email list. 

For example, right now I have a list of 90 emails, each of which has an outstanding order. I need to be able to filter my orders list so that it only shows orders from those 90 emails.

We've checked some apps for this feature, but everything seems designed around creating customer segments with no way to get a list of orders for a certain segment. I know the order itself has an email field, so I'm not sure why I can't find this feature. 

[VipulBudhiraja]

If you didn't finding in shopify. My suggestion would be export them in excel file And then extract them manually 
It will roughly take an hour or so.
Hopefully it will resolve your issue

[Benjamen]

Hello 👋

A good consideration might be to use Shopify Flow to tag the orders based on a condition if the customer already in a segment that you've created.
This would work best with new orders (orders made after you've implemented a Shopify Flow solution). Just throwing out another possibility. I hope this helps 😊

[BetterReports-K]

Hi @Wunderlink,

Keanna here from Better Reports. I would recommend our app Better Reports for this!

Better Reports can filter our sales reports by the email or tags associated with the customer or order. You can use the native filter for this, or we can create a custom field where you can paste a list of emails to streamline filtering.

In addition to custom reporting, Better Reports has more than 80 built-in reports available out of the box that cover many common use cases for merchants. You can schedule reports to run at set frequencies to your email or Google Drive or export the reports in CSV, Excel, HTML or PDF format.

I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.

What do you think?

[Jonathan-HA]

Hi there,

If exporting the order data to a CSV/Excel file or Google Sheets could work as an alternative, our EZ Exporter app can help with this.

In the app, you can create a custom template where you can specify a comma-separated list of email addresses to filter by.  You can then keep reusing this template for this specific report and automate it as well to be sent to an email address, Google Sheets, Dropbox, etc.

[Wunderlink]

Thanks for the replies everyone, we'll check out some of these apps and see what makes sense!