Change the customer on an order?

We have a customer that checked out as guest. Then later saw the login screen and just assumed that the new account they created after the fact would have their guest order associated with it. Is there a way for me to change the orders customer from guest to their new account? Can I just edit the customerId in the database to their new accounts customerId?

Yeah you should just be able to change the CustomerId in the Order table. I can't think of any other dependencies as the addresses get duplicated in the database when the order is placed so they'll just work. Give it a go, you can always revert if something doesn't seem right afterwards. It might be worth clearing the cache from the admin area after updating the database but even that's unlikely to be necessary I think.

You may want to also update the Customer_id in the CustomerAddresses table

New York wrote:

I think that you have to change only the columns CustomerId, BillingAddressId and ShippingAddressId if the addresses already exist for that customer.