Email a Daily Out-of-Stock Report
Out-of-stock products cost sales quietly. This workflow checks your catalog every morning, lists every variant at zero or below, emails the list to your team and logs the day's count to Google Sheets so you can see whether stockouts are trending up.
How it works
5 steps to start every day knowing exactly what's sold out
Every morning at 7am
Every morning at 7am
Find every sold-out variant in Shopify
Find every sold-out variant in Shopify
Build the list of sold-out variants
Build the list of sold-out variants
Log today's stockout count to Google Sheets
Log today's stockout count to Google Sheets
Email the sold-out list to your team
Email the sold-out list to your team
Ready to start every day knowing exactly what's sold out
Get setup in 5 minutes.
FAQs
Does it include products that don't track inventory?
No. The query only looks at variants with inventory tracking on.
Can I include low stock too?
Yes. Change the filter to inventory_quantity:<=5, or whatever threshold you use.
Why log to Google Sheets?
The daily count shows whether stockouts are rising, which a single email can't.
Personalize this template
Customize this workflow even further:
You're in good company
"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."
"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."
"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"
start every day knowing exactly what's sold out
5 min setup • Fully supported if you need help
