Managing a WooCommerce store can be rewarding, but sometimes you need to clear your entire product catalog, whether you’re rebranding, restructuring, or starting fresh.
Knowing how to delete all WooCommerce products properly ensures your store remains clean, organized, and error-free.
This guide walks you through multiple methods, from beginner-friendly options to advanced developer solutions.
Why Delete All WooCommerce Products?
There are several valid reasons for removing products in bulk:
-
Rebranding: A new brand direction may require a complete product reset.
-
Discontinued Products: Remove outdated inventory to avoid confusion.
-
Data Cleanup: Eliminate clutter from old or test products.
-
Development & Testing: Reset your store during staging or testing phases.
Before You Start
Before deleting products, make sure to:
-
✅ Create a full database backup
-
✅ Confirm you have administrator permissions
-
✅ Consider SEO impact (especially if products have backlinks)
Deleting products is permanent if done incorrectly.
Methods to Delete All WooCommerce Products
1. Delete Products Manually (Beginner-Friendly)
This method works well for smaller stores.
Steps:
-
Log in to your WordPress Admin dashboard.
-
Navigate to Products > All Products.
-
Select products using checkboxes (or select all).
-
From the Bulk Actions dropdown, choose Move to Trash.
-
Click Apply.
-
Go to the Trash tab and click Delete Permanently.
âš If you skip the final step, products remain recoverable in Trash.
2. Delete Products Using SQL (Advanced Users)
For large stores, SQL queries are much faster.
Steps:
-
Access your database via phpMyAdmin.
-
Select your WordPress database.
-
Run the following queries:
DELETE FROM wp_postmeta WHERE post_id NOT IN (SELECT id FROM wp_posts);
DELETE FROM wp_term_relationships WHERE object_id NOT IN (SELECT id FROM wp_posts);
âš Replace
wp_with your database prefix if different.
This method permanently removes products and related metadata.
3. Use a Plugin (Flexible & Safe Option)
Plugins allow bulk deletion with filtering options.
Recommended Plugins:
-
Bulk Delete – Delete products based on conditions (date, category, status).
-
WP Reset – Useful for development environments.
Using Bulk Delete:
-
Install and activate the plugin.
-
Navigate to Bulk WP > Bulk Delete.
-
Select WooCommerce Products.
-
Configure deletion conditions.
-
Click Bulk Delete.
This method is safer than SQL and easier for non-technical users.
4. Delete Products Using WP-CLI (Developer Method)
If you have server access, WP-CLI is the fastest way.
Command:
This command:
-
Deletes all products
-
Skips the Trash
-
Removes them permanently
âš This cannot be undone without a backup.
Important Considerations
Before deleting products, keep in mind:
Backup First
Always create a fresh backup of:
-
Database
-
Media files
SEO Impact
Deleting products may:
-
Remove indexed URLs
-
Break backlinks
-
Cause 404 errors
Consider setting up redirects if needed.
Customer Communication
If this is a live store:
-
Inform customers of changes
-
Avoid confusion during transitions
How to Restore Deleted Products
You can restore products if:
-
They are still in Trash
-
You have a recent backup
If deleted via SQL or WP-CLI without backup, recovery is difficult.
Conclusion
Deleting all WooCommerce products can be done in several ways depending on your experience level:
-
Manual deletion for small stores
-
SQL queries for speed
-
Plugins for flexibility
-
WP-CLI for developers
Always back up your store before proceeding.
By following this guide, you can safely reset your WooCommerce product catalog and ensure your store aligns with your current business goals.