Auto-Disable Unsold Magento 2 Products After 1 Year w/ Gmail Approval
Automatically detects Magento 2 products unsold for 12 months, emails a report for Gmail approval, and disables approved ones to optimize inventory.
This n8n workflow runs monthly on the 1st at 8 AM to maintain a clean Magento 2 catalog by identifying products with zero sales in the past year. It calculates the cutoff date, fetches recent orders via REST API to extract sold SKUs, retrieves the full product catalog, and compares to flag unsold items. An HTML report with SKU, name, price, and status is generated and sent to the merchant (e.g., via Gmail) for interactive approval (Approve/Decline).
Upon approval, it batches and updates each un
- Platform
- n8n
- Category
- E-commerce
- Price
- $24.99
- Creator
- Viktor Guerrero
- Magento 2
- E-commerce
- Inventory Management
- Unsold Products
- Gmail Approval
- Automation
- REST API
- Scheduled Cleanup
- Product Disable
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related E-commerce workflows
- Automate AI-Generated Virtual Try-On Images for WooCommerce$14.99
- Automate E-commerce Visual Content Creation with AI$19.99
- Automate Multilingual Shopify Product Descriptions with AI Vision Analysis$4.99
- Automate 3D Product Video Creation from 2D Images for E-Commerce$14.99
- Automate Shopify SEO Content Creation with GPT-4 & Claude Multi-Agent System$24.99
- Create a Smart Shopping Assistant with Persistent Memory Using Zep, GPT-4, and Google Sheets$4.99
More from Viktor Guerrero
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.