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
Modules
- 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.
Files
- 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 pricingHow to use the module?
You can open this tool from the Tools > Database cleaning menu