Product Sorting

Well…I tried this before. I will show product from A to Z but the featured product will be at the end of the list. I want the featured product on top and sort from A to Z after that.

Edited (I tried the following before):

add_filter( ‘woocommerce_get_catalog_ordering_args’, ‘custom_woocommerce_get_catalog_ordering_args’ );
function custom_woocommerce_get_catalog_ordering_args( $args ) {
$args[‘meta_key’] = ‘_featured’;
$args[‘orderby’] = ‘meta_value title’;
$args[‘order’] = ‘ASC’;
return $args;
}

• This reply was modified 9 years, 2 months ago by boscotwcheung.

This is a request from a customer. They have a lot product and it is hard to sort by drag and drop now. They want to hardcode the sorting.

I found it can be done by the custom field. But I need to think a better custom field value for “isFeatured” as it also sort from A to Z…

Anyway, the technical problem is solved. You can close this thread. Thanks.

I changed “_featured” to a custom field.

I did a do_action(‘wp_insert_post’, ‘xxx’). I will create a custom field called “isHot” based on the “_featured” value when saving the post.

The logic are:
if (“_featured” == true){ “isHot” = ‘Hot’;} else {“isHot” = ‘Normal’;}

And now, I can sort by “isHot” and ‘title’ in ASC. The hot item will show first and then A to Z

Thanks,
Alex

add this to function.php

add_action( ‘wp_insert_post’, ‘custom_product_save’ );
function custom_product_save($post_id){

$post_type = get_post_type( $post_id );
// check if post type is a product
if ($post_type == ‘product’){
// add isHot custom fields based on the value of “_featured”
$isHot = get_post_meta($post_id, ‘_featured’, true);
if ($isHot){
update_post_meta($post_id, ‘isHot’, ‘Hot’);
} else {
update_post_meta($post_id, ‘isHot’, ‘Normal’);
}
}

}

// Sort the product by hot item first and A to Z after that
add_filter( ‘woocommerce_get_catalog_ordering_args’, ‘custom_woocommerce_get_catalog_ordering_args’ );
function custom_woocommerce_get_catalog_ordering_args( $args ) {
$args[‘meta_key’] = ‘isHot’;
$args[‘orderby’] = ‘meta_value title’;
$args[‘order’] = ‘ASC’;
return $args;
}

However, you need to update all the existing product to add the isHot custom fields. (should be easy to write a script to do a batch update)

Yes, you need to add “isHot” custom field and value to all the product first. A script is needed to do a batch for this.