UPDATE `customer_entity`
SET `password_hash` = CONCAT(SHA2('SaltPASSWORD', 256), ':SALT:1')
WHERE `entity_id` = 7615;
Please note that if SPJ9WIp7 is the salt and User’s password is 7qLzX33ETxYE, the following will be your query:
UPDATE `customer_entity`
SET `password_hash` = CONCAT(SHA2('SPJ9WIp77qLzX33ETxYE', 256), ':SPJ9WIp7:1')
WHERE `entity_id` = 7615;
7615 is the customer id
Lets break it into 2 parts:
a. Migrate Customer data
b. Migrate Customer Passwords
This is rather easy to be honest, there are several plugins for importing data from CSV and then mapping the CSV fields.
My recommended plugin is Customer/Order/Coupon CSV Import Suite by SkyVerge
It basically does everything from customer email to customer address data. It also provides column mapping and custom attribute import for all users. Also comes with multiple configuration options.
Best Free Alternative is https://wordpress.org/plugins/import-users-from-csv-with-meta
But in this one, you can not import magento2 passwords as of v 1.15.0.1
I will update about the solution very soon. So as of now only paid option is there.
This wordpress plugin checks and updates passwords of users migrated from Magento2 to WordPress
Plugin Link: https://github.com/harshvardhanmalpani/migrate-password-from-magento2-to-wordpress
user_pass column will have this kind data from Magento2 dcbdc524f215fd054502dcad5a23a702ec029c02ff8d7051d049f76e29927f8b:C8yVqeuPfkHWvkmipx0iKLPtOUGETpLL:1usermeta table must have a meta_key “migrated_cs” for this user, meta_value can be anything positiveFor new wordpress based users which dont have anything to do with magento2, it doesnt do anything
For all migrated users (those have the key “migrated_cs”), this plugin checks if input password matches old password from magento2 or not, if matched, it clears the key migrated_cs and updates the password using wordpress’ algorithm ; else results false.
Short Answer:
Not possible via Magento2 Admin Backend.
Solution:
You need to update eav_attribute table and edit information about backend_source, frontend_input etc.
Simple query for that is:
UPDATE `eav_attribute` SET `backend_model`="Magento\\\Eav\\\Model\\\Entity\\\Attribute\\\Backend\\\ArrayBackend", `backend_type`="varchar", `frontend_input`="multiselect", `source_model`=NULL WHERE `attribute_id`=YOUR_ATTRIBUTE_ID_INTEGER LIMIT 1
Replace YOUR_ATTRIBUTE_ID_INTEGER with your attribute_id like 355
Magento2 has this authentication pop up on checkout page, which many store owners wont like to see on their checkout page.
The pop up itself is generated by Magento_Customer::account/authentication-popup.phtml
But this pop up works very differently on checkout page. In fact this is a separate pop up than the one you see in header area. It is embedded in a series of js files which are governed by knockout-js
Other file responsible is: vendor/magento/module-checkout/view/frontend/web/js/proceed-to-checkout.js
Edit file or overload the file
app/design/frontend/YourVendor/YourTheme/Magento_Checkout/web/template/onepage.html
delete the following lines and save the file
<!-- ko foreach: getRegion('authentication') -->
<!-- ko template: getTemplate() --><!-- /ko -->
<!--/ko-->
Reference:
By default, app/design/Magento/Checkout/view/frontend/web/template/summary/cart-items.html file is being used
Or vendor/magento/module-checkout/view/frontend/web/template/summary/cart-items.html
To overload this file, create file cart-items.html in your theme folder. Make sure you place the file in Magento_Checkout/web/template/summary/
Edit the line
<span data-bind="text: getCartLineItemsCount()"></span>
And replace it with
<span data-bind="text: getItemsQty()"></span>
Reference Files:
vendor/magento/module-checkout/view/frontend/web/js/view/summary/cart-items.js
The following code does not adhere to Magento’s developer recommendations. Using object manager in such a way externally is a TERRIBLE idea.
Comment out line number 2 and then run the script. Edit line 11 and put the attribute code you want to dump
<?php
header("Location: /");exit;
use \Magento\Framework\App\Bootstrap;
error_reporting(E_ALL);
ini_set("display_errors", 1);
include('./app/bootstrap.php');
$bootstrap = Bootstrap::create(BP, $_SERVER);
$objectManager = $bootstrap->getObjectManager();
$eavConfig = $objectManager->get('\Magento\Eav\Model\Config');
$attribute = $eavConfig->getAttribute('catalog_product', 'manufacturer');
$options = $attribute->getSource()->getAllOptions();
$options = array_slice($options, 1);
usort($options, function($a, $b)
{
return strcasecmp($a['label'], $b['label']);
});
if (count($options))
$v = "<table>";
foreach ($options as $option) {
$v .= "<tr><td>" . $option['value'] . '</td><td>' . $option['label'] . '</td></tr>';
}
if (count($options))
$v .= "</table>";
echo $v;
?>
<style>
table tr:nth-child(odd){background:#444;color:#fff}
</style>
Edit the file pub/errors/default/503.phtml and put the following code
<?php
/**
* How to edit and customize code of Magento 2 Maintenance 503 Page
* Add analytics if any
* Replace <COMPANY NAME> with your Organization Name
*/
?>
<!doctype html>
<title>Site Maintenance</title>
<style>
body { text-align: center; padding: 150px; }
h1 { font-size: 50px; }
body { font: 20px Helvetica, sans-serif; color: #333; }
article { display: block; text-align: left; width: 650px; margin: 0 auto; }
a { color: #dc8100; text-decoration: none; }
a:hover { color: #333; text-decoration: none; }
</style>
<article>
<h1>We’ll be back soon!</h1>
<div>
<p>Sorry for the inconvenience but we’re performing some maintenance at the moment. If you need to you can always <a href="mailto:abcd@COMPANY NAME">contact us</a>, otherwise we’ll be back online shortly!</p>
<p>— Team COMPANY NAME</p>
</div>
</article>
In Magento Admin Panel, Go to Catalog in Left Menu > Categories
Select the category you want to edit and in Design Section > Layout Update XML, put this value:
<head>
<meta name="robots" content="NOINDEX,NOFOLLOW"/>
</head>
Save the category and then Clear the cache
On a fresh install of Magento2 on cpanel based hosting, you receive the following error while running any command on SSH
[eee@e1 www]$ php bin/magento cache:clean
X-Powered-By: PHP/7.0.31
Content-type: text/html; charset=UTF-8
bin/magento must be run as a CLI application
[eee@e1 www]$ php bin/magento setup:upgrade
X-Powered-By: PHP/7.0.31
Content-type: text/html; charset=UTF-8
bin/magento must be run as a CLI application
You have to point php to correct binary;
Use the following code in order:
First, open the file which can alter the runtime variables like .bash_profile or .bashrc
cd ~ ; nano .bash_profile
OR
cd ~ ;nano .bashrc
Go to last line and paste this (depending upon php version change ea-php71 or ea-php70):
alias php='/opt/cpanel/ea-php71/root/usr/bin/php'
Save the file and exit the editor.
Log out and login again OR use the following command
$ source ~/.bashrc
If you are not sure about current php version, use which php or php -v command. If you think the cpanel configuration is the issue, fix EasyApache 4 PHP cli issue. With this way you can fix the setting and enable the new php version