Auto-Disable Unsold Magento 2 Products After 1 Year w/ Gmail Approval

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 unsold product's status to disabled (status=1) using Magento's REST API. A confirmation email summarizes changes with a product table. Fail-safes like conditional checks prevent actions if no orders exist, ensuring safe operations. Handles large catalogs with aggregation and batching for scalability.

Ideal for e-commerce merchants to automate inventory cleanup, reduce clutter, improve SEO by focusing active products, and save manual review time. Customizable for intervals or thresholds, it boosts efficiency for small to enterprise stores managing inactive stock.