Case Study: Social Media Notification in Odoo ERP

Case Study: Social Media Notification in Odoo ERP

Writer: Tekgenio Writer

Header: Giammarco Boscaro via Unsplash

Client Requirements

The client required a real-time notification system within Odoo ERP to alert users whenever a new comment is received on any social media platform, including Facebook, Instagram, LinkedIn, Twitter, and YouTube. These notifications should be accessible only to users with Social Marketing access.

Challenges & Key Considerations

• Real-Time Notification System: Ensure that Odoo users with Social Marketing access receive instant alerts for new comments.
• Multi-Platform Support: The solution must work across multiple social media accounts (Facebook, Instagram, LinkedIn, Twitter, YouTube).
• Integration with Odoo Notifications: Notifications should appear within Odoo’s system, allowing seamless user interaction.
• Cron Job Execution: Ensure scheduled actions retrieve and update comment notifications periodically.
• Access Control: Only users with Social Marketing access should receive the notifications.

Solution Implemented

• Social Media Notification System:
  • Whenever a new comment is received on any of the connected social media platforms, a notification alert is triggered in Odoo.
  • Notifications appear in Odoo’s notification panel, ensuring visibility to Social Marketing users.
  • The notification contains details such as:
    • Platform Name (e.g., Facebook, Instagram, etc.)
    • Post Link
    • Comment Content
    • Comment Author
• Access Control for Notifications:
  • Only users with Social Marketing access will receive notifications.
  • Users without this role will not be notified of new social media comments.
• Integration with Odoo’s Scheduled Actions (Cron Jobs):
  • Created scheduled actions (cron jobs) under Odoo’s Scheduled Actions module to:
  • Fetch new comments from social media platforms at regular intervals.
  • Trigger notification alerts for newly received comments.
  • Mark comments as read once reviewed by the user.
  • Cron jobs run at predefined intervals to ensure timely updates.

Results & Benefits

• Real-Time Engagement: Users receive instant alerts when customers engage with posts.
• Seamless Social Media Management: All interactions are tracked directly within Odoo.
• Improved Workflow: Marketing teams can quickly respond to social media interactions.
• Controlled Access: Only authorized Social Marketing users receive notifications, ensuring security.
• Scalable Integration: Supports multiple social media platforms with automated updates.