close

Necessary update of your password on PrestaShop Addons

Hello,

You are currently the holder of an Addons account created from your Paypal account, which allows you to connect to our marketplace.

In order to increase security and simplicity, we are implementing a single authentication system. Therefore, signing in with PayPal won’t be possible on our marketplace, from April 2nd on. Read morearrow_right_alt

To continue to access your personal space on PrestaShop Addons, we simply invite you to reset your password as of now by clicking on the link below.

You will receive a new password allowing you to directly sign in to your Addons account, without using PayPal. Once logged in, you will be able to change this password in your personal space.

Your Addons account will not be affected in any way by this development.

close

check_circle Het artikel is toegevoegd aan je winkelwagen

close
Your data will be transferred to the Partner when you download this module.
close

Ik bevestig mijn persoonsgegevens te blijven

close

Top, Uw webshop heeft baat bij! Deze module is gedownload. U hoeft hem alleen nog maar op uw PrestaShop-winkel te installeren. Hulp nodig? Bekijk onze tutorial: Een betaalde of gratis Addons-module installeren

Best seller
V1.6.0.V4 - 8.0.2
Van V1.6.0.4 tot V8.0.2

Overzicht

Monitor, optimize, repair, defragment and clean database tables. Increase the performance and speed of the web and fix DB errors. It keeps the database 100% optimized and without errors. Contains more advanced features.

Wat deze module u te bieden heeft

directions_car Verhoogt de snelheid van uw site
The Ultimate Database Optimizer for Prestashop module is a powerful tool designed to optimize, repair, clean, defragment the Database tables. It also contains advanced tools to perform actions such as compressing tables, changing file formats, changing tables, etc ...
 
Your store's database is a very delicate part of your business, where all its information is stored (product catalog, page content, customers, purchases, registrations, etc ...). Throughout the 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 appearing referential integrity errors. 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 errors that will affect both the user's browsing on the web and the purchase processes, registrations, etc. .

This translates into economic losses, loss of 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 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 in order to have the Database at full performance, 100% optimized and without any error or critical failure.

WHAT CAN THE ULTIMATE DATABASE OPTIMIZER MODULE DO?

The module performs the following actions on your Database:

  • OPERATION 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
  • DELETE DUPLICATE VALUES IN CONFIGURATION
  • DEFRAGMENT THE TABLES
  • CHANGE THE DATABASE PREFIX
  • CHANGE THE BOARD MOTOR
  • CHANGE THE FILE FORMAT OF THE TABLES
  • COMPRESS AND UNCOMPRESS THE TABLES
  • MONITOR THE STATUS OF THE DATABASE
  • DISPLAY NOTIFICATIONS ON SUGGESTIONS, WARNINGS AND RISKS IN THE DATABASE STATUS
  • SHOW ADVANCED INFORMATION OF THE DATABASE AND ITS COMPLETE STRUCTURE
  • CLEAR THE RECORDS FROM THE DYNAMIC TABLES
  • REMOVE ABANDONED SHOPPING CARTS
  • REMOVE SPECIFIC EXPIRED PRICES
  • ELIMINATE EXPIRED DISCOUNTS
  • DELETE THE CATALOG
  • DELETE DATA OF ORDERS, CUSTOMERS, ADDRESSES, ETC...
  • MAKING A BACKUP COPY OF THE DATABASE
  • RESTORATION OF BACKUP COPIES OF THE DATABASE
  • RECORD ALL ACTIONS CARRIED OUT FROM THE MODULE
  • PERIODIC MAINTENANCE OF THE DATABASE THROUGH SCHEDULED TASKS
  • BACKUP COPIES OF THE DATABASE THROUGH SCHEDULED TASKS
  • DISPLAY THE STATUS OF THE DATABASE THROUGH AUTOMATIC EMAIL SENDING

Another of the newest features is the integration of a complex algorithm to carry out constant monitoring tasks of the database, instantly warning of the status of the database, so that the user can know at all times what situation the database is in. database and be able to 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 "Optimization in one click" to be able to perform a complete optimization of the Database with just 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 the Database of your store fully optimized, repaired and at full capacity, considerably increasing the performance and speed of the web, speeding up to the maximum all the processes and queries that are carried out during the purchase operations and registration of customers in the store. You will increase SEO and avoid critical errors in the store.

