ridle

Hey,

I had the exact same problem. But the funny thing is, it actually DOES save it in the correct order. It just doesn’t show in the back-end.

I went digging into the code and made a temporary fix. Let me know if it works for you too.

There needs to come an official update ofcourse later on.

Change the file to the code below /rearrange-woocommerce-products/views/template-parts/-tab-all-products.php

<?php
/**
 * List all products with PHP sorting after query.
 *
 * @package ReWooProducts
 */

if ( ! defined( 'ABSPATH' ) ) {
	exit; // Exit if accessed directly.
}

$args = array(
	'post_type'      => array( 'product' ),
	'posts_per_page' => '-1',
	'post_status'    => array( 'publish' ),
);

// If a term_id is provided, limit to that category.
if ( isset( $_GET['term_id'] ) && ! empty( $_GET['term_id'] ) ) { // phpcs:ignore WordPress.Security.NonceVerification
	$term_id = sanitize_text_field( wp_unslash( $_GET['term_id'] ) ); // phpcs:ignore WordPress.Security.NonceVerification

	$args['tax_query'] = array(
		array(
			'taxonomy' => 'product_cat',
			'terms'    => array( $term_id ),
			'field'    => 'id',
			'operator' => 'IN',
		),
	);
	// Remove WP_Query ordering so we can handle it with PHP.
	// (Alternatively, you can leave ordering here if it helps pre-sort but it might not be enough.)
} else {
	$args['orderby'] = array(
		'menu_order' => 'ASC',
		'title'      => 'ASC',
	);
}

$products = new WP_Query( $args );

$sorted_items = array();

// Build an array of items with the needed sort values.
if ( $products->have_posts() ) {
	while ( $products->have_posts() ) {
		$products->the_post();
		global $post;
		
		// Initialize a default sort order.
		$sortorder = 0;
		if ( isset( $term_id ) ) {
			// Define the meta key based on term_id.
			$meta_key  = 'rwpp_sortorder_' . $term_id;
			$meta_val  = get_post_meta( $post->ID, $meta_key, true );
			$sortorder = ( '' !== $meta_val ) ? intval( $meta_val ) : 0;
		}

		// Also grab menu order and title as fallback sort criteria.
		$menu_order = intval( $post->menu_order );
		$title      = get_the_title( $post->ID );

		$sorted_items[] = array(
			'post'       => $post,
			'sortorder'  => $sortorder,
			'menu_order' => $menu_order,
			'title'      => $title,
		);
	}
	wp_reset_postdata();
}

// Now sort the array using PHP's usort.
// The sort order is: sortorder (meta) first, then menu_order, then title.
usort( $sorted_items, function( $a, $b ) {
	if ( $a['sortorder'] !== $b['sortorder'] ) {
		return $a['sortorder'] - $b['sortorder'];
	}
	if ( $a['menu_order'] !== $b['menu_order'] ) {
		return $a['menu_order'] - $b['menu_order'];
	}
	return strcmp( $a['title'], $b['title'] );
});
?>

<div id="rwpp-products-list">
	<?php
	$serial_no = 1;
	foreach ( $sorted_items as $item ) {
		$post = $item['post'];
		setup_postdata( $post );
		$product = wc_get_product( $post->ID );
		include '-product.php';
		$serial_no++;
	}
	?>
</div>

<button id="rwpp-save-orders" class="button-primary">
	<?php esc_html_e( 'Save Changes', 'rearrange-woocommerce-products' ); ?>
</button>

<div id="rwpp-response"></div>
<?php wp_reset_postdata(); ?>