Magento 2 Low Stock Alert via Slack & Gmail (MSI Compatible)

This n8n workflow automates the process of checking for low-stock products in a Magento 2 store (compatible with Multi-Source Inventory - MSI) and sends out alerts via Slack and/or Gmail. It helps store managers stay informed about critical stock levels, enabling timely restocking and preventing out-of-stock situations.

What it does

This workflow performs the following steps:

1. Schedules a Check: The workflow is triggered on a predefined schedule (e.g., daily, hourly) to initiate the stock check.
2. Fetches Product Data: It makes an HTTP request to a Magento 2 API endpoint to retrieve product information, likely including stock levels.
3. Processes Product Data: A Code node is used to process the raw data received from Magento, likely extracting relevant product details and stock quantities.
4. Filters for Low Stock: An If node evaluates the processed product data to identify items that have fallen below a specified low-stock threshold.
5. Sends Slack Alert (Optional): For products identified as low stock, it sends a notification to a designated Slack channel with details about the affected products.
6. Sends Email Alert (Optional): Additionally, for low-stock products, it can send an email notification via Gmail to a specified recipient list.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Magento 2 Store: Access to a Magento 2 store with API access enabled.
• Magento 2 API Credentials: API URL and authentication details (e.g., OAuth tokens or API keys) for your Magento 2 instance.
• Slack Account: A Slack workspace and a configured Slack credential in n8n to post messages.
• Gmail Account: A Gmail account and a configured Gmail credential in n8n to send emails.

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file for this workflow.
   • In your n8n instance, click "New" to create a new workflow.
   • Go to "File" > "Import from JSON" and upload the downloaded JSON file.
2. Configure Credentials:
   • HTTP Request (Magento): Edit the "HTTP Request" node (ID: 19).
     • Update the URL to your Magento 2 API endpoint for fetching product data (e.g., /rest/V1/products).
     • Configure the Authentication method (e.g., OAuth2, API Key) with your Magento credentials.
   • Slack: Edit the "Slack" node (ID: 40).
     • Select or create a new Slack credential.
     • Specify the Channel where alerts should be posted.
     • Customize the Text of the message as needed, using expressions to include product details.
   • Gmail: Edit the "Gmail" node (ID: 356).
     • Select or create a new Gmail credential.
     • Enter the To email address(es) for recipients.
     • Customize the Subject and Body of the email, using expressions to include product details.
3. Configure Low Stock Threshold:
   • Edit the "Code" node (ID: 834) to adjust the logic for identifying low-stock products. This is where you'll define what constitutes "low stock" based on your product data structure.
   • Edit the "If" node (ID: 20) to refine the conditions for triggering alerts based on the output of the "Code" node.
4. Set Schedule:
   • Edit the "Schedule Trigger" node (ID: 839).
   • Configure the desired Interval (e.g., every hour, once a day) for the workflow to run.
5. Activate the Workflow:
   • Once all configurations are complete, save the workflow.
   • Toggle the workflow to "Active" to start monitoring your Magento 2 stock levels.