Module Ultimate Database Optimizer
Module Ultimate Database Optimizer

Module Ultimate Database Optimizer

LWMOD_UDO
€111.99 
Tax excluded

The Ultimate Database Optimizer module is the definitive solution that repairs, optimizes and keeps the database of your PrestaShop store clean. It is the module with the most features and functions to perform periodic maintenance of the database, preventing errors and increasing the speed of query processing and the overall performance of the website.

Ratings and comments from our customers
( 0.0 / 5) - 0 feedback(s)
 
Previous
Next

What is the Ultimate Database Optimizer module?

The Ultimate Database Optimizer module for Prestashop is a powerful tool designed to optimize, repair, clean, defragment Database tables. It also contains advanced tools to perform actions such as compressing tables, changing file formats, changing table formats, etc...

The database Your store is a very delicate part of your business, where all of its information is stored (product catalog, page content, customers, purchases, records, etc...).

During the entire life of an online store, the database is in constant use: reading records, recording new records and deleting records. These operations leave traces in the tables, fragmenting the information, deteriorating its structure and causing referential integrity errors to appear.

If attention is not paid and measures are not applied, the database will begin to be unstable, slowing down all its operations and causing serious errorsthat will affect both the user's navigation on the web and the purchasing processes, registrations, etc...

This is translates into economic losses, loss in the number of sales and problems with customers due to not being able to navigate or use the store correctly. This also causes a decrease in SEO and therefore a loss in daily visits.
 
Ultimate Database Optimizer has been developed as a total solution to all these problems. Becoming an essential module that every online store should have to ensure that the Database works at full capacity, 100% optimized and without any errors or critical failures.

WHAT CAN THE ULTIMATE DATABASE OPTIMIZER MODULE DO?

The module performs the following actions in your Database:

  • MANAGEMENT THROUGH AN ADVANCED GRAPHIC INTERFACE
  • ANALYZE THE DATABASE COMPLETELY
  • OPTIMIZE THE DATABASE
  • COMPLETE OPTIMIZATION WITH JUST ONE CLICK
  • REPAIR THE DATABASE TABLES
  • REPAIR ORDERS WITH MISSING ADDRESSES
  • REMOVE DUPLICATE VALUES IN THE CONFIGURATION
  • DEFRAGMENT THE TABLES
  • CHANGE THE DATABASE PREFIX
  • CHANGE THE TABLE ENGINE
  • CHANGE THE FILE FORMAT OF THE TABLES
  • COMPRESS AND DECOMPRESS THE TABLES
  • MONITORING THE STATUS OF THE DATABASE DATA
  • SHOW NOTIFICATIONS ABOUT TIPS, WARNINGS AND RISKS IN THE STATUS OF THE DATABASE
  • SHOW ADVANCED INFORMATION ABOUT THE DATABASE AND ITS COMPLETE STRUCTURE
  • CLEAN PivotTable Records
  • REMOVE ABANDONED SHOPPING CARTS
  • REMOVE EXPIRED SPECIFIC PRICES
  • REMOVE EXPIRED DISCOUNTS
  • DELETE THE CATALOG
  • DELETE DATA OF ORDERS, CUSTOMERS, ADDRESSES, ETC...
  • MAKING A BACKUP OF THE DATABASE
  • RESTORING COPIES DATABASE SECURITY MAINTENANCE
  • RECORD ALL ACTIONS TAKEN FROM THE MODULE
  • PERIODIC MAINTENANCE OF THE DATABASE THROUGH SCHEDULED TASKS
  • BACKUPS OF THE DATABASE THE DATABASE THROUGH SCHEDULED TASKS
  • SHOW THE STATUS OF THE DATABASE THROUGH AUTOMATIC EMAIL SENDS

Another of the most innovative features is the integration of a complex algorithm to carry out constant monitoring tasks of the database, instantly notifying the status of the same, so that the user can know at all times what situation the database is in and can solve any problem from the same module.

This module is designed both for advanced users who have knowledge of the structure of the Database, and for clients who do not have much knowledge. You will have at your disposal a button called "One-Click Optimization" to be able to perform a complete optimization of the Database just by pressing that button. The system will carry out the necessary actions automatically, leaving the Database 100% optimized.

With this module you will be able to keep your store's Database fully optimized, repaired and at full performance, considerably increasing the performance and speed of the website, maximizing all processes and queries carried out during purchase operations and customer registration in the store. You will increase SEO and avoid critical errors in the store.

A professional tool adapted for all levels of users!

CLEANING DYNAMIC TABLES

