Prestashop Change URL

To change domain name of a Prestashop site, you need to edit 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 “domain” and “domain_ssl” value.

Changing Installation Folder

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

Here are SQL commands to change 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;

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

1	rm -rf var/cache

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

See PrestaShop

Clear Cache

Leave a Reply Cancel reply