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.
    add-query
  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.
    build-query 
    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.
    add-query-after
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!

Like this Article?

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.

News / Announcements

WordPress wp-login.php brute force attack
Updated 2014-07-17 06:43 pm EST
Hits: 200894

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

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!