I would like to have a timestamp stored for when a person subscribes or unsubscribes.
Looking at the database: specifically the table
newsletter_subscription I see the field
changed_status_at. However, this does not get populated, it is left null.
Evaluating the file /app/code/core/Mage/Subscriber.php I cannot see any reference to this field either.
Doing some research I found this link. However, after placing the suggested solution on the line(s) 350 and 376 of Subscriber.php it makes no difference and was still unchanged. Thus, is this a bug in magento and if so how would I correct this?
After playing around with this, I placed
->setChangeStatusAt(Mage::getModel('core/date')->gmtDate('Y-m-d H:i:s')) before every save call in the file. For example,
$this->setSubscriberStatus(self::STATUS_UNSUBSCRIBED) ->setChangeStatusAt(Mage::getModel('core/date')->gmtDate('Y-m-d H:i:s')) ->save();
This looks to be setting the changed status date now. But, I can only see it if I go to manage customers. Thus, how could I:
A) do this without editing core files?
B) show this date in Newsletter => Newsletter Subscriptions