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

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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?
Attachment 17541

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!

Quote:

---

Originally Posted by 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

Attachment 17546

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.

Quote:

---

Originally Posted by 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.

Quote:

---

Originally Posted by 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!!!

Quote:

---

Originally Posted by 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,

Quote:

---

Originally Posted by 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.

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/

Quote:

---

Originally Posted by swguy

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

---

Thanks.
But I am still stuck with the blank page If I click on the send email link.

I could see other issues as well.
When I try to log in from the front end, I get whoops your session has expired message.

All these happened after I installed the add customers from admin 2.0 plugin.
Now I have removed all those files. But these problems still exist.

How to proceed further.

I am using: Zencart v1.5.1
PHP- Version 5.6.40

Quote:

---

Originally Posted by RK123

Thanks.
But I am still stuck with the blank page If I click on the send email link.

I could see other issues as well.
When I try to log in from the front end, I get whoops your session has expired message.

All these happened after I installed the add customers from admin 2.0 plugin.
Now I have removed all those files. But these problems still exist.

How to proceed further.

I am using: Zencart v1.5.1
PHP- Version 5.6.40

---

Noting that there are no storefront/front-end files changed by this plugin; could you post the contents of one of the logs you're receiving, making sure to xxx-out your site's secret-admin-subdirectory name.

Quote:

---

PHP Fatal error: Maximum execution time of 60 seconds exceeded in /home/XXXXXXX/public_html/ adminxxxx /includes/functions/general.php on line 33

PHP Fatal error: Maximum execution time of 60 seconds exceeded in /home/ XXXXXXX /public_html/includes/classes/db/mysql/query_factory.php on line 482


PHP Fatal error: Maximum execution time of 60 seconds exceeded in /home/ XXXXXXX /public_html/adminxxxx/includes/functions/database.php on line 16

PHP Fatal error: Maximum execution time of 60 seconds exceeded in /home/ XXXXXXX /public_html/adminxxxxx/add_customers_backend.php on line 650


PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4980709 bytes) in /home/ XXXXXXX /public_html/adminxxxxxxx/includes/functions/html_output.php on line 324



PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in /home/ XXXXXXX /public_html/includes/classes/db/mysql/query_factory.php on line 486

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted
(tried to allocate 20 bytes) in /home/ XXXXXXX /public_html/includes/functions/audience.php on line 60

PHP Fatal error: Allowed memory size of 134217728 bytes exhausted
(tried to allocate 1048576 bytes) in /home/ XXXXXXX /public_html/adminxxxxxxx/add_customers_backend.php on line 651

PHP Fatal error: Maximum execution time of 60 seconds exceeded in /home/ XXXXXXX /public_html/adminxxxxxxxx/add_customers_backend.php on line 73

---

These are some of the logs

Quote:

---

Originally Posted by RK123

These are some of the logs

---

Those logs don't make any sense to me, although it could be a by-product of running the (oldy-moldy) zc151 on PHP 5.6.40. I didn't think that zc151 would run on PHP versions above 5.4.

I've just submitted v3.0.0 of Add Customers from Admin for the Zen Cart moderators' review; I'll post back here when it's available for download.

