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

Odoo v9 project: How to send customer satisfaction rating email?

Subscribe

Get notified when there's activity on this post

This question has been flagged
projecttemplatev9rating
11 Replies
9907 Views
Avatar
Thomas

Hi!

I see that there is an option to request a customer satisfaction rating for projects. I followed this procedure to set it up (only the project part, not the website part): http://odoo-users.readthedocs.io/en/latest/project/advanced/feedback.html


Now my question is: How do I send the template-based rating e-mail?


Best wishes and thanks in advance for any answers!

0
Avatar
Discard
Avatar
Jorge Lahoz
Best Answer

Hi Thomas,

I am facing the same problem with Error 500, I managed to solve it. You must first get into your main Odoo page if you have multiple databases and select the correct one (you do not need to log in). Then, you can get into the rating url and you won't see the error anymore.

I know it can be anoying, many of us need to have more than one database running in a single Odoo server but, to solve this, I had to ran a separate Odoo server for each.

I will try to develop a script or a query so you do not need to run several servers. There must be a way to first redirect the user to the database selection and (without him realising) make him select the database and go back to the rating page.


PS: I know you have probably managed to solve this by your own, just wanted to answer in case anyone else is having the same problem. ;D

0
Avatar
Discard
Avatar
Simplify-ERP® - Wapsol GmbH
Best Answer

Customer Ratings is a super-useful feature on v9e.

We have it working. Mails go out. Clicking on one of the 3 levels applies the rating.

Now..

We want to embed a link to the Task/Issue, so that the user can review it before giving a rating.

Alternatively, we'd like to include in the mail-body details such as Duration (time taken to implement the task), Date-Started/Finished, etc. etc.

Which model/document can be called for embedding these values in the mail-template. These are the available fields out-of-the-box.





















Thank you

Simplify-ERP® – Ashant Chalasani

0
Avatar
Discard
Thomas
Author

Hi Ashant!

I am a bit late with giving an answer, but maybe it is still interesting for you or others. You could just add the respective fields in the e-mail template. Go to the Settings module and then to E-Mail templates and either edit the original Customer Satisfaction Rating mail or create a new one. In that mail you can include dynamic placeholders for fields which belong to the project.issue object. This can be e.g. the name (res_name), date of creation (create_date) and so on. Just use the dynamic placeholder generator in the e-mail template edit dialog. Best, Thomas

Simplify-ERP® - Wapsol GmbH

Thank you Thomas.

Would you know which fields to exactly use (from the "dynamic placeholder")?

Thomas
Author

Sure. First of all, I am not an odoo expert and the proposed methods might not be the best way to do this. Now, an e-mail template only applies to one specific model, either project.task or project.issue. If you need it for both then I guess you need to create two templates.

Accessing a link to an issue/task only works if the user is logged in to your Odoo environment. If that is the case you can just add: ${object.name} to the e-mail template text and set a hyperlink to the respective view (mark ${object.name} and add link to URL), e.g. https://YOUR-ODOO-DOMAIN.COM/web?debug=#id=${object.id}&view_type=form&model=project.issue&action=280&active_id=5&menu_id=199

In the link, you can see that the issue view is identified by the id number of issue, which can be dynamically set using ...id=${object.id}...

Now, to add some facts about the issue/task to the e-mail just add dynamic placeholders to the e-mail template, like:

${object.create_date}

${object.days_since_creation}

In the e-mail template dialog just go to the tab Dynamic Placeholder Generator, click on Field and then select "Search more" from the drop-down list. This will give you a complete overview of all available fields. Most of them are pretty self-explanatory. By sending an e-mail based on the template all dynamic placeholders will be filled with respect to the concerned project.issue or project.task.

I hope that helps. Best, Thomas

Thomas
Author

Ooops, I just realized that my answer does not make sense. For the rating to work the object is not project.issue or project.task but Rating. I am not sure if that object has any link to the actual taks or issue triggering the rating. I would try to add all available fields to the mail and sent it to yourself as a test. Then you know what each field does. If that does not do it, then you would need a link from one object to another and I have no idea how to do that.

Thomas
Author

I just tested this a little bit more: There are actually a few fields available for Rating that link to the task/issue:

- ${object.display_name} or ${object.res_name} both give the name of the task/issue

- ${object.create_date} plots the date of creation in yyyy.mm.dd hh:mm:ss

- ${object.__last_update} and ${object.write_date} both give me the date and time when the task/issue has been moved to the rating stage, so basically the time when the rating e-mail is sent. This is not really the date of the last modification. Maybe the name with a link to the actual task/issue (as described before) is sufficient for you?

Avatar
Thomas
Author Best Answer

Hi Yenthe!

So after playing around with this a little bit I figured out what the bottleneck is:

The provided solution in Odoo v9 ONLY works if a Customer for a task is set or a Contact for an issue is set. And the customer can only use the reply buttons in the mail if he/she has a login to Odoo. That is a problem for me as our customers do not have an account with our Odoo system.

I guess the problem is with the href links bound to the buttons in the mail, for example <a href="/rating/${object.access_token}/10"></a>. This link takes the user to OurOdooDomain/rating/xyz. If the user is not registered and logged in to our OurOdooDomain an "Error 500: Bad request" exception is thrown. Any ideas on how this could be circumvented? Probably not with this type of link, he? Guess I will have to change the call to action on that button.

If anyone has any ides, I would love to know! Best wishes

0
Avatar
Discard
Avatar
Yenthe Van Ginneken (Mainframe Monkey)
Best Answer

Hi Thomas,

You first have to active this setting under Projects > Configuration > Settings. Activate the option "Allow activating customer rating on projects, at issue completion" and save it.
After activating this feature you can go to the settings of a project and you'll see a new checkbox named "Customer satisfaction". If you tick this on the rating e-mails will be sent the moment you set a task to the completed state. 

Regards,
Yenthe

0
Avatar
Discard
Thomas
Author

Hi Yenthe! I already did all of that and I have a stage Done with "Is a close stage" marked and the default "Rating project request" template selected as "Rating E-Mail template". However, if I move a task or issue there no e-mail is being sent. So, the question remains. How do I actually send the mail? Do I understand it right that the mail should be sent automatically when a card is moved to the respective rating stage?

Yenthe Van Ginneken (Mainframe Monkey)

@Thomas, that is correct. It should send out the e-mail automatically when moving it to the respective rating stage. Do you have an outgoing e-mailserver and is it active / working? If the answers are yes I'd suggest you to update your Odoo instance to the latest code. If that still doesn't fix it it is time to start debugging.

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
howto make tasks in template project invisible for the person it is assigned to?
project template
Avatar
0
Mar 15
4270
Create task from customer form V9 community
project community v9
Avatar
0
Nov 15
3867
no task in template project / how to install the fix ?
project task template
Avatar
0
Mar 15
4523
how to open a project from a project template
project template from
Avatar
Avatar
1
Mar 15
8537
How to disable default text creation in tasks when etherpad module is installed / How th duplicate task when etherpad is activated
project task etherpad v9
Avatar
0
Jul 16
4639
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