Changing the shop name is done within the database. This may seem a bit daunting to anyone unfamiliar with moving around the cPanel and database tool. There are two ways to alter the data in the databse using the phpMyAdmin tool. One is to run a query and the other is to navigate the rows and do a direct edit. We cover both methods below.

Accessing the phpMyAdmin tool

First we need to get to the phpMyAdmin tool.

  1. Log into your cPanel dashboard.
  2. Find the Databases category and click on the phpMyAdmin icon.
  3. Once inside the phpMyAdmin tool, click on the Databases tab. This brings up a list of databases in your account. Click on the name of your PrestaShop database.

Using a direct table edit

  1. Once you select the database the screen will list all of the tables.
  2. Scroll down and click on the ps_configuration table.
  3. The new screen displays all the rows in the ps_configuration table. Scroll down and click on the Value column (the 5th one) of the PS_SHOP_NAME row. In the default PrestaShop 1.6 database, this is row number 235. The value column has the current shop name in it.
  4. The column will allow you to edit the name of the shop. Enter the new name and click Enter.

Using a SQL Query

If you are familiar with using a SQL Query, this can be a faster method.

  1. Once the database tables appear on the screen, look to the tabs at the top of the screen and click on the SQL tab.
  2. This brings you a blank SQL Query screen where you can enter and run your query. The specific query you need to run is below. The only thing you need to change is "New Shop Name". Change that to be your desired store name, be sure to keep the quotes around the name.
    UPDATE ps_configuration SET value = "New Shop Name" WHERE name ="PS_SHOP_NAME"
  3. Once entered, click on the Go button in the lower right corner. Once the query runs you should get a success message at the top of the screen.

Now that you have changed the shop name in the database, visit your site. The shop name will appear in the tab of the browser for the storefront. It will also appear in the upper left corner of the back office. Enjoy your newly named store.

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-06-25 6:41 am

Hi,

 

thanks for the guide. I changed it in BO, which did not work, followed your guide and the correct name is already in the field, but still will not display in BO.

Staff
18,098 Points
2014-06-25 9:28 am
Hello RPP,

I am happy your shop name changed on the front end. You say it is not showing the new name in the BO? In my testing I am seeing the new name in the BO. Where in the BO are you seeing the old shop name? If it is something I can identify and fix I would like to update the article.

Kindest Regards,
Scott M
n/a Points
2014-06-25 9:34 am

I am still seeing "my ecommerce" in the top left of the BO, also at the end of page titles.http://puu.sh/9Jqzm/3cfc63d0cd.png

Strange thing is that when viewed in myphpadmin it does show the updated name.

Staff
18,098 Points
2014-06-25 9:41 am
Hello RPP,

Thanks for the quick response. The corner does get that info from the field that was changed. Try and clear your browser cache to see if that is the issue.

Kindest Regards,
Scott M
n/a Points
2014-06-25 9:53 am

Hi,

No, that still does not work. In fact I have had this issue since 1.5 on different projects I have worked on, even when it has been changed in the database it never seem to update the BO.

Thank you for your help!

Staff
18,098 Points
2014-06-25 10:01 am
Hello RPP,

That is very odd, it should change immediately for you or at least after clearing cache. Are you one of our customers? If so, I could try and take a look for you. I would need the domain name to do so, but I can remove it from a post before it goes public if you like.

Kindest Regards,
Scott M

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.

6 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!