Email a Daily Out-of-Stock Report

5 min setup
No coding required
Runs automatically

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.

schedule icon
Every morning at 7am
Find every sold-out variant in Shopify
google sheets logo icon
Log today's stockout count to Google Sheets
email icon
Email the sold-out list to your team

How it works

5 steps to start every day knowing exactly what's sold out

schedule icon

Every morning at 7am

App connector: Schedule • Time to complete: 1 minute

Runs once a day.

Find every sold-out variant in Shopify

App connector: Shopify • Time to complete: 1 minute

Run a productVariants query filtered to inventory_quantity:<=0 for tracked, active products. Return the product title, variant title, SKU, vendor and inventory quantity.

Build the list of sold-out variants

App connector: Loop • Time to complete: 1 minute

Turn the variants into one list with a line per variant: product, variant, SKU, vendor.

google sheets logo icon

Log today's stockout count to Google Sheets

App connector: Google Sheets • Time to complete: 1 minute

Add a row with the date and the number of sold-out variants.

email icon

Email the sold-out list to your team

App connector: Email • Time to complete: 1 minute

Email the list with the total count in the subject, for example 12 variants out of stock today.

Trusted by 1,000+ merchants
Logo: Rothy's Logo: Adidas Logo: Allure Logo: GQ Logo: DraftKings Logo: Chubbies Logo: Made In Cookware Logo: MUD/WTR

Ready to start every day knowing exactly what's sold out

Get setup in 5 minutes.

Use this template →

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:

Set custom delays
Schedule actions to trigger after a set time period, such as sending follow-up emails 3 days after an event.
Chain multiple actions
Connect several steps together in one workflow, like tagging data, updating records, and notifying your team simultaneously.
Store data in tables
Save order details, customer preferences, or custom metrics in your own database for reference and reporting.
Deploy AI agents for smart decisions
Let AI agents evaluate complex scenarios and choose the right action path based on your defined rules.

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."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

start every day knowing exactly what's sold out

5 min setup • Fully supported if you need help