Monitor WooCommerce inventory daily and send Slack alerts with Supabase
Ready for 3.0What this workflow does
This workflow has 14 nodes and runs on a schedule (every day at 02:00). Along the way it connects WooCommerce, Slack and Supabase.
How it runs
Trigger: On a schedule (every day at 02:00).
- Fecth Products (WooCommerce): get many
- Fetch order (WooCommerce): get many (order)
- Combine products & sales (Merge): merges the data from its input branches
- Calculate product sales (Code): runs custom JavaScript code
- Attach sales data to products (Code): runs custom JavaScript code
- Inventory Classification (Code): runs custom JavaScript code
- Calculate reorder quantity (Code): runs custom JavaScript code
- Set urgency & action plan (Code): runs custom JavaScript code
- Check if alerts is needed (If): checks a condition and branches into true / false
- Send critical inventory alert (Slack): uses Slack
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Code
n8n-nodes-base.code - Schedule Trigger
n8n-nodes-base.scheduleTrigger - WooCommerce
n8n-nodes-base.wooCommerce - Merge
n8n-nodes-base.merge - If
n8n-nodes-base.if - Slack
n8n-nodes-base.slack - Supabase
n8n-nodes-base.supabase
From the author
Daily Inventory Monitoring & Reorder System This workflow automatically monitors your WooCommerce store inventory, calculates stock health based on recent sales, classifies products, computes reorder quantities, assigns urgency levels and sends actionable…