LokusWP

// Load and parse the JSON data
$json_data = '{
  "0480": {
    "anonim": true,
    "message": "Semoga Allah lipat gandakan rezekinya"
  }
}';

$data = json_decode($json_data, true);

// Process each entry in the JSON data
foreach ($data as $customer_note => $note_data) {
    // Create a direct database query to find orders with this customer note
    global $wpdb;
    
    // Get the correct table name based on whether HPOS is enabled
    $order_table = $wpdb->prefix . 'wc_orders';
    
    // Query for the order with this customer note
    $order_id = $wpdb->get_var(
        $wpdb->prepare(
            "SELECT id FROM $order_table WHERE customer_note = %s LIMIT 1",
            $customer_note
        )
    );
    
    if ($order_id) {
        $order = wc_get_order($order_id);
        
        if ($order) {
            // Convert anonim boolean to 0/1
                  // Convert anonim boolean to 0/1
            $anonim_value = $note_data['anonim'] === true ? 1 : 0;
            
            // Save anonim status
            $order->update_meta_data('_wc_billing/fundrizer/anonim', $anonim_value);
            
            // Save message - no need to escape as update_meta_data handles this
            $order->update_meta_data('frzr_message', $note_data['message']);
            
            // Save the changes
            $order->save();
            
            // Log success
            error_log("Updated order #$order_id with customer note '$customer_note': anonim=$anonim_value, message=" . esc_html($note_data['message']));
            echo "Updated order #$order_id with customer note '$customer_note' \n"; 
        }
    } else {
        // Log no order found for this customer note
        error_log("No order found with customer note: $customer_note");
        echo "No order found with customer note: $customer_note /n";
    }
}

echo "Processing complete!";