As time goes by, data is stored in the databases in the tables related to customer visits, statistics, connection data, etc... Therefore, daily records are saved in the database . These records take up space and slow down the operation of the database. This module allows you to perform periodic manual and/or automatic cleaning of these dynamic tables. It also has a warning function when the database tables contain an excessive number of records, as well as a heavy size.

ELIMINATION OF ABANDONED SHOPPING CARTS

The table where the shopping cart data is stored often fills up over time with waste and records of abandoned shopping carts that have no importance over time. Therefore, in order to eliminate them, this module has a useful tool. It is possible to delete all abandoned carts or limit deletion by date.

ELIMINATION OF SPECIFIC PRICES

When we configure the offer prices for each of the products, on some occasions we limit them by date, so after that time, the record of the specific price for the product is invalidated and saved in the database as waste. It is very important from time to time to clean this waste. With this module it is possible to do so, even by expiration date.

DATABASE BACKUPS

The most important thing to save your store. With this module you have a section to manage database backup files, make backup copies, restore them or download them in a compressed file to your computer. It has an option to automate the process of making backup copies using a CRON task and automatically every time any action is performed within the module. You will never lose the most important data of your store. An automatic daily backup is the solution!

SENDING EMAILS

One of the newest features in this module is that you can automatically receive to your email address or a group a complete database activity log, notification messages and warnings about the status of the database and Sending the database backup file each time. Ultimate Database Optimizer will keep you instantly informed of everything that is happening to your store's database.

ADVANCED UTILITIES

This is one of the most notable features of this module. We know that a user cannot be constantly aware of the status of your database, for that reason this module implements the scheduled task function so that all actions can be perform periodically with the desired frequency:

  • Database check and repair
  • Optimization and defragmentation
  • Database compression
  • Making backup copies
  • Referential integrity error repair
  • Repair of orders with missing addresses.
  • Database engine change
  • Cleaning pivot tables
  • Elimination of abandoned carts
  • Elimination of specific expired prices
  • Elimination of expired discounts
  • Email sending with notifications and warnings of the status of the database
  • Email sending with database backup
  • Deleting backups from the repository.

REPAIR, OPTIMIZATION AND DEFRAGMENTATION

The most common problems we face in the Prestashop MYSQL database are data loss, waste in related tables, orphaned records and fragmented data. Because of this, the database becomes unstable and errors and anomalous behavior begin to appear in the store. The module has the ability to repair, optimize, defragment and sanitize the database easily and quickly and efficiently. You will keep your database in optimal conditions and avoid losses in sales.

ADVANCED STATUS MONITORING SYSTEM

This module is designed with a complex algorithm in charge of constantly monitoring the database in search of any anomaly. Detect the problem and report it in detail through a notification and alert viewer. You will know at all times how the database is, and if there is a problem, it will inform you in detail so that you can solve it with the module's own tools. Through a status bar indicator, you will be able to know the level of optimization that your Prestashop database has.

IMPROVED GRAPHIC INTERFACE

It has a completely IMPROVED and OPTIMIZED graphical interface so that you can navigate between the module options in the easiest and most intuitive way. Shows an information panel with all the relevant database data (version, table engine, total number of tables, database size, etc.), and a status bar indicating the optimization percentage .

OPTIMIZATION IN A ONE CLICK

It has a button with the complete optimization function just by pressing it. So you don't have to worry about anything. Ultimate Database Optimizer will do everything for you and leave your database 100% optimized by taking the appropriate and necessary actions in each case. PRESS THE BUTTON AND LET ULTIMATE DATABASE OPTIMIZER DO EVERYTHING FOR YOU.

SCHEDULED TASKS

This is one of the most notable features of this module. We know that a user cannot be constantly aware of the status of your database, for that reason this module implements the scheduled task function so that all actions can be perform periodically with the desired frequency:

  • Database check and repair
  • Optimization and defragmentation
  • Database compression
  • Making backup copies
  • Referential integrity error repair
  • Repair of orders with missing addresses.
  • Database engine change
  • Cleaning pivot tables
  • Elimination of abandoned carts
  • Elimination of specific expired prices
  • Elimination of expired discounts
  • Email sending with notifications and warnings of the status of the database
  • Email sending with database backup
  • Deleting backups from the repository.

ACTIVITY REGISTER

A complete record of all module activity is available on the database. You will have information about each of the actions taken in the database, so that you can know exactly, knowing the trace left by each action taken.

SOME COMMON PROBLEMS AND ERRORS THAT THIS MODULE REPAIRS

  • Fixes the error of showing price 0 in the product list when the product has combinations.
  • Fixes the error that some orders disappear in the order table "Orders" from the back-office orders section.
  • Fixes the "Order again" action error that shows the empty cart to proceed with the purchase.
  • Solves speed problems in the Back-office and Front-Office related to the state of the Database.
  • Solves problems with duplicate and erroneous values ​​in the Back-office configuration

