Email customers that have an unfulfilled line item

[Wunderlink]

Hi, we have a product that has been out of stock for some time, but we have still been accepting orders for it.

We need to email everyone that ordered this product but has not yet had it fulfilled. Note that most of these orders included other items that have been fulfilled, so the orders that should be included in this set are Unfulfilled or Partially Fulfilled.

How can we email these customers to let them know the timeline for their missing product? We're trying to avoid using an external email service like mailchimp. 

Shopify's mail app doesn't really work for this because there's no way to create a customer segment from a list of orders (wtf?). We were looking into using Flow for this, just not sure how to collect the orders.

[TheUntechnickle]

Hey @Wunderlink.,

 Let me suggest a solution using Shopify's Flow.

Here's how you can accomplish this:

1. Create a Flow workflow that identifies these specific orders:

   • Trigger: "Order updated" or "Order created" (depending on your needs)
   • Condition: Check if the order contains the specific product AND has a status of "Unfulfilled" or "Partially Fulfilled"
   • Action: Add the customer to a specific customer tag (e.g., "awaiting-product-X")

2. Export the list of tagged customers:

   • Go to Customers → Export
   • Filter for customers with your specific tag
   • Export to CSV

3. Use Shopify's bulk email feature:

   • Go to Customers → select all tagged customers
   • Use the bulk actions menu to send an email
   • Craft your message explaining the timeline

If you need to do this retroactively for existing orders:

1. Use Shopify Admin API to identify the orders:

   • Query orders containing your specific product with status "unfulfilled" or "partially_fulfilled"
   • Extract the customer emails
   • Tag these customers for future tracking

2. Use Shopify's built-in notification templates:

   • Create a custom notification template
   • Send it to the identified customers

Hope this helps 🙂

Shubham | Untechnickle