This version (see https://github.com/lat9/add_customers_from_admin) is a heavy rewrite/refactor and now requires Zen Cart 1.5.7 (or later) for its proper operation.

Various PHP notices, warnings and deprecations were corrected.
The processing in the admin's add_customers_backend.php has been moved to /admin/includes/classes/addCustomers.php

Quote:

---

Originally Posted by lat9

I've just submitted v3.0.0 of Add Customers from Admin for the Zen Cart moderators' review; I'll post back here when it's available for download.

This version (see https://github.com/lat9/add_customers_from_admin) is a heavy rewrite/refactor and now requires Zen Cart 1.5.7 (or later) for its proper operation.

Various PHP notices, warnings and deprecations were corrected.
The processing in the admin's add_customers_backend.php has been moved to /admin/includes/classes/addCustomers.php

---

Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=1477

Hi All,

I'm running Zen Cart 1.5.7c and installed Add Customers from Admin v3.0.0.... All seems to be working fine so far! Great job!

I have the MOD "Extra Fields on Customer Sign Up" installed (also working fine), but I wanted to add these extra fields to "Add Customers from Admin v3.0.0".....

I've added the Labels & Text Fields to "STORE_ADMIN/add_customers.php.... All good there!

---------------------------

My Question.....

Where do I add the "extra-field" code so that the additional data is submitted with the Add Customer Form?

Does it go in "STORE_ADMIN/includes/classes/addCustomers.php" ??

If Yes, is that the only place?

Thanks!

Yes, you'll update the insertCustomer method in /YOUR_ADMIN/includes/classes/addCustomers.php to also insert those newly-added fields.

Quote:

---

Originally Posted by lat9

Yes, you'll update the insertCustomer method in /YOUR_ADMIN/includes/classes/addCustomers.php to also insert those newly-added fields.

---

Great! Worked like a charm.... :cool:

Thanks for your reply lat9!

Hello there. I am using 1.5.6c for my store. When i install the plugin , it shows the link for it in admin/customers , but when i click on it I get a blank page. The log file says

PHP Warning: require(includes/admin_html_head.php): failed to open stream: No such file or directory in /home/user/domain/admin/add_customers.php on line 128.

Line 128 of that file is <?php require DIR_WS_INCLUDES . 'admin_html_head.php'; ?>

What am i missing here ?

Version: v3.0.0 only runs on 1.5.7. You will need to use an older version or upgrade your cart.

Ah thank you so much! , I should have read the compatible versions list right under the downloads. 2.0.10 is the last version that supported my 1.5.6 cart. Thanks again.

I am busy upgrading my store to ZenCart v158.
Upon installing this plugin's latest version, I get an Err 500 when accessing the admin/customers/add customer function.
The error log mentions a missing file admin/includes/languages/english/gv_name.php
It seems this fiile was renamed in ZC v158 to lang.gv_name.php

How can I fix it?
Any support thread about the new naming of language fles? (Can I expect similar problems with this/other plugin modules...)

This plugin (and many others) will need some love before they're fully ready for 1.5.8. For now, just add customers on the storefront.

Quote:

---

Originally Posted by swguy

This plugin (and many others) will need some love before they're fully ready for 1.5.8. For now, just add customers on the storefront.

---

Thank you for the prompt reply, swguy.

Makes me feel really disheartened, though. It started with the hosting provider only supporting pHp8.0 and up from beginning October.
I had to fix a lot of errors on my v155 store in order to get it working. It is still running at the moment, albeit shakily. However, the amount of error logs created every day is just crazy, so I decided to upgrade to v157.

The v157 upgrade caused a lot of database integration problems though. (I did not perform the steps in the best order).

So this week I decided to start over (as per your suggestions). Then I discovered v158 was released. In order to buy some extra time until the next forced pHp upgrade, I decided to give it a go. Now, after many hours of work, I realize that many plugins will need an update before being compatible (e.g. due to different language file convention).

Unfortunately, after 10 years we have learnt to rely heavily on some plugins in order to get the work done in a sufficient way on a daily basis...

Seems I will have to start again on v157, hopefully encountering less integration problems.

Wish I knew about all this before I started...

Basically, it is "Welcome to the world of opensource".
As a small business it cost too much to buy premade that someone maintains constantly. But still cost too much to try and do it yourself with software that others have been gracious enough to share or share at a lower cost than they really should be making for it. For me it has tended to be a game of staying up to date enough not to get hacked but not so much that your software stops functioning at the level you need it to.

As a reminder, you can always hire this kind of work out. If you hire someone from the Commercial Help Wanted forum, you're supporting the product too.

Quote:

---

Originally Posted by wsworx

Basically, it is "Welcome to the world of opensource".
As a small business it cost too much to buy premade that someone maintains constantly. But still cost too much to try and do it yourself with software that others have been gracious enough to share or share at a lower cost than they really should be making for it. For me it has tended to be a game of staying up to date enough not to get hacked but not so much that your software stops functioning at the level you need it to.

---

wsworx, as a small business owner, I agree 100% with your philosophy and have consented to the struggle many years ago. (In a way, I even enjoyed the challenges).

However, in the case of v158, it would have been nice to be warned in some way of the many additional pitfalls...

Quote:

---

Originally Posted by swguy

As a reminder, you can always hire this kind of work out. If you hire someone from the Commercial Help Wanted forum, you're supporting the product too.

---

swguy, I would love to be able to do that. But, residing in South Africa, the exchange rate just makes it basically impossible. (I have asked for quotes in the Help Wanted forum in the past). So, I am stuck with my own rusted programming skills. Luckily my son is a full stack developer, and I can bug him (when he is available) for some assistance (only costing me the price of a meal or two...)

> However, in the case of v158, it would have been nice to be warned in some way of the many additional pitfalls...

Please create the change you want to see. It's the open source way. PRs are welcome to the documentation repo at
https://github.com/zencart/documentation

I have beefed up the Release Specific Upgrade Considerations page.
https://docs.zen-cart.com/user/upgra...onsiderations/

>However, in the case of v158, it would have been nice to be warned in some way of the many additional pitfalls...

IMHO this is a definite use-case for the hated <blink> tag, to point out in big flashing text in no uncertain terms that trying to integrate ZC158 into an existing shop as an "upgrade" is just not a feasible option/the path of madness. There are too many changes and will introduce multiple break points with mods.

Users should take a new ZC158, import and upgrade their real database and then sequentially add their mods one by one, fixing, fettling and learning along the way.

This module is working ok for me on 158a after a small change to add_customers.php
Line 395 replace zen_get_countries() with zen_get_countries_for_admin_pulldown()

You will have a blank dropdown if you don't make this edit.

Quote:

---

Originally Posted by strelitzia

This module is working ok for me on 158a

---

I should point out that the site where it's used isn't using States and looking at the code for that I suspect it may need updating too.

Quote:

---

Originally Posted by strelitzia

I should point out that the site where it's used isn't using States and looking at the code for that I suspect it may need updating too.

---

Quote:

---

Originally Posted by strelitzia

This module is working ok for me on 158a after a small change to add_customers.php
Line 395 replace zen_get_countries() with zen_get_countries_for_admin_pulldown()

You will have a blank dropdown if you don't make this edit.

---

Thanks for the update. I've not updated this in many years since I don't have clients who use it.

Quote:

---

Originally Posted by lat9

Thanks for the update. I've not updated this in many years since I don't have clients who use it.

---

I tested it on a site using states and it does indeed ned further edits else it stops loading after the states label.

As you haven't had any need to update it I will put together an update and submit it to ZC plugins if that's ok with you @lat9

Quote:

---

Originally Posted by strelitzia

I tested it on a site using states and it does indeed ned further edits else it stops loading after the states label.

As you haven't had any need to update it I will put together an update and submit it to ZC plugins if that's ok with you @lat9

---

I'd prefer that you PR the changes to https://github.com/lat9/add_customers_from_admin so that we don't wind up with multiple sources for the plugin's files.

Is this plugin compatible in 1.5.8?

Quote:

---

Originally Posted by jodean

Is this plugin compatible in 1.5.8?

---

Nope, last updated for v1.5.7.

Using 1.5.8a
Classic Responsive
Plugins used are SBA, Access Blocker, EP
I need to move all customer data from one website to another. When I say customer data, I am referring to address book, previous orders, login info, etc.

I have in the past exported the data via phpmyAdmin one table at a time, which is fine, but a bit time consuming. Can you tell me if this plugin is intended to do the same thing? Looks like it may be a moot point since it's not working with 1.5.8a, according to the last comment, but was hoping there may be another suggested direction.
Thank you so much.

Quote:

---

Originally Posted by chuckrey

Using 1.5.8a
Classic Responsive
Plugins used are SBA, Access Blocker, EP
I need to move all customer data from one website to another. When I say customer data, I am referring to address book, previous orders, login info, etc.

I have in the past exported the data via phpmyAdmin one table at a time, which is fine, but a bit time consuming. Can you tell me if this plugin is intended to do the same thing? Looks like it may be a moot point since it's not working with 1.5.8a, according to the last comment, but was hoping there may be another suggested direction.
Thank you so much.

---

This plugin simply addresses customer information (i.e. the base customers-table record and any address-book entries). I'll note that it can be very dangerous to also capture previous orders into a pre-existing database.

Dutch translation for Zen Cart 1.5.7 (in Admin folder).

DirkS