Our previous article in our Working with SQL Manager course taught you to create custom SQL queries. This article will show you how to view the results of these custom queries.

Viewing custom SQL query results 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. From the custom query list, find the one you want to view results for and click on the View icon. This icon looks like a piece of paper with a magnifying glass on it.
    view-query
  4. You are now on the query results view screen. The query name appears in bold at the top above the view. The view itself has the column names across the top. All data is sorted in the order the query selected them.  For longer queries you will have a scrollbar to see other columns to the right and a side scrollbar to view any additional rows.
    results-view

    Simply click the Back To List button to go back to the Query list screen. If you want to learn more about the SQL Manager section, continue on to our next article on Exporting the SQL query.

You are viewing Section 2: How to view custom SQL Query results in PrestaShop 1.5
Section 1: How to add custom SQL Queries in PrestaShop 1.5
Section 3: How to export a custom SQL Query in PrestaShop 1.5
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-11-06 3:48 am

query to retrieve abandoned cart users email address in prestashop 1.5 please.

Staff
10,997 Points
2014-11-06 11:39 am
Hello,

Thank you for contacting us. I wouldn't be able to custom code an SQL query for you, but the Official PrestaShop forums may be a good place to post your request. This is because it is frequented by people who develop sites in PrestaShop.

There are many PrestaShop Addons available for managing abandoned carts, it may be easier just to use one of them.

If you have any further questions, feel free to post them below.

Thank you,
John-Paul

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.

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