Big Data - SQL to CSV data with ease

0,00 €

This module will allow you to run SQL queries to retrieve data form table, CSV (for Excel) file, or form "serialize".

download

More details

Module version1.1.3
Last update17/01/2020
Compatible with PrestaShop 1.6Yes
Compatible with PrestaShop 1.7Yes

Here is a module allowing fairly easily recover your data via SQL queries.
The module contains several default SQL queries, you can edit them, delete them, add more without any limit.

 

logo_youtube.png


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"
  • Stock products and variations, for shop "1"

14 other products in the same category