Automatically disable unsold Magento 2 products after 1 year with Gmail approval

This workflow is designed for Magento 2 merchants who want to automatically identify and deactivate products that haven't been sold in the past 12 months, helping to maintain a clean and optimised catalog. This automation includes order analysis, product comparison, management approval, and automated product deactivation, with full reporting and transparency. 🔧 What It Does - 1st of Every Month at 8 AM, it triggers a scheduled cleanup. - Calculates the date 12 months ago from the current day. - Fetches all Magento 2 orders created in the last 12 months via REST API. - Extracts all SKUs of products sold during that period. - Fetches the entire product catalog from Magento 2. - Compares all products with sold SKUs to determine which products had zero sales in the last year. - Prepares an HTML email report (including SKU, Name, Price, Status) of the unsold products. - Sends the report to the merchant (e.g., [email protected]) for approval via interactive email (Approve / Decline). - If approved, each product is automatically disabled (status updated to 1) in Magento 2 using the REST API. - Aggregates all disabled products and sends a confirmation email with a summary and product table. - Ensures safe operations with conditional logic and user review before taking any action. 🧠 Key Features - ✅ Fully automated detection of inactive inventory. - ✅ Uses n8n's Gmail Approval Node for human decision-making. - ✅ Works with Magento 2’s REST API and handles large product sets with batching and aggregation. - ✅ Includes fail-safe conditional checks (e.g., don’t run if no orders are found). - ✅ Clean HTML email reports with product metadata. - ✅ Modular and scalable for different business sizes or intervals. 📦 Use Case Perfect for: - Magento 2 store owners or managers - Digital operations teams aiming for lean product catalogs - Agencies maintaining Magento-based ecommerce stores - Any business needing automated product lifecycle management 🔐 Credentials Required - Magento 2 API Bearer Token (for reading orders and updating products) - Gmail OAuth2 (for sending approval and summary emails) 🛠️ Customizable Parameters - Trigger interval (currently set to monthly at 8 AM) - Email recipients for approval and notifications - Product status change (can be extended to delete or archive instead of disabling) 🧩 Workflow Stack - Trigger: Schedule (Monthly) - Nodes Used: - HTTP Request - Code (JavaScript) - IF Condition - Gmail (Approval & Notification) - Split Out / Split in Batches - Aggregate - Merge