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:
Extra Product Tabs – Tab Creator, CSV Import and SEO
Transform chaotic descriptions into a professional offer that sells! The Extra Product Tabs module allows you to instantly add unlimited tabs (e.g. Size Guide, Video,...
Login as Customer – Log into user accounts from PrestaShop Back Office
This module enables instant access to any customer account directly from the PrestaShop administration panel. It allows quick verification of issues reported by buyers...
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...
Increase the long product description and image ALT text limit in PrestaShop 8/9
PP Limit Manager removes the length restriction applied to the long product description and product image ALT text in the new PrestaShop 8 and 9 product form. The module...
Customer Email Verification after Registration in PrestaShop
Tired of fake accounts and typos in customer email addresses? Meet Email Verification – a simple and completely free PrestaShop module designed to keep your database...
- New
Free Simple Omnibus Price Module – Omnibus Directive for PrestaShop
Simple Omnibus Price is a completely free PrestaShop module that automates displaying the lowest price from the 30 days prior to a price reduction. Protect your store...
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...
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...
Clean URLs Pro – remove IDs from PrestaShop URLs
Clean URLs Pro removes numerical IDs from product, category, CMS category, CMS page, brand, and supplier URLs — without core modifications and with zero overrides. Simply...
- Discount
Google reCAPTCHA (v2 + v3) – Stop Bots, Yes to Customers
Tired of deleting spam from your inbox and fake accounts from your store panel? This module is your digital guardian that lets only real people into your store. Install...
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...
PrestaShop Integration with Google Merchant Centre (Version Pro)
Product Feed PRO streamlines catalogue publishing between your store and advertising platforms. It is practical for e-commerce teams that need faster time-to-market for new...
Advanced PrestaShop traffic and performance optimization generator (htaccess)
Stack Pro is a protective module for PrestaShop that restricts artificial and automated traffic at the server level through controlled modification of the .htaccess file....
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.
Advanced Search for PrestaShop
Advanced product search for PrestaShop that helps customers find the right products faster and makes it easier to complete purchases in your PrestaShop store . The module...
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,...
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!
