Questions tagged [fulltext]

The tag has no usage guidance.

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

Magento 2 - Fulltext search Product SKU / Product Name in Sales Order Grid

I'm a newbie, new to magento 2. Please guide me here: I want to search fulltext product sku and product id in grid order. I have now added the product sku and product id to the grid, the filter is ...
user avatar
0 votes
0 answers
19 views

How to change Elastic Search's "OR" search logic to "AND" in Magento version 2.4.2+

Is it possible to change the default customization of "OR" to "AND" in Elastic Search version 7.9? If so, where? If I for example search for 'proteus fitness' it shows products ...
user avatar
  • 1
0 votes
0 answers
88 views

Magento 2.4.2 Elastic search 7 Fulltext search

I am trying to customize the default Magento 2.4.2 Elasticsearch 7. Right now the default Full-text search is not giving that good result. For Example I have product name like Women T shirt, Men T ...
user avatar
  • 71
1 vote
0 answers
315 views

Magento 2 custom ui_grid filterSearch issue

I have an error when attempting to search for a keyword in my custom table In Network tab, i have a call to https://mylocalsite.local/admin/mui/index/render/?namespace=my_grid&search=123&...
user avatar
  • 13
0 votes
1 answer
2k views

Fulltext search throws "The bucket doesn't exist"

Reopening this discussion, as none of the found solutions worked. I have about 60 categories and subcategories, going down 4 levels deep. Number of products is irrelevant, this bug reproduces with 10 ...
user avatar
1 vote
1 answer
391 views

Magento 2: Adding full text search to custom grid results in error on count query

I am trying to add full text search to a custom grid. I have done the following steps added full text indexes to related columns in the table in the ui component xml file, added <filterSearch name=...
user avatar
5 votes
1 answer
396 views

Custom search functionality

I want to implement custom full text search functionality for front end that fetch result only from company table. Kindly please let me know if you guys have any idea. In frontend User can search with ...
user avatar
1 vote
0 answers
58 views

How data are coming into ElasticSearch while running catalogsearch_fulltext?

I have ElasticSearch as a catalogue search engine. Whenever we are running catalogsearch_fulltext, it is pushing the data into ElasticSearch. I need to do apply a filter to those data before pushing ...
user avatar
  • 9,489
0 votes
1 answer
2k 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(); ...
user avatar
  • 1,127
5 votes
0 answers
225 views

Magento 2 - Product names with number/digits & special characters are not searchable

I have product names like ' 8" X 6" cards ' they contain measurements i.e. numbers and characters. when I try to search these products on the frontend. the Ajax search returns the product fine and ...
user avatar
3 votes
1 answer
541 views

Magento 2.2.5: About Search FullText

I'm doing "search by fulltext" in "Banner Slider" module, and every thing works perfect, but when i click on "x" button to reset the search, it return exactly the same slide as the last slide which in ...
user avatar
  • 1,168
3 votes
0 answers
232 views

Magento Full Text Search through API

I have an API2 REST end point that is trying to do a full text search. The problem is that it's always returning empty results for not specific reason. This is the code i have: $query = Mage::...
user avatar
0 votes
1 answer
190 views

Fulltext search in layered navigation page

if we pass a query string in the /catalogsearch/result?q=string page it will return products which match the string with any of its attributes. But in the filter navigation search result page, we can'...
user avatar
  • 77
7 votes
4 answers
4k views

How do I change Magento 2 search from OR logic to AND?

How do I change Magento 2 mini search logic from OR to AND? Right now if I search for 'Shoe laces', it returns all products with terms either 'shoe' or 'laces'. I need a Fulltext search so that only ...
user avatar
  • 191
3 votes
2 answers
3k views

Magento2: Search programatically like Magento2

I've tried looking for products programmatically that get the same results as magento 2 searches (In the search box). I have used: $result = array(); $filter1 = $this->_filterBuilder->...
user avatar
  • 529
1 vote
1 answer
2k views

Magento2: FullText Search Programatically

Does anyone know how to run a search using FullText and a string? I'm trying to inject use Magento\CatalogSearch\Model\ResourceModel\Fulltext\Collection as Fulltext; and do $this->_fulltext->...
user avatar
  • 529
2 votes
1 answer
63 views

sphinx search enable ssl

when I enable the SSL i got the following error and indexing search can any one now about this error
user avatar
2 votes
1 answer
30 views

Editing catalog product

I would like to change the text of my product file. to change the text "19 pour inclut" with "tva inclue" I tried to find the file in /app/design/frontend/default/your_theme/template/catalog/product/...
user avatar
  • 21
1 vote
0 answers
173 views

Add categories to fulltext index table

While for regular product attributes like manufacturer, name, color, you can choose to include or exclude from search. For product categories is not possible. So if I go to the table "...
user avatar
3 votes
1 answer
1k views

Error when running full text search in Magento 1.9.3.0

I was installing some e-commerce tagging for a customer (cart.phtml and view.phtml) and after doing some regression testing it was found that the full-text search function was not working. This ...
user avatar
  • 131
0 votes
1 answer
615 views

How data is inserted in catalogsearch_fulltext table?

I have two stores. The catalogsearch_fulltext table contains values for a product available in both stores as shown in screen shot below. The values inserted in name column are SURGICAL STEEL ...
user avatar
1 vote
1 answer
350 views

How to add custom module content in magento 2.0.7 list.phtml

How to add custom module content in magento 2.0.7 list.phtml Without modifying core list.phtml i need to append my custom module content in magento 2.0.7 list.phtml
user avatar
0 votes
1 answer
42 views

Search results - item count doesn't match up to actual count

Getting a weird issue on my Magento search results page. Basically, it says "17 item(s)" in the header, yet if I manually count them up, I only have 12! That was by selecting "all" from the item ...
user avatar
2 votes
1 answer
2k views

Constant lock wait timeout

My site is constantly getting bogged down my lock wait timeouts. I'm using a virtual server with 6 cores and 6gb of ram. There's about 1,500 products on my site and it's a multi-domain installation. I'...
user avatar
  • 161
0 votes
2 answers
2k views

CatalogSearch - add weight to different attributes

I have my fulltext catalogsearch working fine for now, but I still see some not-so-relevant results. Before telling me that Magento's built-in search is terrible I'll tell you that I know there are ...
user avatar
1 vote
2 answers
1k views

CatalogSearch - exclude child product names from fulltext

I've been playing with the catalogsearch for a while, and I'm almost done, but there is one odd thing happening to me. The only "usable in search" attributes are name, child_skus and synonyme. In ...
user avatar