OpenCart 3.x Admin Module: Database Cleanup & Optimization

A powerful and secure administrative tool, designed to keep your OpenCart 3.x database clean, optimized, and efficient. This module provides full control over database maintenance through an intuitive interface, detailed reporting, and historical tracking of all cleanup operations.

Dynamically lists all relevant database tables (e.g. cart, session, customer_activity, api_session, etc.)
- Each table is selectable via checkbox
- Bulk selection / deselection options
- Allows precise control over which tables are cleaned
- Remove sessions older than X days
- Clear abandoned carts
- Delete old logs and API sessions

Optimization Process

Each selected table goes through:

- Size measurement (before)
- Execution of cleanup query
- Count of affected rows
- Table optimization (OPTIMIZE TABLE)
- Size measurement (after)
- Cleanup Logs & History

Logged Data Includes:
- Date & time of cleanup
- Admin user who executed the action
- Tables affected
- Deleted rows per table
- Old vs new table size
- Total space saved

Benefits
* Keeps database lean and fast
* Reduces hosting/storage usage
* Improves admin and frontend performance
* Prevents accumulation of unnecessary data