Database Cleaning and Optimization: Give your PrestaShop a spring clean!
Give your PrestaShop store a Spring clean and avoid multiple bugs
Boost performance of your PrestaShop store
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!
Try it for FREE
Don't hesitate to try our Database Cleaning and Optimization module for free on one of our virtual shop!
Click on the 'Try it on a demo store' button on your left.
All our PrestaShop modules are present on the virtual demo shop, Store Commander included.
Database Cleaning and Optimization is accessible from Modules menu in PrestaShop backoffice.
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”.
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
This module does not overwrite the index.php files used to prevent visitors from reading PrestaShop folders.
Yes, minor updates that do not induce a change of version (for instance 1.1 to 1.2) are free of charge upon request and proof of purchase (your invoice) ; major updates (for instance 1.4 to 2.0) which constitute major changes can be purchased from the Modules tab of our website (https://www.storecommander.com/fr/modules-prestashop/307-module-terminator-31-pour-prestashop-15.html).
Terminator optimizes all tables at once. If you have only a few options on your hosting site and you have access to phpmyadmin, you can select and then optimize tables by groups and their sizes. Once logged onto phpmyadmin, select the database to get the list of tables, select a table group, or all tables and then deselect the bigger tables, and click on 'optimize' at the bottom of the page. Here is a technical explanation: http://dev.mysql.com/doc/refman/5.0/fr/optimize-table.html.
Phpmyadmin shows the 'lost space' on the right-handside in columns when displaying tables. If the value is important, this is when you can use this tool.