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

Our database maintenance module for PrestaShop allows you to maintain the quality and performance of your online store. Indeed, a well maintained database is essential to ensure the speed and reliability of your site.

This module will allow you to manage precisely the data you can delete on your PrestaShop store in order to restore its performance and reduce the size of your database.

Each proposed scenario is accompanied by a precise explanation of its action to help you make your decision to use it or not to delete these data.

You will have the possibility to select each scenario individually to run it automatically and regularly using a Cron task.

Clean up the database

• Statistical data
• Email log
• Logs log
• Search log

All of this data can be deleted without any risk since it only concerns data from the past to allow you to analyze the proper functioning of your store or to understand your visitors. A retention period allows you to limit the retention of this information to several days.

Cleaning up customers

• Abandoned carts
• Guests without address
• Guests without orders
• Customers without address
• Orphan addresses
• Customers without orders
• Customer threads

These scenarios are more complex and are accompanied by a detailed explanation to help you decide whether or not to keep this data.

Clean catalog

• Expired specific prices
• Expired coupons
• Unused feature values
• Unused custom feature values
• Empty characteristics
• Unused attribute values
• Empty attribute groups

Clean the cache

Option available from version 1.3.0 of the module

Different scenarios by compatible PrestaShop versions

PrestaShop 1.6 and some versions 1.7

• Smarty cache and compile files
• XML Cache
• Smarty theme cache files
• Smarty class index
• Deletion of all temporary images from the directory (img/tmp)

Recent PrestaShop 1.7 and PrestaShop 8

• All production cache files
• All dev cache files
• Deletion of all temporary images from the directory (img/tmp)

The main interest of this option is to allow you to schedule a cron task to regularly and automatically empty the caches of your PrestaShop store.

Clean the modules

This option will allow you to easily identify all modules that are not installed on your store, but have a directory on your server.

The presence of these module folders causes two things, one is that the module management page will take longer to load and the second is that if the module in question is poorly developed, you can leave an open door to hackers, so it seems essential to delete these folders.

The module will give you two options for action on each module.

On all the modules, you will be able to retrieve the archive of the module with a simple click, which can be interesting if you want to send this module to a service provider so that he can install it and carry out his tests on his side without intervening on your store, or simply, retrieve the archive of the module that you are about to delete.

For the modules that are not installed, you will be able to delete the directory of this module with a simple click and thus improve the performance and security of your store.

Detection of lost modules

You will have the list of modules that are considered by your store to be still installed while the module's directory is absent from the hosting server, you can then either put back the module's directory to uninstall it properly, or use my module to delete the elements concerning this module with a simple click.

Detection of unnecessary files or directories

Some module installations or uninstallations don't always go as planned. Here, you'll see all non-module-related files and folders, so you can efficiently clean up your module folder without having to open your usual FTP client.

Database management tools

• Tool for customizing your database table prefixes to improve the security of your installation.

Cron tasks

The module allows you to select scenarios to be launched automatically via Cron tasks.

What's more, you can easily alleviate constraints by scheduling regular deletion of the data you deem necessary.

This feature streamlines workflow and makes it more efficient, ultimately improving productivity and organization.

If some scenarios appear obvious when choosing their deletion (expired specific prices, expired vouchers), you will have to be careful on the others even if I propose them these can have a negative influence on the use of your store, so take the time to read each explanation well to avoid making any mistake.

WARNING

You are solely responsible for the use that can be made of this module and for your choices regarding the deleted data. Only a regular and controlled backup policy could save you in case of handling error, because these deleted data cannot be simply restored.

CHANGELOG

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