Gary Kovar

If <a href="http://wp-cli.org/" title="WP-CLI" rel="nofollow ugc">WP-CLI</a> is available this plugin adds 2 new commands. 
 wp dbsnap 
 creates a snapshot of your database. No fuss, no muss… 
 wp dbsnapback 
 restores the snapshot. That simple…
If you need 2 different checkpoints you can name them 
 wp dbsnap db-before-i-do-something-sketchy 
 wp dbsnapback db-before-i-do-something-sketchy

DB Snapshot

I am running this on my local VVV installs and it is sooo easy to test stuff that changes anything in the WordPress DB.
take a snapshot and you have your "clean working wordpress" preserved. Test and revert to test again, and again, and again.

Thanks for the great tool!!

Great Development tool

Extends WP-CLI to include a db checkpoint for development purposes.

Gerasimos

WP Republic

Building a WooCommerce store is easy. Maintaining a massive one is hard.
We built WPRepublic Bulk Category Removal for WooCommerce to be the Swiss Army knife that every store administrator wishes they had. This plugin is designed to host a variety of essential add-ons and utilities, evolving into a complete operations center for your shop.
<h3>The First Module: The “Bulk Delete” Solution</h3>
Have you ever tried to delete a product category in WooCommerce, only to realize the products inside it stay behind?
You are left with thousands of orphaned items, and the default interface only lets you delete them 20 at a time. It is slow, it times out, and it frustrates even the most patient admins. 
For years, there wasn’t a simple, native way to say: “Delete this category AND everything inside it.”
Now there is.
The WPRepublic Bulk Category Removal Cleanup Module allows you to select specific categories and surgically remove all products contained within them.
<h3>Why this is the tool you’ve been looking for:</h3>
<ul>
<li>The “Missing” Feature: Finally, you can bulk delete thousands of products based on their category with a few clicks.</li>
<li>Deep Cleaning: It doesn’t just delete the post. It scrubs the database of orphaned relationships, <code>postmeta</code>, and <code>wc_product_meta_lookup</code> entries, keeping your database lean and fast.</li>
<li>Safety First: Includes a Dry Run mode (enabled by default). Simulate the entire process and read the logs before you delete a single byte of data.</li>
</ul>
<h3>🚀 Supercharged with WP-CLI</h3>
For developers and site reliability engineers, the graphical interface is just the beginning. 
WPRepublic Bulk Category Removal comes with robust WP-CLI integration out of the box.
<ul>
<li>No Timeouts: managing 50,000 products? Run the cleanup from the terminal. It is faster, more stable, and immune to browser timeouts (PHP max_execution_time).</li>
<li>Secure & Scriptable: Automate your store maintenance via cron jobs or shell scripts securely.</li>
<li>Dry Runs in Terminal: Test your cleanup logic directly in the command line before executing.</li>
</ul>
<h3>What’s Next?</h3>
This is just the beginning. WPRepublic Bulk Category Removal for WooCommerce is being actively developed to include more modules for bulk editing, customer management, and store optimization.
<blockquote>
WARNING: This is a powerful, destructive tool. Always perform a full database backup before running a live cleanup.
</blockquote>
<h3>WP-CLI Commands</h3>
Use the power of the command line to manage your store cleanup efficiently.
<h3>1. List Categories</h3>
View a table of all product categories, their IDs, slugs, and product counts.
<pre><code>wp wpr-bulk-category-removal-woocommerce list-categories
</code></pre>
<h3>2. Run Cleanup</h3>
Execute the cleanup process for specific categories.
Options:
<ul>
<li><code>--term-id=<ids></code> : A comma-separated list of category IDs to process.</li>
<li><code>--category-slug=<slugs></code> : A comma-separated list of category slugs.</li>
<li><code>--dry-run</code> : (Optional) Simulate the cleanup without deleting data.</li>
</ul>
Examples:
Safe Simulation (Dry Run): 
 wp wpr-bulk-category-removal-woocommerce run –category-slug=temp-collection –dry-run
Live Cleanup (By ID): 
 wp wpr-bulk-category-removal-woocommerce run –term-id=152,189
Live Cleanup (By Slug): 
 wp wpr-bulk-category-removal-woocommerce run –category-slug=clothing,accessories

WPRepublic Bulk Category Removal for WooCommerce

The ultimate modular toolkit for WooCommerce admins. Starts with the "Missing Feature": Bulk Delete Products by Category (with WP-CLI support).

DB Snapshot vs WPRepublic Bulk Category Removal for WooCommerce