Automatic email according to order status

[travelbaba]

Hello, I'm asking to develope a feature in virtue mart 3.

My needs:

I change the order status with an external software directly in database, let's say from C to P and form P to S according if the order in in progress or sent.

I need, I suppose with a cronjob, that every day at 8pm the system check if the status is changed, if yes fire a email with the order status notification.

Until the status is "sent", then it's finished.

Is that possible?

Thanks for quotation.

[welrachid]

Why dont you change the status the "correct" way with all the triggers that should be triggered?
Is there a reason for you to change things directly in the DB?

[GJC Web Design]

I need, I suppose with a cronjob, that every day at 8pm the system check if the status is changed, if yes fire a email with the order status notification.

Until the status is "sent", then it's finished.

Is that possible?

yes-- possible