How to Delete All Woo Commerce Products

Glenn Blog 0 Comments

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 Woo Commerce 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 Woo Commerce Products 0da77002febbfe28d15144a57bbcc2c9 s 180 d mm r g

Glenn

A highly experienced WordPress Web Developer, Front-end and 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.

Leave a Reply

Your email address will not be published. Required fields are marked *