Give Products extraordinary weight boost to ensure Products show up first.

searchwp-customizations.php

<?php

// Give Products extraordinary weight boost to ensure Products show up first.
// @link https://searchwp.com/documentation/knowledge-base/post-type-first-top/
add_filter( 'searchwp\query\mods', function( $mods ) {

  $post_type = 'product'; // Post type name.

  $source = \SearchWP\Utils::get_post_type_source_name( $post_type );

  $mod = new \SearchWP\Mod( $source );
  $mod->relevance( function( $runtime ) use ( $source ) {
    global $wpdb;

    return $wpdb->prepare(
        "IF( {$runtime->get_foreign_alias()}.source = %s, '999999999999', '0' )",
        $source
    );
  } );

  $mods[] = $mod;

  return $mods;
} );

Correct 👍

Ok, I have this working great now with the code below. However, I'm getting this notice using debug mode. Is this expected because of an unusual use case of wpdb or is there some way I can fix it?

Notice: wpdb::prepare was called incorrectly. Unsupported value type (object). (This message was added in version 4.8.2.) in /wp-includes/functions.php on line 5313

// Give some post types extra weight boost to ensure they show up first.
// @link https://searchwp.com/documentation/knowledge-base/post-type-first-top/
// @link https://gist.github.com/jchristopher/7fe0117f98318e71fcdcd9de116def62
add_filter( 'searchwp\query\mods', 'redpoppy_searchwp_boosts' );
function redpoppy_searchwp_boosts( $mods ) {

	// how much to boost each post type
	$boosts = array(
		'works'      => 200,
		'recordings' => 50,
		'events'     => -50,
	);

	foreach ( $boosts as $post_type => $boost ) {

		$source = \SearchWP\Utils::get_post_type_source_name( $post_type );

		$mod = new \SearchWP\Mod( $source );
		$mod->relevance(
			function( $runtime ) use ( $source, $boost ) {
				global $wpdb;
				return $wpdb->prepare(
					"IF( {$runtime->get_foreign_alias()}.source = %s, %s, '0' )",
					array(
						$source,
						$boost,
					)
				);
			}
		);

		$mods[] = $mod;
	}
	return $mods;
}

I found that sometimes $mods is not an array, so to avoid fatal errors, I had to implement this at the start of the function:

if ( ! is_array( $mods ) ) {
	$mods = array( $mods );
}