Where to find notifications in Admin

[pokemon3d]

Hello,

I'd like to know where in the back office I can see which customer has asked for which product alert ?

Thanks for your help

[swguy]

To the best of my knowledge, there is no facility to view this in admin. To do it in phpmyadmin, use the query

SELECT p.name, c.email FROM `ps_product_lang` p, ps_customer c, ps_mailalert_customer_oos o where o.id_product = p.id_product and p.id_lang = 1 and c.id_customer = o.id_customer

Of course, you must have installed the module "mail alerts" in admin->modules first.

[pokemon3d]

Wow. I have found the SQL query expert !!!
I am gonna try this. Thanks a lot.

For the PS team, maybe a good idea to add such a tab into the back office, where admin could have a global view on the requested products alerts from customers.

Regards

[fwedtam]

and what about "non-customers" who asked to be notified (via the mail-alert module, on the product page) ?

Fred