If your domain name changes for whatever reason, you will need to make this change in the PrestaShop backoffice (337: How to change your shop URL in PrestaShop 1.5). However, access to change the URL may not always be available through the dashboard. To accommodate this possibility, you can make the change directly in the mySQL database. The following article walks you through the steps for making this change using phpMyAdmin.

Modify the Shop URL in the Database using phpMyAdmin

  1. Login to your cPanel.
  2. Scroll down to the database section and click on phpMyAdmin.
  3. Select Select the database in phpMyAdminWhen you have launched phpMyadmin, select the database by scrolling down the left side list. If you're not sure how to find your PrestaShop 1.5 database, go to 341: How to find your database name for PrestaShop 1.5. Once you have found your database, click on it to open.
  4. Select table for Shop URLWhen the database is open, scroll down the left side until you see the table labeled "tableinitals_shop_url". Table initials usually default to "ps" but can be changed to something else during the installation process. Click on this table to select and open it. You will see the option to EDIT this table at left (as indicated in the screenshot at right).
  5. Edit the URL entries in the tableClick on EDIT and then change the URL entries. Make sure to change both the entries with the appropriate URL. If you aren't sure about the SSL or you are not using it, simply use the same one.
  6. Scroll to the bottom, make sure the drop-down menu on left says SAVE and click on GOClick on GO at the bottom of the page in order to save your entries.

The change of the shop URL in the database should only be done as necessary because it will affect ALL links within the shop.

If you have FRIENDLY URLs set, then you will need to turn this option off, save the change, then turn it back on in order to set the updated URLs in the database. For more information on setting Friendly URLs, go to How to set up Search Engine Friendly URLs in PrestaShop 1.5

Continued Education in Course Prestashop 1.5
You are viewing Section 6: 351: How to change your site URL directly in the Database for PrestaShop 1.5
Section 5: 352: Adding payment modules to PrestaShop 1.5
Section 7: 350: How to fix the fopen and magicquotes error in Prestashop
Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question
n/a Points
2014-03-14 9:38 pm

I do not find tableinitals_shop_url anywhere.

Staff
9,479 Points
2014-03-17 8:15 am
As stated within the note at the bottom of this article, you may need to disabled the friendly URLs, then re-enable them to see this option.
n/a Points
2014-03-25 1:55 pm

That needs to be higher on the page; I never get down to the bottom. None of this solves my problem, anyway. It was alread pointing to my domain. Only my first page works; others are blank.

Your answer is insulting.

Staff
17,855 Points
2014-03-25 2:46 pm
Hello Caroline,

We're sorry to hear that you're still having problems with your PrestaShop installation. If you could please give us more information on your site (such as the URL, version of the software loaded, modules loaded, etc.), then we may be able to provide your more information or research the issue for you in order to resolve it. We do have a close relationship with PrestaShop and would be glad to help you solve your problem. Please provide a little more relevant information and we would be happy to continue troubleshooting the issue.

Kindest regards,
Arnel C.

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

5 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!