where to find email list for "notify me when available"

[al167]

Hello all!

i have an out of stock product,

we have the option  for the customer to notify me when the stock is available, 

we want to know how many people have put down there email for each out of stock product. is there any way to see this in back office or in database files ?

prestashop version 1.7.4.3

any help would be very much appreciated!

 

Cheers 
Allan

[yama]

 

[al167]

Thankyou Yama

many thanks!😀

i have found the database file!

The list is found in Table: ps_mailalert_customer_oos

 

 

[Rhobur]

There is no need to work with the DB table, the backoffice has such a list in Advanced Parameters -> Email.

[willowtree]

I can't see in Advanced PArameters -> Email any list for what products customers have asked to be notified about?

[ComGrafPL]

34 minutes ago, willowtree said:

I can't see in Advanced PArameters -> Email any list for what products customers have asked to be notified about?

Check setting in Mail alerts module.

[willowtree]

I have the mail alerts module. It is configured: Product Availability is on (Give the customer the option of receiving a notification when an out of stock product is available again.)

I cannot find a list that shows me how many/who has requested notifications for which products?

[MinnaLaa]

On 12/29/2021 at 7:55 PM, willowtree said:

I have the mail alerts module. It is configured: Product Availability is on (Give the customer the option of receiving a notification when an out of stock product is available again.)

I cannot find a list that shows me how many/who has requested notifications for which products?

 

Hello, would this help you?

PS 1.7.

Go to Advanced parametres and there should be SQL query.

Add a new query and put this into the field:

SELECT id_product,id_product_attribute,customer_email
FROM ps_mailalert_customer_oos

After saving it, you can open it from the list

[Rynraf]

On 4/21/2022 at 3:42 PM, MinnaLaa said:

SELECT id_product,id_product_attribute,customer_email
FROM ps_mailalert_customer_oos

A little improved query... I sorted list from products with the bigger amount subscriptions for notification, but you can just change last line of query and sort list by product name. I'm interested in how many people subscribe for notifications, not a list of each email address.

 

SELECT n.id_product AS "product id" , pl.name AS "product name", n.id_product_attribute AS "product attribute", COUNT(n.customer_email) AS "count customers"
FROM ps_mailalert_customer_oos n
LEFT JOIN ps_product_lang pl ON n.id_product=pl.id_product
WHERE pl.id_lang=1
GROUP BY n.id_product
ORDER BY COUNT(n.customer_email) DESC;

 

But I'm still looking for a module which just will show how many subscriptions for availibility notification is for product, the best way - on product page in backoffice...

[policeclearance]

However, I can see a list of customers with active subscriptions. Maybe this is the list I could use to notify customers about new products. I could also create a mailing list for customers interested in new products.