Free PrestaShop Database Audit & Controlled Cleanup

PP-M070F
  • 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.

0.00 € Tax excluded

Additional services:

Installation +29.10 €

  • Free module shared with the PrestaShop community
  • Possibility to report suggestions and bugs - corrections according to availability
  • No warranty or support as standard (no SLA)
  • Download available after logging into the customer account. Download limit 99
  • Need modifications or support? ask about the service

Information Parameters:

  • 1.2.0
  • Store Version PHP Version
    1.7.5 + 7.1 – 7.4
    8.x 8.1 – 8.3
    9.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

# 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).

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.

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!