Add Customers from Admin 2.0 (1.5.0 and later) [Support Thread]

@linuxguy2, I'll need to review/update the plugin for continued support on Zen Cart 1.5.5 and later. Last time I touched it was 3 years ago, a millennium in Zen Cart time!

I'll post back here once I've had a chance to see how it "plays with" current Zen Cart versions.

Quote:

---

Originally Posted by lat9

@linuxguy2, I'll need to review/update the plugin for continued support on Zen Cart 1.5.5 and later. Last time I touched it was 3 years ago, a millennium in Zen Cart time!

I'll post back here once I've had a chance to see how it "plays with" current Zen Cart versions.

---

Lat9

Yes 3 years is a long, long time :)

Because it's incorrect do you know how to get parts 2a and 2b removed from my post #108 and #109?

Thanks for your help.

Quote:

---

Originally Posted by linuxguy2

Lat9

Yes 3 years is a long, long time :)

Because it's incorrect do you know how to get parts 2a and 2b removed from my post #108 and #109?

Thanks for your help.

---

Due to the way that the Zen Cart forums operate, you could send a PM to the moderators (e.g. swguy) to request that a posting be removed or modified.

Hey Lat9,

I installed Add_customers_from_admin-2.0.9 on my ZC server recently. The admin copy of the welcome email that gets sent still includes EMAIL_TEXT instead of the email body. I see that you fixed it in version 2.0.1 but it looks like it's still happening... Anyway you could point me in the right direction as to fixing this? I know it was a few years ago.

Regards,
Nick

Quote:

---

Originally Posted by nvales

Hey Lat9,

I installed Add_customers_from_admin-2.0.9 on my ZC server recently. The admin copy of the welcome email that gets sent still includes EMAIL_TEXT instead of the email body. I see that you fixed it in version 2.0.1 but it looks like it's still happening... Anyway you could point me in the right direction as to fixing this? I know it was a few years ago.

Regards,
Nick

---

Nick, I haven't had the chance to update this plugin for continued support under Zen Cart 1.5.6 and later. I'll put it on my list to check.

An updated version tested on ZC 1.5.7c with PHP 7.4 has now been made available in the plugins section.
https://www.zen-cart.com/downloads.php?do=file&id=1477

1.5.7c
PHP 7.5

I am working with "add_customers_from_admin-2.0.10" plugin.

On the backend page "Add Customers" I need the "Choose A Customer" dialog to be sorted so I can actually find a customer easily.
In the file "add_customers_backend.php", at line 642, I added "ORDER BY customers_lastname" but it is not working.
Can someone tell me how to get this sort to work?

Code:

---

function create_customer_drop_down() {
  global $db;
  $customers = array();
  $customers[] = array ( 'id' => '0', 'text' => TEXT_PLEASE_CHOOSE );
 
  $sql = "SELECT customers_id, customers_firstname, customers_lastname, customers_email_address FROM " . TABLE_CUSTOMERS . " ORDER BY customers_lastname";
  $customersRecords = $db->Execute($sql);
 
  while (!$customersRecords->EOF) {
    $customers[] = array('id' => $customersRecords->fields['customers_id'], 'text' => $customersRecords->fields['customers_firstname'] . ' ' . $customersRecords->fields['customers_lastname'] . ' (' . $customersRecords->fields['customers_email_address'] . ')');
    $customersRecords->MoveNext();
  }
 
  return $customers;
}

---

Thank You for your assistance with this.

Quote:

---

Originally Posted by wsworx

1.5.7c
PHP 7.5

I am working with "add_customers_from_admin-2.0.10" plugin.

On the backend page "Add Customers" I need the "Choose A Customer" dialog to be sorted so I can actually find a customer easily.
In the file "add_customers_backend.php", at line 642, I added "ORDER BY customers_lastname" but it is not working.
Can someone tell me how to get this sort to work?

Code:

---

function create_customer_drop_down() {
  global $db;
  $customers = array();
  $customers[] = array ( 'id' => '0', 'text' => TEXT_PLEASE_CHOOSE );
 
  $sql = "SELECT customers_id, customers_firstname, customers_lastname, customers_email_address FROM " . TABLE_CUSTOMERS . " ORDER BY customers_lastname";
  $customersRecords = $db->Execute($sql);
 
  while (!$customersRecords->EOF) {
    $customers[] = array('id' => $customersRecords->fields['customers_id'], 'text' => $customersRecords->fields['customers_firstname'] . ' ' . $customersRecords->fields['customers_lastname'] . ' (' . $customersRecords->fields['customers_email_address'] . ')');
    $customersRecords->MoveNext();
  }
 
  return $customers;
}

---

Thank You for your assistance with this.

---

Never mind folks.
I now see that is actually sorting by last name.
If I want the last name to show first I have to rearrange the code accordingly.

Hi,
2 days ago I installed this plugin (Add customers from Admin 2.0).
Now today when I click on the send email link, I see only a blank page.
Why is it so?
How to correct it?
Attachment 19848

Blank page guidance: https://docs.zen-cart.com/user/troub...ng/blank_page/