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.

Xfinitysoft

Set WooCommerce order limits with minimum and maximum quantities, cart totals, and role-based rules. Also, control product, category, and checkout order restrictions with ease.
<ul>
<li><a href="https://orderlimit.xfinitysoft.app/" title="Demo" rel="nofollow ugc">Try the Demo</a> </li>
<li><a href="https://woocommerce.com/document/order-limit/" title="Technical Documentation" rel="nofollow ugc">Technical Documentation</a></li>
<li>👉 <a href="https://woocommerce.com/products/order-limit/" title="Check out the Premium Version" rel="nofollow ugc">Check out the Premium Version</a></li>
<li><a href="https://www.facebook.com/xfinitysoft" rel="nofollow ugc">Facebook Page</a></li>
</ul>
<iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/p-rgKRYiXgE?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe>
If you run a WooCommerce store, controlling how much customers can order is crucial for managing stock, avoiding overordering, and boosting sales. <a href="https://woocommerce.com/products/order-limit/" title="Check out the Premium Version" rel="nofollow ugc">Order Limit for WooCommerce</a> gives you powerful tools to set minimum and maximum order amounts, product quantity limits, and cart restrictions without complex setups.
Whether you need to restrict checkout in WooCommerce based on order value, create user role-based order limits for wholesalers, or simply enforce a minimum purchase in WooCommerce, this plugin helps you handle it all.
From product-level rules to cart validation, category-based order limits, and payment gateway restrictions, this plugin is built for store owners who want smarter control over how orders are placed.
Isn’t that amazing? Wait until you see its features 😃👇
<h3>Powerful Features of Order Limit for WooCommerce</h3>
Here’s what you get with this WooCommerce min and max order restriction plugin:
<h4>🛒 Product & Category Order Limit Features</h4>
<ul>
<li>Product Purchase Limit Control: Set minimum and maximum order quantities or amounts for individual products.</li>
<li>Variation-Specific Purchase Restrictions (Pro): Apply unique minimum and maximum order limits to each variation of a variable product.</li>
<li>Aggregate Product Rule Combinations: Combine restrictions across selected products for cumulative purchase control.</li>
<li>Category-Based Order Limits: Define minimum and maximum purchase restrictions across entire product categories.</li>
<li>Aggregate Category Rules: Apply combined restrictions across multiple categories by quantity or value.</li>
<li>Exclude Specific Products (Pro): Exempt items like gift cards, subscriptions, or promos — or even assign them their own special purchase cap.</li>
<li>Exclude Specific Products from Rules (Pro): Exempt items like gift cards, subscriptions, or promotional products from restrictions.</li>
</ul>
<h4>👥 Customer & User Role Order Restrictions</h4>
<ul>
<li>User Role-Based Order Rules (Pro): Create tailored restrictions for wholesalers, retailers, logged-in users, or guest shoppers.</li>
<li>Customer-Specific Purchase Limits (Pro): Assign unique order rules to specific customers for tighter control.</li>
<li>Guest-Only Restrictions (Pro): Apply special purchase limits for guest checkouts.</li>
<li>User Purchase History Limits (Pro): Restrict new orders based on a customer’s past WooCommerce purchases.</li>
<li>Storewide Purchase History Control (Pro): Track combined sales across all customers to set total store limits.</li>
<li>Real-Time Order Validation (Pro): Instantly verify past orders before allowing checkout.</li>
<li>Wholesale Order Flexibility (Pro): Set relaxed order limits for wholesale buyers while applying stricter rules for retail shoppers.</li>
<li>Order Status Control (Pro): Choose which order statuses (e.g., Completed, Processing) count toward purchase history limits.</li>
</ul>
<h4>🛍️ Cart & Checkout Restriction Features</h4>
<ul>
<li>Cart Total Restrictions: Enforce minimum and maximum cart totals (items or amount) before checkout.</li>
<li>Cart Quantity Restrictions: Apply minimum and maximum product quantity rules directly at the cart level.</li>
<li>Hide Checkout Button: Prevent checkout until cart or order rules are met.</li>
<li>Payment Gateway Restrictions (Pro): Apply purchase restriction rules for specific payment methods such as PayPal, Bank Transfer, or COD.</li>
<li>Exclude Shipping Costs (Pro): Ensure order limits are based only on products, not shipping fees.</li>
</ul>
<h4>⏳ Time-Based & Storewide Order Rules</h4>
<ul>
<li>Time-Based Reset Rules: Reset order limits daily, weekly, monthly, yearly, or on custom intervals.</li>
<li>Precise Reset Options: Choose to reset at midnight or from the customer’s last purchase time.</li>
<li>Global Order Count Limits (Pro): Limit the total number of orders storewide on flexible schedules.</li>
<li>Global Order Value Caps (Pro): Restrict the total revenue across your store over a set period.</li>
<li>Store Closure Mode (Pro): Pause all new orders instantly with a one-click storewide block.</li>
</ul>
<h4>💬 Messaging, Alerts & Shortcodes (Free + Pro)</h4>
<ul>
<li>Custom Limit Messages: Display personalized warning or error messages to customers when limits are exceeded.</li>
<li>Dynamic Message Placeholder Support: Use placeholders such as {store-name}, {max-order-limit}, or {remaining} to make messages clear and dynamic.</li>
<li>Advanced Notices (Pro): Customize messages for specific cases — parent products, accumulative rules, or returning customers.</li>
<li>Dynamic Quantity Alerts: Show real-time notifications on how many items a customer can still purchase.</li>
<li>Shortcodes for Rules & Limits: Display order rules anywhere on your store using simple shortcodes.</li>
<li>Remaining Limit Shortcodes: Show remaining product or order allowance with shortcodes like [wc-order-limit-remaining].</li>
</ul>
<h4>🌐 Multi-Vendor Marketplace Compatibility</h4>
<ul>
<li>Compatibility with WC Vendors Pro (Pro): Admin can set vendor-specific order limits. Let vendors set their own order limits, share control with admins, or apply global restrictions across vendors.</li>
</ul>
<h3>Compatible with WC Vendors Pro</h3>
Our plugin works seamlessly with <a href="https://wordpress.org/plugins/wc-vendors/" title="WC Vendors Plugin" rel="ugc">WC Vendors</a> , giving marketplace admins and vendors full flexibility over order restrictions:
<ul>
<li>Per-Vendor Order Limits: The admin can set individual minimum and maximum limits for each vendor’s products.</li>
<li>Admin Control Sharing: The admin can grant vendors permission to adjust their own order restriction settings.</li>
<li>Vendor Self-Management: Vendors with access can create or update their own WooCommerce order limits without relying on the site admin.</li>
</ul>
This makes it the perfect solution for multi-vendor stores that need product quantity limits, cart restrictions, or checkout rules tailored to each vendor.
<h3>🆚 Free vs Pro Features of Order Limit for WooCommerce</h3>
<h4>Free Version</h4>
✔ Set min/max order quantities or amounts per product (simple products) 
✔ Set min/max purchase restrictions per category 
✔ Combine product or category limits for cumulative control 
✔ Min/max cart totals (by items or amount) 
✔ Min/max cart quantities 
✔ Hide checkout button until limits are met 
✔ Reset order limits daily, weekly, monthly, yearly, or custom 
✔ Customizable limit messages, dynamic placeholders, real-time quantity alerts 
✔ Display rules and remaining limits anywhere on your store 
✔ Create, edit, bulk-manage, enable/disable rules
<h4>Pro Version</h4>
✅ Set min/max order quantities or amounts per product (simple products) + variation-level rules, dependent parent rules, purchase history rules, user targeting, payment method restrictions, time spans, custom notices 
✅ Set min/max purchase restrictions per category + cumulative across multiple categories, dependent parent rules, purchase history rules, user targeting, payment method restrictions, time spans, custom notices 
✅ More advanced accumulative control with custom notices and dependencies 
✅ Exclude specific products (e.g. gift cards, promos) and optionally set custom max limits for them 
✅ Create rules for specific customers, guest users, or user roles with min/max order count or amount 
✅ Apply rules per user role (wholesale, retail, guest, logged-in) 
✅ Assign unique restrictions to selected customers 
✅ Restrict based on past orders (current user or all users) 
✅ Choose which order statuses count toward history-based rules 
✅ Min/max cart totals (by items or amount) + per-category cart total restrictions, exclude shipping cost from limits 
✅ Min/max cart quantities 
✅ Hide checkout button until limits are met + block checkout per payment method 
✅ Restrict rules by payment gateway (PayPal, COD, Bank Transfer, etc.) 
✅ Reset order limits daily, weekly, monthly, yearly, or custom + more precision: reset at midnight or purchase time, custom day of week/month 
✅ Storewide daily/weekly/monthly caps on total order count or value, plus store closure mode 
✅ Customizable limit messages, dynamic placeholders, real-time quantity alerts + advanced notices for parent/child rules, purchase history rules, accumulative rules, and role/customer-specific rules 
✅ Display rules and remaining limits anywhere on your store + more shortcode variants (product, category, customer, cart, storewide) 
✅ WC Vendors Pro support (vendor-specific rules, admin control, shared restrictions) 
✅ Create, edit, bulk-manage, enable/disable rules + adds more rule types & conditions
<h3>WooCommerce Order Restriction is Ideal for Store Owners Who Want To:</h3>
<ul>
<li>Set WooCommerce Minimum Order Amounts: Require customers to spend a specific amount before checkout, helping increase average order value.</li>
<li>Apply WooCommerce Maximum Order Quantity Rules: Stop customers from purchasing more than a set number of items, preventing stockouts and abuse during sales.</li>
<li>Create Min/Max Order Rules Per Product or Category: Control purchase quantities at both product and category levels with flexible settings.</li>
<li>Restrict Checkout Based on Cart Value: Block checkout if the cart total doesn’t meet your defined minimum or maximum threshold.</li>
<li>Manage Wholesale and Retail Orders Differently: Apply user role-based order limits so wholesalers can place bulk orders while retail customers face stricter rules.</li>
<li>Limit Discounted or Promotional Items: Control how many sale products or coupon-based items a single customer can purchase.</li>
<li>Use Time-Based Order Rules: Automatically reset purchase limits daily, weekly, or monthly, perfect for seasonal or recurring promotions.</li>
<li>Control Orders by Payment Method: Apply order restrictions to specific payment gateways like COD, PayPal, or bank transfers.</li>
<li>Enforce Cart Limits at Checkout: Define cart-level restrictions that encourage larger purchases or stop oversized orders.</li>
<li>Automate Inventory Control: Reduce manual oversight with rules that handle stock protection, order caps, and purchase limitations automatically.</li>
</ul>
<h3>Use Cases of This WooCommerce Order Restriction Plugin</h3>
Order Limit for WooCommerce isn’t just another min/max plugin—it’s built to solve real problems for different types of online stores. Here are some of the most popular use cases:
<ul>
<li>Retail Stores: Apply a WooCommerce minimum order amount to encourage larger carts, or set maximum order quantities on hot products to prevent hoarding during promotions.</li>
<li>Wholesale Businesses: Use role-based order rules to require higher minimum purchases for B2B buyers while keeping retail customers unrestricted.</li>
<li>Food & Beverage Shops: Add daily order limits on perishable goods like bread, cakes, or meals to match production capacity.</li>
<li>Event Planners & Ticketing: Restrict the maximum number of tickets or event merchandise a customer can buy to avoid scalping.</li>
<li>Handmade & Custom Products: Set WooCommerce purchase restrictions to control order quantities on items with limited production time.</li>
<li>Seasonal or Holiday Sales: Use time-based order rules to spread inventory across a holiday season and stop buyers from clearing out your stock.</li>
<li>Subscription Services: Limit the number of items per subscriber each week or month, keeping order volume aligned with delivery capacity.</li>
<li>Promotional Campaigns: Restrict discounted items or coupon-based purchases with WooCommerce product quantity limits to maintain fair distribution.</li>
<li>Over-Ordering Prevention: Stop bulk or excessive purchases during promotions or when stock is low.</li>
<li>Inventory Workflow Automation: Automate minimum and maximum purchase rules to reduce manual oversight.</li>
<li>High-Demand or Limited Stock Items: Enforce WooCommerce cart limits to prevent overselling when supply is low.</li>
<li>Payment-Based Order Control: Apply restrictions when customers choose certain gateways like COD, PayPal, or Bank Transfer.</li>
</ul>
<h3>Customer Support and Technical Documentation</h3>
We provide 24/7 customer support to help you set up and customize your WooCommerce order rules. Our detailed <a href="https://woocommerce.com/document/order-limit/" title="Documentation" rel="nofollow ugc">technical documentation</a> covers everything from creating product-level restrictions to configuring cart limits and checkout restrictions.
Still Need Help?
<a href="https://woocommerce.com/my-account/contact-support/?select=order-limit#contact-us" title="Get Support" rel="nofollow ugc">Reach out anytime</a>, and our support team will get you up and running quickly.

Order Limit for WooCommerce – Set Order Restrictions, Min and Max Amount/Quantity, Cart Control, and Checkout Restrictions

Set WooCommerce order limits with ease. Control min/max quantities, cart totals, category rules, user role restrictions, and checkout limit.

Fast Woo Order Lookup vs Order Limit for WooCommerce – Set Order Restrictions, Min and Max Amount/Quantity, Cart Control, and Checkout Restrictions