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]