テンプレートページのwoocommerceのカスタムループを介して注目の製品を表示する

Question

テンプレートページのwoocommerceのカスタムループを介して注目の製品を表示する

22

71438 2015-07-23

woocommerceストアの6つの注目商品をhome-page.phpテンプレートに表示したいと思います.いくつかの調査の結果、これを行う正しい方法はカスタムループを使用することであることがわかりました(スタイリングなどのクラスを追加したいので、ショートコードは使用したくありません).また、woocommerceが使用するキーが注目の製品は「_featured」です.以下のコードをまとめて、ストアで注目の商品として選択した商品を表示しましたが、機能しません...助けていただければ幸いです.

 <?php

    $args = array(
        'post_type'   => 'product',
        'stock'       => 1,
        'showposts'   => 6,
        'orderby'     => 'date',
        'order'       => 'DESC' ,
        'meta_query'  => array(
            array(
                'key'     => '_featured',
                'value'   => 0,
                'compare' => '>',
                'type'    => 'numeric'
            )
        )
    );

    $loop = new WP_Query( $args );
    while ( $loop->have_posts() ) : $loop->the_post(); global $product; ?>

        <li>    
            <?php 
                if ( has_post_thumbnail( $loop->post->ID ) ) 
                    echo get_the_post_thumbnail( $loop->post->ID, 'shop_catalog' ); 
                else 
                    echo '<img src="' . woocommerce_placeholder_img_src() . '" alt="Placeholder" width="65px" height="115px" />'; 
            ?>
            <h3><?php the_title(); ?></h3>

            <?php 
                echo $product->get_price_html(); 
                woocommerce_template_loop_add_to_cart( $loop->post, $product );
            ?>    
        </li>

<?php 
    endwhile;
    wp_reset_query(); 
?>

I would like to display 6 featured products from my woocommerce store on my home-page.php template. After some researched I found that the right way to do this was through a custom loop,( I do not wish to use shortcodes because I would like to add additional classes for styling etc. ) I also found that the key that woocommerce uses for the featured products is '_featured'. I put together the code below to display any products that I chose to be featured products in my store, but it doesn't work... Any help is appreciated.

<?php

    $args = array(
        'post_type'   => 'product',
        'stock'       => 1,
        'showposts'   => 6,
        'orderby'     => 'date',
        'order'       => 'DESC' ,
        'meta_query'  => array(
            array(
                'key'     => '_featured',
                'value'   => 0,
                'compare' => '>',
                'type'    => 'numeric'
            )
        )
    );

    $loop = new WP_Query( $args );
    while ( $loop->have_posts() ) : $loop->the_post(); global $product; ?>

        <li>    
            <?php 
                if ( has_post_thumbnail( $loop->post->ID ) ) 
                    echo get_the_post_thumbnail( $loop->post->ID, 'shop_catalog' ); 
                else 
                    echo '<img src="' . woocommerce_placeholder_img_src() . '" alt="Placeholder" width="65px" height="115px" />'; 
            ?>
            <h3><?php the_title(); ?></h3>

            <?php 
                echo $product->get_price_html(); 
                woocommerce_template_loop_add_to_cart( $loop->post, $product );
            ?>    
        </li>

<?php 
    endwhile;
    wp_reset_query(); 
?>

