I entered an order manually and filled in all the details correctly. The invoice has been generated and the confirmation has been sent to the customer.
Oops, I used the wrong email address…
How can I reset the status of an order so that I can correct the email address and resend the confirmation?
Either as a workaround or, as a last resort, via the database?
Once an order is in the “Completed” state, it is essentially archived and not meant to be changed anymore. It is not supported to move an order out of that state - except to a cancelled state.
If the order is still in the processing state, you can make whatever change you need. I like to have a “resend confirmation” status change that keeps it in the same status but sends the emails out again for this sort of use case.