CHANGELOG - Basic PrestaShop Database Cleaner -------------------------------------------- Version 1.2.0 (2026-06-15) - Added: Support for clearing PrestaShop Faceted Search Cache (layered_filter_block table). - Added: Dynamic checking to only display and clean layered_filter_block if it exists in the database. - Added: Configuration support for layered_filter_block in both manual cleaning (Should Clean) and Cron Jobs (Web + CLI). - Improved: Database table queries are now cached during the request to improve performance. Version 1.1.0 (2026-05-12) - Added: New "Execution Logs" tab to track cron job history and verify server execution. - Improved: Cron reporting format. Now explicitly shows "rows deleted" or "skipped" to avoid confusion. - Added: Self-healing logic for the log table (auto-creates if missing). - Added: Important warnings and instructions in the "Cron Job" configuration tab. - Fixed: Discrepancy between front controller cron and standalone CLI script reporting. - Improved: Unified UI feedback for manual and scheduled cleaning. Version 1.0.0 (Initial Release) - Basic cleaning of connections, logs, stats, and guest tables. - Database optimization feature (OPTIMIZE TABLE). - Cron job support with security token.
Optimizer and Database Cleaner for PrestaShop
Keep your store light, fast, and efficient by automatically removing unnecessary data.
Over time, PrestaShop stores accumulate thousands of records in the database (visitor connections, abandoned carts, error logs) that do not add value, but they do Slow down the loading of the website. and increase the weight of your backups.
This module allows you to take control and perform a deep cleaning with a single click or automatically.
💎 Main Benefits:
Improve loading speed (WPO): A lighter database responds more quickly to server queries.
Disk space savings: Drastically reduce the weight of your database by removing outdated records.
Faster backups: Despite weighing less the database, your backups are generated and restored in much less time.
Total Automation Set up a CRON task and forget about cleaning manually; the module will do it for you periodically.
🛠 Included Functions:
1.Cleaning of Statistics and Connections
Remove the trace of old connections, traffic sources, and visited pages that typically take up gigabytes of space.
Tables:
connectionsPlease provide the text you would like to be translated from Spanish to English.connections_sourcePlease provide the text you would like to be translated from Spanish to English.connections pagePlease provide the text you would like to be translated from Spanish to English.
2.System Log Cleanup
Delete error log data, "Page Not Found" (404) records, and user search queries from the store.
Tables:
logPlease provide the text you would like to be translated from Spanish to English.Page Not FoundPlease provide the text you would like to be translated from Spanish to English.search statsPlease provide the text you would like to be translated from Spanish to English.
3.Customer Maintenance and Carts
Abandoned Carts: Remove old carts that never turned into an order (you can choose the age).
Expired Specific Prices: Remove expired offers and discounts to keep the price table clean.
Guests: Clean guest user records to optimize the customers table.
4.SQL Table Optimization
Include a tool for OPTIMIZE TABLE that reorganizes the physical storage of data files and indexes, improving input/output efficiency.
⚙ Featured Technical Features:
Intelligent Filters: You decide what to delete.You can choose to keep the data from the last week, the last month, or the last 6 months.
Statistics Panel: Visualize in real-time how many rows each table has before deciding to clean it.
CRON Configuration: Generate a secure URL so that your server can automatically execute the cleaning daily or weekly.
Security: Generate a unique security token to prevent external individuals from activating the cleaning.
Product Questions
No questions yet. Be the first to ask a question!




