This morning I was working on an email issue ( multi-store ) where customers were able to purchase but didn’t receive the order confirmation email.
As always, I had a look at what has been deployed recently and checked pretty much all logs on the production environment. Unfortunately, I couldn’t find anything.
I started looking at database changes, especially the core_config_data table, and noticed that the template for the order confirmation was defined twice. This was kind of weird because those email settings were set to ” Use System Value “.
|
1 2 3 4 5 6 7 8 9 10 11 12 |
select * from core_config_data where path like 'sales_email/order%' order by scope; +-----------+----------+----------+------------------------------------------+-------+---------------------+ | config_id | scope | scope_id | path | value | updated_at | +-----------+----------+----------+------------------------------------------+-------+---------------------+ | 1907 | default | 0 | sales_email/order/template | 27 | 2021-01-20 04:30:44 | | 1908 | default | 0 | sales_email/order/guest_template | 27 | 2021-01-20 04:30:44 | | 1909 | default | 0 | sales_email/order/copy_to | NULL | 2021-04-06 07:33:12 || | 4293 | stores | 21 | sales_email/order/template | 27 | 2021-03-18 05:09:26 | | 4296 | stores | 21 | sales_email/order/guest_template | 27 | 2021-03-18 05:09:26 | | 4299 | stores | 21 | sales_email/order/copy_to | NULL | 2021-03-20 05:12:37 | +-----------+----------+----------+------------------------------------------+-------+---------------------+ 6 rows in set (0.01 sec) |
I ended up deleting the IDs 4293, 4296, 4299 which has fixed the issue immediately. I still don’t know why those values were set twice, but I hope this will help someone…sometime.