Reset customer password from admin

Does anybody know if someone has tackeld this problem or put in a feature request?

It would save a lot of time if there was a way to reset a customers password from the admin side of the site. Doing it through a mysql statement is not something I want a csr to be able to do. Has anybody requested this in the past and am I just being a nudge?

Does anybody else think this would be helpful?

The Forgotten Password doesn't work?

This will reset the password for the customer and email it to them ...

This works for about 90% of customers, but invariably there will be a few that either can't copy the new password in properly or don't get the reset email./ I find myself resetting their passwords for them to something common which they can go in and change later.

It always ends up in my lap though because I am the only one here who knows how to md5 a password or work in phpmyadmin. Xt cookmmerce threw the ability to do this in their admin and I thought it was a nice feature so I thought I would see if it was something that anyone had thought about or worked on

Hi there
Not sure what would change if you reset a password via the admin panel. We us the master password contribution so we can log into any customer's account if we need to (eg process a faxed order). On the odd occasion where we want to reset a customer's password we change the email address in admin to our own email, then reset theire password (which is emailled to us) and then change customer's email back to what it was.

That is an interesting way of solving the problem, I end up resetting passwords two or three times a week.

I know the reset password from the front end works for most people and I am quite sure that the people that it doesn't work for are probably human error. I am also positive that the people it doesn't work for don't end up buying and the few that do call to get help do end up purchasing.

The way I would like it to work is that in the customers admin area, when you click on the customer's name, you would have another button off to the right that would allow you to reset their password to a ord of your choice, or just add the password fields to the edit view.

I guess this isn't much of a problem for other people so I guess I will just mod it for my own sites.

Thanks to all who responded.

If you create this, will you share it please? I think it is a great idea. Some of us do get customers that are not very computer saavy and need assistance with copy and paste.

Thanks!

I, too, have to change manually the passwords of several customers on regular basis.

There is a fast way to do so: if you install the master password contribution, you can login to any customer's account, go to the "change password" menu and change it directly there (use the master password when asked the previous password of the customer, it will work)...

Don't forget to delete the cookies, otherwise you can not connect to another account from the same computer...

sanji

Quote:

---

Originally Posted by sanji

I, too, have to change manually the passwords of several customers on regular basis.

There is a fast way to do so: if you install the master password contribution, you can login to any customer's account, go to the "change password" menu and change it directly there (use the master password when asked the previous password of the customer, it will work)...

Don't forget to delete the cookies, otherwise you can not connect to another account from the same computer...

sanji

---

Yes, that worked for me. Obvious when you think about it.

Many thanks for the help.:blink:

Quote:

---

Originally Posted by Nedward

Yes, that worked for me. Obvious when you think about it.

Many thanks for the help.:blink:

---

I am getting this problem all the time, please could someone simplify how you install the master password contribution?

Very much appreciated for any reply'

Copy and paste the contents of pass.sql into Admin - Tools - Install SQL Patches then click Send.

Then drag and drop the 'includes' folder in the mod to the root dirctory of your site.

I tried logging in to the customer's account with the master password and resetting it from there but it did not work using the master password as the customer's password. I cleared cookies and still not working for me.

Anybody found a solution to this?

I also currently login with master password, but the whole process is time consuming.

I think the best option would be on the customers screen in admin you press a button and it changes the customer password to something common, such as 'password.' Shouldn't be terribly difficult, except for the whole encrypted part.

If anyone thinks they can do this, but needs a little motivation let me know and I will post it in the commercial section.

-lindasdd

NEW MODULE from Le Brand Real IT Solutions :

Change any customers password easily, directly from Admin !

Just download and install the attached zip file.

Tested on 1.3.9h and working fine.

Very simple module that should work an any 1.3.x version.

Thanks,



Le Brand Real IT Solutions - Charis Chrisochoou

GREECE

Quote:

---

Originally Posted by lebrand2006

NEW MODULE from Le Brand Real IT Solutions :

Change any customers password easily, directly from Admin !

Just download and install the attached zip file.

Tested on 1.3.9h and working fine.

Very simple module that should work an any 1.3.x version.

Thanks,



Le Brand Real IT Solutions - Charis Chrisochoou

GREECE

---

Hi, sorry for my bad english... I had install your module...
Then where i can change the password? If I go in the modify of the customer i don't see the box for change password...

Sorry for last message...Now I see "Change Password" in TOOLS of "ADMIN".... good module....
But there is a problem...it's not possible search a customer....I have 2400 customers...and it's impossible...
Now for to find a customer you need see all the page that there are in "Change Password"....Ist' possible put a "search" in the
"Change password" ???
Tks..

Quote:

---

Originally Posted by lebrand2006

NEW MODULE from Le Brand Real IT Solutions :

Change any customers password easily, directly from Admin !

Just download and install the attached zip file.