What are the main advantages of purchasing this module?

ADVANTAGES YOU GET AS A MERCHANT

  • The PrestaShop store database will be fully optimized, repaired and will work at 100% performance. You will avoid losses in sales due to critical errors in the database.
  • The speed of the stores will increase considerably.
  • The database will take up less space and will be lighter.
  • You will be able to carry out periodic maintenance of the database.

ADVANTAGES THAT CUSTOMERS OBTAIN

  • Customers will enjoy an optimized, fast and error-free store in their database. They will navigate with complete tranquility, confidence and speed.
Version
1.6.6.1
Compatibility
PrestaShop 1.6
PrestaShop 1.7
PrestaShop 8
Multishop compatibility
Yes

LEGEND

[DEL] = Element removed
[NEW] = New element
[ADD] = Feature added
[FIX] = Bug fixed
[ IMP] = Improvement

3.1.3.11 (02/07/2024)

- [FIX] Issue with minimum requeriments to operate the module when max_execution_time value is unlimited.

3.1.3.10 (02/07/2024)

- [FIX] Data integrity repair issue in tables stock and stock_mvt for PrestaShop 8 version.
- [IMP] Some performance enhacements optimizing PHP code.

3.1.3.9 (03/05/2024)

- [FIX] Minor bugs.

3.1.3.8 (01/05/2024)

- [FIX] Remove max_execution_time parameter from CRON to avoid issues with minimum requeriments.
- [FIX] Bug endless deep scan process when there are missing order addresses.
- [IMP] Some improvements in database optimization processes.

3.1.3.7 (26/03/2024)

- [FIX] Cron task issue blocked due .htaccess file security directives.
- [FIX] Issue performing duplicated ajax process when deep scan is repeated without reloading page.
- [IMP] Table detection with suffix _shop or _lang avoiding issues when tables contains shop or lang string but they are not related to language or multishop.
- [IMP] Use of frontcontrollers for cron tasks to increase security.

3.1.3.6 (06/02/2024)

- [FIX] Bug when activate debug profiling.
- [FIX] Deprecated usage of code.

3.1.3.5 (20/12/2023)

- [FIX] Bug skipping last process in deep scan.

3.1.3.4 (19/11/2023)

- [FIX] Typography issue in code from Database.php file.
- [FIX] Minor bugs.
- [ADD] New feature to check missing tables during check integrity process.

3.1.3.3 (03/11/2023)

- [FIX] Issue during deep scan process never end kepping looping in last process check.
- [FIX] Visual issue in admin tabs collapsed.
- [FIX] Security issues against SQL Injections.

3.1.3.2 (30/08/2023)

- [FIX] Issue during installation in Prestashop 1.6. version.
- [FIX] Issues with source code.

3.1.3.1 (07/08/2023)

- [FIX] Issue in mySQL execution with multiple queries.

3.1.3 (13/04/2023)

- [FIX] Minor BUGS.
- [FIX] Bug in search filter from log table.
- [IMP] Performance executing some optimization and repair tools.
- [IMP] Check table errors process avoiding check tables with more than 1.000.000 records to avoid get stuck the process.
- [IMP] Deep scan process.
- [IMP] One Clic Optimization tool.
- [NEW] Option to remove orders from deleted customers.

3.1.2 (22/03/2023)

- [FIX] Minor bugs.
- [FIX] Issue checking missing carts in database.
- [IMP] PHP code and visual.
- [IMP] CRON tasks engine.
- [ADD] Prestashop 8 compatibility.

3.1.1 (15/10/2022)

- [FIX] Issue checking cache attribute issues in multishops.
- [FIX] Issue not meeting requeriments when max_input_time PHP parameters has value -1.
- [IMP] PHP code.
- [IMP] System to check and fix cache default attribute issues.
- [ADD] New system check engine to detect missing default attributes causing zero price in product list.

3.1.0 (14/06/2022)

- [FIX] Minor bugs with parameters value in Control panel.

3.0.9 (23/12/2021)

- [FIX] PHP code with bad function name.
- [FIX] PHP code with SQL bad syntax.
- [FIX] Adding reparing tables when there is a carts with missing products when optimization in one click is performed.
- [ADD] Messages when tables are fragmented.
- [IMP] Deep scan process to avoid browser freeze during performing actions.
- [IMP] Code to optimize memory use in optimization cron task.

3.0.8 (14/12/2021)

