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:

Triggers impulse buys with real-time notifications

Eliminates human error in duplicate posting

Scales effortlessly as your catalog grows

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 posted_items (item_id INT PRIMARY KEY, item_type ENUM('product', 'coupon') NOT NULL, item_value VARCHAR(255), posted BOOLEAN DEFAULT FALSE, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP);

Required Credentials

Magento API (HTTP Header Auth)

MySQL Database

Telegram Bot Sticky Notes

`❗ IMPORTANT SETUP NOTES ❗

For products: Ensure 'url_key' exists in custom_attributes

For coupons: Magento REST API must expose coupon rules

MySQL user needs INSERT/SELECT privileges

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:

Checks for new products/coupons via Magento API

Verifies against MySQL database

Only posts if record doesn't exist

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!