- `var_dump(get_meta_values( '_featured'、 'product');`の結果を追加します.ここで、関数 `get_meta_values`は、[この回答](http://wordpress.stackexchange.com/a/)で説明されているカスタム関数によってサポートされています.9451/31545)
  
  Add the result from `var_dump( get_meta_values( '_featured', 'product' );` where the function `get_meta_values` is supported by the custom function explained in [this answer](http://wordpress.stackexchange.com/a/9451/31545)
  - 0
  - 2015-07-24
  - Pieter Goosen

9 回答

投票

23

2017-05-08

これはWooCommerce3.0で変更されました.これは単なるmeta_queryではなく、tax_queryが含まれるようになりました.議論は今:

     $meta_query  = WC()->query->get_meta_query();
    $tax_query   = WC()->query->get_tax_query();
    $tax_query[] = array(
        'taxonomy' => 'product_visibility',
        'field'    => 'name',
        'terms'    => 'featured',
        'operator' => 'IN',
    );

    $args = array(
        'post_type'           => 'product',
        'post_status'         => 'publish',
        'ignore_sticky_posts' => 1,
        'posts_per_page'      => $atts['per_page'],
        'orderby'             => $atts['orderby'],
        'order'               => $atts['order'],
        'meta_query'          => $meta_query,
        'tax_query'           => $tax_query,
    );

woocommerce/contains/class-wc-shortcodes.phpを参照

This has changed in WooCommerce 3.0. It's not simply a meta_query, but now includes a tax_query. The arguments are now:

    $meta_query  = WC()->query->get_meta_query();
    $tax_query   = WC()->query->get_tax_query();
    $tax_query[] = array(
        'taxonomy' => 'product_visibility',
        'field'    => 'name',
        'terms'    => 'featured',
        'operator' => 'IN',
    );

    $args = array(
        'post_type'           => 'product',
        'post_status'         => 'publish',
        'ignore_sticky_posts' => 1,
        'posts_per_page'      => $atts['per_page'],
        'orderby'             => $atts['orderby'],
        'order'               => $atts['order'],
        'meta_query'          => $meta_query,
        'tax_query'           => $tax_query,
    );

See woocommerce/includes/class-wc-shortcodes.php

まさに私が探していたものです！

Just what I was looking for!
- 1
- 2018-05-10
- joshkrz
また、Woocommerce 3.0の場合、 `woocommerce_placeholder_img_src`の代わりに` wc_placeholder_img_src`を使用することをお勧めします.

Also for Woocommerce 3.0, they recommend using `wc_placeholder_img_src` instead of `woocommerce_placeholder_img_src`.
- 0
- 2018-05-25
- Robotnicka

6

2017-12-24

WooCommerce3の注目製品ループ

 <ul class="products">
<?php
$args = array(
    'post_type' => 'product',
    'posts_per_page' => 12,
    'tax_query' => array(
            array(
                'taxonomy' => 'product_visibility',
                'field'    => 'name',
                'terms'    => 'featured',
            ),
        ),
    );
$loop = new WP_Query( $args );
if ( $loop->have_posts() ) {
    while ( $loop->have_posts() ) : $loop->the_post();
        wc_get_template_part( 'content', 'product' );
    endwhile;
} else {
    echo __( 'No products found' );
}
wp_reset_postdata();
?>

Featured Products Loop in WooCommerce 3

<ul class="products">
<?php
$args = array(
    'post_type' => 'product',
    'posts_per_page' => 12,
    'tax_query' => array(
            array(
                'taxonomy' => 'product_visibility',
                'field'    => 'name',
                'terms'    => 'featured',
            ),
        ),
    );
$loop = new WP_Query( $args );
if ( $loop->have_posts() ) {
    while ( $loop->have_posts() ) : $loop->the_post();
        wc_get_template_part( 'content', 'product' );
    endwhile;
} else {
    echo __( 'No products found' );
}
wp_reset_postdata();
?>

- 6
- 2018-05-24
WooCommerce Wiki によると:

[製品を取得するために]カスタムWP_Queriesまたはデータベースクエリを作成すると、データがカスタムテーブルに移動してパフォーマンスが向上するため、WooCommerceの将来のバージョンでコードが破損する可能性があります.

WooCommerceは、wc_get_products()またはWC_Product_Query()の代わりにWP_Query()またはget_posts()を使用することを提唱しています.

ここであなたが望むことを達成するために使用したコードで投稿を書きました: https://cfxdesign.com/create-a-custom-woocommerce-product-loop-the-right-way/

According to the WooCommerce Wiki:

Building custom WP_Queries or database queries [to retrieve products] is likely to break your code in future versions of WooCommerce as data moves towards custom tables for better performance.

WooCommerce advocates using wc_get_products() or WC_Product_Query() instead of WP_Query() or get_posts().

I've written a post with the code I used to achieve what you want here: https://cfxdesign.com/create-a-custom-woocommerce-product-loop-the-right-way/
- 申し訳ありませんが、いくつかの書かれたコードを見ずに、あなたの記事を理解するのは難しいです.コーディングを含めていただけますか?
  
  sorry, without seeing some written code, it is hard to understand your article. Can you please include some coding ?
  - 0
  - 2019-06-05
  - HOY
- @HOY埋め込みプラグインが壊れていました.これで修正され、コードが表示されます.
  
  @HOY the embed plugin was broken; it's fixed now and you can see the code!
  - 0
  - 2019-06-05
  - cfx
- ありがとう、解決策を探している間、私はこれを以下で思いついた.完全にチェックできなかったので、あなたとどう違うのかわかりませんが、非常に短く、カスタム製品のループを手伝ってくれました.https://www.kathyisawesome.com/woocommerce-modifying-product-query/
  
  thank you, while looking for solutions, I came up with this one below. I am not sure how it differs from yours since I was not able to check yours throughly but it is very short and helped me with a custom product loop. https://www.kathyisawesome.com/woocommerce-modifying-product-query/
  - 0
  - 2019-06-05
  - HOY
- 2
- 2018-04-28
これはかなり古いことはわかっていますが、別の解決策をここで共有したところです.このトピックに到達した人も.

meta_queryまたはtax_queryを使用する代わりに、 wc_get_featured_product_ids()も:

$args = array( 'post_type' => 'product', 'posts_per_page' => 6, 'orderby' => 'date', 'order' => 'DESC', 'post__in' => wc_get_featured_product_ids(), ); $query = new WP_Query( $args );

お役に立てば幸いです！
I know this is quite old, but I've just shared an alternative solution here and I think it can help those reaching this topic too.

Instead of using meta_query or tax_query, you can use wc_get_featured_product_ids() too:

$args = array( 'post_type' => 'product', 'posts_per_page' => 6, 'orderby' => 'date', 'order' => 'DESC', 'post__in' => wc_get_featured_product_ids(), ); $query = new WP_Query( $args );

I hope it helps!

1

2018-09-26

ベース: https://github.com/woocommerce/woocommerce/wiki/wc_get_products-and-WC_Product_Query

試してみます:

外側のループ:

 $args = array (
'limit' => 6,
'orderby' => 'title',
'order' => 'ASC',
'category' => $club_cat,
'stock_status' => 'instock',
'featured' => true,

 );

 $products = wc_get_products( $args );

ループ内:

 $query = new WC_Product_Query( array(
'limit' => 6,
'orderby' => 'title',
'order' => 'ASC',
'category' => $club_cat,
'stock_status' => 'instock',
'featured' => true,
'return' => 'ids',

 ) );

 $products = $query->get_products();

Based on: https://github.com/woocommerce/woocommerce/wiki/wc_get_products-and-WC_Product_Query

I would try:

outside loop:

$args = array (
'limit' => 6,
'orderby' => 'title',
'order' => 'ASC',
'category' => $club_cat,
'stock_status' => 'instock',
'featured' => true,

 );

 $products = wc_get_products( $args );

in the loop:

$query = new WC_Product_Query( array(
'limit' => 6,
'orderby' => 'title',
'order' => 'ASC',
'category' => $club_cat,
'stock_status' => 'instock',
'featured' => true,
'return' => 'ids',

 ) );

 $products = $query->get_products();

1

2020-07-12

woocommerceによると、これが製品を取得する標準的な方法であるため、人々はwc_get_productsの使用を開始する必要があります. wc_get_productsには、trueに設定する必要がある引数があります.したがって、コードは以下のとおりです.

  <?php 

// Display featured products by category. on this case its "shirts" which is the slug of the category.
$query_args = array(
    'featured' => true,  
    'category' => array( 'shirts' ),
);
$products = wc_get_products( $query_args );

global $post;
$columns = wc_get_loop_prop( 'columns' );
?>
<div class="woocommerce columns-<?php echo esc_attr( $columns ); ?>">
  <?php
    woocommerce_product_loop_start();
    foreach ($products as $product) {
        $post = get_post($product->get_id());
        setup_postdata($post);
        wc_get_template_part('content', 'product');
    }
    wp_reset_postdata();
    woocommerce_product_loop_end();
  ?>
</div>

ここで投稿全体を参照してください: https://jameshwartlopez.com/plugin/get-featured-products-of-a-category/

People should start using wc_get_products because woocommerce said this is the standard way of retrieving product. wc_get_products has an argument featured which just needs to be set to true. So the code is simply below.

 <?php 

// Display featured products by category. on this case its "shirts" which is the slug of the category.
$query_args = array(
    'featured' => true,  
    'category' => array( 'shirts' ),
);
$products = wc_get_products( $query_args );

global $post;
$columns = wc_get_loop_prop( 'columns' );
?>
<div class="woocommerce columns-<?php echo esc_attr( $columns ); ?>">
  <?php
    woocommerce_product_loop_start();
    foreach ($products as $product) {
        $post = get_post($product->get_id());
        setup_postdata($post);
        wc_get_template_part('content', 'product');
    }
    wp_reset_postdata();
    woocommerce_product_loop_end();
  ?>
</div>

See full post here: https://jameshwartlopez.com/plugin/get-featured-products-of-a-category/

0

2016-07-11

wp_postmeta テーブルのデータベースを見ると、meta_key が _featured とmeta_value は yes またはno になるため、値 0 または 1 の代わりに yes と記述します.またはno



 ＆lt;?php
    $ q=new WP_Query([
      'post_type'=＆gt;'製品'、
      '在庫'=＆gt;1、
      'ショーポスト'=＆gt;3、
      'orderby'=＆gt;'日付'、
      '注文'=＆gt;「DESC」、
      'meta_query'=＆gt;[
        ['キー'=＆gt;'_featured'、 'value'=＆gt;'はい' ]
        ]
    ]);
 if($ q-＆gt; have_posts()):
        while($ q-＆gt; have_posts()):$ q-＆gt;the_post();
//製品情報を表示します
        終わり;wp_reset_query();
 endif;
?＆gt;


                                                                        if you take a look in the database in wp_postmeta table you will see meta_key will be _featured and meta_value will be yes or no so instead of value 0 or 1 write yes or no    

<?php
    $q = new WP_Query([
      'post_type'   =>  'product',
      'stock'       =>  1,
      'showposts'   =>  3,
      'orderby'     =>  'date',
      'order'       =>  'DESC',
      'meta_query'  =>  [ 
        ['key' => '_featured', 'value' => 'yes' ]
        ]
    ]);
    if ( $q->have_posts() ) :
        while ( $q->have_posts() ) : $q->the_post();
            // display product info
        endwhile; wp_reset_query();
    endif;
?>


                                                                        
                                                                        
                                                                        
                                                                        
                                                                            
                                                                                
                                                                                    
                                                                                    ソース
                                                                                
                                                                            
                                                                            
                                                                                
                                                                                    
                                                                                    Aamer Shahzad


                                                    
                                                        
                                                            

                                                                
                                                                    
                                                                        
                                                                            
                                                                            
                                                                                0
                                                                            
                                                                            
                                                                        
                                                                    
                                                                    
                                                                    
                                                                        
                                                                            
                                                                        
                                                                    
                                                                    
                                                                        
                                                                            
                                                                            2019-04-03
                                                                        
                                                                    
                                                                    
                                                                         <ul class="products">
    <?php
        $args = array(
            'post_type' => 'product',
            'posts_per_page' => 12,
            'tax_query' => array(
                    array(
                        'taxonomy' => 'product_visibility',
                        'field'    => 'name',
                        'terms'    => 'featured',
                    ),
                ),
            );
        $loop = new WP_Query( $args );
        if ( $loop->have_posts() ) {
            while ( $loop->have_posts() ) : $loop->the_post();
               echo '<p>'.get_the_title().'</p>';
            endwhile;
        } else {
            echo __( 'No products found' );
        }
        wp_reset_postdata();
    ?>
</ul><!--/.products-->
 
                                                                        <ul class="products">
    <?php
        $args = array(
            'post_type' => 'product',
            'posts_per_page' => 12,
            'tax_query' => array(
                    array(
                        'taxonomy' => 'product_visibility',
                        'field'    => 'name',
                        'terms'    => 'featured',
                    ),
                ),
            );
        $loop = new WP_Query( $args );
        if ( $loop->have_posts() ) {
            while ( $loop->have_posts() ) : $loop->the_post();
               echo '<p>'.get_the_title().'</p>';
            endwhile;
        } else {
            echo __( 'No products found' );
        }
        wp_reset_postdata();
    ?>
</ul><!--/.products-->


                                                                        
                                                                        
                                                                        
                                                                        
                                                                            
                                                                                
                                                                                    
                                                                                    ソース
                                                                                
                                                                            
                                                                            
                                                                                
                                                                                    
                                                                                    Dhaval
                                                                                
                                                                            
                                                                            
                                                                                
                                                                                    
                                                                                        
                                                                                    
                                                                                    
                                                                                        
                                                                                    
                                                                                    
                                                                                        
                                                                                    
                                                                                    
                                                                                        
                                                                                    
                                                                                    
                                                                                        
                                                                                    
                                                                                    
                                                                                        
                                                                                    
                                                                                
                                                                            
                                                                            
                                                                        
                                                                    
                                                                    
                                                                
                                                            
                                                            
                                                                
                                                                    
                                                                        
                                                                            
                                                                                
                                                                                    ** [編集]あなたの答え**と説明を追加してください:**なぜ**それが問題を解決できるのでしょうか?
                                                                                    Please **[edit] your answer**, and add an explanation: **why** could that solve the problem?
                                                                                    
                                                                                    
                                                                                    
                                                                                
                                                                                
                                                                                    
                                                                                        
                                                                                    
                                                                                    0
                                                                                    2019-04-03
                                                                                    
                                                                                        
                                                                                            
                                                                                            fuxia

Hooman Askari · Accepted Answer · 2015-09-15

17

2015-09-15

引数を次のように変更します:

 $meta_query   = WC()->query->get_meta_query();
$meta_query[] = array(
    'key'   => '_featured',
    'value' => 'yes'
);
$args = array(
    'post_type'   =>  'product',
    'stock'       =>  1,
    'showposts'   =>  6,
    'orderby'     =>  'date',
    'order'       =>  'DESC',
    'meta_query'  =>  $meta_query
);

wp-content/plugins/woocommerce/contains/class-wc-shortcodes.php(@ 595)にアクセスすると、WCショートコードに対してどのように行われるかを確認できます.

Change your args to be like this:

$meta_query   = WC()->query->get_meta_query();
$meta_query[] = array(
    'key'   => '_featured',
    'value' => 'yes'
);
$args = array(
    'post_type'   =>  'product',
    'stock'       =>  1,
    'showposts'   =>  6,
    'orderby'     =>  'date',
    'order'       =>  'DESC',
    'meta_query'  =>  $meta_query
);

If you go to wp-content/plugins/woocommerce/includes/class-wc-shortcodes.php (@595) you can find how it's done for WC shortcodes.

注意すべき重要な点は、「_featured」は数値として保存されないということです.文字列「yes」または「no」として格納されます.OPの質問の他のすべてが機能するはずで、私のために機能しました.

They key to note is that '_featured' is not stored as a numeric value. It is stored as a string 'yes' or 'no'. Everything else in the OP question should work, worked for me.
- 3
- 2016-07-03
- i_a
WooCommerce 3.0以降、このソリューションは機能しなくなりました.以下の私の更新された答えを参照してください.

As of WooCommerce 3.0, this solution no longer works. Please see my updated answer below.
- 1
- 2018-06-12
- dpruth