Manufacturers search

[AlgellA]

Can anyone come up with a search facility for manufacturers please?

It's really quite annoying that this essential feature does not exist.

Thanks in advance

[dbltoe]

Addvanced search allows you to limit your search by manufacturer.

https://docs.zen-cart.com/user/searc...ed-search-page

[AlgellA]

Addvanced search allows you to limit your search by manufacturer.

https://docs.zen-cart.com/user/searc...ed-search-page

Thanks. I should have said in the Admin console. There is no way to search for a manufacturer.

[dbltoe]

You will need to reset between searches but, go to ADMIN >> Catalog >> Categories/Products and enter a manufacturer in the Search: box.

The only downside is that it will bring up the term even if it is in a cat/product's description.

Still, you should be able to get through the fog that way.

[lat9]

You will need to reset between searches but, go to ADMIN >> Catalog >> Categories/Products and enter a manufacturer in the Search: box.

The only downside is that it will bring up the term even if it is in a cat/product's description.

Still, you should be able to get through the fog that way.

Unfortunately, with zc157c anyway, the search function looks only at the products' name, description, model and id values. Custom code is required to look in the manufacturers as well.

[swguy]

I could have *sworn* that in 1.5.8 you could go to the manufacturers page and open a listing page showing all products. Guess not.

[lat9]

I could have *sworn* that in 1.5.8 you could go to the manufacturers page and open a listing page showing all products. Guess not.

That's not what the OP requested. S/he is looking for that search functionality from the admin's Catalog :: Categories/Products listing.

[swguy]

Understood, but this would provide the same functionality - better because there would be no false positive matches.

[carlwhat]

That's not what the OP requested. S/he is looking for that search functionality from the admin's Catalog :: Categories/Products listing.

in v158, 2 new lines of code and it's done.

        if ($search_result && $action != 'edit_category') {
                $keyword_search_fields = [
                    'pd.products_name',
                    'p.products_model',
                    'pd.products_description',
                    'p.products_id',
// first new line:
                    'man.manufacturers_name',
                ];
                $where .= zen_build_keyword_where_clause($keyword_search_fields, trim($keywords));
// second new line:
                $products_query_raw.= " LEFT JOIN " . TABLE_MANUFACTURERS . " man ON (man.manufacturers_id = p.manufacturers_id) "; 

[AlgellA]

You will need to reset between searches but, go to ADMIN >> Catalog >> Categories/Products and enter a manufacturer in the Search: box.

The only downside is that it will bring up the term even if it is in a cat/product's description.

Still, you should be able to get through the fog that way.

That's fine when you want to search all products under a manufacturer but it does not return the manufacturers record so that you can edit it quickly