Pulizia Revolution

 Database Cleanup & Optimization

The database is where most performance degradation begins. PrestaShop stores with a few years of history typically have millions of rows in cart, log, and statistics tables that serve no ongoing purpose. Cleanup Revolution identifies these records and lets you remove them safely.

• Abandoned cart cleanup — remove carts older than a configurable threshold (30, 60, 90+ days) that were never converted to orders
• Guest account pruning — delete guest accounts that never completed a purchase and have no associated data
• Log table trimming — clear connection logs, page-not-found logs, mail logs, and other log tables that grow indefinitely
• Statistics cleanup — remove outdated statistics data that impacts query performance without providing actionable insights
• Orphaned record detection — find database rows that reference products, categories, or other entities that no longer exist
• Table optimization — run OPTIMIZE TABLE on fragmented tables to reclaim wasted space and improve query performance
• Size reporting — see exactly how much space each table consumes and how much can be reclaimed

 Image Management

• Orphaned image detection — find product images on disk that have no matching database record (deleted products, failed imports)
• Missing image detection — identify database records that point to image files that no longer exist on disk
• Duplicate image finder — locate identical images uploaded multiple times, wasting storage space
• Unused thumbnail cleanup — remove regenerated thumbnails for image types that are no longer in use
• Disk space reporting — detailed breakdown of image storage by type (product, category, manufacturer, CMS)
• Selective deletion — review detected issues and choose which to fix, with bulk actions for efficiency

 File & Cache Cleanup

• Cache purging — clear Smarty cache, Symfony cache, and theme cache files that can grow to gigabytes on busy stores
• Temporary file cleanup — remove files in /tmp, /upload, and other temporary directories left by imports, exports, and failed operations
• Module leftover detection — find files, directories, and assets left behind by uninstalled modules
• Override cleanup — identify overrides from modules that are no longer installed
• Email template cleanup — detect duplicate or outdated email templates across themes

 Duplicate & Integrity Finder

• Duplicate product detection — find products with identical names, references, or EAN codes that may have been imported twice
• Duplicate category detection — identify categories with the same name and parent, often created by failed imports
• Data integrity checks — verify referential integrity across product-category, product-image, and product-attribute relationships
• Missing translation detection — find products and categories with incomplete translations across your active languages

 System Health Check

A comprehensive audit of your store environment that goes beyond cleanup to identify configuration issues, performance bottlenecks, and potential problems before they become emergencies.

• PHP configuration audit — check memory limits, max execution time, upload sizes, and OPcache settings
• MySQL performance review — analyze slow query log, buffer pool utilization, and table engine mix
• Disk space monitoring — track total, used, and available space with threshold warnings
• Module conflict detection — identify modules hooking into the same positions that may cause conflicts
• Actionable recommendations — each finding includes a specific recommendation with expected impact

 CRON Automation & Audit Logging

• Scheduled cleanup tasks — configure recurring database, image, and cache cleanup on daily, weekly, or monthly schedules
• Dry-run mode — preview every cleanup action before execution, showing exactly which records and files will be affected
• Full audit trail — every cleanup action logged with timestamp, affected record count, reclaimed space, and rollback data
• Rollback capability — critical operations create restore points that allow reversal if needed
• Email reports — receive summary reports after each automated cleanup run