Database Optimization

Your store is slow? You don't know what to do? This modue may be solution! This free prestashop addon removes all unwanted informations from database. Speed up your store, clean your store database for free.

This essential PrestaShop module optimizes your store's database for peak performance and faster load times. It efficiently cleans unnecessary data, tackling large entries like abandoned carts, connection details, guest information, and visit sources. By removing these unneeded records, the module resolves performance bottlenecks caused by oversized tables. This ensures a significantly more responsive shopping experience, improving overall store speed and efficiency. Please note, this process includes the removal of certain statistical data.

A lighter database. A faster store. Database Optimization for PrestaShop. PrestaShop stores a lot of data you don't need forever: abandoned carts, visitor logs, connection stats, guest sessions. Every visit, every page view, every cart that never became an order adds rows. On busy shops these tables can grow to hundreds of thousands of records—slowing down queries, backups, and the back office. You don't need that data forever. Old visitor stats are rarely used if you rely on Google Analytics. Abandoned carts that never converted can be removed safely. Clearing them frees space and often improves response times. The problem is doing it safely: you must not touch carts that have orders, and you should know exactly what you're cleaning. Database Optimization gives you a single back-office screen with one switch per table. You see how many records will be removed and when each table was last cleaned—so you can clean statistics regularly but keep cart cleanup for when you really need it.

What you get with this module Selective cleanup: Turn on only the tables you want to clean. No blind "clean all"—you stay in control. Record count & last cleaned: Each option shows how many rows will be removed and the date of the last cleanup. No guesswork. Safe cart handling: Only carts that have no linked order are deleted. Completed orders and their carts are never touched.

What you can clean (and why it matters) Unwanted carts: Removes only abandoned carts—carts that were never converted into orders. Frees a lot of space on busy stores. Carts linked to existing orders are never deleted. Connections: Basic visitor connection logs (IP, time, etc.) used by native PrestaShop statistics. Safe to clear if you use external tools like Google Analytics. Connections Page: Stores the path of pages visited per connection. This table can grow very large and slow down the database. Safe to remove. Connections Source: Referrer data (where the visitor came from). Clearing this affects native statistic reports on traffic sources. Optional if you use other analytics. Guests: Information about unregistered visitor sessions, linked to the connections table. Registered customers are not affected. Clearing guests helps keep the database lean when you also clean connections.

One screen, five switches, one click The module has a single configuration screen. You see the list of tables to optimize, each with a switch, the number of records to clean, and the last cleaned date. Select the tables you want, then click Clean selected tables. A backup before cleaning is recommended.

Tables you can clean Unwanted carts (abandoned only) Connections (visitor logs) Connections Page (visited paths) Connections Source (referrers) Guests (unregistered sessions)

What you see per option Record count (how many rows will be removed) Last cleaned date (or "Never") Short description of what the table stores MyPresta update checker (optional notifications)

Technical specification & compatibility Standard PrestaShop module. No core overrides. Uses native Db and HelperForm. Safe for upgrades and multistore. PrestaShop: 1.6, 1.7, 8.x, 9.x. PHP 5.6+. Tab: Administration. No front-office hooks; back-office only. Cart cleanup: DELETE only carts not in orders. Others: TRUNCATE. MyPresta update checker included.