Automated Inventory Cleanup for Unsold Products

This n8n workflow streamlines inventory management by automatically identifying products that haven’t been sold in the past year, and then facilitates their deactivation through a structured approval process. The workflow initiates on a monthly schedule, retrieves recent orders, and extracts SKUs of sold items. It fetches the complete product catalog from a Magento 2 store and filters out products that remain unsold over the last 12 months. An email is then sent to designated stakeholders, listing these inactive items and requesting approval for deactivation. Upon approval, the workflow automatically updates the product status to inactive on Magento, generates a comprehensive report, and notifies the team of the changes. This automation helps maintain a clean, efficient product catalog, reducing inventory clutter and optimizing sales strategies.