Order Confirmation Emails after Upgrade to 2.3.3

[rkgilchrist]

Hi 

I upgraded from 2.2.7 to 2.3.3 last month and have now discovered that my store is no longer sending Order Confirmation Emails when an order is placed.

I have setup Magento to send emails a Asynchronously (Admin-> Stores -> Configuration -> Sales -> Sales Emails ->General Settings -> Asynchronous sending = Enable) 

I am fairly sure the problem is with the cron job that sends the emails.

I have 2 Questions:

1. How do I debug the cron job to find out the problem?

2. My Store has taken a lot of orders since the email the problem started. Are all these order confirmation emails queued up to be sent? And if so how do I clear this queue as I don't want customers receiving an email for an order they placed weeks ago?


Any help would be greatly appreciated

Thanks 
Rob

[rkgilchrist]

Hi 

Follow up on my previous post. 

The problem is not with the cron job. 

There are 2 columns in sales_order table

email_sent

send_email

When an order is placed, I believe its meant to set the send_email to 1 and then the cron job picks these orders up and sends the order conf email, it then sets the email_sent to 1.

For some reason in my  Live environment for orders that use the  Sagepay Payment method,  the send_email is not being set, therefore no emails are being sent.

I now have to work out why this flag is not being set. 

Anybody got any ideas?

Cheers

R

[doubleip]

Hi,
did you find any solution on that problem?

Thank you,
Maria

[doubleip]

In my case it was a problem on trird party payment modal.