Woocommerce – Changing the order of the upsell products [closed]

Getting too long for a comment, sooo in my super simple test overriding up-sells.php on a fresh WC install with a WP_Query, I can change the orderby and order parameters and the products display in the order of my array of product ids:

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

$my_upsells = [171, 170, 172];

$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'            => $my_upsells,
    'meta_query'          => $meta_query
);

$products = new WP_Query( $args );

while( $products->have_posts() ) : $products->the_post();
    echo get_the_title() . "<br>";
endwhile;

One thing to note, WordPress does say that you cannot combine post__in and post__not_in in the same query, and you shouldn’t need it anyways if your $upsells array already has the ids you want.

Would you mind sharing the whole template file you’re working in, or at least more about how you’re outputting the results of this query? It doesn’t sound like the query you’re working on is affecting your output at all, so that makes me think you have some kind of disconnect going on there.

Edit: It appears that you are using a very old version of woocommerce @ v1.6.4 that means your Woocommerce hasn’t been updated since 2012! The function get_upsells() that you said you added is actually a woocommerce function, and it’s deprecated in Woocommerce 3, which is what I’m testing on. I’d strongly suggest doing some updates before you continue attempting to fix anything.

I can’t continue to help you until we know your issues aren’t being caused by your out of date version of Woocommerce, and possibly an outdated version of WordPress.

Related Posts:

  1. how to retrieve specific product attribute value in an sql query?
  2. WP_Query with “post_title LIKE ‘something%'”?
  3. Pagination with custom SQL query
  4. How to query only for products with status “in stock” in WooCommerce? [closed]
  5. Is it possible to wrap Geo Location search around WP_Query?
  6. WP_Query for WooCommerce Products
  7. Is it possible to select against a post’s parent’s fields with WP_Query?
  8. How do I order pages and categories by ID or name in the same query?
  9. How to make an activities stream mixing posts and comments?
  10. SQL Statement generated by WP_Query not producing expected results
  11. What is an efficient way to query based on post_meta?
  12. SQL query equivalent to WP User Query
  13. WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
  14. Recommended way to drop a pending query (in pre_get_posts)?
  15. Retrieve products with specific attribute and in category – woocommerce
  16. How to combine tax_query and date_query in WordPress
  17. WordPress altering my custom query, How to fix it?
  18. Display featured products through custom loop in WooCommerce 3 [closed]
  19. SQL User Query by Multiple Roles using PHP
  20. Advanced WP Query hogs the SQL server
  21. Get product list of given category
  22. How to exclude products by tag from woocommerce shop page?
  23. WooCommerce Only OnSale Products Loop Snippet [closed]
  24. Query post with meta_query where date is not in future
  25. WP User Query get all authors with last name starting with specific letter
  26. Select from wp_post and multiple meta_value from wp_postmeta
  27. How to correctly pass values to wpdb->prepare()?
  28. merge two query arguments into one WP_Query call
  29. Sort users by “birthday” using WP_User_Query
  30. How To Fix WP Query Returns Results But Shouldn’t?
  31. Woocommerce returns Product post_status as published even tho it is in status draft
  32. List of the years with posts presented
  33. showing all search result in one template
  34. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  35. Slow WP_Query for custom post type
  36. Complex WP SQL Query
  37. Woocommerce query all products and categories
  38. Sorting events by descending date, and ascending time if multiple events on a date
  39. Take all produts by category
  40. Editing the default wordpress search
  41. How to get all product attributes for filters in WooCommerce?
  42. How to extract specific post
  43. Having trouble with WooCommerce Storefront child theme single.php “related posts” modification [closed]
  44. Out Of memory issue on post per page parameter
  45. wordpress ajax relationship query
  46. wp_query not working with post_type
  47. How to pass orderby params to $wpdb->prepare()?
  48. Debugging wp_query orderby for taxonomy
  49. Woocommerce pagination and result count after custom loop
  50. Getting additional columns from sql
  51. How to order WP_Query to group results?
  52. Redirect Search to Form When No Product Results Are Found
  53. WP_Query Taxonomy categories filtering
  54. Exclude a Woocommerce product from WP_Query
  55. Query where ANDing slug values not working
  56. Woo Commerce using WP_Query to get products that match price range, with an additional required product attribute
  57. Multiple meta_key ordering with pre_get_posts
  58. WP_Query: apply an SQL function to meta fileld value
  59. Assign a minimum result count for WooCommerce query shortcodes?
  60. Woocommerce: order posts by meta key
  61. var_dump of WP_Query object is not empty, while .have_posts() return false
  62. Unlimited Page Sitemap Link
  63. How to avoid filling up an array each time I run a WP_query?
  64. How to SQL query posts IDs by categories AND authors?
  65. Randomly select one of last 3 posts
  66. $wp_query->found_posts not returning correct value
  67. Tax Query on product_cat using NOT IN as operator does not exclude that category
  68. Woocommerce Shortcode which displays a table with product data
  69. Passing a SQL query to the WP Query
  70. Make a products only viewable to a specific user ID in meta_query pre_get_posts
  71. Customize the Sorting Dropdown in WooCommerce use another list or more page
  72. WP_Query() not working as expected
  73. ElasticPress is (aparently) messing with my search filters
  74. Any way to use FETCH_KEY_PAIR with $wpdb?
  75. How sort products by calculate value? ( custom post meta, price, option)
  76. wc_get_products() return empty object
  77. How can I filter products by meta in Woocommerce REST API?
  78. What is the equivalent WP_Query of a SQL Query?
  79. What code to use in an array to call the current sub-category?
  80. Get categories within specific term
  81. Select multiple categories with is_tax
  82. Query child posts with tax query on parents
  83. Woocomerce – Order products by float attribute in archive pages
  84. Not able to fetch woocommerce variation sales products for particular category products
  85. Slow Query with more 100 products
  86. Create global array to compare inside a query
  87. WP_Query to Retrieve Posts from WooCommerce Products that are Only in Catalog
  88. Calculating efficiently on large amount of data generated by wp_query
  89. How to add in WP_Query to every 3 posts displayed? [duplicate]
  90. Woocommerce WP_Query post__not_in problem
  91. What argument does my function need to echo get_results() query results
  92. Using the same WP_Query for shop and widgets in WooCommerce shop
  93. Include post_status check within $wpdb query
  94. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  95. WP Query to order posts by multiple meta fields
  96. How to return value from sql and display it
  97. WP_Query with several meta_query-statements and order by meta_value
  98. wpdb LIKE request shows all database data
  99. Variations as Single Products [closed]
  100. How to make OR condition in WP_Query