To send notifications to customers about shipping delays you can create two workflows. First workflow is the following:
- This workflow can be set to run regularly, e.g., daily, using the Scheduled time trigger.
- Select orders that were created more than 7 days ago, are paid, but not yet fulfilled, not tagged by late_fulfillment tag. You can replace late_fulfillment with any tag of your choice. Just ensure the same tag is used in both the search query and tagging step. Search Query:
created_at:<='{{ scheduledAt | date_minus: "7 days" }}' AND fulfillment_status:unfulfilled AND financial_status:paid AND tag_not:late_fulfillment
[details=Show More]
The search can return a maximum of 100 orders. If you expect more than 100 delayed orders daily, consider scheduling the workflow to run more frequently to notify all affected customers.
[/details]- The final step in this workflow triggers another workflow using the Start custom order workflow action with the Specifier field set to Notify customer about shipping delays value. This functionality is supported by the Flow Companion app.
Second Workflow is the following:
- This workflow starts with the Order: custom trigger triggered trigger.
- Add a condition to filter orders based on Specifier = Notify customer about shipping delays.
- Add the late_fulfillment tag to ensure the order isn’t processed again.
- Send a notification email to the customer.