The names of the tables in SQL queries can use as prefix of "ps_" (prefix by default tables, example ps_cart), or _DB_PREFIX_ (the most recommended if you want to re - use SQL queries on other shops, _DB_PREFIX_cart will give ps_cart for example), or even _PREFIX_ (if you want to make shorter, _PREFIX_cart give ps_cart for example).

For each query you can save a description in order to better see you there, the available actions are:

see,

Save,

delete,

see the result in serialized form,

Open the file CSV with Excel.

Different queries that are provided by default:

List of addresses

List of categories

List of customers

List of manufacturers

List of suppliers

Detail of orders over the last 3 months, with costs of deliveries for shop "1"

Tags

Newsletter

Big Data - SQL to CSV data with ease http://www.coeos.pro/118-571-large/big-data-sql-to-csv-data-with-ease.jpg This module will allow you to run SQL queries to retrieve data form table, CSV (for Excel) file, or form "serialize".﻿ Modules Prestashop0EUR

Our webstore uses cookies to offer a better user experience and we recommend you to accept their use to fully enjoy your navigation.