WooCommerce database cleanup

A leaner database.
A faster store.

Clean orders, HPOS tables, Action Scheduler backlog, and orphaned metadata. Every risky operation gets a backup first, so you can undo in one click.

  • WordPress 6.0+ · PHP 8.0+ · WooCommerce 7.0+
  • Free plan includes real cleanups, not just a report

Health Score

Database health at a glance

Fair
62
Autoload weight-12
Action Scheduler-8
Transients-5

847MB

Database size

1.2M

Scheduler rows

312MB

Recoverable

When did your store get this slow?

WooCommerce databases grow quietly. Transients pile up, scheduler logs balloon, and generic cleaners never touch the tables that matter.

Slow queries & checkout

Expired transients, orphaned metadata, and bloated tables make every page load and checkout step slower.

Bloated database

Action Scheduler logs reach millions of rows. Old orders, abandoned carts, and post revisions inflate your database size.

Generic cleaners miss WooCommerce

Most plugins only clean transients and revisions. They ignore WooCommerce-specific bloat like HPOS orders and cart sessions.

Check, clean, schedule

Start with a full picture of your database, run targeted cleanups, then let PRO handle the rest on a schedule.

1

Check

Health Score, table sizes, autoload weight, fragmentation. You see what's costing you speed before deleting anything.

2

Clean

Run cleanups for transients, revisions, logs, Action Scheduler, and more. Each one reports rows removed and MB freed.

3

Schedule

With PRO, Autopilot runs daily, weekly, or monthly. Your database stays lean without you opening the plugin.

WooCommerce-first

Goes deeper than generic WordPress cleaners

Most tools stop at transients and revisions. This plugin targets the tables that actually bloat a WooCommerce store.

  • Action Scheduler Completed, failed, and cancelled tasks older than 30 days
  • Order Cleanup Trashed, cancelled, and failed orders with full cascade delete
  • HPOS-ready Works with legacy post-based orders and High-Performance Order Storage
  • Abandoned cart sessions Orphaned cart sessions older than 30 days

Order Cleanup (PRO)

Trashed Cancelled Failed
Older than 90 days

Dry-run preview

1,847 orders

~142 MB recoverable

Automatic backup before deletion · 1-click restore

Compare plans

Free vs PRO

Free shows the full picture and runs real cleanups. PRO adds automation, deep WooCommerce cleanup, and safety nets.

Free

Diagnose + manual cleanups

$0

  • Full Health Score & diagnostics
  • 5 Quick Clean types (manual)
  • Index Advisor (view only)
Best value

PRO

Automate + deep cleanup

$59/yr

  • Everything in Free
  • Autopilot + Order Cleanup (HPOS)
  • Backups, reports & priority support
Included Partial Limited in Free PRO only
Feature Free $0 PRO $59/yr
Diagnose
Health Score 0–100 score with factor breakdown
Database Overview Total size + pie chart of largest tables
Table Sizes & Fragmentation Per-table size, row count, fragmentation
Autoload Weight Risk level for options loaded on every request View Manage
Index Advisor Detects missing high-impact indexes View Apply
Manual clean
Quick Clean Transients, revisions, WC logs, spam, Action Scheduler
Rows removed & MB freed Every cleanup shows exact impact
Deep WooCommerce clean
Order Cleanup Flagship Trashed, cancelled & failed orders · HPOS + legacy · dry-run preview
Orphan Metadata & Cart Sessions Disconnected postmeta/termmeta + abandoned carts (>30 days)
Optimize Tables Defragment fragmented tables · recover disk space
Orphan Media Cleans orphaned attachment records. Files on disk stay safe.
Autoload Manager Find orphan autoload options from uninstalled plugins
Automate
Autopilot Daily, weekly, or monthly scheduled cleanups Manual
Weekly Report Health Score, size, fragmentation. Delivered by email or Slack.
Safety & support
Backups & 1-Click Restore Surgical snapshot before every destructive operation
Priority Support In-dashboard chat · email replies · notification badge
Install free Get PRO

All plans require WordPress 6.0+, PHP 8.0+, WooCommerce 7.0+. PRO payment via Stripe inside the plugin.

Safe on production stores

Batch processing, backups, and HPOS support built in from day one.

1-Click Restore

Automatic snapshot before every destructive operation. Undo with one click.

Never times out

Processes 500 rows at a time with throttling. Works on million-row databases.

HPOS Compatible

Detects and supports both legacy and High-Performance Order Storage modes.

Server-side security

Destructive SQL is cryptographically signed and verified before execution.

Autopilot (PRO)

Schedule Weekly
Next run Mon, Jun 16 · 3:00 AM
Last run Removed 24,891 rows · 89 MB freed
Transients Revisions Logs Scheduler Orphan meta

Hands-off maintenance

Set the schedule once

Autopilot runs your cleaners daily, weekly, or monthly. No manual passes needed to keep the database lean.

PRO also sends weekly health reports to email or Slack: score, size, fragmentation, autoload weight, and what's still cleanable.

One plan, one price

Install free. Upgrade when you want automation and deep cleanup.

Free

Full diagnostics + manual cleanups

$0

  • Health Score & diagnostics
  • Quick Clean (5 cleanup types)
  • Index Advisor (view only)
  • Table size diagnostics
Install free
Most popular

PRO

Automation + deep WooCommerce cleanup

$59/year

Pay via Stripe inside the plugin

  • Everything in Free
  • Autopilot scheduled cleanups
  • Order Cleanup (HPOS + legacy)
  • Backups & 1-click restore
  • Weekly reports & priority support
Get PRO · $59/yr

Support without leaving WordPress

PRO users get priority support through an in-dashboard chat. Send a message from your store and get a reply by email, plus a notification badge in WordPress admin.

Priority Support

DB Optimizer · PRO

Can I safely delete orders older than 6 months?

Yes. Run Order Cleanup with a dry-run preview first. Every row is backed up before deletion, and you can restore with one click.

Common questions

No. Destructive operations create an automatic backup first, and you can restore with one click. The plugin only removes safe, disposable data: expired transients, spam comments, and orders you explicitly choose to delete.

Yes. The plugin detects and supports both legacy post-based order storage and WooCommerce's High-Performance Order Storage (HPOS).

Yes. All operations process in batches of 500 rows with throttling. No 504 timeouts, even on databases with millions of rows.

We still recommend a full database backup before major cleanups. The plugin also creates surgical snapshots of every row it deletes (orders, media), stored securely with 1-click restore.

No. Orphan Media only removes orphaned database records. Your actual files on disk are preserved.

$59/year via Stripe, directly inside the plugin. No need to leave WordPress. Cancel anytime.

Start with a free cleanup

See your Health Score and recover space today. Upgrade to PRO when you're ready for automation.