2

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.

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

2 Answers 2

3

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

4
  • 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
    Commented Dec 24, 2015 at 5:14
  • Yes it is magento default functionality
    – Abdul
    Commented 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
    Commented 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 ? Commented Jun 11, 2018 at 4:35
-1

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.