Import Customer from WordPress to Magento

A simple way to import customer from WordPress to Magento System:

  • Export customer from WordPress site to csv file.
  • Modify the header of csv file follow this one:
    ID website firstname lastname email password_hash billing_firstname billing_lastname billing_company billing_postcode billing_city billing_street1 billing_telephone billing_country billing_region shipping_firstname shipping_lastname shipping_company shipping_postcode shipping_city shipping_street1 shipping_telephone shipping_country shipping_region group bob.
    website field is website code of Magento site. You can check code of your Magento site by this way:  System -> Manage Store.
    Group must be General
  • Next, go to System -> Import/Export -> Dataflow Profiles (Note that we will not go to System -> Import/Export -> Import) -> Import Customer -> Upload File -> Up file this CSV with header modified above -> Save -> Run Profile -> Run Profile in Popup
  • Sometime you will need to add this line to the index.php file: ini_set(‘max_execution_time’, 300); to increase the execution time.

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: