Automatic Magento 2 product & coupon alerts to Telegram with duplicate protection

Boost Sales with Automated Magento 2 Product and Coupon Notifications ---------------------------------------------------- This n8n workflow automatically posts new Magento products & coupons to Telegram while preventing duplicates. Key benefits: ✅ Increase conversions with time-sensitive alerts (creates urgency) ✅ Reduce missed opportunities with 24/7 monitoring ✅ Improve customer engagement through rich media posts ✅ Save hours per week by automating manual posting Why This Works: 1. Triggers impulse buys with real-time notifications 2. Eliminates human error in duplicate posting 3. Scales effortlessly as your catalog grows 4. Provides analytics through database tracking Perfect for e-commerce stores wanting to: Announce new arrivals instantly Promote limited-time offers effectively Maintain consistent social presence Track performance through MySQL This workflow automatically: ✅ Detects new products AND coupons in Magento ✅ Prevents duplicate postings with MySQL tracking ✅ Posts rich formatted alerts to Telegram ✅ Runs on a customizable schedule ✨ Key Features -------------- For Products: Product name, price, and image Direct store link Media gallery support For Coupons: Coupon code and status Usage limits (times used/available) Active/inactive status indicator Core System: 🔒 MySQL duplicate prevention⏰ 1-hour schedule (customizable)📱 Telegram notifications with Markdown 🛠️ Configuration Guide ----------------------- Database Setup CREATE TABLE IF NOT EXISTS posteditems (itemid INT PRIMARY KEY, itemtype ENUM('product', 'coupon') NOT NULL, itemvalue VARCHAR(255), posted BOOLEAN DEFAULT FALSE, createdat TIMESTAMP DEFAULT CURRENTTIMESTAMP, updatedat TIMESTAMP DEFAULT CURRENTTIMESTAMP ON UPDATE CURRENTTIMESTAMP); Required Credentials 1. Magento API (HTTP Header Auth) 2. MySQL Database 3. Telegram Bot Sticky Notes ❗ IMPORTANT SETUP NOTES ❗ 1. For products: Ensure 'urlkey' exists in customattributes 2. For coupons: Magento REST API must expose coupon rules 3. MySQL user needs INSERT/SELECT privileges 4. Telegram bot must be added to your channel first 🔄 SCHEDULING: - Default: Checks every 1 hours at :00 - Adjust in Schedule Trigger node ⚙️ Technical Details -------------------- Workflow Logic: 1. Checks for new products/coupons via Magento API 2. Verifies against MySQL database 3. Only posts if record doesn't exist 4. Updates database after successful post Error Handling: Automatic skip if product/coupon exists Empty result handling Connection timeout protection 🌟 Why This Template? --------------------- Complete Solution: Handles both products AND coupons Battle-Tested: Prevents all duplicates reliably Ready-to-Use: Just add your credentials Fully Customizable: Easy to modify for different needs Perfect for e-commerce stores using Magento 2 who want automated, duplicate-free social notifications!