I cannot import a customer-csv if the ‘website’ field is missing, or empty or containing ‘ETK-shop’. This field has to contain the value ‘ADMIN’ Then the import goes well, without errors.
However, if the field ‘website’ contains 'ADMIN', the customer cannot log in. I need to change the value of ‘website’ field to ETK-shop for the customer to be able to log in. But this cannot be done via ‘Manage Customers’ (?). So I need to alter the field website_id in the table ‘mage customer entity’:
UPDATE `etkm01_mage1`.`mage_customer_entity` SET `website_id` = '1' WHERE `mage_customer_entity`.`entity_id` =8201;
This does not seem the right way to get it to work. So what am I doing wrong? How can I import customers with the right website/-id?