I PUT PHP code on my functions.php page
if( get_option( 'first_time_45' ) ) {
} else
{
global $wpdb;
$results = $wpdb->get_results( 'SELECT id FROM wp_posts WHERE post_type LIKE "product" ', OBJECT );
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->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');
}