Mail alerts module - where is data saved?

[manu1987]

Hello everyone, 

 

The mail alerts module that comes with prestashop lets customers save an alert if a product is out of stock. Prestashop sends an e-mail to the customer as soon as the stock quantity is changed and higher than 0.

 

The missing feature is, how do I know what products are chosen by the customer to be alerted when they are back in stock? That would really help to find out what has to be ordered in again.

 

I presume it is saved somewhere in the database. Does anybody has a hint how this information can be found?

 

mail alerts module v.3.3 / prestashop v.1.6.0.9

[shacker]

the module advises to the client, and when you install it, creates a table, whis is 

 

$sql = 'CREATE TABLE IF NOT EXISTS `'._DB_PREFIX_.MailAlert::$definition['table'].'`

(

`id_customer` int(10) unsigned NOT NULL,

`customer_email` varchar(128) NOT NULL,

`id_product` int(10) unsigned NOT NULL,

`id_product_attribute` int(10) unsigned NOT NULL,

`id_shop` int(10) unsigned NOT NULL,

`id_lang` int(10) unsigned NOT NULL,

PRIMARY KEY  (`id_customer`,`customer_email`,`id_product`,`id_product_attribute`,`id_shop`)

) ENGINE='._MYSQL_ENGINE_.' DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci';

 

Table is 

mailalert_customer_oos

[manu1987]

Thank you for your reply I looked for this table and found it.

 

If someone else looks for this:

 

Login to your cpanel --> PHPMyAdmin--> choose database --> 'ps_mailalert_customer_oo' to see e-mail addresses