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.

Wecomm Solutions

Official AliExpress Plugin for WooCommerce, publish any products you have in your WooCommerce store on AliExpress.
AliExpress is an online retailer based in China, owned by the Alibaba group, one of the best online markets in the world.
Located in USA, Russia, Spain, Italy, among others. It offers stores for companies and individuals to sell their products on its own platform.
AliExpress WooCommerce is the official plugin for WooCommerce. This plugin allows sellers to synchronize their product catalog, does not matter if they are simple or variable products. You will be able to sell your products easily with a single click, and synchronize AliExpress categories with your WooCommerce categories.
When receiving an order through AliExpress, this plugin will download this order into WooCommerce and you will be able to manage your shipment, assigning a tracking number to the order so that it is notified to AliExpress.
You previously must have a seller account on AliExpress, <a href="https://login.aliexpress.com/join/seller/unifiedJoin.htm?_regbizsource=ES_Woo_Wecomm" rel="nofollow ugc">click here to create an account</a>
<a href="https://wecomm.es/en/documentation" rel="nofollow ugc">Online Documentation</a>
Characteristics
<ul>
<li>Product Synchronization.</li>
<li>AliExpress Categories Synchronization.</li>
<li>Attribute Synchronization.</li>
<li>Characteristics Synchronization.</li>
<li>Order Synchronization.</li>
</ul>
Product Functions
<ul>
<li>Product Title</li>
<li>Description</li>
<li>SKU</li>
<li>Stock</li>
<li>Category</li>
<li>Price</li>
<li>Variations</li>
<li>Characteristics</li>
<li>Images</li>
<li>Images of Variations</li>
<li>Weight</li>
<li>Dimensions</li>
</ul>
Order Functions
Synchronize all orders automatically from AliExpress in your WooCommerce, manage the shipping process directly from WooCommerce, when shipping the product, mark the order as ‘Finished’ and enter the tracking number so that AliExpress notifies the customer.
Categories
AliExpress WooCommerce allows you to synchronize AliExpress categories with the local WooCommerce categories, and easily set a percentage added to the total of product when sending to AliExpress.  
You will be able to set the default measurements and weight of the entire category, avoiding modifying the required parameters product by product.
Attributes
The attributes allow to create variations of the products, different colors, etc… This is also synchronized with the product and with the AliExpress Attributes, also allows to select an alias to rename the attributes of AliExpress.
Characteristics
Just as attributes are used to create variations in WooCommerce, they also allow you to define the product with its characteristics. For instance the finish or the material which the product is made. This is very important because AliExpress uses this data to position the product when the customer is looking for something concrete.
<h3>Support</h3>
When your support license and upgrades are active you can request support for any problem the plugin may causes or doubt you may have. 
Problems or doubts external to the plugin are not included. <a href="https://wecomm.es/en/documentation" rel="nofollow ugc">click here for more information</a>

AliExpress for WooCommerce

Va muy bien, hay algunas cosas que mejorar pero lo normal para la primera versión, mucho animo! A vender en AliExpress!

Super util!!

El plugin me daba un error y creé un ticket en soporte.

Después de varios días sin obtener respuesta me comunico con su WhatsApp.

Me preguntan qué ticket és y les respondo.

Nunca más me contestaron...

Iba a pagar por la suscripción pero ahora lo descarto totalmente.




Horrible

Official AliExpress Plugin for WooCommerce, publish any products you have in your WooCommerce store on AliExpress.

Fast Woo Order Lookup vs AliExpress for WooCommerce