delete all draft product from sql

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter lododicesimo

    (@lododicesimo)

    i finded this:
    DELETE FROM wp_term_relationships 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’;

    and i think that what i need is like:
    DELETE FROM wp_term_relationships 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’ AND post_status = ‘draft’);
    DELETE FROM wp_posts WHERE post_type = ‘product’ AND post_status = ‘draft’;

    is it correct?!

    Thread Starter lododicesimo

    (@lododicesimo)

    sorry this:

    DELETE FROM wp_term_relationships WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type = ‘product’ AND post_status = ‘draft’);
    DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type = ‘product’ AND post_status = ‘draft’);
    DELETE FROM wp_posts WHERE post_type = ‘product’ AND post_status = ‘draft’;

    Thread Starter lododicesimo

    (@lododicesimo)

    it works!
    (the previus code)

    you can change draft in your post status u need!

    bye

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘delete all draft product from sql’ is closed to new replies.