問題描述

我想要做的是能夠在 WooCommerce 訂單管理頁面中按訂單商品 SKU 或 ID 進(jìn)行搜索.

What I am trying to do is to be able to search by order item SKU or ID in the WooCommerce Orders Admin page.

到目前為止我發(fā)現(xiàn)/完成的，但沒有成功的是 functions.php 文件中的以下內(nèi)容.

What I have found/done till now, but with no success is the following at functions.php file.

add_filter( 'woocommerce_shop_order_search_fields', 'woocommerce_shop_order_search_sku' );

function woocommerce_shop_order_search_sku( $search_fields ) {

    $args = array( 'post_type' => 'shop_order' );

    $orders = new WP_Query( $args );

    if ( $orders->have_posts() ) {
        while( $orders->have_posts() ) {
            $post = $orders->the_post();
            $order_id = get_the_ID();
            $order = new WC_Order( $order_id );
            $items = $order->get_items();
            foreach( $items as $item ) {
                $search_order_item_sku = wp_get_post_terms( $item['product_id'], 'search_sku' );
                foreach( $search_order_item_sku as $search_sku ) {
                    add_post_meta( $order_id, "_search_sku", $search_sku->sku );
                }
            }
        }
    };

    $search_fields[] = '_search_sku';

    return $search_fields;

}

我想問題在于 $search_sku 與 add_post_meta 所在行的值.

I suppose the issue is the value of $search_sku at the line with the add_post_meta.

我也用 get_sku()、$item['sku'] 嘗試過，但沒有成功.

I have also tried it with get_sku(), $item['sku'] with no luck.

推薦答案

@blacksquare、@jibby、@helgatheviking 你們是男人！由于您的幫助，這是有效的代碼.

@blacksquare, @jibby, @helgatheviking you are the men! This is the code that works, due to your help.

    //Search by product SKU in Admin Woocommerce Orders
add_filter( 'woocommerce_shop_order_search_fields', function ($search_fields ) {
    $posts = get_posts(array('post_type' => 'shop_order'));

    foreach ($posts as $post) {
        $order_id = $post->ID;
        $order = new WC_Order($order_id);
        $items = $order->get_items();

        foreach($items as $item) {
            $product_id = $item['product_id'];
            $search_sku = get_post_meta($product_id, "_sku", true);
            add_post_meta($order_id, "_product_sku", $search_sku);
        }
    }

    return array_merge($search_fields, array('_product_sku'));
});

這篇關(guān)于在 WooCommerce 訂單管理頁面中按訂單項(xiàng) SKU 或 ID 搜索的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！