我对管理面板产品搜索有一些问题。某些类别中的产品无法按SKU找到,只能按名称找到,而其他类别可以。我试着用SKU:
, 但这并没有改变任何事情。WordPress v5.1.1,WooCommerce v3.6.4
Can't find a product by SKU
1 个回复
SO网友:Rohit Verma
Add This Code In functions.php then save it.
更改后,您可以在屏幕截图中看到更改function search_by_sku_for_admin( $search, &$query_vars ) {
global $wpdb, $pagenow;
if ( \'edit.php\' != $pagenow || empty($search) ) {
return $search;
}
$args = array(
\'posts_per_page\' => -1,
\'post_type\' => \'product\',
\'meta_query\' => array(
array(
\'key\' => \'_sku\',
\'value\' => $query_vars->query[\'s\'],
\'compare\' => \'LIKE\'
)
)
);
$posts = get_posts( $args );
if ( empty( $posts ) ) return $search;
$get_post_ids = array();
foreach($posts as $post){
$get_post_ids[] = $post->ID;
}
if ( sizeof( $get_post_ids ) > 0 ) {
$search = str_replace( \'AND (((\', "AND ((({$wpdb->posts}.ID IN (" . implode( \',\', $get_post_ids ) . ")) OR (", $search);
}
return $search;
}
add_filter( \'posts_search\', \'search_by_sku_for_admin\', 999, 2 );