A professional tool adapted for all levels of users!

Wat uw klanten zullen waarderen

Customers will enjoy a streamlined, fast and seamless store in their database. They will navigate with complete peace of mind, confidence and speed.

Installatie

Identical installation to any Prestashop module.

IMPORTANT: If you already have a version older than 3.0.0 of this module installed, you must uninstall and remove it completely before installing the latest version.

Anders

IMPORTANT

This module exhaustively checks the database by carrying out queries and processes that require a lot of resources from the server where the store is hosted. We have detected some problems during the execution of the processes of this module with clients who have hired shared hosting servers or with limited resources or not optimized for Prestashop due to exceeding the limits established by the hosting provider or due to an overuse of CPU / resources RAM due to poor server optimization.

Keep in mind that if the server where you have the store is not optimized and does not have good delivery of resources or has limitations in some parameters, you may experience problems with the execution of the module processes.

In that case, you have to contact the hosting provider to solve these incidents, because it is not a problem that comes from the module.

Our module works perfectly in our demo store that you can access to be able to test the module and check its operation before making the purchase.

In case of doubt you can consult us before making the purchase

Hulp nodig?

Deze ontwikkelaar antwoordt in deze talen:
es, en

Technische fiche

Laatste update

21.03.2023

Module talen

en, de, es, fr, it, pl, pt, ru +2

Compatibele PrestaShop versies

V1.6.0.4 - V8.0.2

Multi-shop compatibiliteit 

info

Module versie

V 3.1.2

Nummers van download

754

Niveau

Beginners

Documentatie

Included

Ontwikkelaar

Community developer

Ontwikkelaarstalen

es, en

Categorie

Website performantie

Functies

WHAT ULTIMATE DATABASE OPTIMIZER DOES...
 
CLEANING OF DYNAMIC TABLES
As time goes by, the databases store data in tables related to customer visits, statistics, connection data, etc ... Therefore, daily records are kept 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.
 
REMOVE ABANDONED SHOPPING CARTS
The table where the data of the shopping carts is stored, over time is usually filled with waste and records of abandoned shopping carts that are not important with the passage of time. Therefore, in order to eliminate them, this module has a useful tool. You can remove all abandoned carts or limit removal by dates.
 
ELIMINATION OF SPECIFIC PRICES
When we configure the sale prices for each of the products, sometimes we limit them with a date, so after that time, the record of the specific price for the product is invalidated and saved in the database as a residue. It is very important from time to time to clean these residues. With this module it is possible to do it, even by expiration date.
 
BACKUP COPIES OF THE DATABASE
The most important thing to save your store. With this module you have a section to manage the backup files of the database, make backup copies, restore them or download them in a compressed file to the computer. You have an option to automate the backup process through a CRON task and automatically each 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 to a group, a complete record of database activity, notification messages and warnings of the status of the database and sending the database backup file every time.
Ultimate Database Optimizer will keep you informed instantly of everything that is happening to your store's database.
 
ADVANCED TOOLS
Ultimate Database Optimizer is also a very powerful tool with advanced utilities to configure the database with options that are not available in any other software. The following utilities are available:

  • Database prefix change - Increasing security against external attacks.
  • Database Engine Switch - Choose between InnoDB and MyISAM, each with its own characteristics.
  • Database file format change - Choose between Barracuda and Antelope. Remarkably increasing performance.
  • Database table compression - Reduces size up to 70%! and increases performance.
  • Elimination of duplicate data in configuration tables.
  • Defragmentation of the tables.

All these advanced utilities are specially implemented to be able to increase the performance of the database, the security and the operating speed. This translates into a 100% secure, error-free and fast online store.


A FAST AND SECURE STORE INCREASES SEO BY IMPROVING WEB POSITIONING

 
REPAIR, OPTIMIZATION and DEFRAGMENTATION
The most common problems we face in the Prestashop MYSQL database is data loss, residuals in related tables, orphaned records and fragmented data. As a result, the database becomes unstable and errors and abnormal behaviors 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 in detail through a notifications and alerts viewer. You will know at all times how the database is, and if there is a problem, it informs 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 of your Prestashop database.
 
