Mail your problems to us on, we will solve it and put the solution here at

Moving Prestashop from localhost to domain

1) Copy all files from from localhost to your FTP, usually into root folder or folder like “shop”

2) Backup database from localhost

Login to phpMyadmin on localhost (https://localhost/phpmyadmin/), select your database to see all the tables. Click on export tab. You can use “Quick” method to export it as .sql file or choose “Custom” and export database as compresssed file (zipped, gzipped, bzipped). I recommend compress the database, so you can upload smaller file in next step.

3) Import database on hosting server

Again, login to phpMyAdmin, select your database (usually you have to create it in administration of hosting account). Make sure your database has setup same collation (usually utf8_general_ci). Click on Import tab, select database file that you exported in previous step and click GO.

4) Change domain name and shop path in database

– Go to ps_configuration table and change PS_SHOP_DOMAIN and PS_SHOP_DOMAIN_SSL from ‘localhost’ to your domain name, e.g.

5) Edit /config/

and change details for connection to new database (usually you have to change _DB_SERVER_, _DB_NAME_, _DB_USER_, _DB_PASSWD_).

5) Regenerate .htaccess

Go to Preferences – SEO & URL and save this screen. It will regenerate new .htaccess.
It’s also better to clear cookies and browser history
Share on Google Plus

About Prof Krishan Kant Lavania

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.