n8n Workflow: Shopify Sales Inventory Management

This n8n workflow automates the process of managing inventory levels on Shopify based on sales data, with a weekly scheduled check and notifications for low stock.

What it does

This workflow simplifies inventory management by:

1. Weekly Schedule: Triggers every Monday at 9:00 AM to initiate the inventory check.
2. Date Calculation: Determines the date range for the past week's sales (e.g., last 7 days).
3. Fetch Shopify Sales: Retrieves all orders from Shopify within the calculated date range.
4. Process Order Data: Extracts relevant product information and quantities from the sales data.
5. Calculate Inventory Adjustments: Determines how much inventory needs to be deducted for each product sold.
6. Apply Inventory Adjustments (Shopify): Updates the inventory levels for affected products in Shopify.
7. Identify Low Stock: Checks for products that have fallen below a predefined low stock threshold after adjustments.
8. Generate Low Stock Report: Compiles a list of products with low stock.
9. Notify via Slack: Sends a notification to a designated Slack channel with the low stock report.
10. Log Activity: Records the successful completion of the inventory update or any issues.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Shopify Account: With API access configured for inventory management and order reading. A Shopify credential needs to be set up in n8n.
• Google Sheets Account: (Optional, but indicated by the presence of a Google Sheets node) A Google Sheets credential might be needed if the Function node is interacting with a sheet for data processing or logging.
• Slack Account: A Slack credential configured in n8n to send notifications.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Shopify: Set up a Shopify credential with the necessary API keys and permissions to read orders and manage inventory.
   • Slack: Create a Slack credential and select the channel where you want to receive low stock notifications.
   • Google Sheets: If the Function node or other parts of the workflow interact with Google Sheets, ensure a Google Sheets credential is set up.
3. Review Node Configurations:
   • Cron Node (ID: 7): Verify the schedule is set to your desired weekly trigger (default is Monday 9 AM).
   • Function Node (ID: 14): This node likely contains custom JavaScript logic for processing sales data, calculating inventory, and identifying low stock. Review and adjust the code if your product data structure or low stock thresholds are different.
   • Shopify Node (ID: 312): Ensure the "Operation" and "Resource" are correctly configured for reading orders and updating product inventory.
   • Slack Node (ID: 40): Confirm the message content and target channel for notifications.
4. Activate the Workflow: Once configured, activate the workflow in n8n. It will automatically run on its scheduled weekly basis.