How to search Products by variation SKUs?

Knowledge Base - Ajax Search Pro for WordPress

Buy Ajax Search Pro!Documentation Get Support

Search…

Indexing variation SKUs to the parent product

For this to work, make sure you have configured and using the index table engine - as well as the search in SKUs search is enabled.
By default, when the _sku field is selected, the plugin will index the product SKUs as well as the variation SKUs - but all separately. To associate the variation SKUs with the parent product as well, use the code below.
After adding the custom code, make sure to re-create the search index.
​
​
​What is this, and where do I put this custom code?​
add_filter( 'asp_post_custom_field_before_tokenize', 'asp_tokenize_sku_variation', 10, 3 );
function asp_tokenize_sku_variation($values, $post, $field) {
	if ( $post->post_type == 'product' && $field == '_sku' ) {
		$args = array(
			'post_type'     => 'product_variation',
			'post_status'   => array( 'private', 'publish' ),
			'posts_per_page'  => -1,
			'fields'          => 'ids',
			'post_parent'   => $post->ID // get parent post-ID
		);
		$variations = get_posts( $args );
		$skus = array();
		foreach ( $variations as $variation ) {
			$sku = get_post_meta($variation, '_sku', true);
			if ( !empty($sku) ) {
				$skus[] = $sku;
			}
		}
		if ( count($skus) > 0 ) {
			$values = array_merge($values, $skus);
		}
	}
​
	return $values;
}
After adding the custom code, make sure to re-create the search index.
​
​

How to search products & product SKU?

Search product attributes

Last modified 4mo ago

Copy link