Big Data - SQL to CSV data with ease
Warning: Last items in stock!
This module will allow you to run SQL queries to retrieve data form table, CSV (for Excel) file, or form "serialize".
|Compatible with PrestaShop 1.6||Yes|
|Compatible with PrestaShop 1.7||Yes|
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.
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 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
This module makes it possible to improve SEO on Google by enriching the content of the description thanks to the figure and figcaption tags. It also improves rendering by zooming in on the image and specific customization possible for each image.
This 2 in 1 module deals with managing the tax news following Brexit with the United Kingdom (Northern Ireland, and Great Britain)But also includes a complete accounting part which allows to have the accounting reports with all the details on all the invoices.
This module makes it possible to "divide" a country into new zones (regions, departments, postal codes ...) in order to allocate for each zone a specific carrier (or several) with a specific tariff.
Easily manage your product images, categories, manufacturers, suppliers and stores with this image manager. It will allow you to avoid storing unnecessary images, indicates if there are missing images and regenerates the images very quickly.
This module allows you to force the customer to register their VAT number depending on the country, so you can force foreigners in your country to register their VAT number.
This module allows you to connect to the customer account very easily without asking for his password. The connection can be made from the back office, but also from the front office.
Your shop has cost thousands of euros, it is your livelihood, so protect it! avoid any flaws, spam, SQL / XSS injections, backup the database and main files and monitor potential attacks