How to Delete All Products in WooCommerce Or Specific (With Use Cases)

Managing a WooCommerce store is a lot like tidying up a cluttered closet.

You wouldn’t keep winter coats hanging around in summer, right? Just like you swap out clothes with the seasons, your store needs regular clean-ups too—removing old or slow-moving products to make space for new arrivals, best-sellers or festive specials.

That’s where the ability to bulk delete products in WooCommerce becomes super helpful.

Whether you want to clear out your entire catalog or remove specific products based on categories, tags, attributes or stock status—this guide walks you through how to do it quickly, safely and even with code (if you’re feeling techy).

Why is removing products from your store essential?

Cleaning up your store is just as important as adding new items. Whether it’s to stay organized or improve the shopping experience, here are a few common reasons to bulk delete products:

• Store revamp or rebranding – clearing old catalog before uploading new products.
• Ending a product line – discontinuing categories, collections or certain brands.
• Removing test or demo data – especially during development.
• Correcting a faulty import – wrong attributes, prices, images or duplicated SKUs.
• Expired or seasonal products – out-of-date listings like holiday items or one-time collections.
• Vendor or marketplace management – removing products from deactivated vendors.
• Performance improvements – cleaning unused variations or bloated product tables.

Essential steps to take before product deletion

Before you hit that delete button for all your products, it’s important to pause and prepare. Deleting products also removes connected data like reviews, images and order histories—so taking a few precautions can save you from future headaches.

Backup your data

Always backup your store before making major changes. This includes customer reviews, product images, past orders and anything else tied to your products.

A backup ensures you can recover critical information if something goes wrong. You can also export your products and related data.

Check for dependencies

Many products are linked to customers, past purchases or promotional campaigns. Deleting them without checking these connections can disrupt customer records, affect order histories or break parts of your site.

Make sure you review and resolve these dependencies first — especially for products that have been purchased before.

Three ways to delete WooCommerce products (tech and non-tech)

Not all deletion methods are created equal.

Some are great for small edits and quick cleanups. Others are powerful enough to handle thousands of products but come with technical risks. And then there are tools designed to make your life easier by offering advanced features with just a few clicks.

In this section, we’ll walk you through three easy methods to delete products in WooCommerce:

1. The default WooCommerce interface – simple and built-in, but limited.
2. SQL commands – risky for non-tech users.
3. The Smart Manager plugin – fast, advanced, flexible, safe, and great for bulk actions with no coding.

We’ll also break down when to use each method and why you might want to avoid them, so you can pick the one that fits your store’s needs best.

Let’s dive in.

The default WooCommerce way

If you only have a limited number of products to delete, WooCommerce’s built-in product management tools can get the job done.

Steps to delete products:

1. Go to your WordPress dashboard.
2. Navigate to WooCommerce > Products.
3. Use Screen Options (top-right) to increase the number of products shown per page.
4. Select the products manually or apply filters (like category, stock status or product type).
5. Click Bulk Actions > Move to Trash and hit Apply.

Why avoid this method:

• The process is slow and tedious for large catalogs.
• Loading more than 100 products per page may slow down the deletion process.
• To permanently delete, go to the Trash tab and remove them from there.

It’s best for small stores with fewer than 10 products.

Running an SQL command

If you’re dealing with a large volume of products and want to delete them all at once, using SQL commands directly in your database can be effective.

However, this method is technical and carries the risk of permanent data loss if not done correctly—so it’s not ideal for beginners.

Caution: Use this method only if you’re comfortable working with databases and have taken a full backup.

Steps to delete products via SQL:

1. Log in to phpMyAdmin from your hosting control panel.
2. Select the correct database that contains your WooCommerce store.
3. Backup your database before making any changes!
4. Select table {prefix}_posts and run the SQL statement as shown.

DELETE relations.*, taxes.*, terms.*
FROM wp_term_relationships AS relations
INNER JOIN wp_term_taxonomy AS taxes
ON relations.term_taxonomy_id=taxes.term_taxonomy_id
INNER JOIN wp_terms AS terms
ON taxes.term_id=terms.term_id
WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'));

DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation'));
DELETE FROM wp_posts WHERE post_type IN ('product','product_variation');

5. Verify that the products have been deleted from your store.

Why avoid this method:

1. Log in to phpMyAdmin from your hosting control panel.
2. Select the correct database that contains your WooCommerce store.
3. Backup your database before making any changes!
4. Select table {prefix}_posts and run the SQL statement as shown.
5. Ideal for developers or advanced users but not user-friendly for non-technical users.
6. High risk of deleting important data if mistakes are made.
7. No way to “undo” the action unless you’ve backed up beforehand.

If you’re looking for a safer, faster and more flexible alternative—especially with bulk filters and no code—check out the third method using Smart Manager.

Using Smart Manager – for easy deletion of thousands of products

If you’re looking for a simple, fast and safe way to delete products in WooCommerce, Smart Manager is your best bet.

Smart Manager is a plugin that gives you a simple and familiar Excel-like spreadsheet interface. Whether you want to delete a few items or clean out thousands of products, you can do it in just a few clicks—without writing a single line of code.

What you can do with Smart Manager:

• Quickly delete, edit or update products, orders, coupons, pages, users and more.
• Use filters to find the exact products you want to remove.
• Switch between different sections like products or orders with ease.

This tool is perfect if you want to save time and keep your store clean without technical work.

You can start with the free version to move up to 50 products to trash at once.

And if you want to permanently delete items or use more advanced options, the Pro version is worth it.

It also lets you export, bulk edit and manage products, orders, coupons, users, taxonomies, custom fields and any WordPress post type — all in one place.

How to delete products using Smart Manager?

1. Download, install and activate the Smart Manager plugin just like any other WordPress plugin.
2. In your WordPress admin, go to Smart Manager. From the dropdown, select Products (if it’s not selected by default).
3. Now, to delete all products, check the box at the top of the column header to select all. Or, select specific products manually.
4. You can also use advanced search to quickly filter and find the products you want to remove.
5. Now, delete the selected products. Click on the Delete icon.
6. You’ll get two options:
   • Move to Trash – products go to trash and can be restored later.
   • Delete permanently – products are removed completely and can’t be recovered.

Choose the option that suits your needs.

That’s it! Follow these steps anytime you want to quickly clean up your product catalog with Smart Manager.

How to delete products with advanced conditions using Smart Manager (use cases)?

Smart Manager gives you full control to filter, find and delete products in WooCommerce based on specific conditions—without writing a single line of code.

Whether it’s outdated stock, non-performing products or just test items from setup, you can remove them in bulk with precision.

Bulk delete products using advanced filters

You can delete products using multiple filters like product name, SKU, price, stock status and more.

Let’s say you want to delete all out-of-stock products priced under $15.

1. Use the Advanced Search filter.
2. Set filters:
   • Stock Status = Out of Stock
   • Price = 15
3. Select the results.
4. Click Delete.

This helps keep your catalog lean and relevant.

Why is this the best method?

• Deletes simple, variable, affiliate products — and variations — in one action
• Filter by category, type, SKU, price, stock status, attribute, vendor, etc.
• No server limits or timeouts
• Perfect for non-developers

Remove test or placeholder products

During store setup, it’s common to add demo or test products. You don’t want these to live on your site. For example, you want to delete all products with names like Test Shirt or Sample Product.

• Filter by Name contains Test or Sample
• Select all matching products
• Click Delete (Trash or Permanent)

It’s quick and helps maintain a professional storefront.

Try Smart Manager live demo

Delete based on categories and attributes

Delete groups of products based on shared tags, categories or product attributes.

Examples:

• Remove the entire Summer Sale category after the season ends.
• Delete all Red-colored Hoodies.

Here are the steps:

1. Filter by Category = Summer Sale
2. Or Attribute (Color) = Red
3. Select and Delete (Trash or Permanent)

This is great for managing seasonal and campaign-specific inventories.

Delete specific product variations

Smart Manager shows each variation (like size or color) in a separate row. You can target and delete only the ones you don’t want.

Let’s say you’re discontinuing Size XXL of a product but keeping other sizes.

