We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [catalogsearch]

Denotes questions related to the Magento catalog search engine

Filter by
Sorted by
Tagged with
0
votes
0answers
6 views

Sort search result products by attribute value in Magento 2

I want to sort the search result collection by product attribute value. Scenario: I have created a custom attribute called "product_category" as a drop down attribute. Which has the below options, ...
0
votes
0answers
18 views

Magento2 Enterprise Edition - Elasticsearch Catalog Permissions Issue

Facing an issue with the Elasticsearch Catalog Permissions on Search & Product List pages. Pre-Conditions: Search Engine - Elasticsearch 6.x Category Permissions - Enabled in configuration and ...
0
votes
0answers
8 views

How to use custom fields in product search query in Magento 2?

The end user needs to be able to search for products using a new field and with data coming from a new table. I added a new string ID field to table catalog_product_entity and created a new table ...
0
votes
0answers
16 views

Magento 1 - Show custom module data in catalog search result page

I want to show custom module data in the search result page along with default data collection. Please suggest a proper solution for the same. Thanks in advance.
0
votes
1answer
10 views

Magento 1.x not showing default Catalogsearch Result Pages

I have removed Searchanise extetension from the code. After that my default Catalogsearch is not working. Control coming in Result, List in this blocks but phtml files related to those block was not ...
0
votes
0answers
15 views

Magento 1 catalogsearch_fulltext table search not working

During Fulltext search Looking for string 'snowden' (it is a books database), on Magento native frontend search returns 8 results. In catalogsearch_fulltext table, typing the query SELECT * FROM ...
0
votes
1answer
29 views

EAV indexer optimization: cannot find option

There is a section in the Magento 2.3 documentation that is titled EAV indexer optimization. It says that you should basically disable the EAV indexer, if you are not using a MySQL based search ...
0
votes
0answers
8 views

How can I display a static block as the second search result in a product search

I would like to incorporate an html block to serve as a banner as the second search result when someone searches for a product on my site. Example: User searches for shirts result 1. Red Shirt 2. ...
0
votes
1answer
30 views

Generate Search Issue when searching just few specific strings on Magento 2.3.2

When I am searching on Magento 2.3.2 website it is generating error as I have provided the image below. It generates results which looks like queries and generate on a specific string. Please help me ...
1
vote
0answers
26 views

Magento 2.2.6 Product Pages Not Opening after upgrade

The product detail pages on my site are no longer opening after upgrading from magento 2.2 to 2.2.6 There are no error rather a catalog search results page is loading instead http://mydomain.co.uk/...
0
votes
1answer
20 views

magento 1.9 Catalog search result showing encoded result in other languages other than english

I have a multi-store website with different languages when I search the terms from other languages it gives an incorrect result with special characters. and the URL is like this catalogsearch/...
1
vote
1answer
123 views

Magento2 enabling elasticsearch empties all categories

I installed elasticsearch and the Magento backend connection test to elasticsearch is successful. If I save settings, clear the cache and reindex as described in the Magento devdocs, all product ...
0
votes
1answer
13 views

Link to search filters by price only

I would like to create links that will search the product catalog by price only without giving any text string. e.g. a link like http://www.example.com/catalogsearch/result/?price=51-100 to directly ...
2
votes
0answers
35 views

Magento 2 Catalog search results are not correct?

I have migrated data from magento 1 to magento 2. I am searching product name: 4.0ct Round Morganite Diamond Engagement Ring Bridal Set 14k White Gold then it is showing lots of products on result ...
0
votes
0answers
13 views

Search is slow for some search strings

I have a magento 2 commerce site. In the header when I search for certain keywords the results load fast _1-2 secs) but for other search strings it loads slow 7-10 seconds. I understand results are ...
1
vote
0answers
12 views

Infinite loop search page

