Example: Shopware Low-Stock Alert Workflow
This example demonstrates how to automatically detect and store low-stock products from multiple Shopware 6 projects defined in Airtable.
It checks stock levels for each project at a scheduled interval, based on the project’s specific low-stock threshold.
Workflow Overview
| Component |
Description |
| Trigger |
Scheduled execution using the Schedule Trigger node. |
| Data Source |
Retrieves project URLs and thresholds from the Airtable “Projects” table. |
| Logic |
Iterates over all projects, checks product stock levels in Shopware via the custom Shopware node. |
| Output |
Stores low-stock summary data in the “Project Low Stock Alerts” table and detailed entries in “Product Low Stock Alerts.” |
Workflow Steps
- Schedule Trigger – Runs at a fixed interval (e.g., every 24h).
- Get Project URLs – Retrieves all Shopware projects and their thresholds from Airtable.
- Loop Over Project URLs – Iterates through each project record.
- Switch Shopware Project Credentials – Chooses the correct Shopware credentials dynamically per project.
- Get Low Stock Products (Per Project) – Fetches all products below the defined stock threshold.
- Serialize Products – Adds useful references such as admin links to each product.
- Filter Project Products – Counts the total number of low-stock products for that project.
- Create Low Stock Project Record – Writes summary data into “Project Low Stock Alerts.”
- Create Low Stock Product Record/s – Logs each low-stock product in the “Product Low Stock Alerts” table, linking it to the project entry.
Airtable Setup
This workflow uses three tables inside the same base:
| Table |
Purpose |
| Projects |
Stores project name, Shopware URL, and threshold. |
| Project Low Stock Alerts |
Stores summary info (project name, total low-stock count, threshold). |
| Product Low Stock Alerts |
Stores per-product low-stock data linked to a project record. |
Download
You can download the ready-to-import n8n workflow JSON below:
Download Shopware Low-Stock Alert Workflow
(Import this file directly into your n8n instance.)
Tips
- Adjust the threshold field in Airtable to customize the alert sensitivity per project.
- Combine with email or Slack nodes to send notifications for low-stock events.
- You can schedule the workflow daily, hourly, or based on custom triggers like webhooks or product updates.
Other Examples
Shopware Sales Report Example Workflow