I have seen a few questions similar to this but nothing that is close enough or that works without error. I am using an extension that changes customer groups based on various conditions, but it only checks orders that are associated to created customers. I want to link all of the guest orders in the database to a respective customer if there is a customer that matches the email address on the guest order. I don’t care how long it runs.. Magento 1.9.2.2
I’ve found a couple of extensions but they require targeting a specific customer. I found this question (Does Magento automatically convert a guest's old order to his new account?) which seems to have a solution, but the script produces an error
Column not found: 1054 Unknown column ‘store.website_id = customer.website_id”
Unfortunately I can’t comment on it because I don’t have enough reputation points.