Prestashop Staging

1. Staging Subdomain e.g. dev.shop.de
2. Set PHP version same as prod
3. Staging DB
4. Delete files from shop/var/cache/prod or dev or _PS_ENV_/prod or _PS_ENV_/dev
5. Copy files from shop prod to shop staging e.g. via web ftp
6. Export DB prod via PHPMyAdmin utf-8, SQL
7. Import DB prod to DB stage
8. Double check, delete files from shop_staging/var/cache/prod or dev or _PS_ENV_/prod or _PS_ENV_/dev

Update Config Files in staging files

shop_dev/app/config/parameters.php
change database_name, database_user, database_password

Update SQL Tables in staging DB

UPDATE xyz_configuration
SET value = 'dev.shop.de'
WHERE name IN ('PS_SHOP_DOMAIN', 'PS_SHOP_DOMAIN_SSL');

UPDATE xyz_shop_url
SET domain = 'dev.shop.de',
    domain_ssl = 'dev.shop.de',
    physical_uri = '/'
WHERE id_shop = 1;

Update .htaccess in staging files

Search and replace

RewriteCond %{HTTP_HOST} ^shop.de$

with

RewriteCond %{HTTP_HOST} ^(shop\.de|dev\.shop\.de)$