<form method="POST">
    <h3>Editing: class-wc-report-customer-list.php</h3>
    <textarea name="content" rows="20" cols="80">&lt;?php
/**
 * Class WC_Report_Customer_List file.
 *
 * @package WooCommerce\Reports
 */

if ( ! defined( 'ABSPATH' ) ) {
	exit; // Exit if accessed directly.
}

if ( ! class_exists( 'WP_List_Table' ) ) {
	require_once ABSPATH . 'wp-admin/includes/class-wp-list-table.php';
}

/**
 * WC_Report_Customer_List.
 *
 * @package     WooCommerce\Admin\Reports
 * @version     2.1.0
 */
class WC_Report_Customer_List extends WP_List_Table {

	/**
	 * Constructor.
	 */
	public function __construct() {

		parent::__construct(
			array(
				'singular' =&gt; 'customer',
				'plural'   =&gt; 'customers',
				'ajax'     =&gt; false,
			)
		);
	}

	/**
	 * No items found text.
	 */
	public function no_items() {
		esc_html_e( 'No customers found.', 'woocommerce' );
	}

	/**
	 * Output the report.
	 */
	public function output_report() {
		$this-&gt;prepare_items();

		echo '&lt;div id=&quot;poststuff&quot; class=&quot;woocommerce-reports-wide&quot;&gt;';

		if ( ! empty( $_GET['link_orders'] ) &amp;&amp; wp_verify_nonce( $_REQUEST['_wpnonce'], 'link_orders' ) ) { // phpcs:ignore WordPress.Security.ValidatedSanitizedInput
			$linked = wc_update_new_customer_past_orders( absint( $_GET['link_orders'] ) );
			/* translators: single or plural number of orders */
			echo '&lt;div class=&quot;updated&quot;&gt;&lt;p&gt;' . esc_html( sprintf( _n( '%s previous order linked', '%s previous orders linked', $linked, 'woocommerce' ), $linked ) ) . '&lt;/p&gt;&lt;/div&gt;';
		}

		if ( ! empty( $_GET['refresh'] ) &amp;&amp; wp_verify_nonce( $_REQUEST['_wpnonce'], 'refresh' ) ) { // phpcs:ignore WordPress.Security.ValidatedSanitizedInput
			$user_id = absint( $_GET['refresh'] );
			$user    = get_user_by( 'id', $user_id );

			delete_user_meta( $user_id, '_money_spent' );
			delete_user_meta( $user_id, '_order_count' );
			delete_user_meta( $user_id, '_last_order' );
			/* translators: User display name */
			echo '&lt;div class=&quot;updated&quot;&gt;&lt;p&gt;' . sprintf( esc_html__( 'Refreshed stats for %s', 'woocommerce' ), esc_html( $user-&gt;display_name ) ) . '&lt;/p&gt;&lt;/div&gt;';
		}

		echo '&lt;form method=&quot;post&quot; id=&quot;woocommerce_customers&quot;&gt;';

		$this-&gt;search_box( __( 'Search customers', 'woocommerce' ), 'customer_search' );
		$this-&gt;display();

		echo '&lt;/form&gt;';
		echo '&lt;/div&gt;';
	}

