How to delete all products, categories, product tags and product attributes from woocommerce

If you want to delete all your products from a WooCommerce installation in order to upload a brand new product list or catalogue then run the following code in the MySQL database.

Thanks for this code to Ciprian and Marcvanzee from .

As Marcvanzee explain: “The idea is that you join the table that contains the relationships between posts and taxonomies (wp_term_relationships) with the table containing the taxonomies (wp_term_taxonomy). Then you join this with the table that contains the terms (wp_terms). This results in all terms and taxonomies that are used by posts. The WHERE clause makes sure that you will only remove the taxonomies and terms of products”

So assuming that you have the standard tables names you can execute the next queries in the phpmyadmin or other inteface to db:


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

2. DELETE FROM wp_term_relationships WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type = 'product');

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

4. DELETE FROM wp_posts WHERE post_type = 'product';

IMPORTANT NOTE: Beware that this query might also remove taxonomies and terms that are used by pages that are not products as well, so if you want to filter this out you need an additional query.


WordPress Version 3.6 – “Oscar Peterson”

On August 1, 2013, WordPress Version 3.6, named for Oscar Peterson, was released to the public and includes a beautiful new blog-centric theme, bullet-proof autosave and post locking, a revamped revision browser, native support for audio and video embeds, and improved integrations with Spotify, Rdio, and SoundCloud.

For more information on this enhancement and bug-fix release, read the WordPress Blog, the Release Post, and see the Changelog for 3.6. For Version 3.6, the database version (db_version in wp_options) changed to 24448, and the Trac revision was r24973.

Published on:
03:05 PM

WordPress “News” Theme

This theme is very easy to customise even if you don’t familiar with wordpress. Please, don’t hesitate and buy it. Our dedicated support is ready to help you to built your website.

Features List:

  • Jquery and Custom JavaScript Powered
  • Google WebFonts ( 500+ Google Fonts )
  • 200+ Retina Ready Icons
  • Cross-Browser Compatibility FireFox, Safari, Chrome, IE8, IE9, IE10
  • Translation Ready ( .pot file included )
  • Drag Drop Homepage Builder
  • SEO Base Built-IN
    • Theme supports google analytics code for SEO
  • Tons of shortcodes


Începând de azi este disponibilă și pagina oficială de Facebook ( )

Monday November 5th, 2012 at 04:40 PM no comments
Top! Power by WordPress. Customization made by Aurel Roman . Slash WP from Hosted By
Social Links: