table viewer
This module allows you to see at a glance table of the database of your store.
Module version | 1.5.0 |
Last update | 22/06/2025 |
Compatible with PrestaShop 1.6 | Yes |
Compatible with PrestaShop 1.7 | Yes |
Compatible with PrestaShop 1.8 | Oui |
If you're a webmaster or store manager and you want to check a table in your database, the easiest and fastest way is now this module, which allows you to select the table from a drop-down list and then view the contents of the selected table in detail. No mistakes are possible; you won't be modifying or deleting any data or tables.
Go to the Configuration tabs to view the settings saved in the configuration table, or to the Tables tabs to view the data present in the table of your choice.
Need more table tabs? No problem, click the blue + button to display an additional table tab, or see more encoded tabs. The same goes for the Configuration tabs and the orange buttons.
This module is designed to be easy to use and very fast, whether for debugging a module or checking certain data in orders or products.
Select the table you're interested in and search for a specific word (included in the SQL query, which reduces the number of rows to display). You can even deserialize data to make it readable.
Depending on the PrestaShop version, the structure of some tables may change. Don't hesitate to quickly check the table structure in your version of PrestaShop.
The deserialize function (json_decode in PHP) is essential to make the contents of certain cells readable (unless you can read {"3":"2,"} without even thinking).
Changelog :
1.0
First version
1.1
update, pagination
1.2
update, sorting, search, translates
1.2.1
modification css pagination, keep pagination length when we change the table or the display
1.2.2
Fixed a security problem
1.3.0
add form with ps_configuration, and option "unserialize"
1.3.1
small patch
1.3.2
"ps_" in the file results.php and showcolumns.php
1.3.3
unserialize and json_decode too
1.3.4
available if the mode maintenance is enable
1.4.0
new version with more tabs
1.4.1
add *** for display all in the table ps_configuration
1.4.2
correction bug smarty
1.5.0
update of the code, add button + and - for increase and decrease the number of tabs
15 other products in the same category
Floating Cart
Boost your sales with our "Sticky Add to Cart" module for Prestashop: an "Add to Cart" button that is always visible for a smooth shopping experience and an immediate increase in your conversions.
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.