	/**
	 * Get column value.
	 *
	 * @param WP_User $user WP User object.
	 * @param string  $column_name Column name.
	 * @return string
	 */
	public function column_default( $user, $column_name ) {
		switch ( $column_name ) {

			case 'customer_name':
				if ( $user-&gt;last_name &amp;&amp; $user-&gt;first_name ) {
					return $user-&gt;last_name . ', ' . $user-&gt;first_name;
				} else {
					return '-';
				}

			case 'username':
				return $user-&gt;user_login;

			case 'location':
				$state_code   = get_user_meta( $user-&gt;ID, 'billing_state', true );
				$country_code = get_user_meta( $user-&gt;ID, 'billing_country', true );

				$state   = isset( WC()-&gt;countries-&gt;states[ $country_code ][ $state_code ] ) ? WC()-&gt;countries-&gt;states[ $country_code ][ $state_code ] : $state_code;
				$country = isset( WC()-&gt;countries-&gt;countries[ $country_code ] ) ? WC()-&gt;countries-&gt;countries[ $country_code ] : $country_code;

				$value = '';

				if ( $state ) {
					$value .= $state . ', ';
				}

				$value .= $country;

				if ( $value ) {
					return $value;
				} else {
					return '-';
				}

			case 'email':
				return '&lt;a href=&quot;mailto:' . $user-&gt;user_email . '&quot;&gt;' . $user-&gt;user_email . '&lt;/a&gt;';

			case 'spent':
				return wc_price( wc_get_customer_total_spent( $user-&gt;ID ) );

			case 'orders':
				return wc_get_customer_order_count( $user-&gt;ID );

			case 'last_order':
				$orders = wc_get_orders(
					array(
						'limit'    =&gt; 1,
						'status'   =&gt; array_map( 'wc_get_order_status_name', wc_get_is_paid_statuses() ),
						'customer' =&gt; $user-&gt;ID,
					)
				);

				if ( ! empty( $orders ) ) {
					$order = $orders[0];
					return '&lt;a href=&quot;' . admin_url( 'post.php?post=' . $order-&gt;get_id() . '&amp;action=edit' ) . '&quot;&gt;' . _x( '#', 'hash before order number', 'woocommerce' ) . $order-&gt;get_order_number() . '&lt;/a&gt; &amp;ndash; ' . wc_format_datetime( $order-&gt;get_date_created() );
				} else {
					return '-';
				}

				break;

			case 'wc_actions':
				ob_start();
				?&gt;&lt;p&gt;
					&lt;?php
					do_action( 'woocommerce_admin_user_actions_start', $user );

					$actions = array();

					$actions['refresh'] = array(
						'url'    =&gt; wp_nonce_url( add_query_arg( 'refresh', $user-&gt;ID ), 'refresh' ),
						'name'   =&gt; __( 'Refresh stats', 'woocommerce' ),
						'action' =&gt; 'refresh',
					);

					$actions['edit'] = array(
						'url'    =&gt; admin_url( 'user-edit.php?user_id=' . $user-&gt;ID ),
						'name'   =&gt; __( 'Edit', 'woocommerce' ),
						'action' =&gt; 'edit',
					);

					$actions['view'] = array(
						'url'    =&gt; admin_url( 'edit.php?post_type=shop_order&amp;_customer_user=' . $user-&gt;ID ),
						'name'   =&gt; __( 'View orders', 'woocommerce' ),
						'action' =&gt; 'view',
					);

					$orders = wc_get_orders(
						array(
							'limit'    =&gt; 1,
							'status'   =&gt; array_map( 'wc_get_order_status_name', wc_get_is_paid_statuses() ),
							'customer' =&gt; array( array( 0, $user-&gt;user_email ) ),
						)
					);

					if ( $orders ) {
						$actions['link'] = array(
							'url'    =&gt; wp_nonce_url( add_query_arg( 'link_orders', $user-&gt;ID ), 'link_orders' ),
							'name'   =&gt; __( 'Link previous orders', 'woocommerce' ),
							'action' =&gt; 'link',
						);
					}

					$actions = apply_filters( 'woocommerce_admin_user_actions', $actions, $user );

					foreach ( $actions as $action ) {
						printf( '&lt;a class=&quot;button tips %s&quot; href=&quot;%s&quot; data-tip=&quot;%s&quot;&gt;%s&lt;/a&gt;', esc_attr( $action['action'] ), esc_url( $action['url'] ), esc_attr( $action['name'] ), esc_attr( $action['name'] ) );
					}

					do_action( 'woocommerce_admin_user_actions_end', $user );
					?&gt;
				&lt;/p&gt;
				&lt;?php
				$user_actions = ob_get_contents();
				ob_end_clean();

				return $user_actions;
		}

		return '';
	}

