PrestaShop Cleaning and Optimization


Just like any website using and saving information in databases, your PrestaShop e-shop contains errors and obsolete information (unused carts, old statistics, old logos...). This interfere with the performance of your website, even slowing down loading times. The PrestaShop cleaning and optimization module is the answer to this issue.


Boost performance of your PrestaShop store

Before making your site live, it's essential to run a deep clean of your PrestaShop database. This will avoid emails being sent to customers by mistake, you will freeup some space on your server and also gain processing time. And all this in no time thanks to the Cleaning and Optimization module for your PrestaShop CMS.

Delete table contents, images and all tests to revert to a clean database. This will avoid cascading bugs when your store goes live or when you migrate to a new version of PrestaShop!

Improve the display performances of your PrestaShop store as well as user experience by deleting unnecessary statistics and free up space on your server and optimize PrestaShop loading speed!

Boost your sales conversion rates. Quality display performances coupled with fast surfing experience will increase confidence and multiply your chances of having visitors actually purchase your products!

The module is included in all or subscription plans and accessible from the Tools menu of our Store Commander interface.


Functionalities of the Cleaning and optimization module for your PrestaShop site

Database cleaning - Putting stores into production or migrating to a new version of PrestaShop

  • Deletes product stock movements
  • Deletes inactive products
  • Deletes products for which the update date is < INPUT_DATE
  • Deletes the log
  • Deletes all shopping carts
  • Deletes all categories and all products. Keeps the default category “Homepage”.
  • Deletes images and documents files.
  • Deletes all commands, associated price rebates, products returned, customized products, credit notes
  • Deletes all credit notes
  • Deletes all customers and their addresses
  • Deletes all messages used as models when you communicate via the page detailing orders
  • Deletes all manufacturers
  • Deletes all suppliers
  • Deletes all carriers and the default (you). Resets carts and orders to display “carrier not selected”.
  • Deletes products and associated images files
  • Deletes all products customization
  • Deletes all products’ characteristics
  • Deletes all attributes and group of attributes
  • Deletes all comments made on products
  • Deletes all tags
  • Deletes all text aliases
  • Deletes all scenes
  • Deletes all discounts
  • Deletes all pages viewed
  • Deletes all connection statistics
  • Resets price range for carriers to zero
  • Resets weight range for carriers to zero
  • Deletes groups
  • Deletes referrers

Database - Maintaining and improving PrestaShop store performances

  • Deletes discount codes for which the maximum date is < INPUT_DATE
  • Deletes all research stats (search_index, search_word, sekeyword, statssearch)
  • Deletes all unused shopping carts > 30 days within the tab Orders
  • Deletes connection statistics < INPUT_DATE (page_views, connection, guests)
  • Deletes all pages unfound


  • Checks whether you use the module for gifts’ lists and deletes all lists.
  • Checks whether you use the module for loyalty points and deletes all points.
  • Modifies the next order number: if you delete orders, you may need to reset the billing meter to zero.
  • Modifies the next order number
  • Modifies the next customer account ID 

Setting the next invoice number

  • If you delete orders you may need to reset the invoice counter. You can start from 1 or 1000 or from any other values.

Optimize database tables

  • This option should be used if you have deleted a large part of a table. Deleted rows are maintained in a linked list and subsequent INSERT operations reuse old row positions. It will reclaim the unused space and defragment the data file and optimize PrestaShop. See MySQL manual for more information.


  • Deletes PrestaShop theme cache
  • Deletes all files in /cache/smarty/cache/*.* and /cache/smarty/compile/*.* (except index.php)
  • Deletes all temporary images

CMS Security

  • This module does not overwrite the index.php files used to prevent visitors from reading PrestaShop folders.

And if you need new functionalities, please get in touch!


Included in all plans!

View pricing

How to use the module?

You can open this tool from the Tools > Database cleaning menu

A question? Contact us
Module's FAQ
Frequently Asked Questions about Modules
Oui, les mises à jour sont installées automatiquement avec votre abonnement Store Commander.
Il s'agit d'une suppression globale de toutes les commandes et de tous les éléments liés ce qui a un impact sur un bon nombre de tables.
Le module optimise toutes les tables d'un seul coup. Si vous avez peu d'options sur votre hébergement mais que vous avez un accès à phpmyadmin, vous pouvez sélectionner puis optimiser les tables par groupe en fonction de leurs tailles. Une fois dans phpmyadmin, sélectionnez la base de données pour obtenir la liste des tables, sélectionnez un groupe de tables, ou "toutes les tables puis décochez les plus grosses tables" et cliquez sur Optimiser en bas de la page. PhpMyAdmin vous indique la "place perdue" à droite dans les colonnes lors de l'affichage des tables, si le chiffre total est important, c'est le moment d'utiliser cet outil..
Il est conseillé de conserver le cache et de le vider uniquement lorsque des modifications sont apportées à votre template.