JRFerreira Posted October 21, 2014 Share Posted October 21, 2014 Hi there, is there any way to the administrator receive an mail/ notification alert when the shipping time came to the end, e.g., i define that if the user wants free shipping, takes 10 working days to receive, and i want to receive an email/ notification to control if the package was received or if i need to talk with my costumer. Best regards Link to comment Share on other sites More sharing options...
tuk66 Posted October 23, 2014 Share Posted October 23, 2014 A special SQL query directly in database? Saved under Advanced parameters > SQL Manager. Link to comment Share on other sites More sharing options...
JRFerreira Posted October 23, 2014 Author Share Posted October 23, 2014 But for that i need to run the query all days, isn't it? Link to comment Share on other sites More sharing options...
tuk66 Posted October 23, 2014 Share Posted October 23, 2014 Yes, it is an easy and quick solution. A module would be more comfortable. Link to comment Share on other sites More sharing options...
JRFerreira Posted October 23, 2014 Author Share Posted October 23, 2014 Ok. Sorry, can you help me on the query pls? SQL is now my strength: S Link to comment Share on other sites More sharing options...
ventura Posted October 23, 2014 Share Posted October 23, 2014 something like that SELECT P.reference AS Reference, PL.`name` AS Product_Name, mac.customer_email AS email, os.name AS Supplier FROM ps_product P LEFT JOIN ps_product_lang PL ON P.id_product = PL.id_product LEFT JOIN ps_supplier os ON P.id_supplier = os.id_supplier LEFT JOIN ps_mailalert_customer_oos mac ON P.id_product = mac.id_product GROUP BY email LIMIT 0 , 30 Link to comment Share on other sites More sharing options...
Recommended Posts