<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

include '/var/www/html/breadsecret.com/wp-load.php';
// set timezone
date_default_timezone_set("Asia/Hong_Kong");
global $wpdb, $current_site, $sitepress;

$record = $wpdb->get_results("SELECT * FROM `stock_log` WHERE order_id != '0' AND order_number = '' order by order_id desc");
foreach($record as $logObj){	
	$order = wc_get_order( $logObj->order_id );
	if($order){
		$order_number = $order->get_order_number();
		//echo "<br>";
		$wpdb->update('stock_log', array( 'order_number' => $order_number ), array( 'order_id' => $logObj->order_id ) );
	}
}