0

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?

Improve this question

1 Answer 1

Reset to default
1

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 {
   $customer->setConfirmation(null);
   $customer->save();
}

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

Improve this answer
12
  • 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
    – Robert Pounder
    Commented Sep 7, 2015 at 14:35
  • 1
    @RobertPounder I was too quick. See edit :)
    – Sander Mangel
    Commented Sep 7, 2015 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?
    – Robert Pounder
    Commented Sep 7, 2015 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
    Commented Sep 7, 2015 at 14:45
  • 1
    customer_entity.entity_id = customer_entity_varchar.entity_id
    – Sander Mangel
    Commented Sep 7, 2015 at 15:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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