Rayjak Posted October 27, 2010 Share Posted October 27, 2010 My store owner wants to know the quantity that needs to be ordered for an out of stock product. They want to know how many of their customers have clicked the "notify me when back in stock" button. I can't find a stat for this. Where/How is the info kept in the database? Link to comment Share on other sites More sharing options...
rocky Posted October 27, 2010 Share Posted October 27, 2010 It's kept in the ps_mailalert_oos table. I don't think there is any option to view the list from the Back Office. Link to comment Share on other sites More sharing options...
Rayjak Posted October 27, 2010 Author Share Posted October 27, 2010 Thank You! I will provide a program to list the info from the database.Your support on this forum is fantastic!! Link to comment Share on other sites More sharing options...
Zenith Posted October 27, 2010 Share Posted October 27, 2010 There is a module that displays a list of customers with mail alerts already...http://www.prestashop.com/forums/viewthread/47173/third_party_modules/module_list_of_customer_out_of_stock_registrationsThis should be added to the default package, very handy for ordering! Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts