Migrate Jigoshop products to WooCommerce

if( get_option( 'first_time_45' ) ) {

} else

{

global $wpdb;
// Query over posts with type product and put the on an Object
$results = $wpdb->get_results( 'SELECT id FROM wp_posts WHERE post_type LIKE  "product" ', OBJECT );

//get every post id and create sale and regular price for it
foreach($results as $result)
{

 $post_id=$result->id;
 $stored_array= $wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM $wpdb->postmeta WHERE post_id = $post_id and meta_key='product_data'" ) );
 $array=unserialize($stored_array);
 $regular_price=$array['regular_price'];
 $stock_status=$array['stock_status'];
 $manage_stock=$array['manage_stock'];
 $backorders=$array['backorders'];
 $price= $wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM $wpdb->postmeta WHERE post_id = $post_id and meta_key='price'" ) );
 $featured= $wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM $wpdb->postmeta WHERE post_id = $post_id and meta_key='featured'" ) );
 $product_attributes=$wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM $wpdb->postmeta WHERE post_id = $post_id and meta_key='product_attributes'" ) );
 $sale_price_dates_from=$wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM $wpdb->postmeta WHERE post_id = $post_id and meta_key='sale_price_dates_from'" ) );
 $sale_price_dates_to=$wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM $wpdb->postmeta WHERE post_id = $post_id and meta_key='sale_price_dates_to'" ) );
 $sku=$wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM $wpdb->postmeta WHERE post_id = $post_id and meta_key='SKU'" ) );
 $stock=$wpdb->get_var( $wpdb->prepare( "SELECT meta_value FROM $wpdb->postmeta WHERE post_id = $post_id and meta_key='stock'" ) );


// $wpdb->query(
//  "
//  UPDATE $wpdb->postmeta
//  SET meta_value = $regular_price
//  WHERE post_id = $post_id
//      AND meta_key = '_regular_price'
//  "
// );

 $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_regular_price',
    'meta_value'=>$regular_price
    ));

$wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_sale_price',
    'meta_value'=>$price
    ));

 $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_price',
    'meta_value'=>$price
    ));

 $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_featured',
    'meta_value'=>$featured
    ));

 $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_product_attributes',
    'meta_value'=>$product_attributes
    ));

  $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_sale_price_dates_from',
    'meta_value'=>$sale_price_dates_from
    ));

   $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_sale_price_dates_to',
    'meta_value'=>$sale_price_dates_to
    ));


  $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_sku',
    'meta_value'=>$sku
    ));

  $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_stock',
    'meta_value'=>$stock
    ));

    $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_total_sales',
    'meta_value'=>'0'
    ));

   $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_backorders',
    'meta_value'=>$backorders
    ));

 $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_downloadable',
    'meta_value'=>'no'
    ));

  $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_height',
    'meta_value'=>NULL
    ));

    $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_manage_stock',
    'meta_value'=>$manage_stock
    ));

        $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_product_image_gallery',
    'meta_value'=>NULL
    ));

      $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_purchase_note',
    'meta_value'=>NULL
    ));



           $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_sold_individually',
    'meta_value'=>NULL
    ));

    $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_stock_status',
    'meta_value'=>$stock_status
    ));

        $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_virtual',
    'meta_value'=>'no'
    ));

                $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_virtual',
    'meta_value'=>'no'
    ));


                $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_visibility',
    'meta_value'=>'visible'
    ));


                $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_weight',
    'meta_value'=>null
    ));

                    $wpdb->insert('wp_postmeta' ,
  array('meta_id' => Null ,
    'post_id' => $post_id,
    'meta_key' => '_width',
    'meta_value'=>null
    ));
}

add_option( 'first_time_45','false');
}