問題描述

這有點(diǎn)奇怪，但我很難找到如何做到這一點(diǎn)的答案:

This is a bit of an odd one, but I'm having trouble finding an answer for how to do this:

我正在嘗試創(chuàng)建一個自定義查詢，以獲取 WooCommerce 訂單中包含的所有產(chǎn)品(及其元數(shù)據(jù)).

I'm attempting to create a custom query that gets all the products (and their meta) which are contained within a WooCommerce order.

例如，假設(shè)我有這些訂單待處理:

For example, let's say I have these orders pending:

• 產(chǎn)品 1
• 產(chǎn)品 2
• 產(chǎn)品 3

• 產(chǎn)品 4
• 產(chǎn)品 5
• 產(chǎn)品 6

我的目標(biāo)是根據(jù)這些訂購的產(chǎn)品創(chuàng)建一個列表，該列表按產(chǎn)品的元進(jìn)行排序.像這樣:

My goal is to create a list based off these ordered products, which is ordered by the product's meta. Something like this:

• 產(chǎn)品 1
• 產(chǎn)品 3
• 產(chǎn)品 4

但同樣，這些只能是訂單中的產(chǎn)品(包括數(shù)量).

But again, these would only be products (including their quantities) that sit within an order.

我面臨的問題是訂購商品"和訂單項(xiàng)元"存儲在數(shù)據(jù)庫中的數(shù)據(jù)非常有限，并且不會顯示與產(chǎn)品相關(guān)的所有信息.因此，換句話說，我沒有找到一種方法來獲取創(chuàng)建循環(huán)以創(chuàng)建我的列表所需的信息.

The problem I'm facing is that "Order Items" and "Order Item Meta" as stored in the database are quite limiting and do not display all the information associated with a product. So in other words, I'm not finding a way to get to the info I need to create the loop to create my list.

我的數(shù)據(jù)庫技能有限，因此不勝感激！

My DB skills are limited so ideas would be appreciated!

推薦答案

以下是一些可能對您有所幫助的相關(guān)代碼:

Here is some related code that might help you:

add_filter( 'woocommerce_shop_order_search_fields', 'woocommerce_shop_order_search_product_cat' );

function woocommerce_shop_order_search_product_cat( $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) {
            $product_cats = wp_get_post_terms( $item['product_id'], 'product_cat' );
            foreach($product_cats as $product_cat) {
                add_post_meta($order_id, "_product_cat", $product_cat->name);
            }
        }
    }
};

$search_fields[] = '_product_cat';

return $search_fields;

}

這篇關(guān)于WooCommerce 按產(chǎn)品元查詢訂單項(xiàng)的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！