How can I convert a group of posts into woocommerce products

2 comments

1. you can use : Post Type Switcher http://wordpress.org/plugins/post-type-switcher/faq/ or
   Convert Post Types : http://wordpress.org/plugins/convert-post-types/ or read this post : https://wordpress.stackexchange.com/questions/127744/convert-wordpress-posts-to-products-in-woocommerce

   Log in to Reply

2. I have used this:

   global $wpdb;
    $wpdb->update(
    $wpdb->posts,
    array( 'post_type' => 'product', ),
    array( 'post_type' => 'post', ),
    // Data Type (available: %s string, %d integer, %f float)
    '%s',
    // SQL "WHERE" clause Type
    '%s'
   );
   

   and this

   UPDATE  `wp_posts` SET  `post_type` =  'product' WHERE  `post_type` = 'post';
   

   Log in to Reply