Clean up and speed up the database
Description
About the Extension
Clean up and speed up the database
Over time, a lot of old, unused data accumulates in your database. This leads to your database becoming unnecessarily bloated and slower. Writing backups also naturally takes longer.
With this extension, you can automatically clean up data waste in many places. Automatically remove outdated logs, guest accounts, shopping baskets, orders, products, media and much more!
The clean-up of old data records can either be executed fully automatically in the background via a scheduled task or manually via a console command. After installing the extension, the automatic execution of the scheduled task is deactivated in the configuration of the extension. This prevents the extension from starting to delete data immediately after installation. Please activate either the execution via scheduled task or via console command in the configuration of the extension.
The deletion of data records is limited per run. This ensures that - e.g. directly after installation - an unlimited number of data records are not deleted, which could potentially overload the database. This means that the data records are deleted one by one sequentially each time the scheduled task or console command is run. The number of data records per run can be adjusted in the configuration of the extension.
Areas
- Guest accounts
Delete old guest accounts that are no longer used. On request, only guest accounts that have not placed any orders will be deleted. However, all customer data is always contained in the order itself when an order is placed. - Orders
Deletes all orders with specified payment method, order, payment and delivery status. Orders with documents already created (delivery note, invoice, etc.) are never deleted. You can also delete all orders with invalid versions. - Orders history
When orders are deleted in the administration (whether manually or automatically), entries in the order, payment and delivery status history are left behind. These data records are not cleaned by Shopware and remain in your database. These old, invalid entries can also be deleted. - Carts
Shopping carts of customers or guests who are not logged in can never be called up again and could therefore even be deleted relatively quickly without any further consequences. The shopping basket table is one of the largest tables within the Shopware database. - Wishlist
For customers with a customer account, all products on the wish list are saved in the database. These could be deleted after a longer period of time if it can be assumed that these customers will not return to the shop. - Products
Especially with a constantly and rapidly changing product range, it can make sense to automatically delete older products. - Product media
Old product images are often overlooked and remain undeleted. The extension searches the "Product Media" folder (including subfolders) for all media that are not assigned to a product and deletes these media automatically. - Password recovery
Old data records that have never been called up for password recovery can be deleted (table "customer_recovery"). - Logs
As long as no errors occur or logs do not need to be checked, they can be deleted without any problems after a certain period of time (table "log_entry"). - Admin notifications
Notifications in the administration that have long been read or are out of date can also be deleted (table "notification"). - Version commit data
Shopware stores versioning data that can be deleted without hesitation after a period of time (tables "version_commit" and "version_commit_data"). - Sales channel api context
Data on the context of API queries is not deleted by Shopware and can be easily removed (table "sales_channel_api_context").
Instructions
- install the extension
- create a backup of the database
- check all settings for all areas in the configuration of the extension
- activate the execution of the scheduled task or the console command in the configuration of the extension
General information
- Snippets
The app uses snippets so that all texts and labels can be translated into other languages in the backend / in the administration - Subshop-able
Relevant configuration options can be individually adapted for each subshop / sales channel - Compatibility
The app is always compatible with the latest Shopware version and the Shopware standard theme - Incompatibility
If you are using a custom theme and/or third-party apps, you should test the app thoroughly before buying. A compatibility can not be guaranteed - Responsive
Whether desktop PC or mobile phone - the app is fully responsive - Test version
The app can be tested free of charge and without obligation for 30 days (see free trial month of the rental license) - Individual change requests
Every company is unique and requires individual solutions that are precisely tailored to its own workflows. Please contact me without obligation to adapt my apps according to your requirements in order to integrate them perfectly into your in-house processes - Liability disclaimer
The app manufacturer is not liable for damages, in particular not for direct or indirect consequential damages, data loss, lost profits, system or production failures that result from the use of the app - except for intent or gross negligence
About me
- 20+ years of experience
For over 20 years in e-commerce and for over 10 years exclusively with shopware. Your specialist with extensive industry and technical knowledge. - Reliable
Shopware is my passion and my hobby. I take care of your project in a reliable and committed way as if it were my own. - Quality
High service quality is the focus. I use state-of-the-art design patterns, current technologies and innovative tools.
Your competent partner
For more than 20 years I have been working as a passionate web developer in e-commerce. In this time I have already advised and supported many companies in interesting projects. Thereby I stand for uncomplicated communication, future-proof solutions, modern technologies and a high level of commitment.
Every company is unique and requires individual solutions that are precisely tailored to its own workflows. Get in contact with me without obligation, to get my apps according to your requirements in order to integrate them perfectly into your in-house processes. I would be happy to provide you with offers for adaptations or, if necessary, individually programmed apps according to your wishes.
Details
- Available: English, German
- Latest update: 11 November 2024
- Publication date: 18 December 2023
- Version: 2.0.0
- Category: Administration
Resources
Reviews (0)
About the Extension Partner
digitvision
Partner Status
-
Shopware
Premium Extension Partner
Details
- Ø-Rating: 4.9
- Partner since: 2018
- Extensions: 88
Support
- Based in: Germany
- Speaks: German, English
- Response time: Very quickly