Every time that I have to move a PrestaShop site, developing or supporting XT Search for Algolia, I face the same dilemma. I follow the steps recommended in the official Best Development Practices: How can I migrate my PrestaShop store to a new server? Still, after downloading the backup, restoring the files, restoring the database and configuring app/config/parameters.php I got redirected to the original domain!

my how to migrate prestashop from one server to another server

The problem is simple, you restore the site, you test the new site and ...

~$ curl -I https://demo-prestashop.localhost/

HTTP/1.1 301 Moved Permanently
Date: Wed, 01 Apr 2020 16:58:07 GMT
Server: Apache/2.4.29 (Ubuntu)
Strict-Transport-Security: max-age=31536000; includeSubDomains
Location: https://demo-prestashop.extly.com/
Content-Type: text/html; charset=iso-8859-1

The solution: replace the domain that is repeated four times in the database tables! ... and, of course, the domain is also in the .htaccess.

  • Table `dbprefix_configuration`, records PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL
  • Table `dbprefix_shop_url`, fields `domain` and `domain_ssl`

UPDATE `dbprefix_configuration` SET `value` = "demo-prestashop.localhost" WHERE `value` = "the-original-domain.com";
UPDATE `dbprefix_configuration` SET `value` = "http://demo-prestashop.localhost" WHERE `value` = "http://the-original-domain.com";
UPDATE `dbprefix_configuration` SET `value` = "https://demo-prestashop.localhost" WHERE `value` = "https://the-original-domain.com";
UPDATE `dbprefix_shop_url` SET `domain` = "demo-prestashop.localhost", `domain_ssl` = "demo-prestashop.localhost" WHERE `domain` = "the-original-domain.com";
  1. Change app/config/parameters.php 
  2. Change the .htaccess
  3. Run the queries to change the `dbprefix_configuration` and `dbprefix_shop_url` tables
  4. To be on the safe side, clear the cache folder var/cache/prod

That's it! Clear the cache and no more redirections.

curl -I https://demo-prestashop.localhost/
HTTP/2 200 
date: Wed, 01 Apr 2020 17:06:32 GMT

To the moon!