How to update bulk of customer address information?

Question

I have one requirement to update the customer first name and last name in address information section. I tried through csv file import/export method but it only update in account information section not in address information such as billing and shipping address in admin panel(customer->manage customer section).

Currently few records in customer information section are present with lastname combine in firstname section (e.g firstname:- testtest1 and lastname:- blank instead of firstname:-test and lastname: test1)

and I want to split the firstname and lastname separately in address information section too.

So how should I proceed to solve this query to my bulk of customer.

Answer 1

Go admin side System -> Import/Export -> Export and Export all customer with all data

After your exported csv file updates bellow header fields data

_address_firstname

_address_lastname

Go admin side System -> Import/Export -> Import and upload your updated csv file

Make bellow settings :

1. Entity Type * : Customer
2. Import Behavior *: Replace Existing Complex Data
3. Select File to Import *: upload updated file

After click Check Data button if no error then click import button

Note : first backup your database

Answer 2

Select File to Import *: upload updated file.

Its not uploading only processing.