Protect and optimize your online store with our PrestaShop database maintenance module

medcleanmyshop

This module offers you many tools to optimize your database, such as cleaning up unused tables. You will be able to schedule automatic maintenance tasks so that you don't have to deal with them manually.

By using this module, you can improve the loading speed of your site, reduce latency and improve the user experience of your customers. Don't hesitate to try it now to enjoy all these benefits!


Data sheet

Version 3.2.1
Core modifications (override) No
Third party subscription: No
Translation : bg-da-de-el-es-et-fi-fr-hu-it-ja-nl-pl-pt-ro-sk-sv-uk
Compatible Prestashop 1.6 Yes
Compatible Prestashop 1.7 Yes
Compatible PrestaShop 8 Yes
Compatible PrestaShop 9 Yes
Compatible thirtybees 1.3 Yes
Compatible thirtybees 1.4 Yes
Compatible thirtybees 1.5 Yes
Compatible thirtybees 1.6 Oui
PhenixSuite compatible Yes
Responsive Design Yes
Multi Shop compatible: Yes
Video https://www.youtube-nocookie.com/embed/basF8VpcOTQ
PrestaShop Forum https://www.prestashop.com/forums/topic/1063299-module-maintain-the-performance-of-your-prestashop-store-by-regularly-cleaning-up-useless-or-obsolete-data
Forum Thirty Bees https://forum.thirtybees.com/topic/5659-module-maintain-the-performance-of-your-prestashop-store-by-regularly-cleaning-up-useless-or-obsolete-data
Addons PrestaShop https://prestashop.pxf.io/maintenance-and-cleaning-of-your-store

99,99 € tax excl.

Secure payment methods

License

By buying this product, you will benefit from all the updates for 365 days.

Number of downloads

431 Downloads

Last Update

04/14/2026: Version 3.2.1

Compatibility

This modules is compatible with all PrestaShop 1.6.x version This modules is compatible with all PrestaShop 1.7.x version This modules is compatible with all PrestaShop 8.x version This modules is compatible with all PrestaShop 9.x version

thirtybees Compatibility

This modules is compatible with all thirtybees 1.3.x version This modules is compatible with all thirtybees 1.4.x version This modules is compatible with all thirtybees 1.5.x version This modules is compatible with all thirtybees 1.6.x version

PhenixSuite Compatibility

This modules is compatible with all PhenixSuite version

Translate in

bg da de el es et fi fr hu it ja nl pl pt ro sk sv uk

Proposed by

Mediacom87


More info

The Problem

Over time, your PrestaShop store accumulates useless data: outdated connection statistics, abandoned carts, guest accounts without addresses, orphan images, modules uninstalled but still referenced in the database…

This dead weight degrades your site’s performance, slows down the back office and complicates maintenance. And cleaning up manually via phpMyAdmin is risky, time-consuming and reserved for experts.

The Solution

MedCleanMyShop brings together over 40 cleanup and optimization scenarios in a clear, tab-organized interface. Each scenario is explained, secured and executable in one click.

From purging statistics tables to fixing data consistency, through cache cleanup, images and modules, everything is automated and configurable via cron tasks.

How It Works

1

Analysis

The module analyzes your database, files and modules to identify obsolete, orphaned or inconsistent data.

2

Cleanup

Choose which scenarios to run manually with one click, or automate them through the module’s built-in cron tasks.

3

Performance

Your store gets its responsiveness back: lighter database, purged cache, normalized files and permissions.

Detailed Features

Database Cleanup

  • Purge statistics tables (connections, page views, sources, guests…)
  • Delete logs and sent emails
  • Configurable retention period in days
  • Real-time record count per table

Customer Cleanup

  • Abandoned shopping carts
  • Guests without addresses or orders
  • Customers without addresses, orders or deleted customers
  • Orphan addresses
  • Customer discussion threads (with or without orders)
  • Detailed list viewable before deletion

Catalog Cleanup

  • Expired specific prices
  • Expired or unusable vouchers
  • Unused custom feature values
  • Each scenario is explained to prevent unintended deletions

Cache Management

  • Smarty cache (compilation and cache)
  • XML cache and class index
  • Symfony prod and dev cache (PS 1.7+)
  • Temporary images (img/tmp)
  • Cache directory size display

Module Management

  • Detection of missing modules (installed in DB but absent from server)
  • Database entry cleanup for missing modules
  • List of uninstalled modules with author filter
  • One-click uninstall, install, delete and ZIP download
  • Cleanup of residual files and folders in the modules directory

Image Tools

  • Detection and deletion of broken images (files missing from disk)
  • Detection and deletion of orphan image files (not linked to any product)
  • Detailed file list viewable before deletion

Database Tools

  • Table prefix change (security)
  • Database engine migration to InnoDB
  • Category tree recalculation (nleft, nright, level_depth)
  • Full customer and order deletion (factory reset)

