InMotion Hosting Support Center

Our first article in our course on Working with SQL Manager discusses the ability for you to work with custom SQL queries. It is a complex technical feature and should only be used by those familiar with the SQL database query language, however, it can be a very powerful tool if used properly.

Adding SQL queries in PrestaShop 1.5

  1. Log into your PrestaShop 1.5 dashboard.
  2. Using the top menu bar, hover over the Advanced Parameters tab and click on the SQL Manager option from the menu.
  3. You are now on the SQL Manager page. To add a new custom query, click on the green Add New button found in the upper right hand corner of the screen.
  4. This brings you to the query build screen. There are two fields here, Name and Request. Both are required. The Name field is simply the name you want to give your query. The Request field is where you type your SQL query code in. Our query is a very simple one that selects data from all the fields from the ps_product table.
    Below that is an area where you see a list of all the tables within your PrestaShop 1.5 database. You can highlight any table and see the fields associated with that table on the right. This way you can get the field names you need to help build a complex query. table-list
  5. Once you have your query constructed, click the Save button located underneath the Request field. This will save your query and return you to the Query list page. You will see your new query in the list.
You are viewing Section 1: How to add custom SQL Queries in PrestaShop 1.5
Section 2: How to view custom SQL Query results in PrestaShop 1.5

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Social Media Login

Social Login Joomla

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

Post a Comment

Email Address:
Phone Number:

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

0 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?


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