Sorting products by category does not work

Awesome! Do you have a slight idea when this would be? We’d happily use the plugin 🙂

It is in rearrange-woocommerce-products.php (search for it).

But I’d like to mention: we’d strongly advise against editing directly in 3rd party plugins. Better to wait for the update 🙂

@aslamdoctor not really. That line is setting the meta_query, but not the meta_key.

Adding the line in my example fixes the issue (now it doesn’t 🙂 ).

Hmm, I get it..

However: the current outcome that it doesn’t sort all the products correctly now 🙂 How do you look at this? Or do you have a fix for that?

Thinking of that: might it be an idea to provide all the products (within a category which is being sorted) with a meta value, so you can sort against it?

Well, I understand the issue of the plugin-maker, because by adding the meta_key it will skip products, which don’t have a custom sort meta_key stored.

In our situation we have “fixed” this as following:

Adding this script to your code:

add_action('pre_get_posts', 'custom_change_for_rearrange_products_plugin');

function custom_change_for_rearrange_products_plugin( $query ) {
	if ( isset( $_GET['orderby'] ) && 'date' === $_GET['orderby'] ) {
		return;
	}

	if ( is_tax( 'product_cat' ) && $query->is_main_query() && ! is_admin() ) {
		$term = get_queried_object();
		if( $term ) {
			$term_id = $term->term_id;
			$meta_key   = 'rwpp_sortorder_' . $term_id;
			$query->set( 'meta_key', $meta_key );
		}
	}
}

Step 2 (important!) is to save all the categories once, so you will “force” to have the needed meta_key stored with each product.

That is something I’d really not know. In our situation this did work, but obviously it might not work in every situation and setup.

But (as far as I know) the plugin overrules the “default” orderby parameters, so why it doesn’t work in your situation, I really don’t know. Best is probably to raise a separate ticket for that.