PrestaShop Database Cleaner
KLN-DB Cleaner — Database cleanup and optimisation module for PrestaShop 1.7 to 9. Speed up your shop by automatically removing obsolete data (abandoned carts, logs, connections, heavy stats, cache) and shrinking your MySQL database size.
⚠️ Important: KLN-DB Cleaner runs irreversible actions (data deletion, table optimisation, advanced cleanup). The user is fully responsible for the operations launched. A full backup of the database is strongly recommended before any use.
Module preview
In-depth information
Smart cleanup of obsolete data
Removes abandoned carts (without orders), guest ghosts, expired connections, old logs and bulky stats. Configurable period (months) with batches of 1,000 records.
Safe removal of expired promotions
Automatically cleans up expired cart rules (cart_rule) and specific prices (specific_price) via the PrestaShop ORM to ensure integrity across all related tables.
Full control and maximum security
No automatic actions: every operation requires manual validation. Protected by unique token for CRONs, strict validation of allowed tables, restrictions on TRUNCATE for sensitive tables.
Customisable CRON automation
Configure CRON tasks with secured URLs (auth tokens). Pick the action (truncate/delete), tables and retention period. Optional, to be enabled manually.
Full interface with detailed stats
View total database size, size of each table (MB), record counts and thresholds. Real-time progress bar: deleted/total and percentage.
Systematic backup recommendation
Before any deletion, the module explicitly reminds you that a full backup is required. Actions are permanent and KLN-WEB is not responsible for misconfigured cleanup.
Technical specifications
| PrestaShop version | 1.7.x — 9.x |
|---|---|
| PHP | 7.4+ recommended |
| Database | MySQL 5.7+ / MariaDB 10.2+ |
| Compatibility | Multi-shop, Multilingual |
| Required modules | None |
| Module size | ~15 MB |
Benefits for your shop
- Improved performance: database 30 to 70% lighter, faster SQL response times.
- Greater stability: fewer overloaded tables, fewer crashes from cache or logs.
- Simpler maintenance: a single click to clean up, or an automatic CRON job.
- No manual SQL: everything goes through the interface, secured and traced.
- Long-term compatibility: tracks PrestaShop versions from 1.7 to 9.
A PrestaShop & WordPress developer for Dubai and the UAE
Fully remote
Dubai, Abu Dhabi, Sharjah: everything runs over video calls, SFTP and Git access. No travel, so no on-site fee on your invoice.
Overlapping business hours
Dubai runs 2 to 3 hours ahead of Paris, so every working afternoon overlaps. Free diagnosis, quote within 24 h, same-day work when the store is down.
Priced and invoiced in EUR
The same rates as in France, quoted and invoiced in euros by KLN-WEB. No travel costs, no distance surcharge.
Day-to-day contact over WhatsApp or email, in English or French.