Email notification if a customer makes a change to their details?

[southpacific]

Is there any way to be notified by email when a customer makes a change to any of their contact or address details?

I am currently running two databases one for offline sales an one for online (obviously zencart) I am not yet ready to move the offline database online so I would like to be notified about any contact detail changes made by my customers online.

Thanks

Sam

[kuroi]

This facility doesn't exist in Zen Cart's core code so you would need to build it. There is a zen_mail function that would make this easier than it might otherwise be, so the tricky bit would be detecting the changes.

A better approach might be to develop reports that run daily or weekly and return any changes to the customer or address_book tables, as these are date stamped each time there's a change.

Both of these options though would require some programming skills and a fairly good kowledge of the innards of Zen Cart.

[southpacific]

Thanks kuroi,

Where would I start? I am a beginner at php but slowly getting my head around it..

I was thinking something simple like:

$email_message = 'Address change:' . "\n\n";
$email_message .= 'Customer ID:' . $customer_id . "\n";
$email_message .= 'Customer:' . $customers_firstname . ' ' . $lastname . "\n";

  tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, 'Address change', $email_message, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

I tried putting it under this line:

<?php if ($messageStack->size('addressbook') > 0) echo $messageStack->output('addressbook'); ?>

in address_book_process.php but doesn't seem to work, any suggestions?

Thanks Sam

[southpacific]

Does anyone know of a good place to start, either to have an email notification or daily report of customer details changes?

Thanks

[Ajeh]

NOTE: tep_ is a prefix for osC and not for Zen Cart ...

If you look in the /includes/modules/pages/account_edit/header_php.php you will see where updates are made that indicate a change has happened to the account around the lines:

    $sql = "UPDATE " . TABLE_CUSTOMERS_INFO . "
            SET    customers_info_date_account_last_modified = now()
            WHERE  customers_info_id = :customersID";

    $sql = $db->bindVars($sql, ':customersID', $_SESSION['customer_id'], 'integer');

    $db->Execute($sql);

You could add your email code after that ...

[southpacific]

Thanks for your reply,

now sure exactly how to use the zen_mail command,

would the script be:

$email_message .= 'Customer:' . $customers_firstname . ' ' . $customers_lastname . "\n";

  zen_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, 'Address change', $email_message, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);

or even easier:

$email_message .= 'Customer:' . $customers_firstname . ' ' . $customers_lastname . "\n";

   zen_mail( "samueljohnstone####################", "$email_message");

Thanks so much for your help. I'm a little bit lost here. If you could give me an example of the code already in zen cart that would help heaps.

Thanks

Sam