DataLife

What plugin are you using for taking orders, WooCommerce?

WooCommerce

And is there another (WooCommerce?) addon plugin involved in any way with sending or formatting emails?

Offload SES Lite, but it doesn’t even get that far. Other emails send perfectly fine. And this email sends fine when an order is made, just not through admin.

For now I just made my email template for “send new invoice” order action look the exact same, so I’m using that as a temporary solution.

I also installed WP Mail Log plugin to try to troubleshoot this, and the email doesn’t appear there either.

Anything in debug.log when you try and resend a new order notification?

How do I find that?

Thank you. Still looking forward to this option.

I saw this suggestion somewhere, would it work?

Run this SQL script:

update wp_woocommerce_order_itemmeta
set meta_value = 'new_product_id'
where meta_key = '_product_id' and meta_value = 'old_product_id'

Thank you for this video. There are 700 orders with this issue, so unfortunately I’d need a more batch-able solution.

Thanks for the hot tip on the email blocker — I may need something like that, although I use Amazon SES for sending emails, not sure if this blocks those too?

Thank you for this trick!

I keep daily backups for 30 days, but the deletion happened several years ago.

Trying your method, I discovered the product was actually deleted at two different times. Luckily, the version with 99% of the orders was recovered: product_id 1408. The other only had 2 orders, and the product_id was 0…?

How can I change both of these product_ids to the new product_id? With some direction I’m comfortable going into phpMyAdmin, although I have little experience there.

• This reply was modified 2 years, 4 months ago by DataLife.

Thanks this helped me too!

Oh, amazing — thank you!

Thanks for the quick response. As a fellow software designer I totally understand why you may not want to add that feature.

It would be great to find a direction for people like me who aren’t coders but can hack something together if shown an example of what they can use.

Only issue with the js example is that you can’t set a time zone from what I can tell, so it takes the time from the user’s computer.

Looking forward to your response, thanks again.

It would definitely seem that way, however this workaround fixed the issue and everything is verified working. Thanks for your responses nonetheless, and for the great plugin!

Changing the From field under the Mail tab to

anything <[email protected]>

fixed this for me!

As long as you have the additional header:

Reply-To: [your-email]

underneath, it shouldn’t make a difference in usability.

@electrosmog thanks so much for the link!

Changing the From field under the Mail tab to anything <[email protected]> worked for me!

Thanks for the help. Unfortunately this didn’t work. I switched to the Twenty Fifteen theme and deactivated all plugins except for Contact Form 7 and WP Stagecoach (the service I use for my staging site). Now the error box is actually red instead of orange.

Any other ideas?

Thank you,
Nathan