Please follow below steps to update customer password using custom php script and CSV file, please take db backup for safety.
Step 1: Created update_customer_password.php file in root of your magento project Paste Below Code in update_customer_password.php file
<?php
$mageFilename = 'app/Mage.php';
require_once $mageFilename;
Mage::setIsDeveloperMode(true);
ini_set('display_errors', 1);
umask(0);
Mage::app('admin');
Mage::register('isSecureArea', 1);
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
?>
<?php
$storagename = "customers.csv";
if(($handle = fopen("var/".$storagename, 'r')) !== FALSE) {
set_time_limit(0);
$row = 0;
$i=0;
while(($data = fgetcsv($handle, 0, ',')) !== FALSE) {
$num = count($data);
if($i!=0)
{
$csv[$row]['customers_email_address'] = $data[0];
$csv[$row]['customers_password'] = $data[1];
$row++;
}
$i++;
}
fclose($handle);
}
foreach($csv as $cust)
{
$customer = Mage::getModel('customer/customer');
$customer->setWebsiteId(1);
$customer->loadByEmail(strtolower($cust['customers_email_address']));
$customerid=$customer->getId();
if($customerid>0)
{
$write = Mage::getSingleton('core/resource')->getConnection('core_write');
$password = $cust['customers_password'];
$customerid=$customer->getId();
$write->query("update customer_entity_varchar set value='$password' where entity_id='$customerid' and attribute_id=12");
echo $cust['customers_email_address'].' ..................<b>Password Updated</b> <br>';
}
else
{
echo $cust['customers_email_address'].' ..................<b>Email NOT FOUND</b> <br>';
}
}
?>
Step 2: Please find .csv file for SAMPLE CSV COPY and put it in VAR folder/directory.
Step 3: Execute .php file in browser and check password is updated or not.
