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://wpzone.co/product/extra-product-options-addon-for-export-order-items-pro/" 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>
<li><a href="https://wpzone.co/product/scheduled-email-reports-for-woocommerce/" rel="nofollow ugc">Scheduled Email Reports for WooCommerce</a> – plugin to automate report sending</li>
<li><a href="https://wpzone.co/product/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://wordpress.org/plugins/product-sales-report-for-woocommerce/" rel="ugc">Product Sales Report for WooCommerce</a> (Free and <a href="https://wordpress.org/plugins/product-sales-report-for-woocommerce/" rel="ugc">Pro</a> – create sales reports for your store</li>
</ul>
<p>If you like this plugin, please consider leaving a comment or review.</p>
<h3>You may also like these plugins</h3>
<p><a href="https://wpzone.co/" rel="nofollow ugc">WP Zone</a> has built a bunch of plugins, add-ons, and themes. Check out other favorites here on the repository and don’t forget to leave a 5-star review to help others in the community decide.</p>
<ul>
<li><a href="https://wordpress.org/plugins/product-sales-report-for-woocommerce/" rel="ugc">Product Sales Report for WooCommerce</a> – setup a custom sales report for the products in your WooCommerce store with toggle sorting options. Including or excluding items based on date range, sale status, product category and id, define display order, choose what fields to include, and generate your report with a click.</li>
<li><a href="https://wordpress.org/plugins/replace-image/" rel="ugc">Replace Image</a> – keep the same URL when uploading to the WordPress media library</li>
<li><a href="https://wordpress.org/plugins/force-update-check-for-plugins-and-themes/" rel="ugc">Force Update Check for Plugins and Themes</a> -force Update Check for Plugins and Themes forces WordPress to run a theme and plugin update check whenever you visit the WordPress updates page</li>
<li><a href="https://wordpress.org/plugins/connect-sendgrid-for-emails/" rel="ugc">Connect SendGrid for Emails</a> –  connect SendGrid for Emails is a third-party fork of (and a drop-in replacement for) the official SendGrid plugin</li>
<li><a href="https://wordpress.org/plugins/custom-css-and-javascript/" rel="ugc">Custom CSS and JavaScript</a> – allows you to add custom site-wide CSS styles and JavaScript code to your WordPress site. Useful for overriding your theme’s styles and adding client-side functionality.</li>
<li><a href="https://wordpress.org/plugins/disable-user-registration-notification-emails/" rel="ugc">Disable User Registration Notification Emails</a> – when this plugin is activated, it disables the notification sent to the admin email when a new user account is registered.</li>
<li><a href="https://wordpress.org/plugins/image-upload-for-bbpress/" rel="ugc">Inline Image Upload for BBPress</a> – enables the TinyMCE WYSIWYG editor for BBPress forum topics and replies and adds a button to the editor’s “Insert/edit image” dialog that allows forum users to upload images from their computer and insert them inline into their posts.</li>
<li><a href="https://wordpress.org/plugins/password-strength-for-woocommerce/" rel="ugc">Password Strength for WooCommerce</a> – disables password strength enforcement in WooCommerce.</li>
<li><a href="https://wordpress.org/plugins/donations-for-woocommerce/" rel="ugc">Potent Donations for WooCommerce</a> – acceptance donations through your WooCommerce store</li>
<li><a href="https://wordpress.org/plugins/shortcodes-for-divi/" rel="ugc">Shortcodes for Divi</a> – allows to use Divi Library layouts as shortcodes everywhere where text comes.</li>
<li><a href="https://wordpress.org/plugins/stock-export-and-import-for-woocommerce/" rel="ugc">Stock Export and Import for WooCommerce</a> – generates reports on the stock status (in stock / out of stock) and quantity of individual WooCommerce products.</li>
<li><a href="https://wordpress.org/plugins/random-quiz-addon-for-lifterlms/" rel="ugc">Random Quiz Generator for LifterLMS</a> – pull a random set of questions from your quiz so users never get the same question twice when retaking or setting up a practice quiz.</li>
<li><a href="https://wordpress.org/plugins/wp-and-divi-icons/" rel="ugc">WP and Divi Icons</a> – adds over 660 custom outline SVG icons to your website. SVG icons are vector icons, so they are sharp and look good on any screen at any size.</li>
<li><a href="https://wordpress.org/plugins/wp-layouts/" rel="ugc">WP Layouts</a> – the best way to organize, import, and export your layouts, especially if you have multiple websites.</li>
<li><a href="https://wordpress.org/plugins/wp-squish/" rel="ugc">WP Squish</a> – reduce the amount of storage space consumed by your WordPress installation through the application of user-definable JPEG compression levels and image resolution limits to uploaded images.</li>
</ul>
<p>To view WP Zone’s premium WordPress plugins and themes, visit our <a href="https://wpzone.co/product/" 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