Important: Always make a full database backup before deleting or emptying any tables!

Common Large Tables You Can Usually Empty (Truncate) Safely

These tables are related to statistics, visitor tracking, or logs. Clearing them will not affect product catalog, orders, or carts:

  • ps_connections, ps_connections_source, ps_connections_page
    Visitor statistics and browsing sessions.

  • ps_guest
    Stores information about guest visitors, not customers.

  • ps_statssearch
    Stores data about what people search for in your shop.

  • ps_log
    System log table—error and event records.

  • ps_mail
    Log of sent emails (safe to empty, but you lose mail history).

  • ps_smarty_cache, ps_smarty_last_flush
    Smarty cache data (PrestaShop will rebuild as needed).

To empty (truncate) a table in phpMyAdmin:

  1. Select your database, check the table, then choose "Empty" (not "Drop").

  2. This will delete all rows, but keep the table structure.