Receive a Daily Order Report Card Email for Shopify

This scheduled trigger runs once per day at 8 AM. The timing delivers yesterday's complete sales data first thing in the morning when planning the day's activities. You can adjust the schedule to run at different times by modifying the schedule value.

This step fetches orders from Shopify using a time range filter. The query parameters include status "any" (captures all orders regardless of fulfillment or payment status), created_at_min set to 24 hours ago, and created_at_max set to now. This ensures the report includes every order placed in the past 24 hours: completed purchases, pending payments, abandoned checkouts converted to orders, and any other order activity. The orders are returned as an array with complete order details including financial status, fulfillment status, line items, and pricing.

Time range calculation: The workflow uses date math to calculate exactly 24 hours before the current time, ensuring consistent reporting windows even as the schedule runs daily.

This step retrieves shop details from Shopify including the myshopify domain. This domain is used in the email template to construct links like the workflow customization link that appears at the bottom of the report card, enabling easy access to modify the workflow or view orders in Shopify admin.

This step runs custom JavaScript that analyzes the order array and calculates key metrics:

1. Total Orders: Counts all orders in the past 24 hours
2. Orders Over $100: Counts orders where total price exceeds $100 (high-value orders)
3. Orders Paid: Counts orders with financial status "paid"
4. Orders Pending: Counts orders with financial status "pending"
5. Orders Fulfilled: Counts orders with fulfillment status "fulfilled"
6. Most Popular Product: Analyzes line items across all orders, counts how many times each product was sold, and identifies the product(s) with the highest sales count

Product popularity logic (from compile_order_data.js): The code maintains a count of each product title across all line items, sorts products by count descending, then returns all products that match the highest count. If multiple products tie for most popular, all are listed comma-separated.

The calculated metrics are returned as an object with properties like orders_total, orders_over_100, orders_paid, orders_pending, orders_fulfilled, and most_popular_product that populate the email template.

This step sends an HTML-formatted email to your configured recipient.

Configuration: You must enter the email address during setup—this could be your personal email, a team distribution list, or a business intelligence tool. The email includes:

1. Subject: "Order Report Card for [current date]"
2. Body: Professional HTML template with MESA branding, the 24-hour date range covered, and a metrics section with:
3. Total Orders count
4. Total Orders Over $100 count
5. Total Orders Paid count
6. Total Orders Pending Payment count
7. Total Orders Fulfilled count
8. Most Popular Product(s) Sold (comma-separated if multiple tied)
9. Customization link: Direct link to edit this workflow in MESA

Email formatting: The HTML template uses responsive design that displays properly on desktop and mobile email clients with clear typography, colored sections, and structured layout for scannable metrics.