Sign inDocsBlogAboutSupportContact
Use Case

How to find inactive users and lapsed customers in WordPress

Two commands surface every account that has gone quiet, and every customer who stopped buying, with their email and order history attached. No CSV exports, no SQL.

5 min read June 2026

The data is already in your database. Getting it out is the hard part.

Every WordPress site accumulates dead weight in its user table. Subscribers who signed up once and never came back. Customers who bought twice in 2023 and disappeared. Accounts that exist only because a checkout created them. The information to find them is sitting in wp_users, wp_usermeta, and your WooCommerce orders, but WordPress gives you no built-in way to ask "who hasn't done anything in 90 days?" or "which customers used to buy and stopped?"

The usual answers are a SQL query you have to write carefully, a reporting plugin that wants its own dashboard, or an export to a spreadsheet you then filter by hand. None of them are quick, and none of them let you act on what you find.

Two TrueCommander commands answer both questions from the navigator, and return the matching people with the details you actually need.

Step one: find users who have gone quiet

The find inactive users command lists accounts with no activity in the last N days. It reads the strongest available signal for each person: the last login TrueCommander recorded, their most recent published post, their most recent approved comment, and their registration date as a floor. One number, one command.

TrueCommander
Inactive users
No activity in 90+ days
42
Matches
customer
Role
90
Days idle
maria.k@example.comlast seen 134 days
devteam@example.comlast seen 118 days
j.nowak@example.comlast seen 97 days

Shown in advanced mode, the navigator's default, where commands start with tp. In easy mode you type the same command without the tp prefix.

A few flags shape the result:

  • -days=90 sets the inactivity window. Use 30 for newsletters, 180 for an annual cleanup.
  • -role=customer targets a single role. Drop it to scan every account.
  • -exclude_roles=administrator,editor keeps staff out of the results. Admins are excluded by default.

One honest caveat. Login tracking only counts logins that happened after TrueCommander was installed, because that is when the plugin started recording them. On a fresh install, lean on the other signals (posts, comments, registration date) for the first few weeks, then login data becomes the strongest indicator.

Step two: narrow to customers who stopped buying

"Inactive" and "stopped buying" are different questions. A customer can log in to check an old order and still never purchase again. For the purchase angle, filter user reads WooCommerce order history directly.

1
Customers who never ordered tp filter user -role=customer -no-orders finds accounts created at checkout or signup that never completed a purchase. Prime candidates for a first-order incentive.
2
Customers who lapsed tp filter user -last-order-days=120 returns everyone whose most recent order is more than 120 days old. These are the people a win-back message is built for.
3
Your best customers, going quiet tp filter user -spent-above=500 -last-order-days=90 surfaces high-value buyers who have slowed down. The most important list of all, and the one nobody usually has time to build.

Every row comes back with the customer's email, role, registration date, order count, and lifetime spend, so you can sort the signal from the noise without opening a single profile.

Step three: act on the list

Finding the people is most of the work. TrueCommander gives you a few honest ways to follow up, all from the same admin:

Tag a customer for later. assign user tag attaches a slug like win-back or vip to a specific account, so "everyone tagged win-back" becomes a single indexed lookup the next time you run a campaign.

Send a personal note. send template email delivers a branded message built in the Email Template Builder, with tags like {{first_name}} filled in for the recipient.

A point worth being straight about: tagging and emailing run per customer, one account at a time, not as a single bulk blast over the whole list. For a true mass campaign, the right move is to use these commands to build a clean, accurate segment, then export those addresses into the email platform you already send broadcasts from. TrueCommander's strength here is the part that is usually painful: getting an exact, current list of the right people in seconds.

Make it a standing report

Both commands can run on a schedule. Add find inactive users to Scheduled Commands once a month and the execution log keeps a running record of who has gone quiet, without you remembering to check. Turn a reactive scramble into a routine.

Every command used here

Ready?

Know exactly who to win back.

Both commands, and the email builder, are included with every TrueCommander license.

Cookies. The short version.

Essential cookies keep the cart and theme working. Analytics only fire if you say yes. Read our policy.