Analyze WooCommerce category sales over time with Airtable and Slack
Ready for 3.0What this workflow does
This workflow has 16 nodes and runs on a schedule (every day). Along the way it connects WooCommerce, Airtable and Slack.
How it runs
Trigger: On a schedule (every day).
- Report Configuration (Edit Fields (Set)): sets 7 fields: granularity, top_categories_limit, top_performer_pct…
- Calculate Reporting Periods (Code): runs custom JavaScript code
- Fetch Orders — Previous Period (WooCommerce): get many (order)
- Fetch Orders — Current Period (WooCommerce): get many (order)
- Fetch Products (WooCommerce): get many
- Normalize Order Items — Previous (Code): runs custom JavaScript code
- Normalize Order Items — Current (Code): runs custom JavaScript code
- Category Map (Code): runs custom JavaScript code
- Combine Orders & Products (Merge): merges the data from its input branches
- Aggregate Sales by Category (Code): runs custom JavaScript code
…plus 5 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 - Edit Fields (Set)
n8n-nodes-base.set - WooCommerce
n8n-nodes-base.wooCommerce - Merge
n8n-nodes-base.merge - Airtable
n8n-nodes-base.airtable - Slack
n8n-nodes-base.slack
From the author
WooCommerce Product Category Sales Performance Report This workflow automatically analyzes sales data by product category, compares performance across time periods (daily, weekly or monthly), stores structured results in Airtable and sends a clear summary to…