We have recently moved our Magento store to another server and have imported our customers through. Import/Export -> Dataflow Profiles.
All 13,500 customers have imported with their addresses, but their addresses have not been set as default for billing/shipping.
This is causing us a problem as during checkout it is causing conflicts with our OneStepCheckOut Module, also some orders are being accepted with no shipping method selected.
We can manually go to Customers -> Manage Customers -> CLICK ON CUSTOMER -> Addresses -> Click Default Billing Address & Default Shipping Address -> Save Customer.
However with 13,500 customers it would take such a long time, I’ve made an iMacro script to automate the process but even with this it would take 36 hours at least and drain our server’s resources.
Is there any php scripts that anyone knows that would simplify this process or does one anyone know a MySQL query I could run?