Low-stock reorder alerts from Shopify inventory
A daily check of Shopify stock levels against sales pace that flags SKUs running low and drafts a reorder note for the buyer to approve.
The use case
Small stores often notice a stockout only after a best seller shows sold out. Inventory counts live in Shopify, lead times live in someone's head or a spreadsheet, and nobody has time to compare them every morning. This agent reads current on-hand quantities, recent sales velocity, and the supplier lead time you record per SKU. It estimates how many days of stock remain, flags items that will run out before a new shipment could arrive, and drafts a short reorder suggestion grouped by supplier. The buyer reviews the list, adjusts quantities, and places any purchase order themselves. Nothing is ordered automatically.
Example workflow
- A scheduled job runs each morning and pulls on-hand inventory by SKU and location from a Shopify export or API connection.
- The agent reads the last few weeks of sales per SKU plus the lead time and minimum order quantity stored in a Google Sheet.
- It calculates estimated days of cover and marks any SKU whose cover is shorter than lead time plus a safety buffer you set.
- Flagged items are grouped by supplier and the agent drafts a suggested reorder quantity with a one-line reason for each.
- The draft is posted to a Slack channel or emailed to the buyer, who edits quantities and decides what to order.
- Approved reorders are placed by the buyer in the usual way, and the sheet logs the date, SKU, and decision for later review.
Tools
- Shopify
- Google Sheets
- Claude
- Zapier or Make
- Slack
- Gmail
Risks and guardrails
- Seasonal spikes or a one-off bulk order can skew sales pace — guardrail: the buyer sees the sales window used and can override any suggested quantity.
- Stale lead times produce alerts that are too late — guardrail: the sheet shows when each lead time was last updated and the agent flags entries older than a set age.
- Inventory split across locations may look healthier than it is — guardrail: the report lists stock per location, not just the total.
- A wrong SKU mapping could suggest ordering the wrong product — guardrail: the agent never contacts suppliers or creates purchase orders; a person places every order.
Related recipe
Supplier Purchase Order Follow-Up Agent: An agent scans your PO tracker for missing confirmations, ship dates, ASNs, and late orders, drafts supplier follow-ups for a buyer to approve, and proposes ETA updates only after a person checks the reply.
Want it set up for you? Request a quote.
Sources
Written by Agents Lookup. Credits and official pages for the tools this use case names:
- Shopify Dev MCP server (AI Toolkit) (official page): shopify.dev/docs/apps/build/ai-toolkit (checked 2026-11-09)
- Claude (official page): claude.ai (checked 2026-11-09)
- Zapier MCP (official page): zapier.com/mcp (checked 2026-11-09)
- Make MCP server (official page): developers.make.com/mcp-server (checked 2026-11-09)
- Slack MCP server (official page): docs.slack.dev/ai/slack-mcp-server (checked 2026-11-09)
- Gmail (official page): developers.google.com/workspace/gmail (checked 2026-11-19)