[MODULE] Maintain the performance of your PrestaShop store by regularly cleaning up useless or obsolete data

Mediacom87 · April 22, 2022

Hi,

I am very happy to present you my new module, because it's been several years that I wanted to have a module like this one in order to maintain the stores of my customers that I have in maintenance contract.

I have already adopted it and it saves me a lot of time and above all it improves considerably the performance of my clients' stores by keeping a good quality database.

So, this module will help you in the task of maintaining your data in order to remove all those that are useless or obsolete.

The module integrates precise and explained scenarios to allow you to make the right decisions to schedule with cron tasks some of the scenarios or simply to launch them manually when you need them.

Clean up the database

Statistical data
Email log
Logs log
Search log

Cleaning up customers

Abandoned carts
Guests without address
Guests without orders
Customers without address
Customers without orders
Customer threads

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

Recent PrestaShop 1.7 and PrestaShop 8

All production cache files
All dev cache files

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.

Of course, each evolution of this module will allow adding scenarios when they are needed or if a user requests it (I will have the last word to validate the integration of this scenario if I think it is necessary).

Discover the module with its demonstration: ~~https://medcleanmyshop.carrd.co/~~

Download it on Thirtybees: https://store.thirtybees.com/shop-modules/administration/automate-the-cleaning-of-your-prestashop-store

Download it on PrestaToolbox: https://www.prestatoolbox.com/administrative-tools/457-automate-the-cleaning-of-your-prestashop-store.html

Download it on Addons: https://addons.prestashop.com/en/website-performance/87733-maintenance-and-cleaning-of-your-store.html

Edited March 21, 2023 by Mediacom87

Mediacom87 · November 2, 2022

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 - 2022-04-12

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

Mediacom87 · December 21, 2022

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

Mediacom87 · December 30, 2022

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

Mediacom87 · January 6, 2023

1.3.2 - 01/06/2023

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

Mediacom87 · January 26, 2023

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

Unfortunately, the increase of the security forces me to withdraw the demonstration of the module, I will have to propose a video of demonstration of use of it in the next weeks.

Mediacom87 · January 28, 2023

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

Mediacom87 · February 3, 2023

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

Mediacom87 · March 10, 2023

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

This update is quite important, because it integrates new concepts.

I noticed that on half of the sites I have under maintenance contract, some module directories were deleted without having uninstalled them properly from the backoffice, which makes the store consider these modules still in place.
You just have to put back the module directory to uninstall it properly.
But my module also provides a solution that allows you to do most of the cleanup with a single click to free up resources for your store, even if you can't find the archive of the module.
Many users enjoy relying on the flagship module Creative Elements.
This module is of WordPress origin and therefore incorporates management methods inherited from this universe, including a solution called Revision, which allows you to keep all changes made to page elements.
Except that they didn't think of a way to simply clean up these revisions and this can quickly harm the performance of your store by filling up your database.
I have therefore implemented, as for the other tables in the database, the possibility of deleting data that has been out of date for a certain number of days and bringing your database back to life.

Of course, you will always find the possibility to backup your database in 1 click for security before doing a big cleanup if you have installed my other module.

Mediacom87 · April 7, 2023

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

Mediacom87 · May 26, 2023

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

Mediacom87 · June 1, 2023

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

Mediacom87 · June 16, 2023

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

Mediacom87 · July 25, 2023

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

Obi · October 9, 2023

This looks like an interesting module but I was unable to actually do anything in the demo. 😞

Also, the database backup module was on the prestashop addons French site, and while I do understand a little bit of the French language, I really don't have the time to translate - and the google translator doesn't work on that site either - so I couldn't view anything regarding the backup module... something I am quite interested in since one of my other sites suffered a catastrophic server crash just last week . . . and my primary database backup could not be restored!

Edited October 9, 2023 by Obi

Mediacom87 · October 9, 2023

2 hours ago, Obi said:

This looks like an interesting module but I was unable to actually do anything in the demo. 😞

