Prestan0ob Posted January 30, 2018 Share Posted January 30, 2018 (edited) My producs are 5733 but search can index max 3291 products. All products are active both on catalog and search. Does anybody has solution about that please? Edited January 31, 2018 by Prestan0ob (see edit history) Link to comment Share on other sites More sharing options...
musicmaster Posted January 30, 2018 Share Posted January 30, 2018 Active products? Link to comment Share on other sites More sharing options...
Prestan0ob Posted January 30, 2018 Author Share Posted January 30, 2018 (edited) 1 hour ago, musicmaster said: Active products? You have right! 3291 are the active products. Thank you! So the problem is with the search module who show the products. It is not working with any of keywords that some products include. Any suggestion please? Edited January 30, 2018 by Prestan0ob (see edit history) Link to comment Share on other sites More sharing options...
musicmaster Posted January 30, 2018 Share Posted January 30, 2018 "It is not working with any of keywords that some products include." This is not the kind of problem description that anyone can help you with. Please take some time experimenting and make your problem description as concrete as possible: - does this problem concern certain products or certain fields? - did you try re-indexing? Link to comment Share on other sites More sharing options...
Prestan0ob Posted January 31, 2018 Author Share Posted January 31, 2018 7 hours ago, musicmaster said: "It is not working with any of keywords that some products include." This is not the kind of problem description that anyone can help you with. Please take some time experimenting and make your problem description as concrete as possible: - does this problem concern certain products or certain fields? - did you try re-indexing? Dear friend thanks for answer. Does not work with any of search fields! Product name Reference Short description Description Category Manufacturer Tags Attributes Features I made a lot of tests by changing the weigh of fields and reindexing but nothing. This happens on certain products and not for all. I try re-indexing many times Witch table in SQL write this information about indexing to try find those products in database? Link to comment Share on other sites More sharing options...
DataKick Posted January 31, 2018 Share Posted January 31, 2018 @Prestan0ob is there any error in server's log? Or maybe there's some javascript error on a page that simply prevents displaying results. Could you please share your site url, sample keyword, and a product that's supposed to show? Link to comment Share on other sites More sharing options...
musicmaster Posted January 31, 2018 Share Posted January 31, 2018 The main search tables are ps_search_word and ps_search_index. One contains a list of words and the other a list that links products to words. It is not rocket science: I implemented a copy of it in Prestools. You can also try to change a product that doesn't index in Prestools and see whether that causes indexation (every product that is changed is re-indexed unless you change some not indexed field like the price). You might follow the advice of Datakick. You use the Greek alphabet and have been playing with character sets. So maybe that added things that crash the indexation engine. Link to comment Share on other sites More sharing options...
Prestan0ob Posted January 31, 2018 Author Share Posted January 31, 2018 4 hours ago, DataKick said: @Prestan0ob is there any error in server's log? Or maybe there's some javascript error on a page that simply prevents displaying results. Could you please share your site url, sample keyword, and a product that's supposed to show? Thanks for info. I will check for errors. But errors should make problem to all products not only for specific. The site is offline. If i go live i will inform. Thank you. Link to comment Share on other sites More sharing options...
Prestan0ob Posted January 31, 2018 Author Share Posted January 31, 2018 2 hours ago, musicmaster said: The main search tables are ps_search_word and ps_search_index. One contains a list of words and the other a list that links products to words. It is not rocket science: I implemented a copy of it in Prestools. You can also try to change a product that doesn't index in Prestools and see whether that causes indexation (every product that is changed is re-indexed unless you change some not indexed field like the price). You might follow the advice of Datakick. You use the Greek alphabet and have been playing with character sets. So maybe that added things that crash the indexation engine. I will try to edit the product name and re-indexing. Thanks for support! Link to comment Share on other sites More sharing options...
Prestan0ob Posted February 9, 2018 Author Share Posted February 9, 2018 Nothing.... Still continue to not show some indexed products. I change the titles and some other fields but nothing. Link to comment Share on other sites More sharing options...
musicmaster Posted February 9, 2018 Share Posted February 9, 2018 You looked at the database tables. But you don't report whether those changes that you make - and that are not coming back in the search results - come in the tables or not. Are you sure this is not a caching problem? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now