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

Chrissy Morris:

Hi,
I've just installed Add Customers From Admin version 1.5.0.
I'm adding customers details individually as and when a customer calls us.
Just wondering if there is a way to switch off the customer's e-mail address field so that it's not necessary to enter an e-mail address?
This would be handy for us as most of our customers who place an order over the 'phone do so because they are not familiar with using web sites and don't have an e-mail address.
Thanks in advance,
Christine
Chrissy, unfortunately it's the customer's email-address that Zen Cart uses to identify which customer you're dealing with.

Perhaps instead of using Add Customers from Admin to define those unique customer accounts, you could create an "order-taker" account that's associated with one of the store's email addresses.

That way, you'd change the bill-to and ship-to addresses for every order, but then you'd have an easy record of what orders were placed over the phone, too.

lat9:

Chrissy, unfortunately it's the customer's email-address that Zen Cart uses to identify which customer you're dealing with.

Perhaps instead of using Add Customers from Admin to define those unique customer accounts, you could create an "order-taker" account that's associated with one of the store's email addresses.

That way, you'd change the bill-to and ship-to addresses for every order, but then you'd have an easy record of what orders were placed over the phone, too.

Many thanks for your reply.
I'll look into your suggestion.
Thanks again.

Thank you for this great Plug-In
I am using 1.5.5e
How do I remove the duplicate Add Customer from the drop menu?

That's going to require some database surgery. You'll need to look in the admin_pages table, looking for entries with a menu_key value of customers. There's (somehow) a duplicate in there.

I'd be interested to know what values are present before you remove one!

lat9:

That's going to require some database surgery. You'll need to look in the admin_pages table, looking for entries with a menu_key value of customers. There's (somehow) a duplicate in there.

I'd be interested to know what values are present before you remove one!

So this is what I have in the database

So I just changed "customersAddCustomer"'s "Show On Menu" status to "N", column to the far right. That took the extra one off.

You must have installed ***Admin: New Customer ***at one point, that's where the additional menu item came from.

lat9:

You must have installed ***Admin: New Customer ***at one point, that's where the additional menu item came from.

Your correct, sort of.
I remembered after the fact that I was using a copy of the live database to get this new site setup.
The old site had this same issue so that is why it popped up with this fresh installation.....lol.
Probably 75% of most issues are always generated by the user.

wsworx:

Your correct, sort of.
I remembered after the fact that I was using a copy of the live database to get this new site setup.
The old site had this same issue so that is why it popped up with this fresh installation.....lol.
Probably 75% of most issues are always generated by the user.

Hi,

I have read the documentation and all the posts in the forum but still have a couple questions.

1:
I have a fresh install of 1.5.6a and during testing several accounts and orders have been created and deleted.
Will there be a conflict in the database Customer ID & Address ID sequence numbers if I delete all the customers and orders (except the Guest) in the new ZC 1.5.6a installation and then import 800+ customers from the ZC 1.5.1. installation?

2:
When doing the import I take it the script generates a new password which can then be emailed to the customer.
2a:
If I'm not mistaken during my testing when I copied the current 1.5.1 (35 character) encrypted password from the old account to the new account (Using PHP Admin) the first time the customer log into 1.5.6a it accepted the customers former password and converted it to the new ( 60 character) encryption.
So am I correct in saying when going from 1.5.1 to 1.5.6a there is now no need to deal with password resets if you also copy the password.
2b:
If that is correct it would be a nice feature to add and so some guidance on where to modify that in the script to not generate a new password but just copy the old one over would be appreciated.

3:
Several of these customers have multiple Bill to Addresses .
I'm assuming I will need to identify those customers and import those additional addresses into their address book(s).
I have done this in the past when creating new accounts for these persons but I was just wondering of ZC 1.5.6a treats the address book differently.

Many Thanks for your time!!!

linuxguy2:

Hi,

I have read the documentation and all the posts in the forum but still have a couple questions.

1:
I have a fresh install of 1.5.6a and during testing several accounts and orders have been created and deleted.
Will there be a conflict in the database Customer ID & Address ID sequence numbers if I delete all the customers and orders (except the Guest) in the new ZC 1.5.6a installation and then import 800+ customers from the ZC 1.5.1. installation?

2:
When doing the import I take it the script generates a new password which can then be emailed to the customer.
2a:
If I'm not mistaken during my testing when I copied the current 1.5.1 (35 character) encrypted password from the old account to the new account (Using PHP Admin) the first time the customer log into 1.5.6a it accepted the customers former password and converted it to the new ( 60 character) encryption.
So am I correct in saying when going from 1.5.1 to 1.5.6a there is now no need to deal with password resets if you also copy the password.
2b:
If that is correct it would be a nice feature to add and so some guidance on where to modify that in the script to not generate a new password but just copy the old one over would be appreciated.

3:
Several of these customers have multiple Bill to Addresses .
I'm assuming I will need to identify those customers and import those additional addresses into their address book(s).
I have done this in the past when creating new accounts for these persons but I was just wondering of ZC 1.5.6a treats the address book differently.

Many Thanks for your time!!!

Additional information desired:
I am using the "Additional Customer Fields" plugin.
customers_extrafield, customers_extrafield2, customers_extrafield3 and customers_extrafield4
Can I just add those entries to the code and the *.csv file and expect that info to be imported also?
if so a little guidance on where/how to add that to the script be greatly appreciated.

Thanks,

linuxguy2:

Additional information desired:
I am using the "Additional Customer Fields" plugin.
customers_extrafield, customers_extrafield2, customers_extrafield3 and customers_extrafield4
Can I just add those entries to the code and the *.csv file and expect that info to be imported also?
if so a little guidance on where/how to add that to the script be greatly appreciated.

Thanks,

Looks like I was WRONG about about 2a and 2b in my original post!!!

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

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

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

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?

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.

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?

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