Automatically Disable Unsold Magento 2 Products After 1 Year with Gmail Approval

This n8n workflow automates the process of identifying and disabling unsold Magento 2 products that have been in stock for over a year, incorporating a human approval step via Gmail. This ensures that old, stagnant inventory is removed from the storefront while providing an opportunity for review before changes are applied.

What it does

This workflow performs the following actions:

1. Schedules Execution: Runs automatically on a defined schedule (e.g., daily, weekly).
2. Fetches Magento Products: Makes an API request to Magento 2 to retrieve a list of products.
3. Filters Unsold Products: Processes the retrieved products to identify those that have been in stock for more than one year and have not been sold.
4. Generates Approval Request: Creates a summary of the identified products and sends an email via Gmail to a designated approver, requesting confirmation to disable these products.
5. Waits for Approval: Pauses the workflow execution until a response (approve/deny) is received from the Gmail approval email.
6. Processes Approval:
   • If approved, it proceeds to disable the products in Magento 2.
   • If denied, it terminates the workflow without making any changes.
7. Disables Products (if approved): For each approved product, it sends an API request to Magento 2 to update its status to disabled.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Magento 2 API Access:
  • A Magento 2 instance.
  • API credentials (e.g., OAuth 1.0a consumer key and secret, or a bearer token) with permissions to read product data and update product status.
• Gmail Account:
  • A Gmail account configured as a credential in n8n.
  • The Gmail account must have permissions to send and receive emails.

Setup/Usage

1. Import the Workflow:
   • Copy the provided JSON code.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the three dots (...) in the top right corner and select "Import from JSON".
   • Paste the JSON code and click "Import".
2. Configure Credentials:
   • Locate the "HTTP Request" node (ID: 19) and configure your Magento 2 API credentials. This typically involves setting up an OAuth 1.0a or Bearer Token credential.
   • Locate the "Gmail" node (ID: 356) and configure your Gmail account credentials. This will likely require setting up a Google OAuth2 credential.
3. Customize Workflow Nodes:
   • Schedule Trigger (ID: 839): Adjust the schedule to your desired frequency (e.g., daily, weekly, monthly).
   • HTTP Request (ID: 19):
     • Update the Magento 2 API endpoint for fetching products.
     • Modify the query parameters to filter products as needed (e.g., status, created_at, type_id).
   • Code (ID: 834): This node likely contains the logic to filter products based on the "in stock for over a year" condition. You may need to adjust the date calculation or other filtering criteria to match your specific business rules.
   • Gmail (ID: 356):
     • Set the "To" email address for the approver.
     • Customize the subject and body of the approval email to provide clear instructions and product details.
     • Ensure the "Wait for Approval" option is correctly configured.
   • HTTP Request (within the "If" branch for approval): Update the Magento 2 API endpoint and request body to correctly disable products based on their sku or id.
4. Activate the Workflow: Once all configurations are complete, activate the workflow by toggling the "Active" switch in the top right corner of the workflow editor.