• Filter by Product name + Variation = XXL
• Select the variations
• Click Delete (Trash or Permanent)

Perfect for keeping your variable products clean and updated.

Delete based on date range

Great for cleaning up old inventory or seasonal products.

Want to remove products added before the start of this year?

1. Use the Advanced Search filter
2. Set: Before 01/01/XXXX (XXXX is the year)
3. Select and Delete (Trash or Permanent)

Note – Deleting the products would also not show the same product name in any of its existing orders or subscriptions.

Delete products directly from the spreadsheet

Just want to delete a few items while browsing?

How:

• Tick the checkbox beside the product rows
• Hit the Delete option (Trash or Permanent)

This is handy when you spot a few unwanted products while managing your catalog.

Delete images from the media library

Smart Manager isn’t just for products—it works on any WordPress post type, including media files.

Do you want to delete all product images uploaded during a failed photoshoot?

• Switch post type to Attachment
• Filter by Upload Date or Filename
• Select and Delete (Trash or Permanent)

This saves you from manual cleanup inside the WordPress Media Library.

How to remove the same products with duplicate descriptions?

Smart Manager allows you to delete products having the same descriptions.

You may find yourself with hundreds of products with duplicate descriptions while creating test products or when you are importing them and you want to get rid of them after you have added the products up.

1. Toggle on the Advanced Search.
2. Select Description from the first dropdown, select is from the second dropdown and enter or copy the description.



3. Smart Manager will fetch your required results. The search result will also include the main product that the Admin would not like to be deleted. So, select the products carefully.
4. Click on the Delete button and choose to delete the products permanently or move them to trash.

Smart Manager also gives you the flexibility to delete duplicate products based on title, stock status, product category, SKU, tags and other product fields, including custom ones.

How to delete orders in WooCommerce?

Old WooCommerce orders clutter the database, slowing your store; regularly deleting WooCommerce orders is crucial for performance, backups, reporting and data privacy.

Use Smart Manager to bulk delete WooCommerce orders, including by criteria like refunded status.

Go to the Orders dashboard, select the orders and choose to move them to trash or delete them permanently. Advanced Search helps you filter and target specific records easily.

Check this WooCommerce delete orders blog for more details.

How to delete customers in WooCommerce?

Cleaning up your WooCommerce customer database doesn’t have to take hours. With Smart Manager, you can filter, review and bulk delete customers in just a few clicks.

You can use the powerful filtering tools to narrow down exactly which users to remove.

For example, imagine you want to delete all customers who registered more than two years ago and whose accounts show no purchase activity.

Open the Customers dashboard in Smart Manager and apply filters like:

• Order Count = 0
• Date Registered

Then click delete to move users to trash first (great for a review period) or delete permanently.

Check this WooCommerce delete customers blog for more details.

How to delete posts and pages?

Managing WordPress content gets overwhelming when you’re dealing with hundreds of posts, product pages, landing pages, drafts or outdated promo content.

Manually opening each item and clicking “Trash” one by one is slow, frustrating and simply not practical for busy store owners.

Use Smart Manager to bulk delete posts and pages instantly.

Open the Posts dashboard, use advanced search to narrow down your search and then delete the needful.

Check out this WordPress delete post page blog for more details.

Conclusion

Deleting products in WooCommerce — whether all at once or selectively — doesn’t have to be complicated. Depending on your needs, you can:

• Use the default WooCommerce admin (small stores)
• Use WP-CLI for fast developer-level cleanup
• Use Smart Manager for the simplest, safest and most efficient bulk deletion

So, whether you have just started or have been running a store for years, whether you have hundreds or thousands of products, Smart Manager is the most convenient solution to delete WooCommerce products. Super-easy and super-quick!

Get Smart Manager plugin now

FAQ

How do I add and remove products in WooCommerce?
You can add new products directly to your WooCommerce store using Smart Manager’s sheet editor. Refer to this doc.

How do I delete multiple variations in WordPress?
Select all the desired variations using the Smart Manager advanced search sheet and delete them.

Can we permanently delete WooCommerce products with one click?
Yes.