Search Redirect if only one result found

If someone uses the search function and only one matching product is found, can the search result redirect to that product's page automatically?

I've searched around a bit, but can't find how to do this.

Thanks in advance!!!!

At the very bottom of includes/modules/pages/advanced_search_result/header_php.php is a piece of code that redirects visitors abck to the advanced search page if there are no products found. You would want to add a similar redirect that says "Aha, only one? then go to the product info page instead!" (but in PHP)

Yeah, except I don't know very much php. I see the file you're talking about, but I don't know how to modify it to do what you said. :(

At the bottom of that file, you have a section of code similar to the following.
Simply add the additional lines highlighted here:```
$result = new splitPageResults($listing_sql, MAX_DISPLAY_PRODUCTS_LISTING, 'p.products_id', 'page');
if ($result->number_of_rows == 0) {
$messageStack->add_session('search', TEXT_NO_PRODUCTS, 'caution');
zen_redirect(zen_href_link(FILENAME_ADVANCED_SEARCH, zen_get_all_get_params('action')));
}
[B]// if only one product found in search results, go directly to the product page, instead of displaying a link to just one item:
if ($result->number_of_rows == 1 && SKIP_SINGLE_PRODUCT_CATEGORIES == 'True') {
$result = $db->Execute($listing_sql);
zen_redirect(zen_href_link(zen_get_info_page($result->fields['products_id']), 'cPath=' . zen_get_product_path($result->fields['products_id']) . '&products_id=' . $result->fields['products_id']));
}

[/B]
// This should be last line of the script:
$zco_notifier->notify('NOTIFY_HEADER_END_ADVANCED_SEARCH_RESULTS', $keywords);
//EOF

That didn't quite work. I have ZenCart 1.3.7.1. The heading of the file (/includes/modules/pages/advanced_search_result/header_php.php) says:

 @version $Id: header_php.php 4857 2006-10-28 17:40:08Z ajeh $

and the end of the file's code is as follows:

$listing_sql = $select_str . $from_str . $where_str . $order_str;
// Notifier Point
$zco_notifier->notify('NOTIFY_SEARCH_ORDERBY_STRING');
$breadcrumb->add(NAVBAR_TITLE_1, zen_href_link(FILENAME_ADVANCED_SEARCH));
$breadcrumb->add(NAVBAR_TITLE_2);

// This should be last line of the script:
$zco_notifier->notify('NOTIFY_HEADER_END_ADVANCED_SEARCH_RESULTS');
?>

Am I looking at the wrong file?

Thanks again for your help!!!

Sorry, that was based on 1.3.8

Just put it above the last notifier section:```
// This should be last line of the script:
$zco_notifier->notify('NOTIFY_HEADER_END_ADVANCED_SEARCH_RESULTS', $keywords);

if I add only the lines that are in red, I get this:

Home :: Advanced Search :: Search Results :: Advanced Search :: Search Results
Advanced Search
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by p.products_sort_order, pd.products_name limit 0, 10' at
in:
[SELECT DISTINCT p.products_image, p.products_quantity , m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_price_sorter, p.products_qty_box_status FROM (products p LEFT JOIN manufacturers m USING(manufacturers_id), products_description pd, categories c, products_to_categories p2c ) LEFT JOIN meta_tags_products_description mtpd ON mtpd.products_id= p2c.products_id AND mtpd.language_id = 1 WHERE (p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND p.products_id = p2c.products_id AND p2c.categories_id = c.categories_id AND ((pd.products_name LIKE '%hp%' OR p.products_model LIKE '%hp%' OR m.manufacturers_name LIKE '%hp%' OR (mtpd.metatags_keywords LIKE '%hp%' AND mtpd.metatags_keywords !='') OR (mtpd.metatags_description LIKE '%hp%' AND mtpd.metatags_description !='') OR pd.products_description LIKE '%hp%') )) order by p.products_sort_order, pd.products_name order by p.products_sort_order, pd.products_name limit 0, 10]

