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

[Mediacom87]

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]

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]

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]

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]

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]

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]

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]

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]

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.

1. 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.
2. 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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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]

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!

 

 * @copyright 2008-today Mediacom87
 * @license   https://opensource.org/licenses/AFL-3.0 Academic Free License version 3.0

 

 

[Mediacom87]

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]

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]

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]

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]

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