In our last article in the Working with SQL Manager course we went over viewing your custom query results. We will now go over how to export your query. This allows you to export a CSV file of the results. Follow the steps below to learn how to export your query in PrestaShop 1.5

Exporting 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 Export icon. This icon looks like a piece of paper with a green arrow pointing upwards.
    export-file
  4. Once you click on the icon yuor CSV file will be saved to your local computer. Depending on your browser, you may be prompted with a pop up box to save your CSV file. In that case, click on OK to save the file to your computer.
  5. Once saved, you can open the file with your favorite text editor. Below is a sample of what our test CSV file looks like. The first set of data is the column headers after which you can see the data rows, all separated by a semi-colon delimiter.
    view-results
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 our Support Center:
Email Address
Optional, but our team may contact you for more information.
Like this Article?

Post a Comment

Name:
Email Address:
Comment:
Are you a bot?
Submit

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

Write New!
Do you want to publish a tutorial to our support center?

News / Announcements

SSL Certficate Warnings
Updated 2014-04-14 11:34 am EST
Hits: 2229
Heartbleed 0-day OpenSSL security bug
Updated 2014-04-14 04:43 pm EST
Hits: 5653

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!