OrderArc › Guides

Should you delete old WooCommerce orders? Archive vs delete

Last reviewed 8 November 2026 · by Nicolás Alejandro Salinas

Delete only the orders that never became sales: failed, pending-payment and cancelled checkouts older than a few weeks. Keep every completed and refunded order for as long as your tax rules require, which is years, not months. If old completed orders are slowing the store, archive them instead of deleting them.

What deleting a completed order removes

What deleting does not fix

A smaller wp_posts or wc_orders table makes the admin faster, but the database file on disk does not shrink until the tables are optimized, and most of the size is in meta, items and notes, which go with the orders. Expect the admin to speed up and the backup size to drop; do not expect the storefront to change.

What is safe to delete

Order status Age Delete?
Failed, pending payment, checkout draft > 30 days Yes. They are abandoned checkouts, not sales.
Cancelled, never paid > 90 days Yes, unless your accounting references cancellations.
On hold any No. Someone may still pay.
Completed, processing, refunded any No. These are your sales records.

Before any bulk deletion: full database backup, then delete on staging first and check that reports, customer accounts and subscriptions still work.

Archiving: the middle ground

Archiving moves completed and cancelled orders older than a threshold out of the live tables into archive tables in the same database. The live screens see only recent orders and become fast; the archived orders remain searchable and can be restored one by one or all at once.

OrderArc does this. What it keeps intact, by design: WooCommerce Analytics (stats tables untouched), download permissions (customers keep downloading), the order number (reserved so a new order can never reuse it), and the customer's own view (archived orders appear as "Older orders" in My Account, read-only). Every batch is copied, verified by count and checksum, and only then removed from the live tables; a mismatch rolls the batch back.

Tested on a 100,000-order store: archive everything older than a year, restore all of it, compare 6 million rows: zero differences.

Install it from WordPress.org: OrderArc – Order Archive for WooCommerce.

OrderArc's Archived orders tab: a searchable list of 95,957 archived orders with date, status, customer, email and total, each with View and Restore buttons
Archived orders stay searchable by number, email, name or phone, and any of them can be opened or restored.

A note on GDPR

"Delete old orders" and "erase personal data" are different obligations. GDPR asks you to erase personal data you no longer need; your tax law asks you to keep the sale. The usual answer is WooCommerce's own tool: Settings → Accounts & Privacy → Remove personal data from orders, which anonymises the customer fields and keeps the financial record. That works on live and archived orders alike.

Sources

More guides