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

[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.

[linuxguy2]

@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.

[lat9]

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.

[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

[lat9]

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.

[strelitzia]

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

[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?

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.

[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?

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.

[RK123]

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?

[swguy]

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