Display Order Quantity on WooCommerce Orders Page

[mahdialikhanusiya]

We believe in improving the WooCommerce experience for store owners and admins. Many of our customers have expressed difficulty in quickly identifying the total quantity of products in each order. By default, WooCommerce doesn’t display this information, making it harder to manage orders efficiently, especially for stores with large volumes of orders. This has led to complaints and frustration from store owners who need to manually check order details for quantity information.

Request:

We request a feature that adds a ‘Quantity’ column to the WooCommerce orders page. This feature would allow store managers to easily see the total quantity of items in each order directly on the orders page, eliminating the need to open each individual order.

[nickolaschang]

Hey @mahdialikhanusiya! The business where I work needed the same thing, so I came up with this snippet:

So, what it does is: it essentially creates a column into the orders dashboard and shows all the products someone have bought in the same order without the need to open all the orders, it also shows how many of each, if you want I could tweak here and there and maybe it would be useful for you.

How to add the snippet: Well ideally you want to have any snippet injector (WPCode, etc) and add as a PHP function, likewise you can also modify the main WooCommerce files, but that's not very helpful as they will be reset in case any update happens…

Disclaimer i haven't tested with dozens of different items in one order, but i assume you don't have customers buying 300 different items at once? (or do you?)

This snippet should work straight out of the box as is, you don't need to change anything, if you have someone there that understands coding, feel free to change anything you want 👍

Snippet for the Products:

// Add a new custom column to admin order list
add_filter( 'manage_edit-shop_order_columns', 'admin_orders_list_add_column_with_sku', 10, 1 );
function admin_orders_list_add_column_with_sku( $columns ){
    $columns['custom_column_sku'] = __( 'Orders Products(SKU)', 'woocommerce' );
    return $columns;
}

// Populate the new custom column with product names and SKUs in the admin order list
add_action( 'manage_shop_order_posts_custom_column', 'admin_orders_list_column_content_with_sku', 10, 2 );
function admin_orders_list_column_content_with_sku( $column, $post_id ){
    if ( 'custom_column_sku' === $column ) {
        // Get the order
        $order = wc_get_order( $post_id );
        if ( ! $order ) {
            return; // Exit if no order is found
        }

        // Initialize a counter for layout
        $count = 0;

        // Loop through order items
        foreach( $order->get_items() as $item_id => $item ) {
            // Get the product from the order item
            $product = $item->get_product();

            // Check if the product exists
            if ( $product ) {
                $name = $product->get_name();
                $sku = $product->get_sku();
                $style = $count > 0 ? ' style="padding-left:6px;"' : '';
                
                // Display product name and SKU
                printf( '<div%s>%s (%s)</div>', $style, esc_html( $name ), esc_html( $sku ) );
                $count++;
            }
        }
    }
}

Snippet for Images (For a quickview of the order)

// Add a new custom column to admin order list
add_filter( 'manage_edit-shop_order_columns', 'admin_orders_list_add_column', 10, 1 );
function admin_orders_list_add_column( $columns ){
    $columns['custom_column'] = __( 'Product Preview', 'woocommerce' );
    return $columns;
}

// Populate the new custom column in the admin order list
add_action( 'manage_shop_order_posts_custom_column', 'admin_orders_list_column_content', 10, 2 );
function admin_orders_list_column_content( $column, $post_id ){
    if( 'custom_column' === $column ){
        // Get the order
        $order = wc_get_order( $post_id );
        if ( ! $order ) {
            return; // Exit if no order is found
        }

        // Initialize a counter for the product thumbnails
        $count = 0;

        // Loop through order items
        foreach( $order->get_items() as $item_id => $item ) {
            // Get the product from the order item
            $product = $item->get_product();

            // Check if the product exists and display its thumbnail
            if ( $product && $product->get_image_id() ) {
                $style = $count > 0 ? ' style="padding-left:6px;"' : '';
                printf( '<span%s>%s</span>', $style, $product->get_image( array( 50, 50 ) ) );
                $count++;
            }
        }
    }
}

[mahdialikhanusiya]

Thanks for sharing the snippet! I’m aware of this approach, but the issue is that every time there’s a new customer or update, I have to maintain these snippets manually. Instead of relying on custom code, this should be an inbuilt feature in WooCommerce.