Order Archive Manager for WooCommerce

Description

Over time, WooCommerce orders pile up in your database. Every order adds rows to wp_posts, wp_postmeta, wp_comments, and several WooCommerce tables. On stores with tens of thousands of orders, this slows down admin pages, checkout queries, and report generation.

Order Archive Manager for WooCommerce moves completed, cancelled, or refunded orders out of the live tables and into dedicated archive tables. Your store gets faster, your order data stays safe, and you can restore any order back to WooCommerce whenever you need it.

How it works

Orders are copied to archive tables row by row inside database transactions. If anything goes wrong during the copy, the transaction rolls back — the original order is untouched. Only after a successful copy and verification does the plugin remove the order from the live tables.

Key features

• Safe Archiving – Moves orders to dedicated archive tables using database transactions
• One-Click Restore – Restores archived orders back to WooCommerce with original IDs preserved
• Permanent Deletion – Permanently deletes archived orders when you no longer need them
• Dry Run Mode – Preview exactly what will happen before making any changes
• Verification Layer – Row counts are checked before any live data is deleted
• Refund Support – Refund posts and their meta are archived alongside the parent order
• Subscription Protection – Orders linked to active WooCommerce Subscriptions are skipped automatically
• Activity Log – Every archive, restore, and delete is recorded with timestamps
• Database Visualiser – See how much space your order tables are actually using
• Archive Health Check – Verifies table integrity and flags any orphaned rows
• Batch Processing – Handles large stores without timing out

What gets archived

When an order is archived, the following data moves with it:

• The order post (wp_posts)
• All order meta (wp_postmeta)
• Order line items (woocommerce_order_items)
• Order item meta (woocommerce_order_itemmeta)
• Order notes (wp_comments)
• Order note meta (wp_commentmeta)
• Refund posts and their meta

Compatibility

HPOS Support – This version supports legacy post-based order storage only. Stores using WooCommerce High-Performance Order Storage (HPOS) will see an admin notice and the plugin will remain inactive. HPOS support is planned for a future release.

WooCommerce Subscriptions – Detected automatically. Orders linked to active subscriptions are skipped during archiving to avoid breaking renewal billing.

Why choose Order Archive Manager for WooCommerce?

Unlike plugins that only change order status or soft-delete orders, this plugin physically moves order data to separate tables. Your live database tables stay lean and fast, while archived data remains fully restorable.

Created by Anandu Ravikumar

Developed by a WordPress and WooCommerce plugin developer focused on database optimization and performance

Support

For support, feature requests, or bug reports, please visit the GitHub repository.

Credits

Developed by Anandu Ravikumar

License

GPL-2.0-or-later – https://www.gnu.org/licenses/gpl-2.0.html