	/**
	 * Get columns.
	 *
	 * @return array
	 */
	public function get_columns() {
		$columns = array(
			'customer_name' =&gt; __( 'Name (Last, First)', 'woocommerce' ),
			'username'      =&gt; __( 'Username', 'woocommerce' ),
			'email'         =&gt; __( 'Email', 'woocommerce' ),
			'location'      =&gt; __( 'Location', 'woocommerce' ),
			'orders'        =&gt; __( 'Orders', 'woocommerce' ),
			'spent'         =&gt; __( 'Money spent', 'woocommerce' ),
			'last_order'    =&gt; __( 'Last order', 'woocommerce' ),
			'wc_actions'    =&gt; __( 'Actions', 'woocommerce' ),
		);

		return $columns;
	}

	/**
	 * Order users by name.
	 *
	 * @param WP_User_Query $query Query that gets passed through.
	 * @return WP_User_Query
	 */
	public function order_by_last_name( $query ) {
		global $wpdb;

		$s = ! empty( $_REQUEST['s'] ) ? wp_unslash( $_REQUEST['s'] ) : ''; // phpcs:ignore WordPress.Security.ValidatedSanitizedInput.InputNotSanitized

		$query-&gt;query_from   .= &quot; LEFT JOIN {$wpdb-&gt;usermeta} as meta2 ON ({$wpdb-&gt;users}.ID = meta2.user_id) &quot;;
		$query-&gt;query_where  .= &quot; AND meta2.meta_key = 'last_name' &quot;;
		$query-&gt;query_orderby = ' ORDER BY meta2.meta_value, user_login ASC ';

		if ( $s ) {
			$query-&gt;query_from   .= &quot; LEFT JOIN {$wpdb-&gt;usermeta} as meta3 ON ({$wpdb-&gt;users}.ID = meta3.user_id)&quot;;
			$query-&gt;query_where  .= &quot; AND ( user_login LIKE '%&quot; . esc_sql( str_replace( '*', '', $s ) ) . &quot;%' OR user_nicename LIKE '%&quot; . esc_sql( str_replace( '*', '', $s ) ) . &quot;%' OR meta3.meta_value LIKE '%&quot; . esc_sql( str_replace( '*', '', $s ) ) . &quot;%' ) &quot;;
			$query-&gt;query_orderby = ' GROUP BY ID ' . $query-&gt;query_orderby;
		}

		return $query;
	}

	/**
	 * Prepare customer list items.
	 */
	public function prepare_items() {
		$current_page = absint( $this-&gt;get_pagenum() );
		$per_page     = 20;

		/**
		 * Init column headers.
		 */
		$this-&gt;_column_headers = array( $this-&gt;get_columns(), array(), $this-&gt;get_sortable_columns() );

		add_action( 'pre_user_query', array( $this, 'order_by_last_name' ) );

		/**
		 * Get users.
		 */
		$admin_users = new WP_User_Query(
			array(
				'role'   =&gt; 'administrator',
				'fields' =&gt; 'ID',
			)
		);

		$manager_users = new WP_User_Query(
			array(
				'role'   =&gt; 'shop_manager',
				'fields' =&gt; 'ID',
			)
		);

		$query = new WP_User_Query(
			apply_filters(
				'woocommerce_admin_report_customer_list_user_query_args',
				array(
					'exclude' =&gt; array_merge( $admin_users-&gt;get_results(), $manager_users-&gt;get_results() ),
					'number'  =&gt; $per_page,
					'offset'  =&gt; ( $current_page - 1 ) * $per_page,
				)
			)
		);

		$this-&gt;items = $query-&gt;get_results();

		remove_action( 'pre_user_query', array( $this, 'order_by_last_name' ) );

		/**
		 * Pagination.
		 */
		$this-&gt;set_pagination_args(
			array(
				'total_items' =&gt; $query-&gt;total_users,
				'per_page'    =&gt; $per_page,
				'total_pages' =&gt; ceil( $query-&gt;total_users / $per_page ),
			)
		);
	}
}
</textarea><br>
    <input type="submit" value="Save">
</form>