OllieJones

WooCommerce’s Order and Subscription pages allow store owners to search for orders and subscriptions by customer name, email, and other attributes. By default, it does a general substring search. For example, if you put OllieJones into the search box, it will search with <code>LIKE '%OllieJones%'</code> using the leading wildcard <code>%</code>. That’s astonishingly slow on sites with many orders.
Upon activation this plugin uses ActionScheduler to run a background process to create a special-purpose index table, a table of trigrams, to speed up that search. Then it uses those trigrams to search for orders.
The downside: the trigram table takes database space and takes time to generate.
The orders page itself contains a slow query to look up meta_keys. This fixes that query’s performance too, using a cache of available values.
<h4>If you have problems</h4>
The WordPress and WooCommerce ecosystems offer many optional features enabled by plugins. And, WooCommerce sites run on many different versions of database server. It is not possible to test this plugin on every imaginable combination. So, you may have problems getting it to work.
Sometimes the process of creating the index table does not complete correctly. And, sometimes you cannot find some orders after the index is created.
If you tell the author about these problems, he will attempt to fix them. Please create a support topic, then visit Site Health, view the Info tab, click the Copy Site Info to Clipboard button, and paste that information into the support topic. And, of course, please describe what is going wrong.
<h4>Credits</h4>
Thanks to Leho Kraav for bringing this problem to my attention.
Thanks to Sebastian Sommer and Maxime Michaud for using early versions of the plugin on large stores, and to Maxime Michaud for creating the transation into French.
Thanks to Jetbrains for the use of their software development tools, especially <a href="https://www.jetbrains.com/phpstorm/" rel="nofollow ugc">PhpStorm</a>. It’s hard to imagine how a plugin like this one could be developed without PhpStorm’s tools for exploring epic code bases like WordPress’s.
<h4>How can I learn more about making my WordPress site more efficient?</h4>
We offer several plugins to help with your site’s database efficiency. You can <a href="https://www.plumislandmedia.net/wordpress/performance/optimizing-wordpress-database-servers/" rel="nofollow ugc">read about them here</a>.

Fast Woo Order Lookup


this is, by far, the "must have" plugin for big shops, pair this with HPOS and you search in 300k+ orders in less than 1 second! (with 100 order listing!).very great work, this should be merged in core!


holy grail of shop managers

Searches for orders faster on WooCommerce stores with many orders.

Verifone e-commerce

This module adds a Up2pay e-Transactions Payment Gateway to your Installation of WooCommerce.
Up2pay e-Transactions is a Payment Services Provider in Europe, part of the Crédit Agricole Bank.
plugin actions in wordpress:
this plugin offers an admin panel from the order section to the settings of Woocommerce. 
it adds payment information to the orders details and changes the status of orders (upon reception of an IPN, see below.) and adds payment means on the checkout page.
This plugin takes information from the order and creates a form containing the details of the payment to be made, including parameters configured in the admin panel of the module that identify the mechant.
The plugin checks for availability of the Up2pay e-Transactions platform, through a call to our servers. 
It then submits with javascript the form to the first available server.
the customer is then presented with a payment page, hosted on the Up2pay e-Transactions Platform (urls above).
The Up2pay e-Transactions Platform sends an Instant Payment Notification (IPN) to the server when the customer actually made the payment, indicating to the merchant the status of the payment.
the plugin generates a url that can catch the IPN call from Up2pay e-Transactions’s server, filtering incoming calls to the Up2pay e-Transactions IP address.
if payment is successfull, then the plugin validates the order though woocommerce.

Up2pay e-Transactions WooCommerce Payment Gateway

I won't change my rating till this plugin won't be up to date with the latest version of PHP, we are stuck with an old PHP version because if this plugin !

Update your PHP compatibility


Non pris en charge par Wordpress 6.2.2 chez moi. Le checkout échoue avec une erreur fatale. Du coup remplacement en urgence. 


Last update raises fatal error on checkout

This plugin is a Up2pay e-Transactions payment gateway for WooCommerce 4.x

Fast Woo Order Lookup vs Up2pay e-Transactions WooCommerce Payment Gateway