Tested on 1.3.9h and working fine.

Very simple module that should work an any 1.3.x version.

Thanks,



Le Brand Real IT Solutions - Charis Chrisochoou

GREECE

---

Does not support table prefixes. Uses only zenDB.customers and failes with a zenDB.prefix_customers convention.

Quote:

---

Originally Posted by studiogrynn

Does not support table prefixes. Uses only zenDB.customers and failes with a zenDB.prefix_customers convention.

---

Find in admin/passchange.php:

PHP Code:

---

  $action = (isset($_GET['action']) ? $_GET['action'] : ''); 


---

Below it add:

PHP Code:

---

$passchangeCust = (DB_PREFIX.'customers'); 


---

Change (what is now around line 34) from

PHP Code:

---

$db->Execute("UPDATE customers 


---

To:

PHP Code:

---

$db->Execute("UPDATE $passchangeCust 


---

And change (approx line 94)

PHP Code:

---

  $passchange_query_raw = "select customers_id, customers_lastname, customers_firstname, customers_email_address from customers order by customers_id"; 


---

To read:

PHP Code:

---

  $passchange_query_raw = "select customers_id, customers_lastname, customers_firstname, customers_email_address from $passchangeCust order by customers_id"; 


---

I have tested this only on my installation. Your experience may vary.

Question. Is there a way to add the option to be able to find the customers name? Especially if you have over 6,000 members. It makes it very difficult to find them.

By the way, thank you so much for offering this for free. It works great. Just need to be able to look up the customers. :clap:

I also meant to say thank you to Studio for the fix posted. I went ahead and fixed those spots before I uploaded. It works great.

The idea in Post #7 is probably a better way BUT I would use the Encrypted Master Password mod for 1.5.0 versus the older master password mod.

Hi,
I added a search, it is by email only.

after the line:

Code:

---

$action = (isset($_GET['action']) ? $_GET['action'] : '');

---

add:

Code:

---

$searchemail = (isset($_POST['email']) ? $_POST['email'] : '');

---

after the line (around line 80) :

Code:

---

<td class="pageHeading"><?php echo PASSCHANGE_HEADING_TITLE; ?></td>

---

add:

Code:

---

<td class="pageHeading">Search email <form action='' method=post><input type=text name=email><input type=submit></form></td>

---

Around line 98 :

Code:

---

    $passchange_query_raw = "select customers_id, customers_lastname, customers_firstname, customers_email_address from $passchangeCust order by customers_id";

---

replace with:

Code:

---

  if ($searchemail){
                $passchange_query_raw = "select customers_id, customers_lastname, customers_firstname, customers_email_address from $passchangeCust WHERE customers_email_address='$searchemail'";
  }else{
                $passchange_query_raw = "select customers_id, customers_lastname, customers_firstname, customers_email_address from $passchangeCust order by customers_id";
  }

---

It is quick and dirty, does not take into account languages etc but works for me.

Enjoy:

ouch, forgot the security check, the first part of the post above should read

after the line:

Code:

---

$action = (isset($_GET['action']) ? $_GET['action'] : '');

---

add:

Code:

---

$searchemail = (isset($_POST['email']) ? $_POST['email'] : '');
$searchemail = zen_db_prepare_input($searchemail);

---

Quote:

---

Originally Posted by dbltoe

The idea in Post #7 is probably a better way BUT I would use the Encrypted Master Password mod for 1.5.0 versus the older master password mod.

---

It does not work for me, using the master password for 'old password' gives 'bad old password' error. Hence the last 2 posts from me with how to add search to the excellent tool provided by Lebrand2006.

I prefer this method anyway rather than editing core files. Makes upgrades a nightmare when you have to go find all your core file mods and apply them to upgrades.

i still can't get this to work and i added the coding for 'prefixes' and still nothing. am i looking in the right place under admin/tools??

There's a recently-submitted plugin Reset Client Password from Admin that might do the trick for you (I haven't used it).

Quote:

---

Originally Posted by lat9

There's a recently-submitted plugin Reset Client Password from Admin that might do the trick for you (I haven't used it).

---

wow - perfect - it works... seems like the same one as the one i was trying from the forum but this one has one SQL update statement and that one did not.

Glad to hear that it's working for you!

Hello,

I just installed the "reset password from admin" plugin on a 1.3.9h zencart shop ... the option shows under admin / tools but it did not work : i changed a password but it is still the old password that applies ... any suggestion ?

thanks

Quote:

---

Originally Posted by badbod

ouch, forgot the security check, the first part of the post above should read

after the line:

Code:

---

$action = (isset($_GET['action']) ? $_GET['action'] : '');

---

add:

Code:

---

$searchemail = (isset($_POST['email']) ? $_POST['email'] : '');
$searchemail = zen_db_prepare_input($searchemail);

---

---

