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.

WP Zone

annaqq

BerryPress

<p><strong>Export the order details for each sale in your WooCommerce store. Simplify order fulfillment, generate accounting reports in a few clicks, and download into CSV format for readability and universal compatibility with Export Order Items.</strong></p>
<p>Export Order Items is simple to set up and works for generating order reports straight out of the box.</p>
<h3>Order Reporting Features And Benefits</h3>
<ul>
<li>Sort orders for pulling specific purchase details</li>
<li>Pull reports based on common range selectors or custom start and end date and time</li>
<li>Sort by order ID or Product ID in ascending or descending order</li>
<li>Filter by order status (Pending Payment, Processing, Completed, Cancelled, etc.)</li>
<li>18 data fields that can be included in the report</li>
<li>Export WooCommerce orders to CSV format</li>
</ul>
<h3>Here’s What You Get When You Upgrade To Pro</h3>
<ul>
<li>Save your export settings as a preset and reuse your reports</li>
<li>Conditional logic for setting what is included in your report</li>
<li>Generate order reports for specific user roles</li>
<li>Export all sales or sort by category, tag, product ID, and included field</li>
<li>Exclude or include free items, refunds, and shipping information</li>
<li>Set what shows on your reports including custom fields, order line item, and variation</li>
<li>Additional formats including CSV-ASCII, XLS, XLSX, HTML, and HTML Enhanced</li>
<li>Change field layout, titles, add rows, and set how decimals display</li>
<li>Advanced compatibility and debug controls<br />
<strong>Want more?</strong> – check out our add-ons for expansion plugins</li>
</ul>
<h3>Faster Easier Report Creation</h3>
<p>We wanted to make exporting WooCommerce orders a fast simple process so we streamlined the process with checkboxes, dropdowns, and toggles. Set your date range, choose how it should be sorted, pick what order status should be included, and set what fields you want to be added in your report.</p>
<p>⭐️⭐️⭐️⭐️⭐️</p>
<blockquote>
<p>“All I needed was a way to pull customer information along with product sales. And this plugin did exactly that right out of the box. Thanks!” <code>-</code> <a href="https://wordpress.org/support/users/fiberlyone/" rel="ugc">fiberlyone</a></p>
</blockquote>
<p>⭐️⭐️⭐️⭐️⭐️</p>
<blockquote>
<p>“The Export Order Items plugin has easy to use functions where you can select the categories you want to have in your report – awesome!” <code>-</code> <a href="https://wordpress.org/support/users/rist/" rel="ugc">rist</a></p>
</blockquote>
<h3>Export And Share Anywhere</h3>
<p>Customize your report with the toggle control settings, configure the formatting, and download your orders as a CSV spreadsheet. Email as an attachment, print it off for order fulfillment, or import it to your favorite spreadsheet software for analysis.</p>
<h3>Is The Pro Version Right For You?</h3>
<p>Over 95% of our users find the free version is perfect for their store. Upgrade to Pro if you need more targeted reporting, advanced options, other formats, and unlimited presets for saving all kinds of report layouts.</p>
<h3>Addons & Integrations</h3>
<p>Looking to automate your reports, share them on the frontend of your site, or create in-depth sales reports? We have more free and premium reporting tools for WooCommerce.</p>
<ul>
<li><a href="https://wordpress.org/plugins/product-sales-report-for-woocommerce/" rel="ugc">Ninjalytics</a> (Free and <a href="https://berrypress.com/product/woocommerce/ninjalytics/" rel="nofollow ugc">Pro</a> – create sales reports for your store</li>
<li><a href="https://berrypress.com/product/woocommerce/scheduled-email-reports/" rel="nofollow ugc">Scheduled Email Reports for WooCommerce</a> – plugin to automate report sending</li>
<li><a href="https://berrypress.com/product/woocommerce/frontend-reports-for-woocommerce/" rel="nofollow ugc">Frontend Reports for WooCommerce</a> – display reports on the frontend of your site</li>
<li><a href="https://berrypress.com/product/woocommerce/extra-product-options-addon/" rel="nofollow ugc">Extra Product Options Addon</a> – export fields from the <a href="https://codecanyon.net/item/woocommerce-extra-product-options/7908619" rel="nofollow ugc">WooCommerce Extra Product Options</a> plugin</li>
</ul>
<p>If you like this plugin, please consider leaving a comment or review.</p>
<p><a href="https://berrypress.com/" rel="nofollow ugc">BerryPress</a> has built a range of powerful plugins for WooCommerce and WordPress. Check out some of our favorites below — and don’t forget to leave a ⭐⭐⭐⭐⭐ review to help others in the community discover them!</p>
<ul>
<li><a href="https://wordpress.org/plugins/export-order-items-for-woocommerce/" rel="ugc">Export Order Items for WooCommerce</a> — Export detailed order data for every sale in your WooCommerce store. Simplify fulfillment, create accounting reports in just a few clicks, and download CSV files for easy sharing and compatibility.</li>
<li><a href="https://wordpress.org/plugins/image-upload-for-bbpress/" rel="ugc">Inline Image Upload for BBPress</a> — Add a TinyMCE WYSIWYG editor to BBPress forums and enable inline image uploads, so users can easily attach and display images within their posts.</li>
<li><a href="https://wordpress.org/plugins/photoberry-studio/" rel="ugc">PhotoBerry Studio</a> — Create beautiful, customizable product photo galleries directly in your WordPress dashboard.</li>
<li><a href="https://berrypress.com/product/woocommerce/automatic-product-categories/" rel="nofollow ugc">Automatic Product Categories</a> — Available as a free version and Pro. Automatically assign products to categories based on custom rules, saving you time and keeping your store organized.</li>
<li><a href="https://berrypress.com/product/woocommerce/live-carts/" rel="nofollow ugc">Live Carts</a> — Available as a free version and Pro. View and analyze live shopping carts in real time to understand user behavior and optimize conversions.</li>
<li><a href="https://wordpress.org/plugins/customer-address-change-notification-for-woocommerce/" rel="ugc">Customer Address Change Notification for WooCommerce</a> — Get instant notifications when customers update their shipping or billing address, helping you stay on top of changes and prevent delivery issues.</li>
</ul>
<p>To view BerryPress’s premium WordPress plugins and themes, visit our <a href="https://berrypress.com/shop/" rel="nofollow ugc">WordPress products catalog page</a>.</p>
<p>Enjoy!</p>


Export Order Items for WooCommerce

Quickly export and download your WooCommerce product orders as a CSV with product, line item, order, and customer data.

Fast Woo Order Lookup vs Export Order Items for WooCommerce