Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Mass mailing campaigns do not track opened and replied e-mails?

Subscribe

Get notified when there's activity on this post

This question has been flagged
emailmailingcampaignodooV8
16 Replies
21853 Views
Avatar
Yenthe Van Ginneken (Mainframe Monkey)

Hi guys

Today I've download and installed the mass mailings module for Odoo V8.
I've setup a testaccount with an incoming and outgoing mailserver and then added the email test account to Odoo.
Everything seems to fine up until the emails are sent. They are sent to the emailadresses I provide but it doesn't seem to track who has read the emails and who replied?
Can anybody tell me what I'm doing wrong or if I am missing something?

Here are my settings.
My campaign: 

My inbox:


My reply on this e-mail:

 

My e-mail configuration settings:

Yet my Odoo still says 0% is opened and 0% has reponded. I do not have anything in my inbox on Odoo either. My e-mail reply is in my Gmail account though!
Any solutions / help?

With kind regards
Yenthe

2
Avatar
Discard
Jaron Soininen

I see that the images in your email are also not loading. So I think your problem might be because you have installed Odoo on your localhost, which does not have a valid domain. Therefore, when people open your mass mail-outs, your Odoo install does not receive the response.

Yenthe Van Ginneken (Mainframe Monkey)
Author

@Jaron, this is not the problem. Sadly there are a few major bugs with parameters regarding to the IP internal and external of the server and multi-database use. I'm looking into this with the developers and we're trying out patches right now. I'll post back an answer with a detailed explenation/fix when everything is verified! :)

Jean-Marc Dupont

Hi, Have you found fixes ? emailing doesn't work for now ...

Yenthe Van Ginneken (Mainframe Monkey)
Author

@Jean-Marc, yes I have find a solution but its rather lengthy. I will write out the answer for you tommorow morning! :)

Sławomir Lis

I found that this is due to not setting session.db. In my case - when I first opened any odoo site - then tracking image was opened correctly. I've modified openerp/http.py: --- http_orig.py 2014-10-31 07:25:02.941976640 +0100 +++ http.py 2014-10-31 07:08:12.907227392 +0100 @@ -324,7 +324,14 @@ The database linked to this request. Can be ``None`` if the current request uses the ``none`` authentication. """ - return self.session.db if not self.disable_db else None + if not self.disable_db: + if self.session.db is None and 'db' in self.httprequest.args: + self.session.db = self.httprequest.args['db'] + return self.session.db + else: + return None + + #return self.session.db if not self.disable_db else None @lazy_property def httpsession(self):

Yogesh

sorry I forgot to add the image content in last comment.

Avatar
Yenthe Van Ginneken (Mainframe Monkey)
Author Best Answer

To get everything working you will need to update some code in the mass_mailing module.
Patch for the new report.url parameter: https://github.com/odoo/odoo/pull/3260.patch
Patch for the mail_mail.py file under mass_mailing/models
and main.py under mass_mailing/controllers:https://github.com/odoo/odoo/pull/3289.patch

You will need to apply those patches. Or alternatively copy the content from these files and import them in your files.
main.py file: http://pastebin.com/zAw64WpH
mail_mail.py file: http://pastebin.com/6g2ddfdZ

After you've applied those patches you can add a new parameter report.url under settings > Parameters > System Parameters with the IP of your Ubuntu VM.
Now you can set a web.base.url, a web.base.url.freeze (to be sure the URL isn't changed by Odoo itself) and a report.url.
Why is this? With this you can define the web.base.url to make the URL for your images and e-mails and use the report.url to make the URL for printing files out in PDF.
Your final settings should look like this:
Now save all your files, edits, ... and restart your Odoo. From now on you can use mass mailing, all images and tracking of opened e-mails will work.

NOTE: At the time of this answer mass_mailing is not supported for multiple databases! This will only work if you have one database or use the --db-filter parameter.
For more information see: https://github.com/odoo/odoo/pull/3289 
Odoo is working on a multi-database fix for tracking but images will not be supported in multi-databases most likely.

 

4
Avatar
Discard
Jean-Marc Dupont

Are all these patches available in last published version of Odoo ? Is development team aware of this ?

Yenthe Van Ginneken (Mainframe Monkey)
Author

They seem to be added to the Github Odoo branche (as you can see here https://github.com/odoo/odoo/blob/8.0/addons/mass_mailing/controllers/main.py). But I don't think they are already into the download link from the Odoo website itself..I'd manually check both files to be sure. I've tested these patches and setup the fixes for this, so yes a developer is aware of this!

Yogesh

This doesn't seem to work for me. I see a broken image in inbox in chrome but nothing in firefox. method track_mail_open(self, mail_id, **post) never gets. How should image blank.gif appear in my inbox. is it okay to appear broken image ?

Yenthe Van Ginneken (Mainframe Monkey)
Author

@Yogesh if you get a broken image preview it means there is still something wrong / you did something wrong. Are you running your Odoo on ONE database and did you follow all my instructions?

Yogesh

Yes I read carefully multiple times. Running database with --db-filter option. I can see this is being append with body of mail but can't find where blank.gif exists.

Yogesh

sorry it seems kind of spamming but its odoo removes html content and makes blank comment.

Axel Mendoza

Hi @Yenthe, I have an issue on this today, in my installation I could see correctly the percent of opened emails but I cannot see the email address of who open the email because the email field in the statistic is gone after the email is send. Any workaround on this?

Yenthe Van Ginneken (Mainframe Monkey)
Author

Hi @Axel I guess you could counterpart this by writing the e-mailadres away on the model on the moment it is being sent? By default there doesn't seem to be anything to keep track of the e-mail anyway.

Avatar
Dhiraj Palekar
Best Answer

For Odoo v9 and above:

Odoo generally sets web url parameter to localhost:8069.

Just set your "web.base.url" parameter value to <your ubuntu server address> ex: <http://00.000.000.00:8069/>  located at Settings >> Technical >> Parameters >> System Parameters and it should work fine. Hope it helps you. Thanks!

0
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
How Email Marketing works? Solved
email marketing mailing campaign
Avatar
Avatar
1
Apr 22
3567
odoo8 email marketing campaing sent email to customer on the basis of it interest
email marketing campaign odooV8
Avatar
0
Mar 15
3938
Drip email campaign Solved
email campaign
Avatar
Avatar
1
Jul 24
2230
Email Campaign
email campaign
Avatar
0
Jun 23
1873
how to know who unsubscribed my email campaign?
mailing campaign
Avatar
Avatar
2
Aug 19
4635
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now