Trying to import customers from an old site to new, the idea behind the migration is to not cause any down time and have the site work exactly as before so i need the customers that were email activated to be so on the new site.

I've looked in customer_entity_int and in the customer_attribute table but too no avail, could someone tell me what magento does behind the scenes when a customer clicks the link in the email activation?


In the customer entity is_active is set to 1. There is also an attribute confirmation for customers that is set to null.

Check Mage_Customer_AccountController::confirmAction and you can see what Magento actually does when the link is clicked. On line 600 the following is done

try {

the setConfirmation part translates to the attribute confirmation which is stored in the table customer_entity_varchar.

  • That's what I thought, but all of the customers have is_active set to one but when trying to log in I get the email not activated thing Sep 7 '15 at 14:35
  • 1
    @RobertPounder I was too quick. See edit :)
    – Sander Mangel
    Sep 7 '15 at 14:40
  • Ah nice one don't suppose you could give me the details on the confirmation and how it is related in db? Sep 7 '15 at 14:42
  • Depends on how you're importing it but as long as you leave the field empty it should be fine
    – Sander Mangel
    Sep 7 '15 at 14:45
  • 1
    customer_entity.entity_id = customer_entity_varchar.entity_id
    – Sander Mangel
    Sep 7 '15 at 15:02

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.