How do I change Magento search to bring up products no matter what order the search terms are in?
I have a problem with Magento search. The search terms have to be in the exact order the way they are listed in the title.
Example: If I search for "Big Green Truck" I get product results but if I search for "Green Big Truck" nothing comes up. There has to be an easy code fix for this. Please help, I am a new-bee
Thank you
search
edited 2 mins ago
Shoaib Munir
11611
asked Jul 1 '14 at 3:09
EricEric
111
add a comment |
I have a problem with Magento search. The search terms have to be in the exact order the way they are listed in the title.
Example: If I search for "Big Green Truck" I get product results but if I search for "Green Big Truck" nothing comes up. There has to be an easy code fix for this. Please help, I am a new-bee
Thank you
search
edited 2 mins ago
Shoaib Munir
11611
asked Jul 1 '14 at 3:09
EricEric
111
Try changing the search mode to "Fulltext & Like". You can do that from system->configuration->catalog.
– Marius♦
Jul 1 '14 at 8:40
add a comment |
I have a problem with Magento search. The search terms have to be in the exact order the way they are listed in the title.
Example: If I search for "Big Green Truck" I get product results but if I search for "Green Big Truck" nothing comes up. There has to be an easy code fix for this. Please help, I am a new-bee
Thank you
search
edited 2 mins ago
Shoaib Munir
11611
asked Jul 1 '14 at 3:09
EricEric
111
I have a problem with Magento search. The search terms have to be in the exact order the way they are listed in the title.
Example: If I search for "Big Green Truck" I get product results but if I search for "Green Big Truck" nothing comes up. There has to be an easy code fix for this. Please help, I am a new-bee
Thank you
search
search
edited 2 mins ago
Shoaib Munir
11611
asked Jul 1 '14 at 3:09
EricEric
111
edited 2 mins ago
Shoaib Munir
11611
asked Jul 1 '14 at 3:09
EricEric
111
edited 2 mins ago
Shoaib Munir
11611
edited 2 mins ago
Shoaib Munir
11611
edited 2 mins ago
Shoaib Munir
11611
11611
asked Jul 1 '14 at 3:09
EricEric
111
asked Jul 1 '14 at 3:09
EricEric
111
asked Jul 1 '14 at 3:09
EricEric
111
111
Try changing the search mode to "Fulltext & Like". You can do that from system->configuration->catalog.
– Marius♦
Jul 1 '14 at 8:40
add a comment |
Try changing the search mode to "Fulltext & Like". You can do that from system->configuration->catalog.
– Marius♦
Jul 1 '14 at 8:40
Try changing the search mode to "Fulltext & Like". You can do that from system->configuration->catalog.
– Marius♦
Jul 1 '14 at 8:40
Try changing the search mode to "Fulltext & Like". You can do that from system->configuration->catalog.
– Marius♦
Jul 1 '14 at 8:40
add a comment |
2 Answers
2
active
oldest
votes
/app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext.php
At line 345 change OR to AND
Please let me know if its ok. Tks
Edit: dont forget to delete existing search terms and refresh cache
answered Jul 1 '14 at 6:45
Bogdan S.Bogdan S.
465
add a comment |
Magento internal search is 20-50% accurate, SPhinx/Lucene 60-80% accurate, Solr is 98% accurate - so we use solr. You can fiddle with the sql but in the end you are limited by the fundamentatls of sql search.
What a proposterly incorrect answer. SOLR is Lucene! Not to mention no search engine has a percentage rating for accuracy. It is as accurate as you make it.
– choco-loo
Oct 11 '14 at 18:02
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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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%2f25552%2fhow-do-i-change-magento-search-to-bring-up-products-no-matter-what-order-the-sea%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
/app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext.php
At line 345 change OR to AND
Please let me know if its ok. Tks
Edit: dont forget to delete existing search terms and refresh cache
answered Jul 1 '14 at 6:45
Bogdan S.Bogdan S.
465
add a comment |
/app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext.php
At line 345 change OR to AND
Please let me know if its ok. Tks
Edit: dont forget to delete existing search terms and refresh cache
answered Jul 1 '14 at 6:45
Bogdan S.Bogdan S.
465
add a comment |
/app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext.php
At line 345 change OR to AND
Please let me know if its ok. Tks
Edit: dont forget to delete existing search terms and refresh cache
answered Jul 1 '14 at 6:45
Bogdan S.Bogdan S.
465
/app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext.php
At line 345 change OR to AND
Please let me know if its ok. Tks
Edit: dont forget to delete existing search terms and refresh cache
answered Jul 1 '14 at 6:45
Bogdan S.Bogdan S.
465
answered Jul 1 '14 at 6:45
Bogdan S.Bogdan S.
465
answered Jul 1 '14 at 6:45
Bogdan S.Bogdan S.
465
answered Jul 1 '14 at 6:45
Bogdan S.Bogdan S.
465
465
add a comment |
add a comment |
Magento internal search is 20-50% accurate, SPhinx/Lucene 60-80% accurate, Solr is 98% accurate - so we use solr. You can fiddle with the sql but in the end you are limited by the fundamentatls of sql search.
What a proposterly incorrect answer. SOLR is Lucene! Not to mention no search engine has a percentage rating for accuracy. It is as accurate as you make it.
– choco-loo
Oct 11 '14 at 18:02
add a comment |
Magento internal search is 20-50% accurate, SPhinx/Lucene 60-80% accurate, Solr is 98% accurate - so we use solr. You can fiddle with the sql but in the end you are limited by the fundamentatls of sql search.
What a proposterly incorrect answer. SOLR is Lucene! Not to mention no search engine has a percentage rating for accuracy. It is as accurate as you make it.
– choco-loo
Oct 11 '14 at 18:02
add a comment |
Magento internal search is 20-50% accurate, SPhinx/Lucene 60-80% accurate, Solr is 98% accurate - so we use solr. You can fiddle with the sql but in the end you are limited by the fundamentatls of sql search.
Magento internal search is 20-50% accurate, SPhinx/Lucene 60-80% accurate, Solr is 98% accurate - so we use solr. You can fiddle with the sql but in the end you are limited by the fundamentatls of sql search.
answered Jul 1 '14 at 8:38
user2935
What a proposterly incorrect answer. SOLR is Lucene! Not to mention no search engine has a percentage rating for accuracy. It is as accurate as you make it.
– choco-loo
Oct 11 '14 at 18:02
add a comment |
What a proposterly incorrect answer. SOLR is Lucene! Not to mention no search engine has a percentage rating for accuracy. It is as accurate as you make it.
– choco-loo
Oct 11 '14 at 18:02
What a proposterly incorrect answer. SOLR is Lucene! Not to mention no search engine has a percentage rating for accuracy. It is as accurate as you make it.
– choco-loo
Oct 11 '14 at 18:02
What a proposterly incorrect answer. SOLR is Lucene! Not to mention no search engine has a percentage rating for accuracy. It is as accurate as you make it.
– choco-loo
Oct 11 '14 at 18:02
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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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%2f25552%2fhow-do-i-change-magento-search-to-bring-up-products-no-matter-what-order-the-sea%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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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
Try changing the search mode to "Fulltext & Like". You can do that from system->configuration->catalog.
– Marius♦
Jul 1 '14 at 8:40