OllieJones

<p>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.</p>
<p>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.</p>
<p>The downside: the trigram table takes database space and takes time to generate.</p>
<p>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.</p>
<h4>If you have problems</h4>
<p>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.</p>
<p>Sometimes the process of creating the index table does not complete correctly. And, sometimes you cannot find some orders after the index is created.</p>
<p>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.</p>
<h4>Credits</h4>
<p>Thanks to Leho Kraav for bringing this problem to my attention.</p>
<p>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.</p>
<p>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.</p>
<h4>How can I learn more about making my WordPress site more efficient?</h4>
<p>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>.</p>


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.

sidngr

<h4>Introduction</h4>
<p>Import Export for WooCommerce is an easy yet extremely useful plugin for both new and advanced users who want to Import / Export data into/from their website.<br />
The plugin facilitates:<br />
Products Import Export for WooCommerce<br />
Product Categories Import Export for WooCommerce<br />
Reviews Import Export for WooCommerce<br />
Orders Import Export for WooCommerce<br />
Coupons Import Export for WooCommerce<br />
Users Import Export for WooCommerce<br />
in just a single click.<br />
Recommended for its quality features like ease-of-use and reliability, this plugin also offers advanced features like filters, standard and custom field mapping, scheduling, log view/download, etc. to convert all these activities into a smooth experience.</p>
<h3>FEATURES</h3>
<h4>General</h4>
<p>🔸 Easy Installation and Detailed Documentation<br />
🔸 Easy to use interface<br />
🔸 AJAX Import/Export process<br />
🔸 Export data to CSV<br />
🔸 Import data from CSV<br />
🔸 Fully responsive and customizable<br />
🔸 Dedicated support</p>
<h4>Products Import Export</h4>
<p>🔸 Multiple Export Filters<br />
🔸 All product types supported<br />
🔸 Custom attributes supported<br />
🔸 Custom fields supported<br />
🔸 Multiple field mapping profiles available<br />
🔸 Multiple scheduling profiles available<br />
🔸 Schedule Import/Export (Automatic Import/Export)<br />
🔸 Import products by URL</p>
<h4>Product Categories Import Export</h4>
<p>🔸 Multiple Export Filters<br />
🔸 Custom fields supported<br />
🔸 Multiple field mapping profiles available<br />
🔸 Multiple scheduling profiles available<br />
🔸 Schedule Import/Export (Automatic Import/Export)<br />
🔸 Import categories by URL</p>
<h4>Product Reviews Import Export</h4>
<p>🔸 Multiple Export Filters<br />
🔸 Custom fields supported<br />
🔸 Multiple field mapping profiles available<br />
🔸 Multiple scheduling profiles available<br />
🔸 Schedule Import/Export (Automatic Import/Export)<br />
🔸 Import categories by URL</p>
<h4>Orders Import Export</h4>
<p>🔸 Multiple Export Filters<br />
🔸 All order statuses supported including custom status<br />
🔸 Custom attributes supported<br />
🔸 Custom fields supported<br />
🔸 Multiple field mapping profiles available<br />
🔸 Multiple scheduling profiles available<br />
🔸 Schedule Import/Export (Automatic Import/Export)<br />
🔸 Import orders by URL</p>
<h4>Users Import Export</h4>
<p>🔸 Multiple Export Filters<br />
🔸 All user roles supported including custom roles<br />
🔸 Custom capabilities supported<br />
🔸 Custom fields supported<br />
🔸 Multiple field mapping profiles available<br />
🔸 Multiple scheduling profiles available<br />
🔸 Schedule Import/Export (Automatic Import/Export)<br />
🔸 Import users by URL</p>
<h4>Coupons Import Export</h4>
<p>🔸 Multiple Export Filters<br />
🔸 Custom fields supported<br />
🔸 Multiple field mapping profiles available<br />
🔸 Multiple scheduling profiles available<br />
🔸 Schedule Import/Export (Automatic Import/Export)<br />
🔸 Import coupons by URL</p>
<h3>FREE FEATURES</h3>
<p>🔸 Products Export<br />
🔸 Products Import<br />
🔸 Product Categories Export<br />
🔸 Product Reviews Export<br />
🔸 Orders Export<br />
🔸 Users Export<br />
🔸 Coupons Export</p>
<h3>PREMIUM PLUGIN</h3>
<p>✅ Import Products, Product Categories, Product Reviews, Orders, Users & Coupons<br />
✅ Export Products, Product Categories, Product Reviews, Orders, Users & Coupons<br />
✅ Create Mapping Profiles for Import & Export process<br />
✅ Create Scheduling Profiles for Import & Export process<br />
✅ View logs for Import & Export<br />
✅ Manage settings of Import & Export process</p>
<p>Download the premium version of the plugin <a href="https://www.codeteam.in/product/woocommerce-import-export/" rel="nofollow ugc">here</a></p>
<h3>DOWNLOAD</h3>
<ul>
<li><a href="https://www.codeteam.in/wp-content/uploads/documentaion/woocommerce-import-export/sn-wie-sample-product-csv.csv" rel="nofollow ugc">Sample CSV of Products Export</a></li>
<li><a href="https://www.codeteam.in/wp-content/uploads/documentaion/woocommerce-import-export/sn-wie-sample-product-category-csv.csv" rel="nofollow ugc">Sample CSV of Product Categories Export</a></li>
<li><a href="https://www.codeteam.in/wp-content/uploads/documentaion/woocommerce-import-export/sn-wie-sample-product-review-csv.csv" rel="nofollow ugc">Sample CSV of Product Reviews Export</a></li>
<li><a href="https://www.codeteam.in/wp-content/uploads/documentaion/woocommerce-import-export/sn-wie-sample-order.csv.csv" rel="nofollow ugc">Sample CSV of Orders Export</a></li>
<li><a href="https://www.codeteam.in/wp-content/uploads/documentaion/woocommerce-import-export/sn-wie-sample-user-csv.csv" rel="nofollow ugc">Sample CSV of Users Export</a></li>
<li><a href="https://www.codeteam.in/wp-content/uploads/documentaion/woocommerce-import-export/sn-wie-sample-coupon-csv.csv" rel="nofollow ugc">Sample CSV of Coupons Export</a></li>
</ul>
<h3>DOCUMENTATION & DEMO</h3>
<p>View the documentation and demo of the plugin <a href="https://www.codeteam.in/documentation/woocommerce-import-export/introduction/" rel="nofollow ugc">here</a></p>


Import Export For WooCommerce

Import Export for WC is an easy yet extremely useful plugin for both new and advanced users who want to Import/Export data into/from their website.

Fast Woo Order Lookup vs Import Export For WooCommerce