How to Send Reminder Emails for Delivery Dates with CC Delivery Date and Time

Hello, this is Azy from Capital Castle.
In this article, I will introduce how to build a reminder email system for orders with upcoming delivery dates using Shopify Flow.

Follow these steps to create a Flow that sends reminder emails for delivery dates.

1. Change the delivery date format to "YYYY-MM-DD" in the settings of "CC Delivery Date and Time".
2. Store the delivery date of each order in the shop's metafield.
3. At the scheduled time, read the shop's metafield that records the delivery date and send reminder emails for orders with upcoming delivery dates.

Let's go through each step.

1. Change the delivery date format to "YYYY-MM-DD"

To be recognized as a date by the program, it needs to be in the "YYYY-MM-DD" format. You can change the format in the Calendar settings (format, etc.).

Display on the online store (YYYY-MM-DD format)

2. Store the delivery date of each order in the shop's metafield

Download Add Delivery Date to Shop Metafield and import it into Shopify Flow.

Import screen in Shopify Flow

After installation, click the "Edit" button to edit.

Edit button in Shopify Flow

Click "Run Code" in the middle to make simple settings.

Run Code Click

In the opened Run Code, set "deliveryDateKeys" and "deliveryTimeKeys" to the strings of Change Text label.
(If you have set the YYYY-MM-DD format in Integration Format, set it to the label for integration format.)

Run Code edit

Save the workflow and turn on the workflow to complete.

Turn on the workflow

Send reminder emails for orders with upcoming delivery dates

Download Reminder Delivery Schedule and import it into Shopify Flow.

Import screen in Shopify Flow

Open the imported Shopify Flow workflow and click edit.

Edit the workflow

Click "Schedule to Run" and specify the reminder date and time.
(The default setting is a daily repeat at 10 AM.)

Schedule settings

Click "Run Code" and set the orders with delivery dates from x days to y days from today to be included in the reminder email.
startDateFromToday: from x days
endDateFromToday: to y days
(The default setting includes delivery dates from 0 days to 6 days from today in the reminder email.)

Run Code edit

Change the "Email address" in "Send Internal email" to the desired recipient.

Send Internal email edit

Save the workflow and turn on the workflow to complete.