Jump to content
Daresh

[Module] Tidy - database clean up and optimization, data consistency fix

Recommended Posts

Prestashop Tidy module will help you keep your store fast and clean. I've noticed that cleaning up millions of old stat rows can improve the performance and increase stability of prestashop.

The module allows you to perform the following operations:

Cleanup

  • delete old abandoned carts
  • delete old connections stats
  • delete old search stats
  • delete old email logs
  • delete old logs
  • delete old guests with no addresses
  • delete old customers with no addresses (useful if your shop suffered from bots registering fake accounts)
  • delete expired specific prices from products
  • delete expired vouchers
  • clear all cache

You can set number of days to only delete data older than this setting (but not for cache, it gets cleared totally).

Data consistency

  • regenerate friendly URL’s for products (for all languages)
  • regenerate friendly URL’s for categories
  • set product's cheapest combination as default

Fix images

  • delete products’ broken images (the ones that appear as question marks)
  • delete unused image files (cleans all leftovers in the img/p/ folder along with empty folders)
  • set first image as cover for products without cover
  • set product’s cover as it’s first image
  • delete temporary images

Fix associations

  • set product’s deepest category as default
  • assign all products to parent categories (usefull if some products are assigned only to some deep categories, but you want them to appear also in parent categories)
  • assign all customer groups to all categories

Mass activation and deactivation

  • deactivate active categories without active products
  • deactivate active products not assigned to any active categories
  • activate inactive categories with active products
  • deactivate active manufacturers without active products
  • activate inactive manufacturers with active products

You can also automate each of the above operations with cron tasks, making your shop clean itself on a daily basis.

[Click here to speed up and clean your shop - module's page on CodeCanyon]

Edited by Daresh (see edit history)
  • Like 1
  • Thanks 1

Share this post


Link to post
Share on other sites

I just added some new features to the module:

  • delete broken images (the ones that appear as question marks)
  • delete unused image files (cleans all leftovers in the img/p/ folder)

Share this post


Link to post
Share on other sites

Just bought your module and it is working perfect with expired prices...

 

Best Regards

Igor

  • Like 1

Share this post


Link to post
Share on other sites

Hi, I read that it has implemented the ability to delete images that remained after the cancellation of the products in the famous img / p / folder. We realized that in the famous folder there are hundreds of unused empty numbered folders 0-9 which however increase the number of files / folders writing with the consequent increase in the use of inodes. Does your form also delete these folders in addition to the images left by mistake? Thank you.
(sorry for any errors but it has been translated by software)

Share this post


Link to post
Share on other sites

Currently it does not delete the folders, but it's a good idea for a future update.

Share this post


Link to post
Share on other sites

 

I assure you that this is a big problem, since infinite folders are created, like Chinese boxes that increase the number of inodes even after a total cancellation of products (as in our case, to start from scratch). If he does this update he will surely have a response in higher sales (we among the first). Anyway, thank you for your quick reply.

Share this post


Link to post
Share on other sites

And there you have it - I just updated the Tidy module to remove empty folders after it finished removing unused images.

So it should also remove empty folders even when there are no unused images, that's probably your case.

Share this post


Link to post
Share on other sites

Great!!! Well done. I proceed immediately with the purchase and put it to work. I hope the installation is simple.
Regards

Share this post


Link to post
Share on other sites

I purchased the form, but still receive nothing on the email. What to do??

Share this post


Link to post
Share on other sites

Module downloaded and installed, however it does not seem to delete all empty folders under the -img / p directory (with names: 1,2,3,4,5, .. etc.). I will do other tests !!
Regards

Share this post


Link to post
Share on other sites

Thanks for your feedback, the folders got deleted during my tests, but maybe there's something that needs to be added, what is your prestashop version?

And the module with that feature  should be v.1.3.8.

Share this post


Link to post
Share on other sites

Hello, the Prestashop version is 1.7.5.2 and your submitted form is 1.3.8. I also noticed that some unused photos that nestle in folders have not been deleted. I have some screenshots to send you. As you can see the famous folders 1,2,3, eccc which are 99% empty have not been deleted and in none of them (image 2) there are photos not deleted.

immagini2.jpg

immagini1.jpg

Share this post


Link to post
Share on other sites

I don't see any empty folders on your screenshots, I think I would need to get access to your shop in order to analyze it.

Share this post


Link to post
Share on other sites

By empty folders, I mean those numbered from 1 to 9, which internally have folders from 1 to nine and so on. It seems to me that these folders are created when I enter products and contain images, which are then not deleted with the deletion of the products themselves. Writing these folders and files makes me increase the number of inodes, which should decrease with their deletion, I think. There are no problems to analyze everything, tell me everything you need in the private email: urisa1@alice.it

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More