Add columns date created and order number to WooCommerce My account Orders

Question

I want to add two types of metadata to an order and its order_items when it is created. I tried some things but it is not working.

The first I want to add is $order->get_date_created(); as meta data to the order.

// Add order date as order meta data
add_action( 'woocommerce_checkout_create_order', 'add_order_date_to_order_meta_data', 10, 2 );
function add_order_date_to_order_meta_data( $order, $data ) {
  $order_date = $order->get_date_created();

        $order->update_meta_data( 'order_created', $order_date );
}

The second is $order->get_id(); that I want to add to both the order itself as to the order_items

// Add order number as order meta data
add_action( 'woocommerce_checkout_create_order', 'add_order_number_to_order_meta_data', 10, 2 );
function add_order_number_to_order_meta_data( $order, $data ) {
  $order_id = $order->get_id();

        $order->update_meta_data( 'order_number', $order_id );
}

I am blank about about how to add it to the order lines. No clue on how to do that. I found the following but I believe that is adding information before a order is created?

add_action( 'woocommerce_checkout_create_order_line_item', 'add_meta_to_line_item', 20, 4 );
 
function add_meta_to_line_item( $item, $cart_item_key, $values, $order )
{
    $_p = $item->get_product();
    $key = $order->get_id();
 
    if ( false !== ( $value = $_p->get_meta( $key, true ) ) )
        $item->add_meta_data( $key, true);
    }

Then after I created these meta fields, I also want to add them to a column in the order overview on the front-end.

/**
 * Adds a new column to the "My Orders" table in the account.
 *
 * @param string[] $columns the columns in the orders table
 * @return string[] updated columns
 */
function metavalue_add_my_account_orders_column( $columns ) {

    $new_columns = array();

    foreach ( $columns as $key => $name ) {

        $new_columns[ $key ] = $name;

        // add meta_value after order status column
        if ( 'order-status' === $key ) {
            $new_columns['order_number'] = __( 'Order Number', 'textdomain' );
            $new_columns['order_created'] = __( 'Order Created', 'textdomain' );
        }
    }

    return $new_columns;
}
add_filter( 'woocommerce_my_account_my_orders_columns', 'metavalue_add_my_account_orders_column' );

I hope someone can help me in the right direction.

Answer 1

Updated - There are some mistakes and missing things in your code. Try the following instead:

// Add order number and order date creation as order meta data
add_action( 'woocommerce_checkout_create_order', 'add_some_order_meta_data', 10, 2 );
function add_some_order_meta_data( $order, $data ) {
    $order->update_meta_data( '_order_number', $order->get_id() );
    $order->update_meta_data( 'order_date', current_time('Y-m-d H:i:s') );
}

// Add order Id as custom order item meta data
add_action( 'woocommerce_checkout_create_order_line_item', 'add_meta_to_line_item', 10, 4 );
function add_meta_to_line_item( $item, $cart_item_key, $values, $order ) {
    $item->add_meta_data( '_order_id', $order->get_id() );
}

// Include order number meta data for the method get_order_number()
add_filter( 'woocommerce_order_number', 'wc_set_order_number', 10, 2 );
function wc_set_order_number( $order_id, $order ) {
    // Get the order number (custom meta data)
    $order_number = $order->get_meta('_order_number');

    return $order_number ? $order_number : $order_id;
}

// Add columns to my account orders
add_filter( 'woocommerce_my_account_my_orders_columns', 'add_my_account_orders_columns' );
function add_my_account_orders_columns( $columns ) {
    $new_columns = array();

    foreach ( $columns as $key => $name ) {

        $new_columns[ $key ] = $name;

        // add meta_value after order status column
        if ( 'order-status' === $key ) {
            $new_columns['number'] = __( 'Order Number', 'textdomain' );
            $new_columns['date-created'] = __( 'Date Created', 'textdomain' );
        }
    }

    return $new_columns;
}

// Column order number content
add_action( 'woocommerce_my_account_my_orders_column_number', 'my_account_order_number_column_content', 10, 1 );
function my_account_order_number_column_content( $order ) {
    echo $order->get_order_number();
}

// Column order date created content
add_action( 'woocommerce_my_account_my_orders_column_date-created', 'my_account_order_date_created_column_content', 10, 1 );
function my_account_order_date_created_column_content( $order ) {
    echo $order->get_meta('order_date') ? $order->get_meta('order_date') : $order->get_date_created()->date('Y-m-d H:i:s');
}

Code goes in functions.php file of the active child theme (or active theme). Tested and works.

---

Notes:

To get the order number, you will use the WC_Order method get_order_number() from order object.

You can change the saved date format as explained in here for WC_Date_time date() method.

For the order Id stored as custom order item meta data the meta key needs to start with an underscore, to make it not visible in customer order and email notifications. So to get it from order items, you will use WC_Data get_meta() method on the WC_Order_Item_Product object $item variable like $item->get_meta( '_order_id') or you can also use the method get_order_id() like $item->get_order_id()…

---

Related:

• Show products name and quantity in a new column on Woocommerce My account Orders
• Set an external order ID when creating programmatically a WooCommerce order?
• How to get WooCommerce order details
• Get Order items and WC_Order_Item_Product in WooCommerce 3