Also, the database backup module was on the prestashop addons French site, and while I do understand a little bit of the French language, I really don't have the time to translate - and the google translator doesn't work on that site either - so I couldn't view anything regarding the backup module... something I am quite interested in since one of my other sites suffered a catastrophic server crash just last week . . . and my primary database backup could not be restored!

Hi,

I confess I don't quite understand your message.

1- yes, the development of a demonstration of a module capable of breaking everything must be limited, precisely to prevent an ill-intentioned user from having fun destroying the demonstration at will.

2- You're talking about the database backup module, which is presented on this forum in French and English, as on all the sites on which it is referenced.

If you have any questions about these two modules, don't hesitate to contact me, either via the forum, my website or the Addons messaging system.

Obi · October 22, 2023

I finally got to see more of your module ... looked pretty good from what I could tell... as long as it actually does EXACTLY what it says. But there seems to be some issue with specifics - maybe language differences, but when I read the license agreement, well that doesn't work for me because I routinely FIX code from software vendors OR MODIFY that code because it does not do exactly what I want or it doesn't perform the task how it should be done... your "license" prohibits that - so that is a deal breaker for me, especially something this sensitive.

Edited October 22, 2023 by Obi

Mediacom87 · October 22, 2023

4 minutes ago, Obi said:

I finally got to see more of your module ... looked pretty good from what I could tell... as long as it actually does EXACTLY what it says. But there seems to be some issue with specifics - maybe language differences, but when I read the license agreement, well that doesn't work for me because I routinely FIX code from software vendors OR MODIFY that code because it does not do exactly what I want or it doesn't perform the task how it should be done... your "license" prohibits that - so that is a deal breaker for me, especially something this sensitive.

Exactly, the license explicitly forbids appropriating my work and transforming it for commercial purposes.

Of course you can adapt the module's operation and code for your site if it doesn't do exactly what you want, although it would be preferable to let me know your requests to see if I can integrate them into the module as I've already done for many users, because they come up with interesting ideas and a vision different from mine.

After that, if it doesn't suit you, don't worry, develop your module to get exactly what you want, that's how the majority of developers in this community do it.

The module code is open source, but not available for you to do just anything with.

Obi · October 24, 2023

On 10/21/2023 at 7:56 PM, Mediacom87 said:

Exactly, the license explicitly forbids appropriating my work and transforming it for commercial purposes.

Of course you can adapt the module's operation and code for your site if it doesn't do exactly what you want, although it would be preferable to let me know your requests to see if I can integrate them into the module as I've already done for many users, because they come up with interesting ideas and a vision different from mine.

After that, if it doesn't suit you, don't worry, develop your module to get exactly what you want, that's how the majority of developers in this community do it.

The module code is open source, but not available for you to do just anything with.

So which exactly is YOUR license: GNU, GPL, LGPL, AGPL, AFL, APL, MPL, MIT, OSL, etc. ? Because the above explanation isn't what I read in your online license document.

Look, I'm not trying to split hairs or anything here, but your explanations are as clear as mud, which is exactly why I haven't made a purchase yet. I'm just tired of getting scammed by software vendors/developers (especially the "open source" variety). So when I see all sorts of legaleze and caveats, I typically run for the hills and write my own code, but even that is getting tiresome since I can't focus on my businesses - which ARE NOT about writing software!

Edited October 24, 2023 by Obi

Mediacom87 · October 24, 2023

33 minutes ago, Obi said:

So which exactly is YOUR license: GNU, GPL, LGPL, AGPL, AFL, APL, MPL, MIT, OSL, etc. ? Because the above explanation isn't what I read in your online license document.

Look, I'm not trying to split hairs or anything here, but your explanations are as clear as mud, which is exactly why I haven't made a purchase yet. I'm just tired of getting scammed by software vendors/developers (especially the "open source" variety). So when I see all sorts of legaleze and caveats, I typically run for the hills and write my own code, but even that is getting tiresome since I can't focus on my businesses - which ARE NOT about writing software!

Mediacom87 · December 16, 2023

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

Mediacom87 · January 12

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

Mediacom87 · January 12

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

Mediacom87 · March 6

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

Mediacom87 · March 25

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