Project Order

How to detect renovation project orders in WooCommerce

Flag large multi-category orders that suggest a renovation or project

Badges large orders spanning 4 or more categories with more than 6 distinct products and a subtotal over £500, identifying likely renovation or project orders that may benefit from dedicated support.

Review info
The problem

Large multi-category orders often indicate a customer undertaking a home renovation or project. These orders have complex fulfilment needs and high customer expectations. Without a flag, they receive the same treatment as routine orders and the opportunity for concierge-level support is missed.

The solution

OrderBadger can automatically flag large multi-category orders that suggest a renovation or project.

Who this is for

Home improvement, furniture, interior design, and general merchandise stores where large cross-category orders suggest a project customer who would value dedicated support.

At a glance
Requires 4+ product categories More than 6 distinct products Subtotal threshold: over £500 Routes to inbox for dedicated support Badge: Project Order (blue, info)
People also search for
WooCommerce flag large multi-category orders as project orders how to identify home renovation orders in WooCommerce detect project-size orders spanning many categories WooCommerce WooCommerce offer concierge support for big project purchases flag complex multi-department orders WooCommerce

How it works

Combines three conditions: the order must span 4 or more product categories, contain more than 6 distinct products, and have a subtotal exceeding £500. When all three are true, the order is badged as a project order and appears in your inbox for review.

Assign a dedicated team member to oversee the order. Proactively contact the customer to confirm requirements, offer delivery coordination, and suggest any missing items. Consider offering a project discount for large orders.

Rule template

Plain English rule Order spans 4 or more categories and distinct product count is over £6 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 '4 or more categories' to '3 or more categories' if your store has fewer top-level categories and projects spread across three is already significant.
  • Reduce 'over £6' distinct products to 'over £4' to catch smaller renovation orders that still deserve dedicated attention.
  • Raise 'over £500' to 'over £750' if £500 orders are routine in your store and you only want to flag the largest projects.
Add or remove conditions
  • Add 'and customer has 0 previous paid orders' to focus on first-time project buyers who may need extra onboarding support. … distinct product count is over £6 and subtotal is over £500 and customer has 0 previous paid orders
  • Add 'and total order weight is over 10 kg' to narrow this to large and heavy project orders that also need special shipping arrangements. … distinct product count is over £6 and subtotal is over £500 and total order weight is over 10 kg

Badge preview

Default: Project Order

When this rule matches

Large Renovation Order
Order spans 5 categories, has 8 distinct products, and subtotal is £750. All three conditions exceeded.
Boundary 4 Categories 7 Products
Order spans exactly 4 categories, has 7 distinct products, and subtotal is £520. All three boundary conditions met.

When this rule does not match

Three Categories Below Threshold
Order has 7 distinct products and a subtotal of £600, but only spans 3 categories - below the 4-category threshold.
Few Products High Value
Order spans 4 categories and subtotal is £800, but only has 5 distinct products - below the 6-product threshold.
Many Products Low Subtotal
Order spans 4 categories and has 8 distinct products, but subtotal is only £300 - below the £500 threshold.

Workflow

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

Inbox
Yes

Good to know

  • Category count is based on the categories assigned to products in WooCommerce. Products with multiple categories may inflate the count.
  • The thresholds (4 categories, 6 products, £500) are fixed in the rule text. Edit the rule to adjust them for your store.
  • This is a heuristic - not all large multi-category orders are projects, and some projects may place multiple smaller orders.

Frequently asked questions

  • Does the subtotal include shipping and tax?
    No. The rule checks the subtotal, which is the product total before shipping and tax are added. This gives a clearer picture of the product value in the order.
  • If a product belongs to multiple categories, does each one count toward the 4-category threshold?
    Yes. Category count is based on all categories assigned to each product. A product tagged with both 'Lighting' and 'Smart Home' contributes two distinct categories.
  • Can I lower the thresholds for smaller stores?
    Yes. Edit the rule text to change the category count, product count, or subtotal thresholds. For example, change to 3 categories, 4 products, and £300 to match your typical project orders.
  • Why does this use subtotal instead of order total?
    Subtotal excludes shipping and tax, giving a more accurate measure of the product value. A large shipping fee on a small order should not inflate the order into project territory.

Related rules

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