the search don't work: it found a blank customer.

I'm trying to setup the script also but I am running into the mySQL error.

ERROR: Cannot execute because table admin_pages(page_key, does not exist. CHECK PREFIXES!
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

I have the default zencart 1.51 and don't understand where to put whats it looking for. Can someone point me in the right direction?

Thanks

Did you install the SQL patch ?

That is the error I'm getting with the sql file that came with the plugin.

I'm having the same problem when I try to run the adminplacementv15.sql patch on ZC 1.5.1, I get:

Error ERROR: Cannot execute because table admin_pages(page_key, does not exist. CHECK PREFIXES!
Warning Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

I've tried changing the prefix to my db name, same error, only then it says MYDBNAME_admin_pages does not exist.

Dear Jesus, FINALLY! Posting this so everyone else who has dealt with issue can fix theirs, too.

Here is the correct text for the sql

INSERT INTO admin_pages (page_key, language_key, main_page, menu_key, display_on_menu, sort_order) VALUES ('passChange',
'BOX_TOOLS_PASSCHANGE', 'FILENAME_PASSCHANGE', 'tools', 'Y', '40');

The original one left out the space between "admin_pages" and "(page_key...)"

Quote:

---

Originally Posted by designsbytrina

Dear Jesus, FINALLY! Posting this so everyone else who has dealt with issue can fix theirs, too.

Here is the correct text for the sql

INSERT INTO admin_pages (page_key, language_key, main_page, menu_key, display_on_menu, sort_order) VALUES ('passChange',
'BOX_TOOLS_PASSCHANGE', 'FILENAME_PASSCHANGE', 'tools', 'Y', '40');

The original one left out the space between "admin_pages" and "(page_key...)"

---

Thank you very much for this! After an hour of trying this was the remedy. It should probably be changed in the file before others get caught up with the same issue.

Installs on my 1.3.9h site. Admin/tools/Change Passwords appears. No search bar. I installed it on another 1.5.4 site and it works fine. Why no search box on 1.3.9h? Am I supposed to install the 1.5.* sql file for a 1.3.9h site?

Quote:

---

Originally Posted by charmlt

Installs on my 1.3.9h site. Admin/tools/Change Passwords appears. No search bar. I installed it on another 1.5.4 site and it works fine. Why no search box on 1.3.9h?

---

Best guess is that something about the 1.3.9 code is different from the 1.5.4 code such as the name of the function to call for the search box, or the sequence of some internal variables is different. I realize not a highly technical response, but see below..

Quote:

---

Originally Posted by charmlt

Am I supposed to install the 1.5.* sql file for a 1.3.9h site?

---

The real question is shouldn't I be upgrading a 1.3.9 site to the latest version so that when the host no longer offers PHP 5.2.17 possibly later this year that the site will still operate?

Hi there guys,

So I installed everything fine with no errors. Installed the SQL patch too, no problem there. Searched for a customer (used my testing account) and reset my password. But the new password doesn't work. Anyone else have this issue or have a solution?

Regards, Hannat

Edit:

Using: Zen Cart v1.5.4, PHP Version 5.4.33 and my DB doesn't have prefixes

Ok,

I figured out that the reason it isn't changing the password is because after hitting "Submit Query" it will find the customer but when you click on "Change Password" the page that is loaded is 'blank'. The customer is no longer selected, so typing in a password there won't do anything.

Any help here?

Regards, Hannat

Quote:

---

Originally Posted by Hannat

Ok,

I figured out that the reason it isn't changing the password is because after hitting "Submit Query" it will find the customer but when you click on "Change Password" the page that is loaded is 'blank'. The customer is no longer selected, so typing in a password there won't do anything.

Any help here?

Regards, Hannat

---

Blank/partial blank: http://www.zen-cart.com/content.php?124-blank-page

Quote:

---

Originally Posted by mc12345678

Blank/partial blank: http://www.zen-cart.com/content.php?124-blank-page

---

Let me rephrase. The page isn't blank, the page loads perfectly. The fields that should have my selected customer's details in are blank.

Sorry about that.

Maybe I am not making any sense.

Once I have selected a customer, via searching for them using their email address, and clicking "Change Password" when the page reloads this is what I see.

Attachment 15081

As you can see the customer name and customer email is blank, so entering a new password doesn't do anything as no customer is selected.

Some help would be appreciated.

Regards, Hannat

Be sure all of the plugin files have uploaded correctly. Corrupt uploads can happen. Anything in the error logs?

I'm having the same issue. I've found that it only occurs when using the search function (which does some pretty weird things). If you page through and select from the list of customers, everything seems to work. So problem is in the search. I've been looking through the code but haven't found the problem yet.

Okay, found the problem and fixed it. I've submitted an update to this plug-in.

Quote:

---

Originally Posted by batracy

Okay, found the problem and fixed it. I've submitted an update to this plug-in.

---

Can you share what the fix was. This is also kept on Github so would like to update there too.

There were about four changes made to the passchange.php file in the admin folder. No other folders or files were changed.

First change was to move the line that sets the $customers_id variable outside the block and moved it up with the other items getting passed variables and information as follows:

Code:

---

  $passchangeCust = (DB_PREFIX.'customers');
  $customers_id = (isset($_GET['cID']) ? zen_db_prepare_input($_GET['cID']) : '');

  if (zen_not_null($action)) {
    switch ($action) {

---

Second change was to add an elseif where the passchange_query_raw variable is set as follows:

Code:

---

if ($searchemail){
                $passchange_query_raw = "select customers_id, customers_lastname, customers_firstname, customers_email_address from $passchangeCust WHERE customers_email_address='$searchemail'";
  }elseif ($customers_id){
                $passchange_query_raw = "select customers_id, customers_lastname, customers_firstname, customers_email_address from $passchangeCust WHERE customers_id='$customers_id'";
  }else{
                $passchange_query_raw = "select customers_id, customers_lastname, customers_firstname, customers_email_address from $passchangeCust order by customers_id";
  }

---

The other two changes were just to make sure the cID variable is not passed when the users presses the Cancel button.

Quote:

---

Originally Posted by charmlt

Installs on my 1.3.9h site. Admin/tools/Change Passwords appears. No search bar. I installed it on another 1.5.4 site and it works fine. Why no search box on 1.3.9h? Am I supposed to install the 1.5.* sql file for a 1.3.9h site?

---

I have the same issue on a site running 1.39h. No search box - and upgrading this site is not an option. Anybody have any ideas?

Quote:

---

Originally Posted by RescoCCC

I have the same issue on a site running 1.39h. No search box - and upgrading this site is not an option. Anybody have any ideas?

---

Problem solved. Just upload the files from the 1.5x folder. Works perfectly.

I just installed Reset--Customer-Password on Zen Cart 1.5.4.
I changed the admin folder name to my admin folder name.
I copied pasted and sent the SQL add_admin_menu_entry-v15xsql

Either it didn't work or I just don't know where to find it.
Can someone tell me where it is suppose to be.
k

Quote:

---

Originally Posted by ken1

I just installed Reset--Customer-Password on Zen Cart 1.5.4.
I changed the admin folder name to my admin folder name.
I copied pasted and sent the SQL add_admin_menu_entry-v15xsql

Either it didn't work or I just don't know where to find it.
Can someone tell me where it is suppose to be.
k

---

What version of Zen Cart do you have?
Where did paste teh sql file? It should have been in Tools>Install SQL Patches

The Zen Cart version is 1.5.4 and yes the patch was installed in Tools>SQL Patches

If I recall, a Change Passwords option is added the the Tools menu.

Thanks.
You are right. I didn't know where to look. I found it under tools and it works.
I appreciate the help.
ken

I did this, everything loaded OK, but the Master password returns this error

Error: Sorry, there is no match for that email address and/or password.

Quote:

---

Originally Posted by stevesh

Copy and paste the contents of pass.sql into Admin - Tools - Install SQL Patches then click Send.

Then drag and drop the 'includes' folder in the mod to the root dirctory of your site.

---

I went to MY Store and changed the Master Password, but it is not working. Any ideas?

Quote:

---

Originally Posted by johnniejetski

I went to MY Store and changed the Master Password, but it is not working. Any ideas?

---

This is not the master password support thread. This plugin resets customer passwords.

@jeking, just wanted to report a bugfix to you. I'm using Admin Profiles, and realized that enabling 'Change Customer Password' from the profile editor did not actually give access to my client's admin account. I found that the page key had a capital 'C' (passChange), but it should be lowercase to allow access to passchange.php.

Here is the updated SQL that worked for me:

Code:

---

INSERT INTO admin_pages (page_key, language_key, main_page, menu_key, display_on_menu, sort_order) VALUES ('passchange', 'BOX_TOOLS_PASSCHANGE', 'FILENAME_PASSCHANGE', 'tools', 'Y', '40');

---

Quote:

---

Originally Posted by jackie.taferner

@jeking, just wanted to report a bugfix to you. I'm using Admin Profiles, and realized that enabling 'Change Customer Password' from the profile editor did not actually give access to my client's admin account. I found that the page key had a capital 'C' (passChange), but it should be lowercase to allow access to passchange.php.

Here is the updated SQL that worked for me:

Code:

---

INSERT INTO admin_pages (page_key, language_key, main_page, menu_key, display_on_menu, sort_order) VALUES ('passchange', 'BOX_TOOLS_PASSCHANGE', 'FILENAME_PASSCHANGE', 'tools', 'Y', '40');

---

---

Thanks for the report and the fix.