Jump to content
Daresh

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

Recommended Posts

Posted (edited)

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 temporary images
  • delete expired specific prices from products
  • delete expired vouchers

You can set number of days to only delete data older than this setting.

Data consistency

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

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

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