Tag: Prestashop

To reset admin password for prestashop 1.6 or below, find value of _COOKIE_KEY from file

config/settings.inc.php 

The line look like

define('_COOKIE_KEY_', 'AySbNFrmveDOXDnEwiAEGxWAOYbckI1Vx2hDpu1JwgNFj19bPUyi6HBc');

Now you need to update ps_employee table using following SQL command.

update ps_employee set passwd=md5("AySbNFrmveDOXDnEwiAEGxWAOYbckI1Vx2hDpu1JwgNFj19bPUyi6HBcYOUR_NEW_PASSOWRD_HERE") where id_employee=1;

Replace “YOUR_NEW_PASSOWRD_HERE” with your new password.

ps_employee maybe differnt depending on what table prefix you selected during prestashop installation.

id_employee=1, change this with id_employee of the user you need to change password. 1 is id for first user.

Once password reset, you will be able to login to admin area. Normally prestashop rename admin folder to random name, this you can find it in FTP as it is just a normal folder.

To change database name, user name and password on PrestaShop 1.7 or later, edit file

./app/config/parameters.php

Once this is done, you need to login to PrestaShop backend and clear cache.

How to Clear Cache in PrestaShop

For older versions, edit

config/settings.inc.php

See PrestaShop

To change the domain name of a Prestashop site, you need to edit the MYSQL database.

Table ps_configuration

Value for following should be changed to new domain.

PS_SHOP_DOMAIN
PS_SHOP_DOMAIN_SSL

Table ps_shop_url

Change the “domain” and “domain_ssl” value.

Changing Installation Folder

If you changing the Prestashop installation folder, then you need to change “physical_uri” to the new path. If it is on root directory, use /

Here are SQL commands to change the URL of PrestaShop to “prestashop.test”

select * from ps_configuration where name="PS_SHOP_DOMAIN";
select * from ps_configuration where name="PS_SHOP_DOMAIN_SSL";
select * from ps_shop_url;

update ps_configuration set value="prestashop.test" where name="PS_SHOP_DOMAIN";
update ps_configuration set value="prestashop.test" where name="PS_SHOP_DOMAIN_SSL";
update ps_shop_url set domain="prestashop.test", domain_ssl="prestashop.test" where id_shop_url=1;

Clear Cache

Delete var/cache folder.

rm -rf var/cache

If Product images not showing after site migration, check PrestaShop Product Images not showing

See PrestaShop