Daily email summary of items ordered in the past 24 hours

Shopify Plus

Topic summary

A user wants to automate a daily email listing unfulfilled line items (not just order numbers) from the past 24 hours to streamline pick-and-pack operations for staff.

Current Challenge:

  • Successfully sends order lists but cannot extract individual line items.

Suggested Solutions:

  1. Shopify Flow - Native tool that can trigger emails based on conditions, though uncertainty exists about whether it supports multiple fields or detailed line item extraction.

  2. Zapier Integration - Third-party workflow automation app available in the Shopify App Store.

  3. Custom Application - Build a solution using webhooks for order creation, extract line items programmatically, and send emails via services like Amazon SES.

  4. Report Pundit App - Offers scheduled reports with customization options, delivery to FTP/Google Drive/BigQuery, and shareable links for staff access.

The discussion remains open with multiple approaches proposed but no confirmed implementation yet.

Summarized with AI on October 31. AI used: claude-sonnet-4-5-20250929.
1

I would like to set up a flow that sends me a daily email of the line items ordered that remain unfulfilled. This way a staff member can easy pick pack the orders to go out.
So far I have managed to send just a list of orders not the individual line items.

2

You can use Shopify Flow to accomplish this. It allows you to set up a trigger and send an email based on that trigger. Otherwise, you would need to develop a custom application, set up a webhook for order creation, extract the line items, and use an email service like Amazon SES to send emails.

3

Hi @antheads ,

For this there are two options:

  1. zapier app for work flow: https://apps.shopify.com/zapier

  2. Need to create custom app.

Hope this help, let me know if you need more help.

Regards,

4

@antheads ,

Shopify can provide this report. However, with Shopify Flow, you can set up conditions and send reports, but I’m not sure if it can include mutliple fields.

For more details, you can refer to these Shopify docs:
https://www.shopify.com/in/flow
https://www.shopify.com/blog/flow-schedules-data-fetching

If you are looking for customization or scheduled reports to FTP, Google Drive, or BigQuery, you can try Report Pundit. You can also use the Share Report option, which allows staff members to view the data through the shared link.