Store automation · Runs every week
Find products likely to run out before a reorder arrives.
Stock levels and daily sales, ranked by days of stock remaining. Run this automation in Fieldwork chat, or schedule it to email you a report when something needs attention.
Find products likely to run out before a reorder arrives — Sep 14
Automation run • Sep 14
Find products likely to run out before a reorder arrives
Output
Six variants could run out before a reorder arrives, including one already out of stock. Estimated revenue at risk is $14,900, with $12,654 concentrated in Alder Wool Throw and Cascade Merino Crew.
Reviewed Harbor & Pine’s September 7–13 orders and September 14 inventory at Portland Warehouse. Assumes steady daily demand and a 21-day supplier lead time. Arrival dates are unconfirmed.
| Variant | Stock | Avg. units/day | Days left | Price | Revenue at risk |
|---|---|---|---|---|---|
| Alder Wool Throw, Ember Stripe | 0 | 2 | 0 | $158 | $6,636 |
| Cascade Merino Crew, Fog M | 12 | 3 | 4 | $118 | $6,018 |
| Mariner Wool Sock, Navy L/XL | 10 | 2 | 5 | $24 | $768 |
| Basalt Enamel Mug, Slate | 14 | 2 | 7 | $26 | $728 |
| Summit Alpaca Beanie, Oat | 10 | 1 | 10 | $44 | $484 |
| Cedar Grove Candle, Coast Fog | 14 | 1 | 14 | $38 | $266 |
Risk = max(0, 21 × daily sales − stock) × price, rounded to whole dollars. This estimates unmet demand at listed prices, not guaranteed lost sales.
- Ember Stripe has been unavailable since Thursday, with 12 orders placed since then. Fog Stripe and Pine Stripe each have over 40 days of stock.
- Supply actual supplier lead times to replace the assumption.
- Next week's check should flag variants newly below 14 days of stock, using this comparison if available.
Automation steps. The agent follows these 4 steps each time it runs, using your connected store.
- 1
Use recent sales and current inventory to find SKUs likely to run out before a purchase order placed today would arrive.
- 2
Rank them by estimated days of stock remaining.
- 3
Show units in stock, average daily sales, and revenue at risk.
- 4
Identify any already out of stock.
Adjust the automation in Chat
Run this automation and tell the agent what to do differently. Ask it to schedule that version if you want the changes in future runs.
- Use each supplier's actual lead time.
- Exclude discontinued products.
- Rank stockout risks separately by warehouse.
Fieldwork emails the scheduled report. Each email links to the full run as a conversation in Fieldwork. The automation asks the agent to keep a log in your knowledge base and read it before each run to check what has changed.
Adjustable schedule
Choose how often it runs at setup, from hourly to monthly. Ask in Fieldwork chat for a custom schedule and timezone.
Only useful reports
When nothing needs attention, the run skips the email. When there are findings, you get a report with a link to the full conversation.
Read-only access
The agent reads your store without changing the source. It can keep notes and a run log in your Fieldwork knowledge base.
This automation reads your store. Connect Shopify, BigCommerce, or WooCommerce to Fieldwork. The automation uses whichever you connect.
More automations for store.
Questions about this automation.
- How do I set this up?
- Connect Shopify, BigCommerce, or WooCommerce, then run it in chat or activate weekly reports. Weekly runs happen every seven days from activation.
- Will it change my store?
- Scheduled runs have read-only store access. They report risks without changing inventory or placing purchase orders.
- Can I change what it checks?
- Ask in chat for different lead times, product exclusions, or warehouse comparisons. Ask to schedule that version for future reports.
- Where does the report arrive?
- Scheduled reports arrive by email with a link to the full conversation. If nothing needs attention, no email or push notification is sent.
Security first
Your data stays yours. Your data is never used to train any AI model - not ours, not a provider's. Fieldwork is GDPR compliant and certifying against SOC 2 and ISO 27001, with encryption in transit and at rest, and org-level access controls throughout.
Try Fieldwork
$50 / user / mo introductory pricing. AI quota included.
- ✓Down from $99 / user / mo
- ✓All platform features
- ✓Early access, no card required