Magento 1 – How to Import Customers with More Than 2 Addresses

addressimportuser

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 ?

Best Answer

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

Related Solutions

Magento – Export and Import Customers

Seems, this is expected behavior by design. Please, look at customer address backend model:

class Mage_Customer_Model_Resource_Address_Attribute_Backend_Street
    extends Mage_Eav_Model_Entity_Attribute_Backend_Abstract
{
    /**
     * Prepare object for save
     *
     * @param Varien_Object $object
     * @return Mage_Customer_Model_Resource_Address_Attribute_Backend_Street
     */
    public function beforeSave($object)
    {
        $street = $object->getStreet(-1);
        if ($street) {
            $object->implodeStreetAddress();
        }
        return $this;
    }
}

And Mage_Customer_Model_Address_Abstract

/**
 * set address street informa
 *
 * @param unknown_type $street
 * @return unknown
 */
public function setStreet($street)
{
    if (is_array($street)) {
        $street = trim(implode("\n", $street));
    }
    $this->setData('street', $street);
    return $this;
}


/**
 * To be used when processing _POST
 */
public function implodeStreetAddress()
{
    $this->setStreet($this->getData('street'));
    return $this;
}

Since Module ImportExport uses attribute's backend models, so this is expected behavior.

Magento1 – Fix Import Customers with Website/Website_ID Field

Be sure to use the website-code as fount under System / Stores (screenshot)

Website code

~~Or create a customer manually in the webshop. Export customers and look what the value of website is. Use this again your the import.~~

~~I think it differs from ETK-shop.~~

The customers you are importing become Admin only and therefore you cannot login from the website.

Added after extra info about the error

Error: Skipping import row, website "%s" field does not exist.

I've took a look at the code, I would almost there is a error in the content entry. Website codes are matches case sensitive, to be sure nothing goes wrong, try entering them both in website and in csv lowercase.

Maybe you could edit System / Stores -> Website and set the code again(lowercase) and the in the import(lowercase). Then try again.

Best Answer

Related Solutions

Magento – Export and Import Customers

Magento1 – Fix Import Customers with Website/Website_ID Field

Added after extra info about the error

Related Topic