Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [catalogsearch]

Denotes questions related to the Magento catalog search engine

5
votes
1answer
39 views

My Search result not showing relevance products properly Magento 2

When i search for any string, the relevance search result not working properly.Can you guys please look into in the attached image? I have enable name and sku for the search. To reproduce this issue ...
0
votes
1answer
28 views

How to disable ElasticSearch using terminal?

I was using ElasticSearch in my old server and then I migrate the server for a new one that it's not using it anymore, so I'm receiving this issue message below. Exception #0 (Elasticsearch\Common\...
0
votes
0answers
15 views

M2 Search Result Not Displaying Correct Result/Products

I've a multi-store setup using multi-website approach. For some products, when I run a search query, I am not getting correct results, instead completely unrelated products are getting displayed. ...
0
votes
0answers
13 views

Magento 1 Search - No Results After Update

Hi guys we dropped the latest magento core over our installation to update everything as it was a little out of date. Since then the search has been returning no results. I have done all of the ...
0
votes
0answers
19 views

Why Magento catalogsearch catalogsearch/result redirect to shop home page

We have tried the product search option in shop frontend, so executed the below URl (GET method) https://www.example.com/catalogsearch/result/?q=searchvalue Search result output are displayed ...
0
votes
0answers
12 views

Searching a category with many items very slow?

This is my search URL after sending a search: https://example.com/catalogsearch/result/?cat=575&q=mysearchterm As you can see, I am searching for mysearchterm in category 575. This is extremely ...
0
votes
0answers
30 views

Magento search Two digit

I have two product in magento, one product contains attribute value 879 and another product contain attribute value 87. but whenever I search in Magento only appear 879 attribute value product. 1) ...
0
votes
0answers
11 views

Sort by Filter in category search page is not working in mobile devices

