How to receive notification emails when somebody posted a new product comment?

[pietpetoors]

How can I get Presta to send me a notification when I receive a new product comment?

I know that the module I need to edit is the built in module: Product Comments, but if I do not receive a notification I do not know that there are new comments waiting to be approved.

I do not want to set it to auto approve because I still want to know about the comments and see what they are about.

Another issue I have is if I go to Product comments and cannot see to what product the comment refers to. It is just a comment and client name but no reference to what product he is talking about. Sometimes you can figure it out from the comment, but if he just says something like "crappy product" there is no way to see which product is crappy so that you can investigate the matter.