Big Data - SQL to CSV data with ease
This module will allow you to run SQL queries to retrieve data form table, CSV (for Excel) file, or form "serialize".
| Module version | 1.1.3 |
| Last update | 17/01/2020 |
| 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,
- 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"
15 other products in the same category
SQL Backup (manual/CRON/mail)
This module allows you to make SQL backups very easily from the back office, but also by CRON task with sending a copy of the database (.sql.bz2 file) by email to the administrators of your choice
Opening of submenus on hover
On the latest versions of PrestaShop the hover over submenus has been removed, put it back for free with this module. download
Product images in descriptions
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.
New VAT rule - Brexit (+ accounting)
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.
Intercept emails
Read sent emails (even locally), identify templates and personalize your emails very easily.
Delivery zones and postal codes
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.
Images and thumbnails: Compression and reSmush
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.
Force the VAT number depending on the country
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.
Login to customer account without password
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.
Change of carrier
This module allows you to change the carrier from the back office and modify the cost of delivery.
Secure your shop!
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
VAT number
Invoice tax-free foreign business customers who have a valid VAT number on VIES after verifying the VAT numbers to avoid VAT scams and customer errors.
Images thumbnails
Improve the rendering of presentation of products by replacing the squares of colours of the attributes by thumbnails.
Hide prices easily
This module allows to hide product prices of some categories for certain customer groups but also encourage visitors to register or to connect with personalized messages.
Show combinations as products
Your customers will be able to order from the category page products (combinations ) that the interress, easier and faster.
