Jump to content

Dirty Butter

Member
  • Content Count

    6,522
  • Joined

  • Last visited

  • Days Won

    137

Everything posted by Dirty Butter

  1. (Debug works with Blueprint) puppet,dog 18 results Not sure exactly what you want from debug info SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.seo_meta_keywords RLIKE '[[:<:]]puppet[[:>:]].*[[:<:]]dog[[:>:]]' OR I.name RLIKE '[[:<:]]puppet[[:>:]].*[[:<:]]dog[[:>:]]' OR I.description RLIKE '[[:<:]]puppet[[:>:]].*[[:<:]]dog[[:>:]]' OR I.product_code RLIKE '[[:<:]]puppet[[:>:]].*[[:<:]]dog[[:>:]]') LIMIT 100 -- (5.12442207336 sec) [CACHED] [13] SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND (I.seo_meta_keywords RLIKE '[[:<:]]puppet[[:>:]].*[[:<:]]dog[[:>:]]' OR I.name RLIKE '[[:<:]]puppet[[:>:]].*[[:<:]]dog[[:>:]]' OR I.description RLIKE '[[:<:]]puppet[[:>:]].*[[:<:]]dog[[:>:]]' OR I.product_code RLIKE '[[:<:]]puppet[[:>:]].*[[:<:]]dog[[:>:]]') -- (5.32946300507 sec) [CACHED] Hope that's what you need to see from Debug. I'll follow with the other scenarios.
  2. STILL trying to fix this search term order problem for our toy site. Is there a way to take the search terms a customer uses and split that string into individual word strings that can be searched for regardless of their order? I'm currently using this code: $regexp = substr($regexp, 0, strlen($regexp)-2); $rlike = " AND (I.seo_meta_keywords RLIKE '".$regexp."' OR I.name RLIKE '".$regexp."' OR I.description RLIKE '".$regexp."' OR I.product_code RLIKE '".$regexp."')"; } But the only part I actually need is I.seo_meta_keywords RLIKE ' ".$regexp." ' as all the title and description terms are listed in the keywords.
  3. As it is now, with the various tweaks you've provided, our plushcatalog Search uses the seo keywords. It finds 64 pages for "dog". So that's not my problem. Search for (without the quotes) "puppet dog" and you'll get hugely different results from "dog puppet".
  4. Revisiting this Search term order issue again. As of 5.2.13 this is still a problem for us. I love the code fix Bsmither provided in this thread, but I'm totally frustrated by the order of search terms roadblock. I have trouble myself finding a given product at times, thanks to putting the search terms in the "wrong" order. It's no wonder customers can't find what they want!
  5. Using the meta keywords as the Search base, as Bsmither helped me do, has helped a lot. BUT the search still will balk if the order of search terms does not match the order the terms are listed. For instance, carter's bear SHOULD return the same results as bear carter's. That doesn't happen.
  6. Revisiting this issue, as I still find problems with our search. I've come to realize that this problem with specific word order is an issue on the Customer's experience with Search as well. Is there any way to make CC search for terms, regardless of what order they are written in the title, description, or (because I'm using your tweak to the code) meta keywords? As an example - try searching for cat carter's and then try carter's cat.
  7. The Bug Tracker is down at the moment, but I do have a request for Search improvements needed there. I'll edit here to add the link when I can. I invite you to add to it, as that may be the only way to get the current Search changed by CC.
  8. Assuming you've fixed your issues, I still see problems with the Google Search, although I certainly appreciate your input. For one, the site is taking forever to load, and it's Olark and Google that are slowing it down. I finally took Olark off our sites, just for that reason. I was able to search for cardiff bracelet, BUT I saw the same issue that was my complaint about CC's Search - it found not only the Cardiff bracelets, but ALL your bracelets. The biggest advantage I saw was the option to use Images - that's certainly a good thing.
  9. Sorry, but I just tried searching for cardiff bracelet, and when that didn't work I tried just cardiff and then Cardiff. I never did get any results.
  10. Still discovering issues with my Search. Tried just now to search for "blue white dog" and discovered that I get a completely different set of results if I search for "white blue dog". No wonder people can't find anything on our site!
  11. I guess I don't understand how relevance works then, as all it did for me was make huge numbers of irrelevant items show in the results, to the point that it was all but useless. We have over 3000 items in the store at this time, with untold numbers of rabbits, bears, and dolls - so there has to be a way to narrow, not expand, the search - which is exactly what you have accomplished for me. From my point of view it's MY job as the seller to anticipate as many likely search terms as possible that a customer might use for a given item and see to it they are in the keywords - thus making the keywords the most relevant for each product. Sorry if I jumped the gun in the Bug Tracker - I was just so pleased with the results.
  12. I'm not sure I understand what you mean, Bsmither. It's finding everything I throw at it now, as long as I have it in the meta keywords - even TY without having to use Advanced search for the manufacturer. That's the easiest place to add misspellings and alternate word choices, as it keeps the front end description from being ugly. Are you saying there's something else that still needs to be added to the search code?
  13. And the SEO search worked, too! Now when they search for kitty, and I used cat in the description - it still shows up as long as I have added kitty and kitten to the SEO, which I always do. Same thing for puppy and dog. AND I can put Carter's in the SEO keywords and the SEARCH WORKS with the apostrophe. I put it there, rather than having to rewrite all my titles and urls. I can add it to all Carters at once with phpMyAdmin!! This was a HUGE help!
  14. I'm revisiting this topic. I did create a request in the bug tracker for improved Search function a long time ago, but nothing ever came of it. We really are being hurt by the Search function! Go to our Plush Animal Shoppe and look up Hallmark bear, and you'll see just how useless the results are. It finds EVERY toy with Hallmark AND EVERY bear, because it finds Hallmark OR bear, not Hallmark AND bear. I've resigned myself to the apostrophe issue as being inherent, but I know there are ways to search that find AND, not OR. Also, the keyword search would still be useful, as I could always put plural variations there if needed, and do currently put common misspelling variations there. The other Search function that drives me crazy is that the Admin Search does not work the same way the Customer Search works. Words have to be in the exact order they are in the title or they can't be found. I know you always have lots of projects going, but if you ever get time to work on this, Bsmither, I sure would appreciate it!!
  15. Boolean operators don't seem to work. I changed one item so all the Carters terms in the listing were changed to Carter's, and I could no longer find it when I searched for Carter's as a customer. I was hoping there would be some way within the CC code to create some special search rules. As you said, most customers wouldn't know how to search with operators, anyway. I will request the seo search feature.
  16. This has been an issue way back to v4 I think. Since CC5 can't handle the apostrophe in the search, I write the brand name in our listings as Carters. If the customer searches for Carter's the search works. But if they search for Carter, it fails. Same thing happens if I write pigtail, but they search for pigtails. Is there any way to create special search rules to match a small number of brands with special characters, such as Carter's and M&M's? Is there any way to create the search in such a way that plurals and common variations show up in the search results? Some searches would be taken care of if the seo keywords were searched as well, as I do put common misspellings and variations there for each listing. So is there any way to include the keywords as part of the search terms?
×
×
  • Create New...