Knowledge Base › Review › Flag large single-SKU orders that may be trade or resale purchases
Bulk Order

How to flag bulk single-product orders for trade review in WooCommerce

Flag large single-SKU orders that may be trade or resale purchases

Badges orders where a single product is ordered in bulk with a high subtotal, helping you identify potential trade or resale customers who may need a trade invoice or wholesale pricing.

Review info
The problem

Large single-SKU orders with significant value are a strong signal of trade or resale purchasing. Without a visual flag, these orders are processed like regular consumer orders and you miss the opportunity to offer trade terms, request resale documentation, or route them through a B2B workflow.

The solution

OrderBadger can automatically flag large single-product bulk orders that may indicate trade or resale purchasing.

Who this is for

Stores that sell products commonly bought in bulk by trade customers - such as food, beauty, hardware, or craft supplies.

At a glance
Single product orders only Quantity threshold: more than 20 units Subtotal threshold: over £500 Routes to inbox for trade review Badge: Bulk Order (blue)
People also search for
detect wholesale single product orders WooCommerce flag high quantity single SKU purchases WooCommerce badge for potential resale orders identify trade buyers ordering one product in bulk large quantity single item order alert

How it works

Checks three conditions: the order must contain only one distinct product, the total quantity must exceed 20 units, and the subtotal must exceed £500. When all conditions are true, the order is badged and routed to your inbox.

Review the order to determine if the customer is buying for trade or resale. Consider offering trade pricing, requesting a resale certificate, or generating a trade invoice. If you have a B2B programme, this is an opportunity to enrol the customer.

Rule template

Plain English rule Order is single SKU and total quantity is more than £20 and subtotal is over £500

Write this (or something similar) in the OrderBadger rule builder. The AI compiler turns it into executable logic automatically.

Make it yours

Adjust thresholds
  • Lower 'more than £20' to 'more than £10' if your products are high-value and even 10 units signals a trade purchase.
  • Reduce 'over £500' to 'over £250' to catch mid-range bulk orders that still warrant a trade pricing conversation.
  • Raise 'over £500' to 'over £1000' if your products are inexpensive and only very large orders are genuinely wholesale.
Add or remove conditions
  • Add 'and customer has 0 previous paid orders' to focus specifically on first-time bulk buyers who are most likely to need trade onboarding. …nd total quantity is more than £20 and subtotal is over £500 and customer has 0 previous paid orders
  • Remove 'order is single SKU' to also catch multi-product bulk orders that still look like trade purchasing.

Badge preview

Default: Bulk Order

When this rule matches

Single Sku Bulk High Value
Order total: £1200.00
Order is a single SKU with 50 units and a subtotal of £1,200 - all three conditions are met.
Single Sku Boundary Values
Order total: £500.01
Order is a single SKU with 21 units and a subtotal of £500.01 - all conditions just barely met.

When this rule does not match

Multi Sku Bulk Order
Order total: £800.00
Order has 30 units and subtotal of £800, but contains multiple different products - not a single-SKU order.
Single Sku Low Quantity
Order total: £600.00
Order is a single SKU with subtotal of £600, but only 5 units - below the 20-unit threshold.
Single Sku Bulk Low Value
Order total: £100.00
Order is a single SKU with 25 units, but subtotal of £100 is below the £500 threshold.

Workflow

This rule includes workflow features that help your team act on flagged orders.

Inbox
Yes

Good to know

  • This uses the subtotal (before shipping and tax), not the order total. Adjust if your business logic requires the full total.
  • Product variations of the same parent product typically count as the same SKU. Verify your WooCommerce variation setup.
  • The 20-unit threshold may be too high or low for your product range. Edit the rule to match your definition of bulk.

Frequently asked questions

  • Why does this rule check subtotal instead of total?
    The subtotal represents the product value before shipping and tax, which is a better indicator of trade purchasing intent. Shipping costs vary and can inflate or deflate the total in ways unrelated to product volume.
  • If a customer orders 25 units of a product across two different sizes, is that a single SKU?
    It depends on how WooCommerce handles the variations. In most setups, different variations of the same parent product are treated as the same product, so the order would still be flagged as single-SKU.
  • Can I combine this with customer rules to only flag bulk orders from new customers?
    Yes. You could create a compound rule that adds a first-time customer condition. Alternatively, use this rule alongside the first-time-registered-buyer rule and look for orders with both badges.

Related rules

How to detect single-product reorders in WooCommerce How to flag bulk quantity orders in WooCommerce How to flag high-value orders for extra checks in WooCommerce

Try this rule in your store

OrderBadger is free on WordPress.org. Install it and create this rule in minutes - no code required.

Install OrderBadger Free