AI-driven inventory management with OpenAI forecasting & ERP integration

This n8n workflow automates the monitoring of warehouse inventory and sales velocity to predict demand, generate purchase orders automatically, send them to suppliers, and record all transactions in ERP and database systems. It uses AI-driven forecasting to ensure timely restocking while maintaining operational efficiency and minimizing stockouts or overstocking.

---

Key Features

Automated Scheduling: Periodically checks inventory and sales data at defined intervals. Real-Time Data Fetching: Retrieves live warehouse stock levels and sales trends. AI Demand Forecasting: Uses OpenAI GPT to predict future demand based on sales velocity and stock trends. Auto-Purchase Orders: Automatically generates and sends purchase orders to suppliers. ERP Integration: Logs completed purchase orders into ERP systems like SAP, Oracle, or Netsuite. Database Logging: Saves purchase order details and forecast confidence data into SQL databases (PostgreSQL/MySQL). Email Notifications: Notifies relevant teams upon successful order creation and logging. Modular Configuration: Each node includes configuration notes and credentials setup instructions.

---

Workflow Process

1. Schedule Trigger

Runs every 6 hours to monitor stock and sales data. Interval can be adjusted for higher or lower frequency checks.