What this procedure is
How to change the shop URL/domain by editing the database when you cannot access the Back Office.
Applies to: PrestaShop 8.x.
Why you would do this
- Store redirects to the old domain.
- You cannot access the admin to use “Set shop URL”.
Prerequisites
- phpMyAdmin access.
- Know the table prefix.
- Database backup (recommended).
Quick diagnosis (before you change anything)
1) Locate the shop_url table
Expected result: find ps_shop_url (with your prefix).
Change URL from the database
Step 1) Edit ps_shop_url
Update domain, domain_ssl, and physical_uri to match the new URL.
Expected result: PrestaShop stops pointing to the old domain.
Step 2) Clear cache manually
Delete var/cache.
Step 3) Test the store
Open the storefront and then the admin.
Final verification
- No redirects to the old domain.
- Loads over HTTPS if SSL is set.
If something doesn’t work (common issues)
Still redirecting
- Also check related URL configuration values.
- Purge CDN/proxy cache.
- Review .htaccess.
Best practices
- This method is sensitive: change only what is needed.
- Save the original values before editing.