Category Archives: PrestaShop

PrestaShop related tips.

PrestaShop – Setup TEST site in sub-domain

Clone production DB to a new database and run following query in new DB


UPDATE `ps_shop` SET `name`=concat('TEST ',`name`);
UPDATE `ps_shop_url` SET `domain`=concat('test.',`domain`),`domain_ssl`=concat('test.',`domain_ssl`);
UPDATE `ps_configuration` SET `value` = concat('test.',`value`) WHERE `name` like 'PS_SHOP_DOMAIN%';
UPDATE `ps_configuration` SET `value` = '0' WHERE `name` = 'PS_SHOP_ENABLE';
UPDATE `ps_configuration` SET  `value`=concat('TEST ',`value`) WHERE `name` = 'PS_SHOP_NAME';
UPDATE `ps_configuration` SET value = '2' where `name` = 'PS_SMARTY_FORCE_COMPILE';
UPDATE `ps_configuration` SET value = '0' where `name` = 'PS_SMARTY_CACHE';

You can run following query to avoid sending mails to customer for any test:


UPDATE `ps_customer` SET `email` = CONCAT(REPLACE(REPLACE(`email` ,'@','-'),'.','_'),'@mydomain.com');