WooCommerce:获取所有产品变型的SKU [英] WooCommerce: Get SKUs of all product variations

问题描述

我有一个产品清单，该清单应在其自己的行中显示变化. 到目前为止，该代码可以正常工作.

I have a list of products which should show variations in it's own row. The code for that works fine so far.

但是我不知道如何显示变化的SKU.

But I couldn't figure out how I could show the SKU of a variation.

这是我当前的代码:

$args = [
    'status'    => array('publish', 'draft'),
    'orderby'   => 'name',
    'order'     => 'ASC',
    'limit'     => -1,
];
$vendor_products = wc_get_products($args);

$list_array = array();

foreach ($vendor_products as $key => $product) {

    if ($product->get_type() == "variable") {

        foreach ($product->get_variation_attributes() as $variations) {
            foreach ($variations as $variation) {

                $list_array[] = array(
                    'SKU'      => $product->get_sku(),
                    'Name'     => $product->get_title() . " - " . $variation,
                );

            }
        }

    } else {

        $list_array[] = array(
            'SKU'      => $product->get_sku(),
            'Name'     => $product->get_title(),
        );


    }
}

return $list_array;

我尝试显示产品属性，还尝试获取版本ID. 什么都不适合我?！

I tried to display the product attributes and I also tried to get the ID of the variation. Nothing works for me?!

没有简单的方法来获取版本SKU吗?

Is there no simple way to get the variation SKU?

推荐答案

您最好使用WC_Product_Variable

You should better use WC_Product_Variable get_children() method like:

$args = [
    'status'    => array('publish', 'draft'),
    'orderby'   => 'name',
    'order'     => 'ASC',
    'limit'     => -1,
];
$vendor_products = wc_get_products($args);

$list_array = array();

foreach ($vendor_products as $key => $product) {

    if ( $product->is_type( "variable" ) ) {

        foreach ( $product->get_children( false ) as $child_id ) {
            // get an instance of the WC_Variation_product Object
            $variation = wc_get_product( $child_id ); 

            if ( ! $variation || ! $variation->exists() ) {
                continue;
            }

            $list_array[] = array(
                'SKU'      => $variation->get_sku(),
                'Name'     => $product->get_name() . " - " . $child_id,
            );
        }

    } else {

        $list_array[] = array(
            'SKU'      => $product->get_sku(),
            'Name'     => $product->get_name(),
        );

    }

}

return $list_array;

甚至其他一些可用的方法，例如 get_available_variations() (在查看其源代码时使用get_children()方法).它应该更好地工作...

Or even some other available methods like get_available_variations() (which use get_children() method when looking at its source code). It should better work...

定位具有不同于"publish""的其他发布状态的变量产品的产品变体.

Targeting product variations of a variable product with different other post statuses than "publish".

在这种情况下，您应该用自定义WP_Query替换get_children()方法，该自定义WP_Query将处理如下所示的其他发布状态:

In this case you should replace get_children() method with a custom WP_Query that will handle other post statuses like below:

$statuses = array('publish', 'draft');

// Args on the main query for WC_Product_Query
$args = [
    'status'    => $statuses,
    'orderby'   => 'name',
    'order'     => 'ASC',
    'limit'     => -1,
];

$vendor_products = wc_get_products($args);

$list_array = array();

foreach ($vendor_products as $key => $product) {

    if ($product->get_type() == "variable") {

        // Args on product variations query for a variable product using a WP_Query
        $args2 = array( 
            'post_parent' => $product->get_id(), 
            'post_type'   => 'product_variation', 
            'orderby'     => array( 'menu_order' => 'ASC', 'ID' => 'ASC' ), 
            'fields'      => 'ids', 
            'post_status' => $statuses, 
            'numberposts' => -1, 
        ); 

        foreach ( get_posts( $args2 ) as $child_id ) {
            // get an instance of the WC_Variation_product Object
            $variation = wc_get_product( $child_id ); 

            if ( ! $variation || ! $variation->exists() ) {
                continue;
            }

            $list_array[] = array(
                'SKU'      => $variation->get_sku(),
                'Name'     => $product->get_name() . " - " . $child_id,
            );
        }

    } else {

        $list_array[] = array(
            'SKU'      => $product->get_sku(),
            'Name'     => $product->get_name(),
        );

    }

}

return $list_array;

这次，您将获得可变产品的所有产品变体.

This time you will get all the product variations of your variable products.

供参考:产品-> Get Children不会返回所有版本#13469

这篇关于WooCommerce:获取所有产品变型的SKU的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！