Topic summary
The discussion centers on creating an automated email notification for customers when their paid orders remain unfulfilled after a specified period (5-7 days).
Key Challenge:
- Shopify Flow lacks native transactional email actions, requiring third-party apps or workarounds
- Users need to identify unfulfilled, paid orders after a time threshold
Proposed Solutions:
Basic Approach (paul_n):
- Use “Get Order Data” action to find paid but unfulfilled orders
- Implement nested loops: one to tag customers, another to send emails
- Limitation: Flow currently allows only one action per loop
Advanced Solution (Yuka_3):
- Workflow 1: Scheduled daily trigger that searches for orders created 7+ days ago, paid, unfulfilled, and not tagged with “late_fulfillment”
- Search query filters up to 100 orders; more frequent scheduling needed for higher volumes
- Uses “Start custom order workflow” action to trigger second workflow
- Workflow 2: Receives custom trigger, adds “late_fulfillment” tag to prevent duplicate processing, sends customer notification
- Requires Flow Companion app for custom trigger functionality
Screenshots provided show workflow configurations and search query syntax for implementation.