I have Edited the drop down of sort by the filter. It Works fine in PLP page. but not working in category search page. <?php /** * Copyright © Magento, Inc. All rights reserved. * See ...
0
votes
1answer
19 views

Magento Search System Issue

I`m having a strange issue with catalog searching. Performing this simple search returns 35 products : catalogsearch/result/index/?q=bac However, when I refine it by category, I still receive the ...
1
vote
1answer
24 views

Magento 2: custom UrlRewrite Controller Router not works with some handlers

I'm creating a module to use custom url rewrites. For this I have created a module and I am using a custom UrlRewrite Controller Router. For testing purpose, I generated the Router below. It works ...
0
votes
0answers
25 views

Magento2: How can remove “q” from catalog search?

I want to search products http://example.com/catalogsearch/result/?pcat=27&cat=9 I don't want to use "q" string in above url. where i can do this and how? Anyone have an idea for that?
0
votes
1answer
20 views

Magento 2 > Partial search on model name

How can I have the default catalog search mechanism search on part of an attribute (in my case - the model attribute)? As it seems out of the box - the search works only on full word, or the beginning ...
1
vote
0answers
18 views

Magento 1.9.3.10 - Search doesn't work, advanced does!

Hi guys got a weird one the normal magento search returns 0 results, but the advanced search works? Tried: Reindexing Clearing Cache Re updating attributes of products to link to website Checked for ...
0
votes
1answer
42 views

Magento2.2 - Error in catalog search

I have facing problem on search product(s) from my website. Someone please help me out to know what happens in this error. When I search for a product in the site search, for example "Dress", the ...
0
votes
1answer
40 views

Magento 1.9 Catalog Search result redirect the live website

I am trying to find where I did mistake when I search abc in catalog search tab. the link local.xyz.com/abc.html Redirect to www.xyz.com/abc.html. Don't know where I did mistake, I already changed the ...
0
votes
4answers
63 views

How to remove add to compare in catalog search result page?

Actually I want to remove add to compare in catalog search result page
0
votes
0answers
21 views

Magento 2 Search by category

I am using Magento 2.2.6 I have drop down of all categories in the left side of search field(on home page). If I select any category and then type something in search field then it will search that ...
2
votes
0answers
21 views

When To Use MultiStore Vs. Categories

I'm attempting to hide the "Add To Cart" button for specific stores currently and am having some issues with my lack of experience. It works in each individual store but not when using the search ...
1
vote
0answers
206 views

Magento 2 Product Searching Not Working

When I'm searching for the product name "Dell" then getting products which don't have any word "Dell" in the product name. e.g- I'm getting following product name when searching for "Dell":- 1- "...
1
vote
0answers
19 views

Magento2: How can create individually custom dropdown of categories and subcategories?

I want to search products by parent categories and sub categories via search box. for example there is two dropdown "search by categories" and "search by sub categories". when we will select first ...
2
votes
1answer
36 views

Magento2: How can search products for specific category via search box?

I want to search products for specific categories though search box. Anyone have an idea for that?
1
vote
0answers
20 views

Magento2: How to search products by categories in mini search?

I want to search products with categories in search box. please find attachment of screenshots. Anyone have an idea for that?
1
vote
0answers
28 views

Catalog Search Issue

When I'm seraching product title "Mixer, Ribbon, 25 CF, 304 S/st, 15 HP, New, HD, (2)" on the website, then getting following error:- 2 exception(s): Exception #0 (Zend_Db_Statement_Exception)...
0
votes
0answers
24 views

Search is not working for some products with magento 1.9.3.7

I know there is already asked this type of question but it does not work for me. I am using magento 1.9.3.7 version when I am going to search products, for some products it is working and for some ...
2
votes
1answer
66 views

Set default direction (ordenation) in Catalog Search Result

Magento 2 uses default "asc" ordenation for category page and Layered Navigation. But in catalog search result page, the default direction is setted to "desc" and I've debugged the code, I've found ...
3
votes
1answer
15 views

How to change advance search url

How i can change advance search url /catalogsearch/advanced/ to /catalogsearch/result/ in magento1
0
votes
0answers
23 views

Search for sku of custom option in shop

I want to configure the search to search for a sku of a custom option. I got different products with custom options and a related sku. I want to get it working, that a customer can search for the sku ...
0
votes
0answers
17 views

Magento 1.9 Custom searchbar for a specific search index

I have a category page of CMS pages, now I am trying to have a custom searchbar for a specific search index, so I can display a result page with only results from the given index. Is this even ...
0
votes
2answers
60 views

Magento 2. What is the role of the search_query table

Magento 2. What is the role of the search_query table? Where is it used? Should I ever clear it? What would be the impact of clearing it?
1
vote
2answers
186 views

Magento2: Catalog search page is not working?

I am getting this search results. How to change Catalog search results Page. When there is no results it displays fine with header and footer. When there is a results, it doesnt displays header and ...
0
votes
0answers
16 views

Strategery InfiniteScroll not working on catalogsearch page

I have installed Strategery InfiniteScroll but there is some issue with the catalogsearch page. There is not working infinitescroll but same reflection on category page works fine. Anyone know how can ...
1
vote
0answers
130 views

Magento 2.2.5 Product attribute “use in search” RESETTING after Index:reindex

UPDATE:: Today i discover that happen when the cron run index:reindex How can i fix? Today during configuring manufacturer attributes i found a bug or however an anomaly on magento 2.2.5 I setting "...
1
vote
0answers
39 views

Magento 2 search returns 1 product only

I have a problem in my store, the search returns only 1 product shows, I already did the re-index and cleared the cache. The products also have stock and visibility for catalog and search. http://...
1
vote
1answer
159 views

Magento 2.2.5: Catalog Search return blank page

I know this question has been ask alots , but i cant find the answer that can fix my problem, so here we are. At first,i enter something into the search text, for example, i enter an "S" word. Then i ...
1
vote
1answer
19 views

Make Magento search more effective? Is there a way to make it search for product names first?

Magento 1.9.1 Porto theme When we do a search for a word which is also contained in product names - it returns all kinds of products but does not show the products that actually have that word in ...
2
votes
1answer
104 views

SQLSTATE[23000]: Integrity constraint violation when searching on frontend

On my frontend when I type anything in the search box I get the following error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'position' in order clause is ambiguous, query was: ...
1
vote
0answers
225 views

Magento 2 catalog search result

I re-enabled the frontend global search and while the autocomplete suggestion work, any query returns the following error. I do notice the URL search does look like this when clicking any suggestion ...
0
votes
0answers
33 views

Magento 2.2 search leading to var/log/report entry

when I try the search engine on my magento 2.2 front office, I have the following error : General error: 1191 Can't find FULLTEXT index matching the column list, query was: INSERT INTO `...
2
votes
3answers
225 views

Improve performance - Catalog Search Fulltext

Do you have some suggestion how can I improve the performance of the catalogsearch_fulltext indexer for Magento 2.1.X I already set this indexer to 'Update By Schedule' so only the updated products ...
0
votes
0answers
95 views

How to use text field attribute in layered navigation in magento2

I want to show text filed attribute in search layered navigation. Default magento doesn't supports this but is it possible can we use text-field attribute in layer navigation? I have referred some ...
0
votes
1answer
179 views

How to change price on product filter result page?

I've created a custom module to show the installments price, and it is working OK in the product page and category page, for this, I've created a plugin, my di.xml: <?xml version="1.0"?> <...
0
votes
0answers
38 views

Magento 1.9 Disabled products displayed in Search

I am working on Magento 1.9 and facing a issue where the disabled products are showing up in search suggestion as well as in search results. What i have tried https://magento.stackexchange.com/a/...
1
vote
2answers
519 views

How to search specific SKU in magento2?

In search bar when i am searching a product using sku (100.40.10), It displays all the product whose sku is having prefix (100.xx.xx) , But i only want it to fetch whose sku is (100.40.10).
1
vote
0answers
13 views

Best method in Magento1 to set search URL's to be no index and no follow

Looking at Magento1 catalog internal search Would adding the below to the search file template be the best method to stop URL's indexing in search engines? NOINDEX,NOFOLLOW Any other ways to do?...
0
votes
0answers
14 views

How to limit search to not show price in Magento2?

Hi currently the realtime search will display everything including icon and price. For example if I type spice it will show a bunch of spice in the database as well as icon and price. What I like to ...
0
votes
2answers
214 views

Magento 2.2.4 : Way to get search result url (including the parameter)?

Every time I type something something in the search bar, I get redirected to the following url: https://XXXXXX.com/catalogsearch/result/?q=typed_text_on_search_bar Is there a way to get the complete ...
6
votes
2answers
191 views

I faced the error while search any string Magento 2

When I search for any string in Magento2 then there is result page showing blank. I got the exception.log file. "[2018-06-01 08:57:23] main.CRITICAL: SQLSTATE[HY000]: General error: 1191 Can't find ...
0
votes
0answers
12 views

getSize() is lost conditions when searching with quick search box

When I search product by sku with quick search box, It returned 3 products, but _totalRecords returned 34 products and paging had 3 pages with 12 products per page. The reason is that there are some ...
1
vote
0answers
46 views

Magento 2 : search are not relevant

Where should I look (xml file) when : Search result are bugged in only my theme. ( I have to press 2 times on the arrow "relevance" to get true result). If I use "Magento Luma", everything is fine. I ...
0
votes
0answers
149 views

Layered navigation only for subcategories in home page

I have these sub-categories under books category. I have tried adding this code to my home page as described in here Magento 2 How to show Layered Navigation on home page? . But it shows only price. ...