magento 2 : catalog search with less than 3 characters The Next CEO of Stack OverflowWhy do special characters in search terms are processed as encoded characters (only on Production Server)?Catalog search gives me a blank pageSearch catalog with less than 3 charactersMagento 2 short search keywordsCatalog Search Sorting Broken With Umlauts / Special CharactersMagento 2 Catalog Search with HyphenEnable Search Suggestion option in Catalog SearchMagento 2 catalog search resultExtend Catalog Search IndexerMagento 2.1.9 Community Edition Catalog Search page not displaying results
Is a distribution that is normal, but highly skewed considered Gaussian?
Does increasing your ability score affect your main stat?
Unclear about dynamic binding
Is it convenient to ask the journal's editor for two additional days to complete a review?
0 rank tensor vs 1D vector
Domestic-to-international connection at Orlando (MCO)
Dominated convergence theorem - what sequence?
How to count occurrences of text in a file?
Running a General Election and the European Elections together
When you upcast Blindness/Deafness, do all targets suffer the same effect?
Is it ever safe to open a suspicious HTML file (e.g. email attachment)?
Make solar eclipses exceedingly rare, but still have new moons
Writing differences on a blackboard
Can MTA send mail via a relay without being told so?
Is French Guiana a (hard) EU border?
Why didn't Khan get resurrected in the Genesis Explosion?
Axiom Schema vs Axiom
Method for adding error messages to a dictionary given a key
Is micro rebar a better way to reinforce concrete than rebar?
I believe this to be a fraud - hired, then asked to cash check and send cash as Bitcoin
Math-accent symbol over parentheses enclosing accented symbol (amsmath)
A Man With a Stainless Steel Endoskeleton (like The Terminator) Fighting Cloaked Aliens Only He Can See
Does Germany produce more waste than the US?
Newlines in BSD sed vs gsed
magento 2 : catalog search with less than 3 characters
The Next CEO of Stack OverflowWhy do special characters in search terms are processed as encoded characters (only on Production Server)?Catalog search gives me a blank pageSearch catalog with less than 3 charactersMagento 2 short search keywordsCatalog Search Sorting Broken With Umlauts / Special CharactersMagento 2 Catalog Search with HyphenEnable Search Suggestion option in Catalog SearchMagento 2 catalog search resultExtend Catalog Search IndexerMagento 2.1.9 Community Edition Catalog Search page not displaying results
I am working on magento 2.1.3.
Is there any possibility to search with 2 characters using catalog search?
Now i can't able to search terms like tv.
magento2 magento-2.1 search
add a comment |
I am working on magento 2.1.3.
Is there any possibility to search with 2 characters using catalog search?
Now i can't able to search terms like tv.
magento2 magento-2.1 search
Go toAdmin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search
– Ankit Shah
Feb 22 '17 at 6:11
magestore.com/magento-2-tutorial/…
– Ankit Shah
Feb 22 '17 at 8:51
add a comment |
I am working on magento 2.1.3.
Is there any possibility to search with 2 characters using catalog search?
Now i can't able to search terms like tv.
magento2 magento-2.1 search
I am working on magento 2.1.3.
Is there any possibility to search with 2 characters using catalog search?
Now i can't able to search terms like tv.
magento2 magento-2.1 search
magento2 magento-2.1 search
edited Feb 22 '17 at 6:26
Danny Nimmo
1,088918
1,088918
asked Feb 22 '17 at 6:05
Sudheesh K SurendranSudheesh K Surendran
105213
105213
Go toAdmin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search
– Ankit Shah
Feb 22 '17 at 6:11
magestore.com/magento-2-tutorial/…
– Ankit Shah
Feb 22 '17 at 8:51
add a comment |
Go toAdmin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search
– Ankit Shah
Feb 22 '17 at 6:11
magestore.com/magento-2-tutorial/…
– Ankit Shah
Feb 22 '17 at 8:51
Go to
Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search
– Ankit Shah
Feb 22 '17 at 6:11
Go to
Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search
– Ankit Shah
Feb 22 '17 at 6:11
magestore.com/magento-2-tutorial/…
– Ankit Shah
Feb 22 '17 at 8:51
magestore.com/magento-2-tutorial/…
– Ankit Shah
Feb 22 '17 at 8:51
add a comment |
2 Answers
2
active
oldest
votes
I do not know your search engine, I suppose that you use Mysql.
It works out of the box with ElasticSearch.
Resolution :
First set the minimun search characters to 1 in Magento configuration : Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search
The data indexed (catalogsearch_fulltext_scope1) looks like :
*************************** 1. row ***************************
entity_id: 45
attribute_id: 73
data_index: tv
The SQL query for 'tv' request:
SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, ((0) + LEAST((MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index` LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = 0 WHERE (stock_index.stock_status = 1) AND (MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 10000
If you check Mysql documentation, there are two parameters for Configuring Minimum and Maximum Word Length :
http://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
So edit your my.cnf file, add these parameters :
ft_min_word_len = 1
innodb_ft_min_token_size = 1
Restart mysql
service mysql restart
Rebuild your index
bin/magento indexer:reindex
Then you will see your product on the search result page.
Moreover for information, Mysql search engine will be depraciated and replaced by ElastiSearch
– Franck Garnier
Nov 20 '18 at 8:44
add a comment |
In my case i needed 'edit' this file:
vendormagentoframeworkSearchAdapterMysqlQueryBuilderMatch.php
There was a constant and ignore config from backend
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f161166%2fmagento-2-catalog-search-with-less-than-3-characters%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
I do not know your search engine, I suppose that you use Mysql.
It works out of the box with ElasticSearch.
Resolution :
First set the minimun search characters to 1 in Magento configuration : Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search
The data indexed (catalogsearch_fulltext_scope1) looks like :
*************************** 1. row ***************************
entity_id: 45
attribute_id: 73
data_index: tv
The SQL query for 'tv' request:
SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, ((0) + LEAST((MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index` LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = 0 WHERE (stock_index.stock_status = 1) AND (MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 10000
If you check Mysql documentation, there are two parameters for Configuring Minimum and Maximum Word Length :
http://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
So edit your my.cnf file, add these parameters :
ft_min_word_len = 1
innodb_ft_min_token_size = 1
Restart mysql
service mysql restart
Rebuild your index
bin/magento indexer:reindex
Then you will see your product on the search result page.
Moreover for information, Mysql search engine will be depraciated and replaced by ElastiSearch
– Franck Garnier
Nov 20 '18 at 8:44
add a comment |
I do not know your search engine, I suppose that you use Mysql.
It works out of the box with ElasticSearch.
Resolution :
First set the minimun search characters to 1 in Magento configuration : Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search
The data indexed (catalogsearch_fulltext_scope1) looks like :
*************************** 1. row ***************************
entity_id: 45
attribute_id: 73
data_index: tv
The SQL query for 'tv' request:
SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, ((0) + LEAST((MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index` LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = 0 WHERE (stock_index.stock_status = 1) AND (MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 10000
If you check Mysql documentation, there are two parameters for Configuring Minimum and Maximum Word Length :
http://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
So edit your my.cnf file, add these parameters :
ft_min_word_len = 1
innodb_ft_min_token_size = 1
Restart mysql
service mysql restart
Rebuild your index
bin/magento indexer:reindex
Then you will see your product on the search result page.
Moreover for information, Mysql search engine will be depraciated and replaced by ElastiSearch
– Franck Garnier
Nov 20 '18 at 8:44
add a comment |
I do not know your search engine, I suppose that you use Mysql.
It works out of the box with ElasticSearch.
Resolution :
First set the minimun search characters to 1 in Magento configuration : Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search
The data indexed (catalogsearch_fulltext_scope1) looks like :
*************************** 1. row ***************************
entity_id: 45
attribute_id: 73
data_index: tv
The SQL query for 'tv' request:
SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, ((0) + LEAST((MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index` LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = 0 WHERE (stock_index.stock_status = 1) AND (MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 10000
If you check Mysql documentation, there are two parameters for Configuring Minimum and Maximum Word Length :
http://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
So edit your my.cnf file, add these parameters :
ft_min_word_len = 1
innodb_ft_min_token_size = 1
Restart mysql
service mysql restart
Rebuild your index
bin/magento indexer:reindex
Then you will see your product on the search result page.
I do not know your search engine, I suppose that you use Mysql.
It works out of the box with ElasticSearch.
Resolution :
First set the minimun search characters to 1 in Magento configuration : Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search
The data indexed (catalogsearch_fulltext_scope1) looks like :
*************************** 1. row ***************************
entity_id: 45
attribute_id: 73
data_index: tv
The SQL query for 'tv' request:
SELECT `main_select`.`entity_id`, MAX(score) AS `relevance` FROM (SELECT `search_index`.`entity_id`, ((0) + LEAST((MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE)), 1000000) * POW(2, search_weight)) AS `score` FROM `catalogsearch_fulltext_scope1` AS `search_index` LEFT JOIN `catalog_eav_attribute` AS `cea` ON search_index.attribute_id = cea.attribute_id LEFT JOIN `cataloginventory_stock_status` AS `stock_index` ON search_index.entity_id = stock_index.product_id AND stock_index.website_id = 0 WHERE (stock_index.stock_status = 1) AND (MATCH (data_index) AGAINST ('tv' IN BOOLEAN MODE))) AS `main_select` GROUP BY `entity_id` ORDER BY `relevance` DESC LIMIT 10000
If you check Mysql documentation, there are two parameters for Configuring Minimum and Maximum Word Length :
http://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
So edit your my.cnf file, add these parameters :
ft_min_word_len = 1
innodb_ft_min_token_size = 1
Restart mysql
service mysql restart
Rebuild your index
bin/magento indexer:reindex
Then you will see your product on the search result page.
answered Feb 22 '17 at 8:11
Franck GarnierFranck Garnier
2,096926
2,096926
Moreover for information, Mysql search engine will be depraciated and replaced by ElastiSearch
– Franck Garnier
Nov 20 '18 at 8:44
add a comment |
Moreover for information, Mysql search engine will be depraciated and replaced by ElastiSearch
– Franck Garnier
Nov 20 '18 at 8:44
Moreover for information, Mysql search engine will be depraciated and replaced by ElastiSearch
– Franck Garnier
Nov 20 '18 at 8:44
Moreover for information, Mysql search engine will be depraciated and replaced by ElastiSearch
– Franck Garnier
Nov 20 '18 at 8:44
add a comment |
In my case i needed 'edit' this file:
vendormagentoframeworkSearchAdapterMysqlQueryBuilderMatch.php
There was a constant and ignore config from backend
add a comment |
In my case i needed 'edit' this file:
vendormagentoframeworkSearchAdapterMysqlQueryBuilderMatch.php
There was a constant and ignore config from backend
add a comment |
In my case i needed 'edit' this file:
vendormagentoframeworkSearchAdapterMysqlQueryBuilderMatch.php
There was a constant and ignore config from backend
In my case i needed 'edit' this file:
vendormagentoframeworkSearchAdapterMysqlQueryBuilderMatch.php
There was a constant and ignore config from backend
answered 2 days ago
MarcMarc
1112
1112
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f161166%2fmagento-2-catalog-search-with-less-than-3-characters%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Go to
Admin -> Stores -> Configuration -> Catalog -> Catalog -> Catalog Search
– Ankit Shah
Feb 22 '17 at 6:11
magestore.com/magento-2-tutorial/…
– Ankit Shah
Feb 22 '17 at 8:51