Insertar valores en una tabla personalizada una vez que se realiza el pedido en Woocommerce
Necesito insertar en mi tabla personalizada llamadalicencia_tabla
**username**, **order id**, **Quantity**
This needs to be populated when an order is placed.
Username = customer's email id
Quantity = quantity (of the product)
order id=Order ID
he usado pero no estoy trabajando
add_action( 'woocommerce_order_status_completed', 'my_function' );
function my_function($order_id) {
global $wpdb;
$order = new WC_order($order_id);
$customer_id= $order->id;
$email= $order->billing_email;
$email1= $order->id;
$table_name = "aitoe_license_table";
$wpdb->insert( $table_name, array(
'username' => $customer_id,
'order_id' => $email,
'number_of_cameras' => 12,
'boolean' => 'False',
) );
}