Inventory Reorder Automation Designer
Design a stock-replenishment workflow using demand, lead time, safety stock, supplier constraints, approvals, and exception handling.
Operations teams automating routine replenishment while retaining control over costly, uncertain, or perishable orders.
You are a supply operations automation specialist who designs controlled inventory replenishment workflows.
Inputs:
1. Products, locations, inventory systems, and service targets: {{inventory_context}}
2. Demand history, forecasts, lead times, and variability: {{planning_data}}
3. Suppliers, pack sizes, minimums, prices, and delivery calendars: {{supplier_rules}}
4. Purchase authority, budgets, approvals, and receiving process: {{controls}}
5. Data quality, shelf-life, capacity, and operational constraints: {{constraints}}
Do the following:
1. Define the stock position using on-hand, allocated, in-transit, backordered, quarantined, expired, and expected demand data, including freshness requirements.
2. Design reorder triggers and quantities using approved policy for lead-time demand, safety stock, service level, order cycles, pack sizes, minimums, shelf life, storage, and budget.
3. Separate automatic recommendations, automatic orders, and mandatory human review based on value, uncertainty, novelty, supplier change, demand spike, and data confidence.
4. Specify supplier selection, approval, purchase-order creation, acknowledgement, delivery tracking, receiving reconciliation, substitutions, shortages, and cancellation behavior.
5. Produce a calculation table, workflow states, approval matrix, exception queue, alerts, reconciliation rules, simulation plan, and rollback controls. Do not invent forecasts or allow low-quality data to trigger irreversible orders.How to use
- Define stock states and authoritative systems.
- Use approved service and safety-stock policies.
- List supplier pack and calendar constraints.
- Simulate the workflow before enabling automatic orders.
Example input
Context: Five veterinary clinics stocking 420 medical and office items. Target: 98% availability for critical medicines and 95% for routine supplies. Data: daily inventory, usage history, supplier lead times of 1-12 days, and open purchase orders. Rules: cold-chain products have strict capacity and shelf life; controlled medicines require pharmacist approval; supplier packs vary. Constraints: orders above EUR 3,000 need finance approval and new substitutes cannot be ordered automatically.
Example output
The workflow calculates net stock by clinic and excludes expired or quarantined units. Routine stable supplies create draft orders using lead-time demand, safety stock, packs, and minimums. Controlled, cold-chain, high-value, low-confidence, and substitute items route to specialized review. Supplier acknowledgement updates inbound stock, receiving reconciles quantity and expiry, and unconfirmed orders trigger escalation before another order can duplicate them.
Customization tips
- — Start with recommendations before full automation.
- — Route novel and low-confidence demand to review.
- — Reconcile supplier acknowledgements and receipts.
- — Protect cold-chain capacity and shelf life.
Tags
FAQ
What is this prompt for?
How should I customize it?
Are there any limitations?
How is it different from a basic prompt?
Related Prompts
All Automation Workflows prompts →Vendor Onboarding Due Diligence Workflow
Design a risk-based vendor onboarding automation covering intake, due diligence, approvals, remediation, setup, and ongoing ownership.
End-to-End Process Automation Blueprint
Design a complete automation blueprint for a manual business process, including trigger logic, tool selection, exception handling, and rollback plans.
Automation Failure Monitoring & Recovery
Create an observability and incident-recovery design for business automations, including logs, alerts, retry policy, ownership, replay, and post-incident review.
Related Skills
Data Quality Exception Automation Designer
Design automated handling for data-quality exceptions using detection, severity, ownership, evidence, remediation, escalation, and closure rules.
Human Approval Queue and Exception Automation Designer
Design reliable human-review queues for uncertain, risky, incomplete, or policy-exception cases in automated workflows.
AI Coding Agent Workflow Builder
Design safe AI coding-agent workflows for planning, repository exploration, implementation, testing, review, and controlled changes.