Overview
This workflow automates the process of disabling Magento 2 products that have not been sold in the past year, incorporating a Gmail-based approval step for added control.
Key Features
- Scheduled trigger to run the process periodically
- Fetches all orders from the past year and extracts sold SKUs
- Retrieves all current product SKUs from Magento 2
- Identifies products not sold in the last year
- Sends a Gmail approval request to a designated user before disabling products
- Processes products in batches for efficiency
Benefits
- Reduces manual effort in catalog management
- Prevents outdated or stagnant products from cluttering the store
- Ensures human oversight with Gmail approval before any product is disabled
- Saves time and minimizes errors compared to manual review
Use Cases
- E-commerce managers seeking to keep their Magento 2 catalog up-to-date
- Businesses wanting to automate product lifecycle management with approval workflows
Integrations & Automation
- Integrates Magento 2 via HTTP requests for order and product data
- Utilizes Gmail for approval notifications and responses
- Employs n8n's scheduling, logic, and batch processing capabilities for robust automation
