Thread: If Single search result go to product page directly skip search results page

How can I alter the page.search.xml.config to go directly to the product page if only one search result. I have already written the logic to do something differently if there is only on search result verus many, but I cannot get it to do the redirect.

You can test in the searchadv.aspx.cs page if an exact match is made for the SKU and then do the redirect there.

Try our search. Type B10 into the search box and press the green search button, rather than choosing it from the drop-down list. If you press the green search button, it is actually going to the searchadv.aspx page and making an SKU match on B10 then re-directing to the product page.

How did you do your redirect via the xml package? Javascript?

No. As I said in the previous post we do the test and re-direct in searchadv.aspx.cs.

Use the searchterm which is passed in as a querystring and immediately perfrom a database lookup using the searchterm as the SKUSuffix (or whatever works for you). If one record is returned then you have an exact match, and re-direct to the page.

This is the code snippet we use to match and re-direct:

Code:

		private bool SearchSKU(string searchTerm)
		{
		
			using (SqlConnection dbconn = new SqlConnection(DB.GetDBConn()))
			{
				dbconn.Open();
							
				string sql = "SELECT TOP 1";
					  sql += "	[PV].[ProductID], ";
					  sql += "	[PV].[VariantID], ";
					  sql += "	[P].[SEName] ";
					  sql += "FROM ";
					  sql += "	[ProductVariant] AS [PV] ";
					  sql += "INNER JOIN "; 
					  sql += "	[Product] AS [P] ON [P].[ProductID] = [PV].[ProductID] ";
					  sql += "WHERE ";											  
					  sql += "	[PV].[SKUSuffix] = '"	+ searchTerm + "'";								  
				using (IDataReader rs = DB.GetRS(sql, dbconn))
				{
					while (rs.Read())
					{
					
						try
						{
							Response.Redirect("/p-" + DB.RSFieldInt(rs, "ProductID").ToString() + "-" + DB.RSField(rs, "SEName") + ".aspx?v=" + DB.RSFieldInt(rs, "VariantID").ToString());
							Response.Clear();
							
							return true;
						}
						catch (Exception ex)
						{
							throw (ex);
						}
					}
				}
			}
			
			return false;

		}

I used a simpler approach:

Code:

<xsl:template match="/">
	<xsl:param name="oneProductID">
		<xsl:value-of select="/root/Products/Product[1]/ProductID/text()" />
	</xsl:param>
	<xsl:param name="oneSEName">
		<xsl:value-of select="/root/Products/Product[1]/SEName/text()" />
	</xsl:param>
	<xsl:if test="count(/root/Products/Product)=1">
		<script type="text/javascript" Language="JavaScript">
			window.location.href = '<xsl:value-of select="aspdnsf:ProductLink($oneProductID, $oneSEName, 0)" />';
		</script>
	</xsl:if>