While accessing the search url (http://localhost/mage2/catalogsearch/result/ or http://localhost/mage2/catalogsearch/result/index) infinite loop. Is it possible redirect to home page? Thanks.
0
votes
0answers
75 views

magento 2.3 why the deleted products still show at the dropdown of search box

I am using magento2.3 and porto theme why the deleted products still show at the dropdown of search box I have cleared all cache ,and clicked the following 5 cache:"Flush Magento Cache,Flush Cache ...
0
votes
0answers
43 views

Mysql query INSERT INTO “search_tmp…” never ends after mass attribute update in Magento 2.3.0 Causes Server overload and site down

MySQL query INSERT INTO “search_tmp…” never ends after mass attribute update in Magento 2.3.0 Causes Server overload and site down my mysql found this query very sluggish and slow, which is as ...
0
votes
2answers
107 views

Magento 2: Unable to unserialize value. Error: Control character error, possibly incorrectly encoded

I am getting Bellow Error when i try to search default Magento search https://temp.com/catalogsearch/result/?q=Hiper Unable to unserialize value. Error: Control character error, possibly incorrectly ...
0
votes
1answer
34 views

Magento 2 search suggestion showing some character and symbols

My search is not working fine, when i try to search, it shows some unknown and irrelevant charters in the suggestion.
1
vote
0answers
30 views

Magento 2 : Website Search Functionality is not Accurate

The search functionality is no longer accurate and provide irrelevant products on my Magento2.3 site. For e.g. when one search for 'shirt' other products appear. How can this be solved so that my ...
0
votes
0answers
33 views

Magento2: how to add fulltext search query in block page

Magento2 : How to add a full-text search query in a block's function within a custom module? This is what I am trying so far: $postCollection->addFieldToSelect('*'); if($search != '') { ...
0
votes
1answer
45 views

How can I add categories to search suggestions in magento 2.3

Am using elastic search as the search engine. Can anyone tell me how can I extend the search suggestions in Magento 2.3.1 to add the categories in search suggestion? Any small help or clue will be ...
0
votes
0answers
9 views

Show filters with price zero at bottom of the list page, Magento 2

We have products whose prices are zero.In list page when i use an filter by price from low to high , the product with zero price will come first.Is there any way to make them bottom of page by using ...
0
votes
1answer
19 views

Search not finding whole words?

I am using Magento 1.9.3.2 and when I search for mercedes on my site, it finds several products such as Original Mercedes-Benz Typenzeichen Zeichen Hecktür Flügeltür SPRINTER. Now, when I search for ...
0
votes
0answers
24 views

Magento2: Search by Keyword in logic update for Grid

In Magento2, For Admin Product Grids, Search by keyword logic is not working effectively when catalog size is bigger. (>= 25 lacs) Due to its searching logic: Searching by SKU Searching by Product ...
0
votes
0answers
22 views

Magento 2.3 - Does default search suggestion doesn't suggest product names?

Can anyone tell me what does the default magento 2.3 search suggestion suggests? Am using default elastic search engine for search. Can I able to suggest product names?
0
votes
0answers
115 views

Magento CE 2.2.2 Elastic Search No Products Front End Category / Listing Pages

Magento CE 2.2.2 ElasticSearch 6.4 PHP 7.1 Apache 2.4 Magento CE 2.2.2 Elastic Search No Products Front End Category / Listing Pages We have installed Amasty Layered Navigation Amasty ...
0
votes
0answers
32 views

Magento 2 : Is search_tmp table removed while doing search for any term?

When searching for any term, earlier Magento by default search_tmp_* table (memory table) was created run time. Whereas in Magento 2.3.2 it is not generating search_tmp_* table when using Elastic ...
0
votes
1answer
29 views

How to custom search function in Magento 2

Because the search of Magento 2 works wrong with my shop, I want a custom search function in Magento 2 but I don't know it where. Please help me, where is function in vendor
3
votes
0answers
75 views

Magento 2.3 Result page blank if an item is found

I am trying to search for products on my Magento 2.3 site. When the result is empty (there are no products found) it just shows a page saying there are no products found. Perfect! But when there is a ...
3
votes
0answers
23 views

Search product work wrong in Magento 2.x

i have a problem with searching products in Magento 2. Ex : My store have 2 products, ABC and XYZ. When I search for the keyword "ABC" or "XYZ", it show product ABC or XYZ. But if i search for ...
0
votes
1answer
22 views

What is the impact if I truncate search_query table?

In my live site currently we have 2.1M records in the search_query table. Due to this large number of records we are facing search slowness. Whether it is advisable to truncate that table or remove ...
0
votes
1answer
40 views

Magento2: How to get product collection by full text search?

How to get product collection by full text search? $query = $this->queryFactory->get()->getQueryText(); $collection = $this->_productCollectionFactory->create(); ...
2
votes
0answers
32 views

Magento 2 Elastic search results show different relevant results

We are using Magento 2.1.8 and facing issue with elastic search results, it's returning all relevant results instead of exact results.
1
vote
2answers
36 views

Magento 2: no search results

When I enter a search query, Magento returns "no results". I am not using any search-related extensions. Already tried reindexing. Where should I start debugging this? I am running Magento 2.2.8
1
vote
0answers
15 views

Magento2: How can customize fulltext to like in admin product grid search?

I want to customize fulltext search with like in product admin grid in Magento2.3. Please find below screenshot: I have checked Module-catalog search for admin grid but unable to do customization. ...
1
vote
1answer
86 views

magento 2.3 search issue

Product SKU based AND PRODUCT NAME SEARCH Not working properly if SKU consists of a special character like (space, dot, etc) it results not giving the exact result. Is there any solution for this? ...
0
votes
0answers
29 views

After update to Magento 2.3.1 the visibilty of Products ist wrong

After I had "stupidly" made an update to Magento 2.31. I have the problem that my configurable child-products are displayed in the frontend. In the admin-article-overview, the value is shown as "...
2
votes
2answers
221 views

Magento 2: Allow empty query field in search

On the webshop that I'm working on, the user can find products by choosing filters (attributes like color/size/category) and/or entering a search query, the search results are then displayed on the ...
4
votes
0answers
40 views

Sort by price is not working on magento 2

This is a website link https://magento-202257-609939.cloudwaysapps.com/catalogsearch/result/index/?product_list_dir=asc&q=wera I am developing for my client and after a search of any product when ...
2
votes
1answer
27 views

Refined search queries

I am currently making a Magento 2 store, and have two separate searches; the first one is just a normal query that searches the whole product database. However, it's the second one that I'm having ...
0
votes
0answers
33 views

Magento 2: How to get search products Collection

I need to get search products collection in .phtml. Currently i'm getting but Bundle products are missing. I want custom search collection. Thanks in advance.
0
votes
0answers
15 views

Search results not showing in main results screen, but are being returned

We are running Magento 2.3. I have been doing some API work (NO internal magento changes) to update products, but have been using the same code for weeks without issue. All of a sudden, searching ...
0
votes
2answers
29 views

Products visible only on the search page

Products are visible only on the search page, but not available on the category page. Admin products visibility on Catalog and Search: Category page screen: Category page filters show the count of ...
0
votes
0answers
271 views

magento 2.3.1 - How to sort product name, price in ascending order in search result page?

Below is my search result page sort by product name in result page. Products are sorting by name by Z to A. I want to show the products in A-Z order when user click Product Name sort By option.How ...
0
votes
0answers
51 views

How sort by option working in category page and search result page in magento 2?

In My category page sort by option if i click Product Name products are sorting A-Z, In Search Page if i click Product Name products are sorting Z-A. Is there any setting to do to sort the products A-...
0
votes
0answers
21 views

How To Add Search By Category In Advanced Search in magento 2.3?

How To Add Search By Category In Advanced Search in magento 2.3 ?
0
votes
0answers
13 views

I have a product that has the same ID between two seperate stores but has different product names

How did that happen? Same SKU as well between both stores. When i search a keyword to find the product in the product grid it only returns one product. However, I get a different product when ...
2
votes
2answers
29 views

Magento 1 location of search bar code

I am trying to move my search bar bar into the white bar so that I can delete the tan bar: But I don't know where to look to find the code for the search bar either in the admin panel or in code.