Email purchasing when Shopify products run low

Every morning at 8:00, the workflow checks the stock at one of your Shopify locations and picks out every product with fewer than 10 left to sell.

If any are running low, purchasing gets one email with a table of the product, variant, SKU and how many are left. On a day when stock is fine, nothing is sent.

You need Shopify and Gmail connected. Choose your store's location and type the purchasing team's email the first time you open it. The low-stock limit of 10 can be changed in the stock step. Up to 250 items are checked per run.

Run every day at 08:00.Run every day at 08:00.

Purchasing team's emailSet purchasing_email to blank.

Products with fewer than 10 leftList stock at (not set). Save it as low_stock.Shopify

If low_stock.count is greater than 0If low_stock.count is greater than 0

Yes

Table of low stock productsMake a table of low_stock.inventory_levels Save it as table.

Email purchasingSend an email to purchasing_email. Save it as emailed. Subject: Products running lowtable.htmlGmail

No

No steps