Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
WooCommerce total order weight column on orders page
<?php
add_filter( 'manage_edit-shop_order_columns', 'woo_order_weight_column' );
function woo_order_weight_column( $columns ) {
$columns['total_weight'] = __( 'Weight', 'woocommerce' );
return $columns;
}
add_action( 'manage_shop_order_posts_custom_column', 'woo_custom_order_weight_column', 2 );
function woo_custom_order_weight_column( $column ) {
global $post, $woocommerce, $the_order;
if ( empty( $the_order ) || $the_order->id != $post->ID )
$the_order = new WC_Order( $post->ID );
if ( $column == 'total_weight' ) {
$weight = 0;
if ( sizeof( $the_order->get_items() ) > 0 ) {
foreach( $the_order->get_items() as $item ) {
if ( $item['product_id'] > 0 ) {
$_product = $the_order->get_product_from_item( $item );
if ( ! $_product->is_virtual() ) {
$weight += $_product->get_weight() * $item['qty'];
}
}
}
}
if ( $weight > 0 )
print $weight . ' ' . esc_attr( get_option('woocommerce_weight_unit' ) );
else print 'N/A';
}
}
?>
@trevormesnik

This comment has been minimized.

Copy link

commented Aug 2, 2013

Which file does this go in to display total weights?

@flistefliste

This comment has been minimized.

Copy link

commented Jul 1, 2014

If the code doesn't work first time, just add a later priority to the main filter to avoid that WC clears columns while loading :

add_filter( 'manage_edit-shop_order_columns', 'woo_order_weight_column',20 );
@mikloshenrich

This comment has been minimized.

Copy link

commented Jul 5, 2014

Awesome. It works like a charm! Thank you.

@Webmetz

This comment has been minimized.

Copy link

commented Mar 19, 2015

I am trying to pull the order weight using a UPS Worldship Export Plugin (myzoogu.com)

How can I modify the following code to pull weight as well? I was able to get the order column, but it would be great to some how store it in meta data.

$query = $wpdb->prepare( "SELECT orden.ID AS order_number,
                    orden.post_modified AS last_date,
                    orden.post_excerpt AS deliverynotes,
                    orden.post_modified AS formatteddate,
                    user.ID AS user_id,
                    user.user_email AS user_email,
                    user.display_name AS user_name,
                    user.user_login AS user_login
                    FROM {$wpdb->posts} AS orden
                    LEFT JOIN {$wpdb->postmeta} AS meta
                    ON (meta.post_id = orden.ID)
                    LEFT JOIN {$wpdb->users} AS user
                    ON (user.ID=meta.meta_value )
                    WHERE
                    orden.post_type='shop_order'
                    AND orden.post_status not in ('trash',  'auto-draft')
                    AND meta.meta_key='_customer_user'
                    AND orden.ID IN ({$orderIdsArrStr})" , '');

                $results = $wpdb->get_results($query);

                if ( !empty( $results ) ) {
                    $OrderXML = '<?xml version="1.0"?>
                <OpenShipments xmlns="x-schema:OpenShipments.xdr">';

                    foreach($results as $result) {

                        $OrderId=$result->order_number;
                        $user_email=$result->user_email;
                        $user_id=$result->user_id;
                       $NewOrderID=get_post_meta( $OrderId, "_order_number", true );
@Netzie

This comment has been minimized.

Copy link

commented Nov 4, 2018

Any chance this could be updated?
Maybe even combined with this: https://stackoverflow.com/questions/45701473/add-the-order-total-weight-to-woocommerce-new-order-email-notification
And to make it complete - For the customers too?: like this: https://da.wordpress.org/plugins/woo-order-weight/
One plugin to rule them all :-)

@MarkPraschan

This comment has been minimized.

Copy link

commented Jan 10, 2019

Lines 10-14 saved me! Thanks @kloon!

@famousmrthomas

This comment has been minimized.

Copy link

commented May 2, 2019

You sir are awesome! :)

@wealthyone

This comment has been minimized.

Copy link

commented May 6, 2019

is there anyway this can be added to the Order page? ( the page with all the details on it)
Seems it is only on the Orders list)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.