jty, where did your post go? I was about to reply to it. I hope it wasn't a moderator censoring the posts again.
My understanding is that Daniel is going to give us Ajax search (whatever that is), and that it will be greatly improved over the current search feature.
In the mean time, I suggest you have very good categories, and that you put up a notice to your customers that they should use the categories instead of the search feature.
My understanding is that Daniel is going to give us Ajax search (whatever that is), and that it will be greatly improved over the current search feature.
In the mean time, I suggest you have very good categories, and that you put up a notice to your customers that they should use the categories instead of the search feature.
I deleted it cos I found a solution. I posted in a moment of complete frustration. My patience level is only 2 years waitPurebeads wrote:jty, where did your post go? I was about to reply to it. I hope it wasn't a moderator censoring the posts again.

Well, it has to be better than the current search cos nothing can be worst than the current search except for no search.My understanding is that Daniel is going to give us Ajax search (whatever that is), and that it will be greatly improved over the current search feature.
This is my one and only criticism of Open Cart and I don't understand why this has been left out of every release when non-essentials like reviews are put in.
I don't care if it's ajax search or jquery search or some other fancy techo word search. I just want a search that can be used by ordinary perople without the need to understand that they need to have the exact term in the exact order of words.
Here's a better solution. Throw out the current search and see this topicIn the mean time, I suggest you have very good categories, and that you put up a notice to your customers that they should use the categories instead of the search feature.
Problem with internal search engine 1.4.8b
http://forum.opencart.com/viewtopic.php?t=19032
I wasn't able to get the other search help working but it is looking that dbstr in that thread is my saviour.
I need to test it further but it's looking good so far on 1.4.9
Thanks for listening to my tantrum. LOL.
I just read that thread, and the last poster said that he was getting too many results, so the solution isn't perfect.
I'm not willing to modify my code that much. I'm just too afraid that the cart will stop working; and if it does, no one will help me to fix it. (Of course, I can always restore the backup file, but I don't need the headache of messing up my cart and then having to fix it.)
For me, OpenCart with a poor search function is still dramatically better than what I had before. On the home page of my cart, I say, "It is better to use the categories than the search function", and I leave it at that. When I first installed the cart, the first customer who tried it out noticed the poor search function, so I put my notice on the home page. In my case, I don't believe that I'm losing sales. However, I'll be very happy when Ajax search is installed.
Incidentally, as a consumer, I can tell you that I am very persistent when trying to find a product. All those people who are getting poor results doing searches on your site are probably trying other search terms before they give up.
By the way, there are plenty of other features that the cart should have, but they are generally available as modules.
I'm not willing to modify my code that much. I'm just too afraid that the cart will stop working; and if it does, no one will help me to fix it. (Of course, I can always restore the backup file, but I don't need the headache of messing up my cart and then having to fix it.)
For me, OpenCart with a poor search function is still dramatically better than what I had before. On the home page of my cart, I say, "It is better to use the categories than the search function", and I leave it at that. When I first installed the cart, the first customer who tried it out noticed the poor search function, so I put my notice on the home page. In my case, I don't believe that I'm losing sales. However, I'll be very happy when Ajax search is installed.
Incidentally, as a consumer, I can tell you that I am very persistent when trying to find a product. All those people who are getting poor results doing searches on your site are probably trying other search terms before they give up.
By the way, there are plenty of other features that the cart should have, but they are generally available as modules.
Agreed. Before Open Cart I was using an asp commercial shopping cart. Then I installed Open Cart and all these orders started coming in. So, I went to Google and found myself on page 1.Purebeads wrote:For me, OpenCart with a poor search function is still dramatically better than what I had before.
Daniel and Qphoria's brains powered me from nowhere in Google to page 1. How good is that. So good that I went straight for the donation button. So good that one of my suppliers rang me and asked how I did it.
However, search is all important to me. Search is how Google became King and how the word google became a verb
Features like tag clouds, testimonials, reviews, coupons, they are good but search is more important IMO. The search button in our sites has to compete with the search button up top that the user can easily choose to go back to Google/Yahoo/Bing.
But ignore me. I was just having a frustration tantrum, hence, I deleted my post.
I apologize for having a hissy fit. LOL. I am happy now. I have my search mod and Open Cart is 100% perfect.
Are you sure the search function is working well now? In the other thread that you referenced, the final poster said that he was now getting too many results. Have you looked at the code and found a way to fix that?jty wrote:However, search is all important to me. Search is how Google became King and how the word google became a verb
Features like tag clouds, testimonials, reviews, coupons, they are good but search is more important IMO. The search button in our sites has to compete with the search button up top that the user can easily choose to go back to Google/Yahoo/Bing.
But ignore me. I was just having a frustration tantrum, hence, I deleted my post.
I apologize for having a hissy fit. LOL. I am happy now. I have my search mod and Open Cart is 100% perfect.
That's important to me because, if I use that mod as it is written, my customers will get way too many results. For example, I sell beads called "rondels". The way the mod is written now (apparently), if a customer searches for "blue rondels", she'll get not just the blue rondels, but all the blue beads and all the rondel beads. So instead of getting 5 items, she'll get 75 items. That would be a disaster.
then you should leave your search as it is, but this is a rare instance for stores to get that many results. I really do think that the search kewords should be exploded with and "and" search by default. as this is the behavior that most people expect.Purebeads wrote:Are you sure the search function is working well now? In the other thread that you referenced, the final poster said that he was now getting too many results. Have you looked at the code and found a way to fix that?jty wrote:However, search is all important to me. Search is how Google became King and how the word google became a verb
Features like tag clouds, testimonials, reviews, coupons, they are good but search is more important IMO. The search button in our sites has to compete with the search button up top that the user can easily choose to go back to Google/Yahoo/Bing.
But ignore me. I was just having a frustration tantrum, hence, I deleted my post.
I apologize for having a hissy fit. LOL. I am happy now. I have my search mod and Open Cart is 100% perfect.
That's important to me because, if I use that mod as it is written, my customers will get way too many results. For example, I sell beads called "rondels". The way the mod is written now (apparently), if a customer searches for "blue rondels", she'll get not just the blue rondels, but all the blue beads and all the rondel beads. So instead of getting 5 items, she'll get 75 items. That would be a disaster.
OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter
Purebeads, lets go to the other thread to continue so we don't dirty this threadPurebeads wrote:Are you sure the search function is working well now? In the other thread that you referenced, the final poster said that he was now getting too many results. Have you looked at the code and found a way to fix that?
Moderators, feel free to delete my post above to keep this place clean.
You've mentioned this elsewhere Xsecrets, and if I've understood correctly, I agree.Xsecrets wrote: .... I really do think that the search kewords should be exploded with and "and" search by default. as this is the behavior that most people expect.
The current search - if you use more than word - searches for the exact search string.
I've tried a couple of mods which search for Keyword A OR Keyword B - but it widens instead of narrows the search. One of them threw an error if the user searched on model (sorry I don't recall which mod did this).
So I don't really know what 'exploded' means in PHP, but if you mean 'search for Keyword A AND keyword B, not necessarily in that order' - that is what I want, and I think it would be great if the search did this by default. Please!

Last edited by Moggin on Mon Oct 04, 2010 12:50 am, edited 1 time in total.
"Exploded" is when a text string is split up by a certain character, for example "the big red ball" when exploded with a space becomes "the", "big", "red" and "ball"
The search would be best if it was a BOOLEAN FULL TEXT search. It will require your database to be in MyISAM format, which OC is AFAIK
The search would be best if it was a BOOLEAN FULL TEXT search. It will require your database to be in MyISAM format, which OC is AFAIK
Follow us to the other thread as posted above. That mod does what we want for the default search. It doesn't do as we want for 'description' search but at least it works for default searchMoggin wrote:but if you mean 'search for Keyword A AND keyword B, not necessarily in that order' - that is what I want, and I think it would be great if the search did this by default. Please!
when can we use 1.5.0 vision system/ thank.
That would be pure speculatıon, 1.5.0 wıll be released when ready, so be patıent pleaseyrshopping wrote:when can we use 1.5.0 vision system/ thank.

Norman in 't Veldt
Moderator OpenCart Forums
_________________ READ and Search BEFORE POSTING _________________
Our FREE search: Find your answer FAST!.
[How to] BTW + Verzend + betaal setup.
...it's a good one - though this may be the one that breaks on 'search by model'...jty wrote: Follow us to the other thread as posted above. That mod does what we want for the default search. It doesn't do as we want for 'description' search but at least it works for default search

Jay, thank you - now I understand 'exploded' strings ..And Boolean full text search, which I agree would be good.
Now, rich06 - the forum member who had 7 million products to list - mentioned http://sphinxsearch.com/ .
I couldn't grasp much of it except the tagline - free open-source SQL full-text search engine. Looked interesting, but could that sort of thing be incorporated into Opencart, I wonder. As I didn't understand much of it, I realise that may be a stupid question.
Hi Daniel & oc team
Will a 'previously viewed products' module be included in 1.5.0?
Also not too keen on the look of 1.5.0, it looks clean and fresh, it just seems to be a bit tight for space(especially drop down menu), if you have loads of categories and information not sure it will hold up, have you tested with loads of categories and info?
I'm not really knocking it as just seen the image, the functionality looks amazing just think larger site may look a bit crowded.
Davy K
Will a 'previously viewed products' module be included in 1.5.0?
Also not too keen on the look of 1.5.0, it looks clean and fresh, it just seems to be a bit tight for space(especially drop down menu), if you have loads of categories and information not sure it will hold up, have you tested with loads of categories and info?
I'm not really knocking it as just seen the image, the functionality looks amazing just think larger site may look a bit crowded.
Davy K
That's coz nobody lives there ;-)JJJaved wrote:Isle of Man (UK) is missing in region 1.4.9.1.
OC2PS
OC 3.0.3.7, vQmod 2.6.2, Journal3 theme
Arcfesték, Csillámtetoválás, Henna
Check out: All my extensions | My FREE extensions
Then they really should rename the place 'Isle of No Man'.sooskriszta wrote:That's coz nobody lives there ;-)JJJaved wrote:Isle of Man (UK) is missing in region 1.4.9.1.
Thank you JJJaved, well spotted.
Hey, but what if someone does!... I think it's missing from 1.4.8b too?
I tried executing this in phpmyadmin (in 1.4.8b DB)- - based on the template discussed here. Seems to work, and nothing dire happened. But backup first and use at your own risk.
oneilldesign wrote:Then they really should rename the place 'Isle of No Man'.sooskriszta wrote:That's coz nobody lives there ;-)

I tried executing this in phpmyadmin (in 1.4.8b DB)-
Code: Select all
DELETE FROM `zone` WHERE `code` = 'IOM';
INSERT INTO `zone` (`zone_id`, `country_id`, `code`, `name`, `status`) VALUES (NULL, 222, 'IOM', 'Isle Of Man', 1) ON DUPLICATE KEY UPDATE zone_id=zone_id;
Who is online
Users browsing this forum: No registered users and 8 guests