- [IMP] Engine to check database user privileges.
- [IMP] Avoid stop process in missing product carts fix process when there is duplicated entries.
- [IMP] Improved process in missing order address checking when customer deletes address but it is in database table as deleted = 0.
- [IMP] Reseting progress bar between processes.
- [FIX] BUG in PHP code in optimization.php file for Optimization cron task.
- [ADD] Allow to perform deep scan even server requeriments are not meet.
- [ADD] Allow to perform optimization task is CRON even user is not Superadmin.

3.0.7 (30/11/2021)

- [FIX] Issue checking database user privileges in some servers with no privileges in information.schema tables.

3.0.6 (19/10/2021)

- [FIX] Issue displaying error message about minimum requeriments when database privileges has more than those minimum 7 privileges requested.
- [FIX] Displaying duplicated popup messages in Control Panel.

3.0.5 (07/10/2021)

- [IMP] Ajax processes.
- [IMP] PHP code.
- [FIX] Issue checking database user privileges when they are combinated into Global and specific privileges.
- [FIX] Issue infinity loading in database status message process.
- [FIX] Issue "Warning: strip_tags() expects parameter 1 to be string, array given" for table name.
- [FIX] Issue variable for warning messages sent in Cron task for Database status process.
- [FIX] Issue sending emails in english language instead administrator profile language selected.
- [FIX] Issue stopping process when max_execution_time is equal to 300.
- [FIX] Emails format and translations.
- [ADD] System to check and fix when there is a missing products in orders carts.

3.0.4 (01/10/2021)

- [FIX] Issue with bad option "disabled" in change database engine dropdown into Cron for optimization section.
- [IMP] PHP code in Cron files.
- [IMP] Database user privileges checking process.
- [IMP] Allow Database basic checking even minimum requeriments are not meet.

3.0.3 (15/09/2021)

- [FIX] Admintab translation issue.
- [FIX] Issue not hidding loading icon in notification container when error is after one click optimization process.
- [FIX] Issue displaying elements found and type of process in status monitor due bad html tags.
- [FIX] Issue displaying duplicated tables when integrity errors are detected.
- [FIX] Issue detecting wrong tables with maximum key length to change engine.
- [FIX] Issue displaying wrong PHP values in Control Panel.
- [FIX] Issue extracting Database when it has symbols.
- [FIX] Issue getting optimization level caused by bad array with dynamic tables.
- [FIX] Issue performing saving logs process even option disabled.
- [FIX] Issue changing database engine in selector option when the engine is just changed.
- [IMP] Integrity error checking engine.
- [IMP] Primary key 0 or null detection engine, fixing some issues related to this.
- [IMP] Increased time to display modal messages before hidding.
- [IMP] PHP code.
- [IMP] Database user privileges and actions restricted per privileges.
- [IMP] Memory limit limitation when value is set to -1 (Unlimited).
- [ADD] Feature to inform about User current privileges and necessary ones in order to work properly.
- [ADD] Feature to hide database password information if the Prestashop emloyee is not an Admin.

3.0.2 (21/08/2021)

- [FIX] Update process issue not deleting old configuration parameters.

3.0.1 (20/08/2021)

- [FIX] Update process issues when old is below to 3.0.0

3.0.0 (10/08/2021)

- [NEW] Major 3.0.0

1.0.9 (22/12/2020)

- [FIX] Error messages with some php parameters.
- [IMP] Increase performance executing actions from this module.

1.0.8 (16/07/2019)

- [FIX] Issue with fragmented data in innoDB tables.
- [ADD] Disallow to repair and optimize tables in myISAM format.

1.0.7 (10/07/2019)

- [FIX] Issue with optimize tables function.
- [FIX] Issue with repair tables button.
- [ADD] Allow to repair and optimize tables in myISAM format.

1.0.6 (08/07/2019)

- [FIX] Issue in operator values (Error 500 in Database panel option).

1.0.5 (03/12/2018)

- [FIX] Issue in checking integrity process with Prestashop 1.7 tables.
- [FIX] Issue saving logs in database restore process.

1.0.3 (14/04/2018)

- [FIX] Issue when write config file when database prefix and engine is changed to.
- [IMP] PHP code.

1.0.2 (24/03/2018)

- [ADD] PrestaTrust feature.

1.0.1 (06/03/2017)

- [FIX] Issue when change database prefix in PS 1.7.0.0 or above versions.

1.0.0 (27/12/2017)

- First developed.

LICENSE

Once you purchase the product, you will receive a LIFETIME license code to be able to use the module indefinitely on the domain you indicate. In addition, the purchase price includes the right to technical support for the following 12 months. Once that time has passed, you will have the option to renew the technical support period for 12 months, paying the cost of the service.

If you want more information about the license conditions, please visit the following link

License Conditions