knjght0011 knjght0011 - 1 month ago 30
PHP Question

Displaying shipping zip code in the "Orders" list Admin -> Woocommerce -> Order

How can I display the shipping zip code associated to order in the “Orders” list view? Is there a hook that is available to include the shipping as an item in the individual order row?
Thank you.

//add a column
add_filter( 'manage_edit-shop_order_columns', 'MY_COLUMNS_FUNCTION' );
function MY_COLUMNS_FUNCTION($columns){
$new_columns = (is_array($columns)) ? $columns : array();
unset( $new_columns['order_actions'] );

//edit this for you column(s)
//all of your columns will be added before the actions column
$new_columns['MY_COLUMN_ID_1'] = 'Distro test';
//stop editing

$new_columns['order_actions'] = $columns['order_actions'];
return $new_columns;
}
// add data to column
add_action( 'manage_shop_order_posts_custom_column', 'MY_COLUMNS_VALUES_FUNCTION', 2 );
function MY_COLUMNS_VALUES_FUNCTION($column){
// ***WHAT MUST I DO HERE!!!!!!!!!!!!!!!!***
//stop editing
}
// sort column
add_filter( "manage_edit-shop_order_sortable_columns", 'MY_COLUMNS_SORT_FUNCTION' );
function MY_COLUMNS_SORT_FUNCTION( $columns ) {
$custom = array(
//start editing

'MY_COLUMN_ID_1' => 'MY_COLUMN_1_POST_META_ID'
//stop editing
);
return wp_parse_args( $custom, $columns );
}

Answer

I tested this and that work on the latest woocommerce version. The way to get order data changed since the link i sent you. So test this :

add_filter( 'manage_edit-shop_order_columns', 'MY_COLUMNS_FUNCTION' );
function MY_COLUMNS_FUNCTION($columns){
$new_columns = (is_array($columns)) ? $columns : array();
unset( $new_columns['order_actions'] );

//edit this for you column(s)
//all of your columns will be added before the actions column
$new_columns['zip_code'] = 'Zip Code';
//stop editing

$new_columns['order_actions'] = $columns['order_actions'];
return $new_columns;
}

add_action( 'manage_shop_order_posts_custom_column', 'MY_COLUMNS_VALUES_FUNCTION',10,  2 );
function MY_COLUMNS_VALUES_FUNCTION($column){
global $post, $the_order;

if ( empty( $the_order ) || $the_order->id != $post->ID ) {
    $the_order = wc_get_order( $post->ID );
}

//start editing, I was saving my fields for the orders as custom post meta
//if you did the same, follow this code
if ( $column == 'zip_code' ) {

    echo (isset($the_order->shipping_postcode) ? $the_order->shipping_postcode : '');
}
//stop editing
}