Quote Originally Posted by rajoo.sharma View Post
It may not be appropriate for everyone, but I think it can be very simple. Do not add any extra text boxes for custom fields for example products_author.

1. includes/modules/pages/advanced_search_result/header_php.php

Find:
$where_str .= "(pd.products_name LIKE '%:keywords%'

After:

OR p.products_model
LIKE '%:keywords%'

Add:
OR p.products_author
LIKE '%:keywords%'

2. includes/languages/your_template/advanced_search.php

Replace:

define('HEADING_SEARCH_CRITERIA', 'Choose Your Search Terms');

with:

define('HEADING_SEARCH_CRITERIA', 'Title, Author, ISBN/ISSN');
I have tried this, and other things, but can't get it to work. I added a field named "item_number" to my products table, and just want to make that searchable - I am running v1.3.8a

Thanks