[Resolved] Order by SKU (Woocommerce and Views)

[Author]

Posts

[xavierC-2]

Hi,

I use Views and Woocommerce to display products in a list.

I would like to order the results by SKU, but it's hidden field, so I don't find it in the drop down box on my View.

I checked this page on the forum : https://toolset.com/forums/topic/sorting-by-custom-field/
The solution is from 2014 and I tried it :

function order_by_sku_func($query, $view_settings) {
    if($view_settings['view_id']!= 129) return $query;
    $query['orderby'] = 'meta_value_num';
    $query['order'] = 'ASC';
    $query['meta_query'][] = array(
           'key' => '_sku',
           'value' => 0,
           'compare' => '>',
    );
    return $query;
}
add_filter('wpv_filter_query', 'order_by_sku_func', 10, 2);

I add this to my functions.php, but it seems it doesn't work : I don't see any new field to choose in the Ordering drop down box.

Can you please help me to solve that issue ?

Thank you.

[Shane Supporter Languages: English (English ) Timezone: America/Jamaica (GMT-05:00)]

Hi Xavier,

Thank you for contacting our support forum.

With our views plugin you should be able to enable these hidden fields to be used. To do this go to Toolset -> Settings -> Frontend-Content -> Hidden Custom fields and click "Select custom field" once you have done this search for _sku and enable it.

After doing that then the sku should show up in the sorting options for your view.

Please let me know if this helps.

Thanks,
Shane

[xavierC-2]

Thanks Shane, it works ! 🙂