We sometimes have people reach out to us asking why they haven't received an order confirmation email. We then find that they ordered with their mobile number instead of their email.
We want to find and tag all these customers that don't have an email attached to their account so we can glance at the tags and help them find the text etc.
How can I search for all orders with no email attached?
I found this Shopify help article - https://help.shopify.com/en/manual/orders/search-view-print-orders#filter-orders-using-custom-terms which mentions you can use structure search terms and links here -> https://shopify.dev/api/usage/search-syntax?shpxid=17fd605d-4C6F-48F3-B8C0-DF9237AFA045#search-query...
However, I can't get a structures search term to work.
For example I have an order from a customer, let's call her Diana.
Entering this search term: first_name:Diana
doesn't return any results.
However entering just
also works and displays all the orders made by customers not named Diana.
Any idea what I am doing wrong?
Found a potential solution.
Went to the customers page and tried using search operators and found they worked.
also worked and showed me all customers without that email.
Then I tried the * operator and it showed me a subset of all my customers, the ones that had some email.
I felt a glimmer of hope rising.
I then tried
and behold, it worked and showed me customers that didn't have an email.
Now I just need to figure out how to get all the orders from this subset of customers.