This module provides a back-office interface for running custom SQL queries against your PrestaShop database and retrieving the results in multiple formats. It is designed for store owners and administrators who need to extract store data — such as orders, customers, or stock levels — without direct database access or technical tools.
- Execute custom SQL queries and view results as an on-screen table, a downloadable CSV file compatible with Excel, or in serialized format
- Save queries with descriptive labels for reuse; saved queries can be viewed, edited, or deleted without limit
- Supports table name prefixes including
ps_, _DB_PREFIX_, and _PREFIX_ shorthand, making queries portable across stores with different database prefixes - Ships with a set of built-in queries covering addresses, categories, customers, manufacturers, suppliers, order details (last 3 months), and product/combination stock levels
This module is well suited to store administrators and developers who regularly need to pull structured data exports from PrestaShop for reporting, analysis, or import into spreadsheet tools, and who want a reusable query library rather than running ad-hoc queries through a database client.
Comments (0)
Your review appreciation cannot be sent
Report comment
Report sent
Your report cannot be sent