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.

  • need to update customer address information via csv or php script?
    – Abdul
    Dec 23, 2015 at 10:04
  • How do i update it through csv..?
    – Ashwini
    Dec 23, 2015 at 10:12
  • Because I try to csv but it's not get updated..
    – Ashwini
    Dec 23, 2015 at 10:12

2 Answers 2


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

After your exported csv file updates bellow header fields data



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

  • 1
    Thanks..I have useful this answer but I want to update only two fields that is first name and last name..But when I export it's shows all fields need to fill compulsory message.
    – Ashwini
    Dec 24, 2015 at 5:14
  • Yes it is magento default functionality
    – Abdul
    Dec 24, 2015 at 5:19
  • If your use magento default Import/Export then customization ImportExport module otherwise your create own custom module for that
    – Abdul
    Dec 24, 2015 at 5:22
  • @Abdul, want to update only selected customer field like address,zipcode and state etc. so how i can import this field using csv file ? Jun 11, 2018 at 4:35

Select File to Import *: upload updated file.

Its not uploading only processing.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.