IMPROVED GRAPHIC INTERFACE
It has a totally IMPROVED and OPTIMIZED graphical Interface so that you can navigate between the module options in the easiest and most intuitive way. It shows an information panel with all the relevant data of the database (version, table engine, total number of tables, size of the database, etc ...), and a status bar indicating the percentage of optimization .
 
ONE-CLICK OPTIMIZATION
It has a button with full optimization function at the touch of a button. So you don't have to worry about anything. Ultimate Database Optimizer will do everything for you and will leave your database 100% optimized by taking the appropriate and necessary actions in each case.

PRESS THE BUTTON AND LET ULTIMATE DATABASE OPTIMIZER DO IT ALL FOR YOU.
 
SCHEDULED TASKS
This is one of the most outstanding features of this module. We know that a user cannot be constantly aware of the status of their database, for that reason this module implements the scheduled task function so that all actions can be performed 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
  • Pivot Tables Cleanup
  • Elimination of abandoned carts
  • Elimination of specific overdue prices
  • Elimination of expired discounts
  • Emails with notifications and warnings of the status of the database
  • Emails with the database backup
  • Deleting backup copies from the repository.
 
ACTIVITY REGISTER
A complete record of all module activity on the database is available. You will have information on each of the actions taken in the database, so that you can know exactly, knowing the trace that each action taken has left.

SOME COMMON PROBLEMS AND ERRORS THAT THIS MODULE REPAIRS
  • Fixes the error of showing price 0 in the list of products when the product has combinations.
  • Fixes the error that some orders disappear in the "Orders" table of the back-office orders section.
  • Fixes the error of the action "Order again" that shows the empty cart to proceed with the purchase.
  • Fixes speed problems in the Back-office and Front-Office related to the status of the Database.
  • Fixes problems of duplicate and erroneous values ​​in the Back-office configuration
 
COMPATIBLE WITH PRESTASHOP 1.6 AND 1.7
MULTISTORE COMPATIBLE

Aanbeveling

This module is designed to work correctly on 99% of the servers on the market. However, to avoid malfunctions or conflicts, it is strongly recommended to have the following server requirements and parameter settings:
 
MINIMUM REQUIREMENTS

  • PHP version 5.6.0
  • Memory limit (memory_limit) 512M
  • Maximum input time (max_input_time) 300 seconds
  • Database connection time (connect_timeout) 10 seconds
  • Maximum allowed database packet (max_allowed_packet) 64MB
  • Maximum execution time (max_execution_time) 300 seconds
  • Database user privileges SELECT - INSERT - UPDATE - DELETE - DROP - CREATE - ALTER
 
RECOMMENDED REQUIREMENTS

  • PHP version 7.1 in Prestashop 1.6 - 7.2 in Prestashop 1.7
  • Memory limit (memory_limit) 2G or higher
  • Maximum input time (max_input_time) 600 seconds or higher
  • Database connection time (connect_timeout) 10 seconds or higher
  • Maximum allowed database packet (max_allowed_packet) 128MB or higher
  • Maximum execution time (max_execution_time) 2000 seconds or higher
  • Database user privileges SUPER

Check with your hosting provider to be able to configure the server with the requirements that are needed for the module to work correctly.

IMPORTANT: 
- In order to take advantage of all the functionalities and tools of this module, the Database user must have SUPER privileges, otherwise some functionalities will be disabled.
- Depends on the number of tables in database, the module, for security reasons, calculates the minimum value in max_execution_time in order to allow use it. 300 seconds is the minimum value for Prestashop default database tables. The more tables the database has, the higher the value of this parameter should be.

Wat is er nieuw in versie 3.1.2(21.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.

Ondersteuning en updates

Op het moment van aankoop wordt uw Business Care abonnement van uw eerste jaar automatisch opgenomen en vervolgens stilzwijgend verlengd aan het einde van de periode.

U kunt uw abonnement op elk moment opzeggen voor het einde van de lopende periode.

Diensten inbegrepen in uw abonnement:

  • Beveiligingsupdates
  • Compatibiliteitsupdates
  • Evoluties en toekomstige functies
  • Onbeperkte ondersteuning

Wilt u meer details? Bekijk de meest gestelde vragen over Business CareBusiness Care.


Hulp nodig?

Deze ontwikkelaar antwoordt in deze talen:
es, en
Chat