Lapsed Product

How to flag product repurchases after a 90-day gap in WooCommerce

Flag orders where a customer is re-buying a product after a long gap

Automatically badges orders where at least one product was last purchased by this customer more than 90 days ago, indicating a lapsed buyer who has returned and may benefit from a win-back experience.

Customer info
The problem

When a previously regular customer comes back after a long absence, it is a critical retention moment. Without flagging these orders, you miss the chance to acknowledge their return and re-engage them.

The solution

OrderBadger can flag orders where a customer is re-purchasing a specific product after a gap of more than 90 days.

Who this is for

Stores selling consumable or seasonal products where customers are expected to repurchase regularly - supplements, pet supplies, skincare, coffee, and similar.

At a glance
Checks per-product purchase recency Threshold: product last bought over 90 days ago Fires even if customer bought other items recently Badge: Lapsed Product (yellow, info)
People also search for
WooCommerce alert when customer re-buys a product after long gap how to detect lapsed product repurchases in WooCommerce flag customers returning to buy the same product after 90 days WooCommerce WooCommerce identify product-specific lapsed buyer retention moments

How it works

Checks each line item against the customer's per-product purchase history. If any product was last bought more than 90 days ago, the order is badged as a lapsed product repurchase. This highlights win-back moments you can act on.

Acknowledge the customer's return with a personalised note or discount code. Consider including a 'what's new' insert for the product or suggesting complementary items they may have missed.

Rule template

Plain English rule At least one specific product in this order was last purchased by this customer more than 90 days ago

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

Make it yours

Adjust thresholds
  • Shorten '90 days' to '60 days' if your products are consumables with a faster expected reorder cycle (e.g. skincare, coffee).
  • Extend '90 days' to '180 days' for durable or seasonal products where a 3-month gap is normal and not yet a lapse.
Add or remove conditions
  • Add 'and customer has 3 or more previous paid orders' to focus on loyal customers whose product-specific lapse is most worth addressing. …er was last purchased by this customer more than 90 days ago and customer has 3 or more previous paid orders
  • Add 'and the item has a discount of more than 10%' to narrow this to lapsed product buyers who came back because of a promotional offer. …er was last purchased by this customer more than 90 days ago and the item has a discount of more than 10%

Badge preview

Default: Lapsed Product

When this rule matches

Last Purchase 120 Days Ago
The Widget was last purchased 120 days ago, which exceeds the 90-day lapse threshold.
Last Purchase Over A Year
The Widget was last purchased 400 days ago, well over the 90-day threshold.

When this rule does not match

Last Purchase 30 Days
The most recent product purchase was only 30 days ago, well within the 90-day window.
Exactly 90 Days Boundary
The last purchase was exactly 90 days ago, which does not exceed the threshold (rule says 'more than 90 days').
Never Bought Null
The customer has never bought this product before so there is no previous purchase date - null does not meet the lapse condition.
Guest Checkout Null
Guest: yes
Guest orders have no purchase history, so days since last purchase is null and the lapse condition cannot be evaluated.

Good to know

  • The days-since calculation relies on WooCommerce order history. Imported or migrated orders may not have accurate dates.
  • Products the customer has never purchased before will have a null value and will not trigger this rule - use the first-time-buying-product rule for those.
  • Guest orders have no history and cannot trigger this rule.

Frequently asked questions

  • How is this different from the lapsed-customer-60-days rule?
    The lapsed-customer rule looks at when the customer last ordered anything. This rule checks when the customer last purchased a specific product, so it fires even if they have been buying other items regularly.
  • If a customer has never bought the product before, will it trigger?
    No. First-time product purchases have a null value for days since last purchase and will not trigger this rule. Use the first-time-buying-product rule for those.
  • Will imported or migrated orders affect the 90-day calculation?
    Only if the imported orders have accurate dates in WooCommerce. Orders with missing or incorrect dates may produce unreliable lapse calculations.
  • Does the rule fire if only one product in a multi-item order is lapsed?
    Yes. If at least one line item was last purchased more than 90 days ago, the entire order gets badged - even if other items were bought recently.

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