Automated Low Stock Reordering and Purchase Management

This workflow automates inventory management by monitoring product stock levels, calculating the necessary re-order quantities, and streamlining purchase order creation and dispatch. Scheduled to run nightly, it begins by fetching products with low stock from Airtable, then gathers supplier details for those products. It calculates dynamic re-order quantities based on current stock and demand forecasts, ensuring optimal inventory levels. The workflow also checks for existing purchase orders to prevent duplicates, groups products by suppliers, and creates new purchase records in Airtable. Additionally, it sends email notifications to suppliers with purchase orders via SendInBlue. This automation reduces manual effort, prevents stockouts, and improves order accuracy, making it ideal for managing supply chain operations smoothly.