Associate ALL guest orders to their respective customers (if exist) by email address

by grok_in_full   Last Updated January 14, 2018 02:09 AM

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

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.

Tags : magento-1.9

Related Questions

Magento 2 Checkouts page customization

Updated May 21, 2017 16:09 PM

Shopping cart price rule shipping issue

Updated May 16, 2018 16:09 PM