Free PrestaShop Database Audit & Controlled Cleanup
- 1.7.5 + | 8.x | 9.x
- EN, FR, IT, DE, PL, ES
- 1.2.0
- 2026-09-14
Database Cleaner Lite is a free PrestaShop module designed for auditing and safely deleting statistical data and system logs. It helps administrators quickly assess database size before performing maintenance routines.
Operating exclusively in the Back Office, the module handles large databases via AJAX batch processing without executing automatic tasks in the background. It is tailored for stores looking to safely control unnecessary database growth.
- New
Information Parameters:
- 1.2.0
-
Store Version PHP Version1.7.5 + 7.1 – 7.48.x 8.1 – 8.39.x 8.1 – 8.5
- 2026-09-14
- EN, FR, IT, DE, PL, ES
- ✅
- ✅
- ✅
- ✅
Key Benefits
- Free Lite Functionality – Complete database auditing and cleanup of statistics, traffic, logs, and email history are fully available without purchasing a Pro license.
- Quick Database Assessment – Displays total database size, row counts, and individual table metrics prior to executing any cleanup.
- Large Database Compatibility – Scans run table-by-table on demand, while cleanup executes in 5,000-record AJAX batches to prevent PHP timeout errors.
- Controlled Data Deletion – Administrators select table groups and manually confirm execution; no background tasks run automatically.
- Core Data Protection – Built-in SQL logic prevents the deletion of records linked to active customer accounts and orders.
- Multistore Support – Clear interface indicators inform users that operations affect the shared database across the entire installation.
Use Cases
Database Cleaner Lite is ideal for stores accumulating high volumes of traffic and statistical data, as well as environments requiring periodic inspection of tables such as connections, guest, pagenotfound, statssearch, log, and mail.
The module is particularly useful prior to server optimization, store migrations, backup creation, or routine administrative maintenance. In Multistore setups, it allows evaluating the shared database before executing agreed-upon cleanups.
Back Office Features
Audit
Scans the database and displays its total size, PHP limits, and a list of tables with row counts and size in MB.
- Table-by-table AJAX scan – Allows smooth analysis of large databases without triggering long single requests.
Clean
Select data from groups such as Statistics and traffic or Logs and mail to initiate cleanup.
- Manual execution & progress tracking – Select the scope, confirm the operation, and monitor real-time progress in the panel.
Batch Processing
Data cleanup runs via sequential AJAX requests, displaying a summary of deleted records upon completion.
- 5,000-record batches – Reduces single PHP request load when processing large volumes of data.
Pre-cleanup Data Verification
Audit results are cached, allowing administrators to review data structure without triggering a re-scan.
- Large database warnings – Prompts the administrator to perform a manual backup when high row counts or file sizes are detected.
Help and Updates
Displays release information and allows checking for newer module versions.
- Independent core features – Lack of connection to the update service never blocks audit or cleanup operations.
Pro Features Preview
Sections like Optimize, History, CSV export, dry-run mode, and time retention settings are clearly labeled as Pro features.
- Clear scope separation – Restricted features are secured on both interface and server levels.
Impact on Sales and SEO
The module does not interact with the Front Office, store design, URL structure, or SEO metadata. Its impact is indirect: regular maintenance of statistics and log data simplifies database administration and backup routines. It does not guarantee SEO ranking improvements, conversion increases, or fixed performance gains – actual results depend on server configuration, database engine, and store state.
Important Notice
Always perform a full database backup before installation and initial cleanup on a production store. Cleanup operations affect the shared database in Multistore environments, and deleted records cannot be restored via the module. The Lite version applies an "All records" retention rule for selected groups, so verify your selection carefully before starting.
# Changelog ## [1.2.0] - 2026-09-14 ### Added - Lite edition: database audit, clean (statistics/logs), AJAX batching, admin tab, support panel with GA UTM tracking. ## [1.0.0] - 2026-02-17 ### Added - Initial scaffold (superseded by 1.2.0 rewrite).
You might also like
FAQs
-
Are the modules compatible with my version of PrestaShop?
Each module in our store contains information about compatibility with specific PrestaShop versions. Please check this information carefully before purchasing. If you are not sure, contact us.
16 other products in the same category:
Custom Product Groups on the Product Page in PrestaShop
With Product Accessories Plus , you can create any product groups you need , set their order, and display them directly on the product page in your PrestaShop shop. You...
Additional Product Fields and Options – Attributes without Combinations (Custom Fields)
This module enables the creation of additional product options without using native PrestaShop combinations. Each option can have a price impact (positive or negative) but...
GPSR — Compliance Module for PrestaShop
GPSR Module for PrestaShop enables quick and compliant management of information required by the GPSR regulation. Automate obligations and increase your shop's security.
SEO Scanner - fast SEO auditing for products, categories and CMS pages in PrestaShop
PP SEO Scanner is an efficient diagnostic tool for PrestaShop, designed to automate on-site SEO auditing. The module analyses products, categories and CMS pages for...
Content page system, an alternative to PrestaShop CMS Pages: categories, pages and FAQ with...
Frustrated by the limited capabilities of PrestaShop's native CMS? PP Page is a powerful alternative that transforms your shop into a fully-fledged publishing platform....
Replace order reference with a numeric reference in PrestaShop
The module organises order identification by replacing the default reference with a numeric one (random or based on the order ID ). It makes customer communication easier,...
Unused Product Images — Free Server Cleanup for PrestaShop
Unused Product Images (Free) is a free PrestaShop module designed to optimize disk space and file limits (Inodes) on your hosting. The tool automatically locates and...
Admin Product Cloner – Selective Product Duplication
Admin Product Cloner is a simple, handy tool for PrestaShop administrators, designed to streamline daily catalogue management. The module replaces the standard, full...
Helpdesk — professional ticketing and customer support system for PrestaShop
PP Helpdesk is a module that turns chaotic email exchanges into a clear, organised ticketing system directly within your PrestaShop store. Customers can comfortably create...
PrestaShop withdrawal module for whole orders and selected products
Bring order to the withdrawal process in your PrestaShop store. The module moves scattered email exchanges into a clear customer-side panel (Front Office) and a structured...
Custom CSS & JS – Free code editor in the PrestaShop panel
PP Custom CSS & JS is a free and highly practical module for every PrestaShop administrator. It allows you to instantly add your own CSS styles and JavaScript scripts...
Take SEO and conversion further: a PrestaShop FAQ module with a built-in editor and FAQPage JSON-LD
The FAQ Builder module makes it easy to add question and answer (FAQ) sections directly to your PrestaShop product descriptions. The management interface sits just above the...
Cash on Delivery (COD) with an Additional Fee for PrestaShop
A cash on delivery module for PrestaShop with the option to apply an additional fee . The fee is added to the order automatically and displayed as a separate line in the...
VAT and VIES Validation for B2B in PrestaShop
PP VAT Checker is a reliable PrestaShop module that automates VAT number verification for your business customers. With direct integration with the VIES database, it...
Ready-made cart link for PrestaShop (free version)
How does it work? The administrator creates a ready-made cart link -> sends it to the customer -> the customer opens it and lands in a prepared cart. PP Cart...
Automatic update of NBP exchange rates with margin
Automatic currency rate updates is a PrestaShop module that automates a critical area of e-commerce: updating exchange rates based on the NBP API and your own margin rules....
Do you need additional features or custom solutions?
- Module customisation tailored to your specific requirements.
- Extending functionality to enhance your store's capabilities.
- Developing bespoke modules designed to meet your unique needs.
- Integrating external systems and additional tools.
- Optimisation and improvements for better performance and user experience.
Do you have ideas on how to improve this software? Share your suggestions for optimisation, new features, or bug reports – we’ll be happy to review them!