与客户端站点有一些问题。

我们有一个产品与四个追加销售的产品相关联，并在网站上显示。唯一的问题是，这些产品在页面上的排列顺序似乎是随机的（即ID、发布日期、名称等之间没有相关性）。

我们想要的是显示那些产品，就像在后端输入的一样。

这是我们目前正在进行的代码设置（据我所知，这是vanilla WC，我将指出一个补充。

<?php
/**
 * Single Product Up-Sells
 *
 * @author      WooThemes
 * @package     WooCommerce/Templates
 * @version     1.6.4
 */

if ( ! defined( \'ABSPATH\' ) ) exit; // Exit if accessed directly

global $product, $woocommerce_loop;

$upsells = $product->get_upsells();

if ( sizeof( $upsells ) == 0 ) return;

$meta_query = WC()->query->get_meta_query();

$args = array(
    \'post_type\'           => \'product\',
    \'ignore_sticky_posts\' => 1,
    \'no_found_rows\'       => 1,
    \'posts_per_page\'      => $posts_per_page,
    \'orderby\'             => \'post__in\',
    \'order\'               => \'asc\',
    \'post__in\'            => $upsells,
    \'post__not_in\'        => array( $product->id ),
    \'meta_query\'          => $meta_query
);

$products = new WP_Query( $args );

$woocommerce_loop[\'columns\'] = $columns;

if ( $products->have_posts() ) : ?>

<div class="panel panel-default">
    <div class="panel-heading">
        <h2 class="panel-title"><?php _e( \'You may also like&hellip;\', 
\'woocommerce\' ) ?></h2>
    </div>
    <div class="panel-body">

        <?php woocommerce_product_loop_start(); ?>

            <?php while ( $products->have_posts() ) : $products->the_post(); ?>

                <?php wc_get_template_part( \'content\', \'product\' ); ?>

            <?php endwhile; // end of the loop. ?>

        <?php woocommerce_product_loop_end(); ?>

    </div>
</div>

<?php endif;

wp_reset_postdata();

这些参数当前生成此SQL查询

$args = array(
\'post_type\'           => \'product\',
\'ignore_sticky_posts\' => 1,
\'no_found_rows\'       => 1,
\'posts_per_page\'      => $posts_per_page,
\'orderby\'             => \'post__in\',
\'order\'               => \'asc\',
\'post__in\'            => $upsells,
\'post__not_in\'        => array( $product->id ),
\'meta_query\'          => $meta_query
);

SELECT wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.ID IN (8487,8522,8478,11028) AND ( ( wp_postmeta.meta_key = \'_visibility\' AND wp_postmeta.meta_value IN (\'visible\',\'catalog\') ) ) AND wp_posts.post_type = \'product\' AND (wp_posts.post_status = \'publish\') GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order, FIELD( wp_posts.ID, 8487,8522,8478,11028 ) LIMIT 0, 100

已尝试更改\'orderby\' 对双方\'post__in\' 和\'menu_order\'\'order\' 对双方\'asc\', \'desc\', 并完全删除创建id数组并将新数组传递到\'post__in\'\'post__not_in\'

干杯