InMotion Hosting Support Center

Changing the shop name can be done in two ways - through the PrestaShop Administrator interface and through the database. The easy way is definitely using the Administrator, but there may be occasions where the name has to be changed through the database. Changing the shop name through the database 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.

Using the PrestaShop 1.6 Administrator Dashboard

  1. Log into your PrestaShop 1.6 Administrator Dashabord.
  2. Once you're in the PrestaShop Administrator, click on PREFERENCES, then scroll down to and click on Store Contacts.
  3. In Store Contacts, click on the Shop Name field and change the name entry as needed.
  4. Click on SAVE to preserve your changes.

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. (note this assumes you are using the default ps_ prefix.)
  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 around 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.

Support Center Login

Social Media Login

   
Social Login Joomla

Related Questions

Here are a few questions related to this article that our customers have asked:
showing as my store in search engines
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
27,163 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
27,163 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
27,163 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
n/a Points
2014-11-18 5:59 am

thanks  

How to change your contack mail adress in PrestaShop 1.6 ???????????

 

 
Staff
11,156 Points
2014-11-18 9:54 am
To do so, click on Modules, and edit the block named Contact Information Block.
n/a Points
2014-11-20 1:12 pm

I say save the site name and email address, change the settings menu. When I update the page comes reinstated.

How can I change the e-mail address with the php my admin as we change the site name.?

Staff
16,268 Points
2014-11-20 2:29 pm
Hello muhtesem,

Thank you for contacting us. Yes, you can change your email address via PHPmyAdmin.

It is located in the employees table. Just replace the existing email address with the new one.

Thank you,
John-Paul
n/a Points
2014-12-30 8:00 pm
file is not called PS_shop_name

does not even exist in the database!!!
mine is qjg_shop
totally different
Staff
24,842 Points
2015-03-16 4:18 pm
Hello Jeff,

Thanks for pointing this out. I will have the article updated in the next few days. The correct table would be PS_SHOP. However, it may differ depending on how you configure the table names for your installation (as it was in yours since you used "qjg" instead of "ps").

Regards,
Arnel C.
Staff
24,842 Points
2015-03-17 10:25 am
Hello Jeff,

First, we did revisit this article for a possible update. The PS_SHOP_NAME is not a file, it's a table entry in the PS_CONFIGURATION table as per the above documentation. If you were to change the ps_shop name, it would NOT affect the name of the PrestaShop Storefront. You will need to make the changes as they are listed above. The EASIEST way to change the store name is to go into the PrestaShop Dashboard, then go to PREFERENCES>Store Contacts then scroll down to SHOP NAME. When you change the shop name there and save it, you will see the changes applied through the PrestaShop store.

The article has been updated for easier reading.

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.

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