The advanced parameters in PrestaShop has the option to allow custom SQL queries in order to obtain specific shop data.  The CSV export option allows you to easily port the data to another application of your choice.  The following tutorial explains how to export the data with the CSV option in PrestaShop 1.5.

Exporting Data from SQL Query Results in PrestaShop 1.5

  1. To get to the Performance section of the Advanced Parameters for Prestashop, first login to the Administrator Dashboard
  2. Hover over menu bar where it says ADVANCED PARAMETERS - click on SQL MANAGER when it appears in the drop-down menu.
  3. You will see something similar to this screenshot:
    prestashop151-SQLmanager-exportcsv

  4. The screenshot above shows an existing query named "newquery."  Look to the far right and look for the first icon in the ACTIONS column of the table. Click on the icon to start the export process.  You will immediately get a window to save the query onto your local computer.  Make sure to note what you named the file and where you saved it so that you can find it again later.  Click on OK in order to complete the saving of the file.

    If you require a different file encoding for the results, you need to change the Settings for the query.  More information for this option can be found in the Changing the Encoding Settings for SQL Manager in PrestaShop 1.5.

Exporting the data into a CSV allows PrestaShop to keep things flexible for the administrator so that they can present their store data to other people who may be using other programs for evaluating or viewing the data.  An example of the CSV data exported is below:

"1";"21";"0";"0";"1";"0";"0";"manufacturer";"";"JOBS";"STEVE";"1 Infinite Loop";"";"95014";"Cupertino";"";"(800) 275-2273";"";"";"";"2012-10-04 20:35:12";"2012-10-04 20:35:12";"1";"0";

Go here for more information on editing or adding SQL queries.

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!

Did you find this article helpful?

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.

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!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.