Start every day with your Shopify sales and stock
Every morning, one email with yesterday's Shopify orders, sales and best sellers, and every tracked item running low or sold out.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1ShopifyGet shopReads your store's name, currency and time zone, so yesterday runs midnight to midnight where your store is and money shows in its own currency.
Repeats while
moreOrderPagesis true- 2ShopifyList ordersReads every order placed yesterday, page by page, and the same weekday a week before, leaving out test, cancelled, voided and fully refunded orders.
- 2
Repeats while
moreWeekBeforePagesis true- 3ShopifyList orders
- 3
For each
order- 4ShopifyGet orderOpens yesterday's orders one at a time, up to 100, to count the units of each product for the top five.
- 4
Repeats while
moreVariantPagesis true- 5ShopifyList product variantsReads every item in your catalogue with its stock, to find the tracked ones at or below your low-stock level.
- 5
- 6GmailSendEmails you the brief: the day's numbers in the subject line, then sales against last week, the top products and the stock to watch.
How it works
What happens on each run, in plain English.
Every morning at 07:00 you get one email about your Shopify store, instead of piecing yesterday together from several admin screens. It leads with yesterday's orders, sales and average order, each compared with the same weekday a week before. Then come the five products that sold the most units, and every tracked item at or below your low-stock level, sold-out items first, so you hear about a sell-out before a customer does.
Yesterday runs from midnight to midnight in your store's own time zone, and test, cancelled, voided and fully refunded orders are left out. A day with no orders still gets its email, saying so. If Shopify cannot be read, nothing is sent and the run is marked as failed, so a problem never passes for a quiet day. On a very busy day the product ranking counts the first 100 orders and says so, while the order count and sales always cover every order; an order that cannot be opened for the ranking is named in the email, and the run is marked as failed.
You need a Shopify connection that can read orders, products and inventory, a Gmail account to send from, and the email address the brief should go to.
You may also be interested in
Low stock and expiry alerts for your pharmacyChecks your pharmacy inventory sheet every morning and emails the medicines running low or near expiry, marking each in the sheet.Daily inventory monitor for low stock and expiryChecks your inventory sheet every morning and emails what is out of stock, running low, expired or expiring soon, marking each row.
Turn order emails into spreadsheet rowsReads order emails hourly, has AI pull out each line item, and appends it to your order sheet.
Never miss a filing or renewal deadlineChecks your deadline sheet each morning and emails you as each licence, permit, tax filing or renewal comes due, with a calendar event.Start from a workflow that already works.
Add "Start every day with your Shopify sales and stock" to your workspace, connect its apps, and make it yours.
Free plan, no credit card