How to send email when update order status from database?

[kaiodadalt]

Hi everyone,

I need to update order status after 2 days (if custommer don't pay) and then, send email of the new status. I would like to know if its possible to do it by database. If don't, can anybody help me?

Thank you very much

[Simonas Invertus]

You can change order status via database, but you will need a script/cron job to send emails. Most likely you can use existing email templates and PrestaShop mail sending functionality, but you need to write a code that will execute it.