How to Delete All WooCommerce Products

Backup First!
Before you do anything please backup your WordPress Database using a WordPress backup plugin like BackupBuddy by iThemes.

1. To delete all your WooCommerce Products, for a fresh start, you will need to access the database directly via a database application such as phpMyAdmin (included in many hosting Control Panels). Navigate to your WordPress Database and then in the SQL tab enter the following database query:-

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='product');

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

2. Click ‘Go’ in phpMyAdmin to run/execute the SQL Query

This will delete all your Woo Commerce products and their associations (including categories/taxonomies/terms info) so please exercise caution when running the Query.

About the Author
how to delete all woo commerce products How to Delete All WooCommerce Products 0da77002febbfe28d15144a57bbcc2c9 s 180 d mm r g


A highly experienced Web Designer / Web Developer (Webflow, WordPress, Weebly & Custom), Front-end / Back-end Developer & New Media Specialist, with extensive knowledge of a wide spectrum of technologies in the Development and Creative Industries, built up over a number of years.