4

I use a csv file to import customers into Magento.
This is the csv file header :

website, email, group_id, group, firstname, lastname, password_hash, billing_firstname, billing_lastname, billing_company, billing_street1, billing_street2, billing_city,billing_region, billing_country, billing_postcode, billing_telephone,billing_fax, shipping_firstname, shipping_lastname, shipping_company, shipping_street1, shipping_street2, shipping_city, shipping_region, shipping_country, shipping_postcode, shipping_telephone, shipping_fax, created_in, is_subscribed

But if the customer have more than 1 billing / shipping address, which modification have I to do on the header ?

2 Answers 2

0

I don't think you need to modify the headers, you can just the extra shipping/billing address on a line after the primary shipping/billing address but you will simply need to include the commas for all other header details that are before and after the address details eg ",,,,City name, Telephone, etc..,,,,"

If your editing the csv file on excel(which isn't recommended) you can just add the address details for all address headers on the row below the row with the primary address details and leave all other details blank

7
  • If I add an other address on the row below the primary, the primary address is override. Apr 21, 2015 at 15:18
  • That is odd, it works for me. Perhaps you have to add the headers address_default_billing and address_default_shipping and set one of the address as default Apr 21, 2015 at 15:29
  • On the row with the other address, do you define the headers website and email ? Apr 21, 2015 at 16:00
  • No i dont define anything except for the other address information Apr 21, 2015 at 16:03
  • With address on a row below, it said that the row has been unheeded because the headers website and mail wasn't fill. If I fill these 2 headers, the primary addresses are overwrited. With the headers address_default_billing/shipping, nothing is done. Maybe there is a specific writing for these headers ? Apr 22, 2015 at 7:15
1

Use Magento Import/Export instead of Dataflow Profile.

Create multiple rows for addresses as in given screenshot.

I have just Exported and Imported it.

Hope it will help you.

Find Screenshots for better understanding and let me know if more detail required.

CSV Example with multiple address

Use Import Export instead of Dataflow Profiles

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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