Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Make Address Default MySQL? 
 
redsy
Jr. Member
 
Total Posts:  17
Joined:  2011-06-04
 

Hi,

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?

Many Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
redsy
Jr. Member
 
Total Posts:  17
Joined:  2011-06-04
 

Hi,

Does anyone have any ideas on this please, we are willing to pay for an extension to fix this issue!

Many Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top