Automate Your Inventory Reordering with Airtable & n8n
detail.loadingPreview
Never run out of stock again. This workflow automatically identifies low-stock products in Airtable and generates purchase orders, ensuring your inventory stays optimized.
About This Workflow
This powerful workflow streamlines your inventory management by proactively identifying products that are running low on stock. It connects to your Airtable base, checks your Products Table against your reorder_threshold, and then intelligently calculates the optimal reorder quantity based on average daily sales and lead times. For each low-stock item, it retrieves crucial supplier details and creates a new record in your Purchase Orders table, complete with the product name, supplier information, and the calculated reorder quantity. Scheduled to run nightly, this automation ensures you're always one step ahead in maintaining optimal stock levels and efficient procurement.
Key Features
- Automated Low-Stock Detection: Continuously monitors your product inventory for items falling below reorder thresholds.
- Intelligent Reorder Quantity Calculation: Dynamically determines the ideal quantity to reorder based on sales velocity and lead times.
- Supplier Data Integration: Seamlessly pulls supplier details for each product to populate purchase orders.
- Purchase Order Generation: Automatically creates new records in your Airtable
Purchase Orderstable. - Scheduled Execution: Runs nightly to ensure your inventory data is always up-to-date.
How To Use
- Connect Airtable: Ensure your Airtable Personal Access Token account is configured and authorized.
- Configure 'Get Products with low stock': Select your Airtable 'Products Tables' base and 'Products Table'. Set the
filterByFormulato{stock_level} <= {reorder_threshold}. - Configure 'Get supplier Details': This node is implicitly linked by the
supplier_idfrom the previous node. Ensure your 'Products Table' in Airtable has a linked record to your 'Supplier' table. - Customize 'Calculate Dynamic Re-order Quantity': Review and adjust the
jsCodeif yoursafetyMargin,avgDailysales calculation, orlead_time_daysrequire different logic. - Configure 'Create purchase records': Select your Airtable 'Products Tables' base and 'Purchase Orders' table. Map the fields, ensuring
quantityis set to={{ $json.reorder_qty }},product_idto={{ $json.product_id }},supplier_idto={{ $json.supplier_id }},Product Nameto={{ $json.product_name }}, andSupplier Emailto={{ $json.supplier_email }}. - Set 'Run Every Mid Night': Confirm the cron expression
0 0 * * *to run the workflow daily at midnight.
Apps Used
Workflow JSON
{
"id": "974cf220-cfa0-497b-99f6-d3cab64f412e",
"name": "Automate Your Inventory Reordering with Airtable & n8n",
"nodes": 6,
"category": "Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 974cf220-cfa0...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
Universal CSV to JSON API Converter
Effortlessly transform CSV data into structured JSON with this versatile n8n workflow. Integrate it into any application as a custom API endpoint, supporting various input methods including file uploads and raw text.
Instant WooCommerce Order Notifications via Telegram
When a new order is placed on your WooCommerce store, instantly receive detailed notifications directly to your Telegram chat. Stay on top of your e-commerce operations with real-time alerts, including order specifics and a direct link to view the order.
On-Demand Microsoft SQL Query Execution
This workflow allows you to manually trigger and execute any SQL query against your Microsoft SQL Server database. Perfect for ad-hoc data lookups, administrative tasks, or quick tests, giving you direct control over your database operations.