Customer Authorization Status Question??

[dcfxking]

I have 2 Questions regarding the customer authorization / approval status options.

I am using the setting of 1 for both options (Must login to browse and must be authorized to browse)

1. Once the custromer requests an account they receive a welcome email saying their account is being reviewed - i get the same email and go in and manually approve them. My questions is - is there any possible way to have an email automatically sent to them when their account is approved? Now i have to manually go into my email and send them a note informing them their account is approved and they can now login.


2. I have been playing around with the different approval statuses that can be used. I thought it may be useful to utilize the "Pending approval - may browse with prices but may not buy" option. I like this because there are some people I want to be able to let into the sie to see what we have but not be able to buy (This is like a demo mode) Then if they want to be able to buy form us they have to fax us an agreement. Whenever i set a customers status to this option - it doesnt even let them login at all. I have made test accounts and for some reason if you set an account to this status when they try to login the page just loads and loads and does not let them in at all.

[DrByte]

1. If you approve them by clicking on the red dot to make it green from the main customers list page, then an email is sent.

[dcfxking]

1. If you approve them by clicking on the red dot to make it green from the main customers list page, then an email is sent.

I just tried this and it did not send me any email. Is there a setting that controls this? That would be exactly the logical thing to happen and exactly what i am looking for.

Thanks for any help.

[DrByte]

What version of Zen Cart are you using?

[dcfxking]

What version of Zen Cart are you using?

Zen Cart 1.3.0
Database Patch Level: 1.3.0

[DrByte]

Notwithstanding the fact that a number of bugs have been fixed in v1.3.0.1 and v1.3.0.2 and you should upgrade, it seems that that I may have spoken too soon ... the email feature described appears to have been put in the 1.3.0.3 release which isn't out yet.

[dcfxking]

My Configuration - Sessions settings are as follows:

Session dir - /home/wireless/public_html/secure/cache
cookie domain - true
force cookie - false
check ssl false
check user agent - false
check ip - false
prevent spider sessions - true
recreate session - true
ip to host conversion - false

[dcfxking]

Notwithstanding the fact that a number of bugs have been fixed in v1.3.0.1 and v1.3.0.2 and you should upgrade, it seems that that I may have spoken too soon ... the email feature described appears to have been put in the 1.3.0.3 release which isn't out yet.

I guess that explains it! So this feature def doesnt work yet?

[DrByte]

So this feature def doesnt work yet?

You could hack it in by yourself if you like. It'll be a bit different in the core when it's released, but you could try it this way:

/admin/customers.php
around line 35 you have:

      case 'status':
        if ($_GET['current'] == CUSTOMERS_APPROVAL_AUTHORIZATION) {
          $sql = "update " . TABLE_CUSTOMERS . " set customers_authorization=0 where customers_id='" . $_GET['cID'] . "'";
        } else {
          $sql = "update " . TABLE_CUSTOMERS . " set customers_authorization='" . CUSTOMERS_APPROVAL_AUTHORIZATION . "' where customers_id='" . $_GET['cID'] . "'";
        }
        $db->Execute($sql);
        $action = '';
        zen_redirect(zen_href_link(FILENAME_CUSTOMERS, 'cID=' . $_GET['cID'] . '&page=' . $_GET['page'], 'NONSSL'));
        break; 

change it to:

      case 'status':
  $customers_id = zen_db_prepare_input($_GET['cID']);
        if ($_GET['current'] == CUSTOMERS_APPROVAL_AUTHORIZATION) {
          $sql = "update " . TABLE_CUSTOMERS . " set customers_authorization=0 where customers_id='" . (int)$customers_id . "'";
        } else {
          $custinfo = $db->Execute("select customers_email_address, customers_firstname, customers_lastname
                                    from " . TABLE_CUSTOMERS . "
                                    where customers_id = '" . (int)$customers_id . "'");
          if ($custinfo->RecordCount() > 0) {
            $message = EMAIL_CUSTOMER_STATUS_CHANGE_MESSAGE;
            $html_msg['EMAIL_MESSAGE_HTML'] = EMAIL_CUSTOMER_STATUS_CHANGE_MESSAGE ;
            zen_mail($custinfo->fields['customers_firstname'] . ' ' . $custinfo->fields['customers_lastname'], $custinfo->fields['customers_email_address'], EMAIL_CUSTOMER_STATUS_CHANGE_SUBJECT , $message, STORE_NAME, EMAIL_FROM, $html_msg, 'default');
          }
          $sql = "update " . TABLE_CUSTOMERS . " set customers_authorization='" . CUSTOMERS_APPROVAL_AUTHORIZATION . "' where customers_id='" . $customers_id . "'";
        }
        $db->Execute($sql);
        $action = '';
        zen_redirect(zen_href_link(FILENAME_CUSTOMERS, 'cID=' . (int)$customers_id . '&page=' . $_GET['page'], 'NONSSL'));
        break; 

in /admin/includes/languages/english/customers.php
add these to the bottom of the file, before the closing ?>

define('EMAIL_CUSTOMER_STATUS_CHANGE_MESSAGE', 'Your customer status has been updated. Thank you for shopping with us. We look forward to your business.');
define('EMAIL_CUSTOMER_STATUS_CHANGE_SUBJECT', 'Customer Status Updated'); 

[dcfxking]

I made the changes but it seems to only be emailing the customer when I go from Green to Red (Approved to Pending)..I need it to email a status update only when they are approved (Red to Green)

Let me know if you think I did something wrong.

Thank you so much for your help - this will help automate my process so much!