(I included the breadcrumbs in hopes that it might help in figuring out what's wrong.)

If I add everything in the box (replacing the last line - this line is still slightly different than what you indicate it should be), it works when only one product is returned, but gives the error message when multiple products should be returned.

I'm still stuck...

For 1.3.7.1, change this:

$listing_sql = $select_str . $from_str . $where_str . $order_str;
// Notifier Point
$zco_notifier->notify('NOTIFY_SEARCH_ORDERBY_STRING');
$breadcrumb->add(NAVBAR_TITLE_1, zen_href_link(FILENAME_ADVANCED_SEARCH));
$breadcrumb->add(NAVBAR_TITLE_2);

// This should be last line of the script:
$zco_notifier->notify('NOTIFY_HEADER_END_ADVANCED_SEARCH_RESULTS');
?>

to this:```
$listing_sql = $select_str . $from_str . $where_str . $order_str;
// Notifier Point
$zco_notifier->notify('NOTIFY_SEARCH_ORDERBY_STRING');
$breadcrumb->add(NAVBAR_TITLE_1, zen_href_link(FILENAME_ADVANCED_SEARCH));
$breadcrumb->add(NAVBAR_TITLE_2);

[B]
// if only one product found in search results, go directly to the product page, instead of displaying a link to just one item:
$result = new splitPageResults($listing_sql, MAX_DISPLAY_PRODUCTS_LISTING, 'p.products_id', 'page');
if ($result->number_of_rows == 1 && SKIP_SINGLE_PRODUCT_CATEGORIES == 'True') {
$result = $db->Execute($listing_sql);
zen_redirect(zen_href_link(zen_get_info_page($result->fields['products_id']), 'cPath=' . zen_get_product_path($result->fields['products_id']) . '&products_id=' . $result->fields['products_id']));
}
[/B]
// This should be last line of the script:
$zco_notifier->notify('NOTIFY_HEADER_END_ADVANCED_SEARCH_RESULTS');
?>

You didn't indicate what to change, so I just added the code. This resulted in the same error.

Can we try one more time?

I really appreciate all of your help!

If it helps, my site is: VictoryToner.com/catalog

Search for C6656AN to return 1 product (redirect works)

Search for HP toner to return multiple products (error message)

PastelBlack:

You didn't indicate what to change, so I just added the code. This resulted in the same error.

Can we try one more time?

I really appreciate all of your help!

Oops ... I've updated my post above.

Dr Byte, I really do appreciate your time and your help!

I am still getting the same error with the repeated breadcrumbs.

You can see what I'm talking about here: VictoryToner.com/catalog

Search for C6656AN to return 1 product (redirect works)

Search for HP toner to return multiple products (error message)

I'm using ZC v1.3.7.1 with a few mods (Customer Tax Exempt v1.1.0, Automatic Login v1.2.1, Encrypted Master Password v1.1, Editable Sidebox v1.0, Search Log v2.0, and Group Pricing Per Item v1.2.1a), so I don't know if the problem lies here.

I would really like to get this to work. :down:

... and if you put the code back to the original from before the edits I suggested, what happens?

Haha... Your post got me thinking...

So I went back to my last backup (a few days ago) and re-uploaded that file before ANY changes were made. It worked the way it originally did.

I then made the change that you suggested and re-uploaded, and it works. :clap:

I must've screwed something up before, but now with the fresh upload it appears to be working.

You are awesome! Many, many thanks!

Thanks for this little snippet, works great especially when searches are done on isbn # where there is only a possability of one. again thanks alot.

DrByte:

At the bottom of that file, you have a section of code similar to the following.
Simply add the additional lines highlighted here:```
$result = new splitPageResults($listing_sql, MAX_DISPLAY_PRODUCTS_LISTING, 'p.products_id', 'page');
if ($result->number_of_rows == 0) {
$messageStack->add_session('search', TEXT_NO_PRODUCTS, 'caution');
zen_redirect(zen_href_link(FILENAME_ADVANCED_SEARCH, zen_get_all_get_params('action')));
}
[B]// if only one product found in search results, go directly to the product page, instead of displaying a link to just one item:
if ($result->number_of_rows == 1 && SKIP_SINGLE_PRODUCT_CATEGORIES == 'True') {
$result = $db->Execute($listing_sql);
zen_redirect(zen_href_link(zen_get_info_page($result->fields['products_id']), 'cPath=' . zen_get_product_path($result->fields['products_id']) . '&products_id=' . $result->fields['products_id']));
}

[/B]
// This should be last line of the script:
$zco_notifier->notify('NOTIFY_HEADER_END_ADVANCED_SEARCH_RESULTS', $keywords);
//EOF

I know its an old post, but was just what I was looking for!

Works in 1.3.9d too :)

Thanks Dr. Byte!

Thanks for bumping the thread, that's a great addition :P

Exactly what I needed. Just applied this to 1.39d and works great, thanks.

Jk10:

Exactly what I needed. Just applied this to 1.39d and works great, thanks.

I think it should be in 1.3.9e