內容簡介
Order Archive Manager for WooCommerce 是一款專為 WooCommerce 設計的外掛，能有效管理大量訂單資料，將已完成、取消或退款的訂單移至專用的存檔表中，提升商店效能並確保資料安全。
【主要功能】
• 安全存檔 - 使用資料庫交易將訂單移至專用存檔表
• 一鍵恢復 - 保留原始 ID 的情況下恢復存檔訂單
• 永久刪除 - 當不再需要時永久刪除存檔訂單
• 預覽模式 - 在變更前預覽將發生的情況
• 驗證層 - 刪除任何現有資料前檢查行數
• 批次處理 - 處理大型商店而不會超時
外掛標籤
開發者團隊
② 後台搜尋「Order Archive Manager for WooCommerce」→ 直接安裝（推薦）
原文外掛簡介
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
