I have exported customers from a magento site. Some customers have confirmed email verification while some have not.
In the exported CSV file, i can see that the customers who have confirmed their account have value set to null in "confirmation" field while those who have not confirmed their email have some hash value set in "confirmation" field.
Now that i import the the customer to another magento site and try to login, i get the message: "user email not confirmed".
When i searched for value for confirmation attribute in database for the particular customer_entity, i see that some hash value is set for the confirmation field. so when i set the value to null, the login works fine for the customer who have their email confirmation done.
But this won't be appropriate when i have three thousand customer to migrate.
What would be a proper solution for this? Am i doing something wrong in the import/export process?