UPDATE wp_posts SET post_status = 'draft' WHERE post_type = 'product' AND post_status = 'publish';
this ithe correct one!