Data Consistency

  • 14 fix scenarios: shops, languages, configuration, native tables, categories, customers, orders, products, carriers, statistics, search, cart rules, modules, invoices
  • Automatic detection and correction of inconsistencies

File & Directory Permissions

  • Analysis of non-compliant permissions (755 directories / 644 files)
  • Bulk or individual correction
  • Detailed list of items to fix

GDPR

  • Full customer data anonymization (name, email, address, phone, SIRET, VAT…)
  • Counter of customers and addresses to anonymize
  • Compliance with regulatory requirements

Cron Task Automation

Each module section provides its own customizable cron URLs. Select which scenarios to include in each task, configure the retention period and schedule automatic execution. A SuperCron mode lets you combine all tasks into a single URL. The last execution date of each task is displayed in the back office.

Installation

Download the module and install it from your back office (Modules > Module Manager)

Access the module configuration — no additional table is created, the module is ready to use

Browse the tabs, review the scenarios and run the cleanups suited to your store

Set up cron tasks to automate the regular maintenance of your store

CHANGELOG

3.2.1 - 07/07/2025

  • Improved module archiving function
  • DataTables library updated to version 2.3.2

3.2.0 - 04/15/2025

  • Add scenario to delete all customers and orders

3.1.9 - 04/11/2025

  • Fixed compatibility bug with versions lower than PHP 7.4

3.1.8 - 04/09/2025

  • Improved table cleaning scenario _lang
  • Improved currency control for payment modules
  • Improved presentation of certain scenarios and refreshment of the retention period to avoid overloading the server
  • Correction of an unlikely case of modules not complying with development guidelines
  • Performance enhancement

3.1.7 - 02/28/2025

  • Minor corrections

3.1.6 - 02/21/2025

  • Added scenarios to correct directory and file access rights
  • Add refresh buttons for each scenario, to avoid having to launch all scenarios and reduce server load

3.1.5 - 01/07/2025

  • Corrected processing of coupon dates

3.1.4 - 11/18/2024

  • Added compatibility with PHP 8.2

3.1.3 - 11/14/2024

  • Added compatibility with PrestaShop 9
  • Scenarios are calculated when the corresponding tab is displayed, to avoid overloading the server
  • Improved module list display

3.1.2 - 10/07/2024

  • Added compatibility with the OpartDevis module to avoid deleting baskets linked to quotes.
  • Fixed a bug in the display of some buttons
  • DataTables library updated to version 2.1.8

3.1.1 - 09/04/2024

  • Fixed translation bug on tables
  • Fixed processing incompatibility when using pm_advancedsearch4 module
  • DataTables library updated to version 2.1.5

3.1.0 - 08/01/2024

  • Correction of a display bug in the list of modules due to some modules having fun in their description
  • Add preview of product images to be deleted
  • Add an option to delete scenario files one by one concerning files not required for product images
  • Add a scenario to automatically delete discount codes that have no date limit but can no longer be used
  • DataTables library updated to version 2.1.3

3.0.5 - 07/23/2024

  • Complete code overhaul to clean up unnecessary product images
  • Activate safe scenarios for crontask during module installation
  • DataTables library updated to version 2.1.0

3.0.4 - 05/13/2024

  • Correction of Cron task management for new scenarios
  • Add number of tables not using correct database engine

3.0.3 - 05/10/2024

  • Fixed a bug limiting the processing of certain scenarios
  • Separation of scenarios to avoid data consistency bottlenecks
  • DataTables library updated to version 2.0.7

3.0.2 - 04/21/2024

  • Fixed bug preventing certain scenarios from being deleted from the catalog
  • Fixed a bug in the option to uninstall several modules at the same time
  • Improved feedback on certain scenarios that can take a long time
  • Improved explanations to help with the use of certain scenarios
  • DataTables library updated to version 2.0.5

3.0.1 - 04/15/2024

  • Fixed a bug when launching SuperCron that did not support all selected scenarios

3.0.0 - 04/09/2024

  • On-demand scenario calculation shifted to avoid server overloads
    Calculation of the data counters to be cleaned is launched only on the scenarios selected for processing with a Cron task, enabling instant visualization of the volume of data to be cleaned without risk.
  • Add a button to refresh the calculation only for scenarios programmed on a Cron task
  • Added an option to change the database engine for InnoDB
  • Add a SuperCron that can launch all Cron tasks with a single URL
  • Add an option to mass uninstall all modules that have been deactivated
  • Add a filter to display only modules by a specific creator
  • Fixed cache issue when changing database table prefix for PrestaShop 1.6
  • DataTables library updated to version 2.0.3

2.5.0 - 03/22/2024

  • Added a scenario to correct database tables that do not use the database engine defined in the parameters
  • DataTables library updated to version 2.0.2
  • Separation of cleaning from Cart Rules for easier processing of large catalogs
  • Preserve module list presentation settings between page displays

2.4.0 - 03/05/2024

  • Improved handling of unused image file deletion scenario for very large catalogs
  • Addition of a new scenario for clearing the cache of filters created by PrestaShop's native faceted navigation module
  • Improved cache clearing for some older PrestaShop 1.7 versions
  • DataTables library updated to version 2.0.1

2.3.0 - 01/24/2024

  • Add a scenario to reassociate invoices with their original order
  • Add a cron job for database repair
  • Add a button on each table concerned to launch only the scenarios selected for cron tasks

2.2.0 - 01/10/2024

  • Bug fix on some PrestaShop 1.6 versions
  • Fixed problem recalculating real-time scenarios when specifying a delay of 0 days
  • Improved module UX

2.1.0 - 01/04/2024

  • Scenarios added to correct problems caused by store deletion
  • Scenarios added to correct problems caused by language deletion
  • Add a scenario to clean up inconsistencies in the configuration table
  • Add a scenario to clean up inconsistencies in native tables
  • Add a scenario to clean up inconsistencies in native tables linked to modules

2.0.0 - 08/12/2023

  • Added scenarios for cleaning up product images in the database and files on the server
  • Improved processing of deletion scenarios with large results
  • Multi-shop support to indicate whether a module is active only on certain stores
  • Asynchronous data loading for enhanced user experience

1.8.1 - 07/25/2023

  • Fixed a bug when analyzing installed modules
  • Correction of a bug in the deletion scenario for customers considered deleted
  • DataTables library updated to version 1.13.5

1.8.0 - 06/14/2023

  • Added option to install a module directly from the module cleaning tab
  • Add an option to change the prefix of your database tables

1.7.0 - 06/01/2023

  • Improved cleaning procedure for abandoned baskets to avoid errors if there are many to delete
  • A new scenario has been added to clean up the modules folder if there are files or folders that don't belong there.
  • Improved module UX
  • Add an option to uninstall a module
  • Integration of module version numbers when downloading modules
  • Add last execution date for each Cron task

1.6.2 - 05/25/2023

  • Improved compatibility with PHP8
  • Added an option to delete several uninstalled modules at once
  • Display the size of the temporary image directory
  • Addition of an option facilitating multiple selection for certain scenarios

1.6.1 - 04/05/2023

  • Add a column indicating the creator of each module
  • Added an option for cleaning the image cache to empty the img/tmp/ folder

1.6.0 - 03/10/2023

  • Adding the identification of modules absent from the server but active in the database
  • Improvement of the design of the tables
  • Fixed a bug in the display of information about some scenarios
  • Added better presentation of data tables with pagination and search function
  • Added cleaning of the revision table created by the Creative Elements module
  • Fixed a bug when a table no longer exists after uninstalling the linked module

1.5.0 - 02/03/2023

  • Fix bug if statssearch module is uninstalled
  • Added a security option by allowing database backup if you have installed my database backup module

1.4.1 - 01/28/2023

  • Fixed a bug on the display of badges on the tabs
  • Added information about the size of the database
  • Fixed a bug in the display of information icons in the pages
  • Adding the directory in the modules table to identify the module folder copies

1.4.0 - 01/26/2023

  • Added a new option to delete the folders of modules present on the server but not installed
  • Added an option to download the archive of a complete module folder, useful before deleting it permanently
  • Performance improvement
  • Addition on some tabs of the module of the number of erasable data
  • Improved security of this module by giving user rights only to SuperAdmin employees

1.3.2 - 01/06/2023

  • Correction on a defect of saving the configuration of the elements to be integrated in the cron tasks

1.3.1 - 12/29/2022

  • Fixed a bug that prevented to view a thread for the scenario: Customer thread about an order
  • Add a better security on SQL queries
  • Added more information on how to use the module

1.3.0 - 12/21/2022

  • Add a tab to clear the cache
  • Adding a cron job to clear the cache
  • Fixed a bug when saving changes in the module configuration

1.2.0 - 11/02/2022

  • Added a scenario to anonymize all personal data of customers
  • Compatibility with PrestaShop 8.0
  • Improvement of the source code of the scenarios
  • Separation of service thread scenarios into those associated with an order and others
  • Add a scenario to remove addresses that are not associated with any customer, manufacturer, supplier or order

1.1.0 - 04/12/2022

  • Added an option to display data that can be deleted on certain scenarios to facilitate decision-making
  • Adding new scenarios to permanently delete clients that are deleted but still present in the database
  • Fixed a bug when deleting customer threads
  • Fixed a bug when deleting customer without address
  • Improved performance on customer data erasure
  • Improved some scenario descriptions to assist in decision-making

1.0.0 - 03/21/2022

  • Initial version

Interested in product

Tell us your interest in this product and we will contact you for more details.

[0/]
Protect and optimize your online store with our PrestaShop database maintenance module
Protect and optimize your online store with our PrestaShop database maintenance module

Reviews