Search the Community

Hello Prestashop people. This is my first post here, I hope I will be clear enough. Some products are not showing in the search result even if they use the same words in the product description. My shop is a vinyl record store. My catalog (more than 7000 products) is updated every morning via CRON My daily cron task: all the products are set at quantity = 0 via sql query in the database all the quantity = 0 are disabled via sql query in the database all the image are erased from the server (/p/*) the catalog is updated from a csv file via the module "Prestashop Importer - import product from csv, xls, xlsx v1.0.35" the image folder is checked and cleaned via the module "elegant image cleaner". the search index is updated completely then I have eBay synchro crons Everything's work smoothly, except that I have recently found a problem with the search result. For exemple, the research of "replica" show up only 4 results, and should at least show up 18 records. e.g. this album https://www.la-face-cachee.com/disques-vinyles-lp-records/rock/(id230460014)_atoll-l-araignee-mal-vinyl containing the word "replica" show up in the result when this one: https://www.la-face-cachee.com/disques-vinyles-lp-records/rock/(id340702941)_atoll-musiciens-magiciens-vinyl or this one https://www.la-face-cachee.com/disques-vinyles-lp-records/rock/(id356270959)_pazop-pazop-vinyl doesn't appear. They have the same description "Replica Records (4)". Of course I tried to re-build the indexation, I tried also to empty the table xx_search_index and xx_search_word, and re-index after, but I have the same bad result every times. I also tried to switch off the languages (only FR is activated now, EN is still there but deactivated), and tried to re-build the index after switching off the search option (Search within word, etc). BUT, when I open and save a missing product, it then appears on the search result. I have really no idea what to do, where to search. Does someone have an idea? Server info: PrestaShop version: 1.6.1.7 Server software version: Apache PHP version: 7.0.19 Memory limit: 1024M Max execution time: 25200 MySQL version: 5.6.35 MySQL engine: InnoDB MySQL driver: DbPDO website url: https://www.la-face-cachee.com Note : I have a mirror of the website for professionals only, all the system is the same, theme, server etc, only the catalog is different (760 products manually added) and the search result work as expected (showing all the "replica" products). Note2 : I've found a weird "word" on the ​xx_search_word : "replicarpccd012", that seems to be a mix of the name "replica" and the "rpccd012" of this product: https://www.la-face-cachee.com/cd/rock/(id355917635)_etron-fou-leloublan-live-at-the-rock-in-opposition-festival-1978-new-london-theatre-cd The fun part is that this product appears also with the "replica" query, as expected with the "Search within word" enabled. Thank you for reading! Phil

Hi everyone! I've been struggling with a problem and wanted to see if anybody around here knows how to help me... My shop is currently using a module (Price Hide Pro) to show prices to selected users/groups. Everything is working properly with the module! The thing is, when I search a product in google, the price shows up for everyone to see 😕 I tried removing the meta tags with the property product:price:amount but it is still showing up. This also happens with Pinterest.. Can anyone help me please? Thanks in advance!

Mon site: https://locomotif-shop.com/ Bonjour, j'ai depuis quelques jours un soucis avec l'indexation sur la Google Search Console. J'ai des URLs dans le style" https://locomotif-shop.com/recherche?tag=roping " qui apparaissent. Ce sont des mots qui sont enregistrés automatiquement pour faciliter la recherche de produits dans mon site. J'utilise le thème "Warehouse" qui lui se sert du module de recherche de Prestashop de base. Je vous joint une capture d'écran de la console Google. Merci par avance pour votre aide.

Bonjour à toutes et à tous, J'ai un soucis d'indexation sur quelques produits (des rubans ashésifs) uniquement lors de la création d'une commande manuelle via le back-office de Prestashop 1.7.7.0 et la recherche de produits pour les insérer dans la commande manuelle. Ces produits apparaissent sans soucis lors de la recherche onglet produits dans le bo. Ces produits apparaissent également en front office. et lors d'une recherche manuelle. J'ai mis en place une cron qui ré indexe tous les produits pendant la nuit. Si vous avez une idée de ce qui peut provoquer ce défaut, je suis preneur. Merci par avance

Bonjour, J'ai installé le module sitemap sur mon prestashop 1.7, il fonctionne parfaitement cependant, il indique à Google les urls généralistes qui redirige ensuite vers l'url de la déclinaison par défaut. Ce qui a un impacte énorme sur l'indexation de mes pages produits car il ne le fait pas ou il mets du temps et il m'indique sur google webmaster tool qu'il a "Indexée, mais non envoyée via un sitemap" Savez-vous comment je peux résoudre ça ? Merci,

Bonjour, Est-ce que quelqu'un sait si c'est possible d'être indexé par Google sans utiliser les outils webmaster ? Est-ce juste plus long ou l'indexation ne se fait pas du tout si on prévient pas Google de la création de son site ? Car le site sur lequel je travaille est en ligne depuis plusieurs mois et n'est pas encore indexé. Il est visible (pas en maintenance). Ça peut prendre longtemps ? Merci d'avance !

Hello, I tried to look for this problem somewhere else but couldn't find anything. We have a shop with 11000 products and half of the references are with a dash, a slash or a dot. It exists like that since 15 years so it wasn't thought for the internet. Example : "154-1578" "23.654" "lplb-x7v" "K502.8/10"... 1/ Prestashop doesn't take into account the dashes or dots, I noticed it's because of the sanitize and find functions on the Search.php class. Also it explodes the words so "154-1578" is becoming "154" and "1578", hence the results are incorrects and the product targeted isn't the first on the results or doesn't appear. People could think that the product doesn't exist. I got around that overriding the Search class like that : <?php /* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ define('PREG_CLASS_PUNCTUATION', '\x{21}-\x{23}\x{25}-\x{2a}\x{2c}\x{2e}\x{2f}\x{3a}\x{3b}\x{3f}\x{40}\x{5b}-\x{5d}'. '\x{5f}\x{7b}\x{7d}\x{a1}\x{ab}\x{b7}\x{bb}\x{bf}\x{37e}\x{387}\x{55a}-\x{55f}'. '\x{589}\x{58a}\x{5be}\x{5c0}\x{5c3}\x{5f3}\x{5f4}\x{60c}\x{60d}\x{61b}\x{61f}'. '\x{66a}-\x{66d}\x{6d4}\x{700}-\x{70d}\x{964}\x{965}\x{970}\x{df4}\x{e4f}'. '\x{e5a}\x{e5b}\x{f04}-\x{f12}\x{f3a}-\x{f3d}\x{f85}\x{104a}-\x{104f}\x{10fb}'. '\x{1361}-\x{1368}\x{166d}\x{166e}\x{169b}\x{169c}\x{16eb}-\x{16ed}\x{1735}'. '\x{1736}\x{17d4}-\x{17d6}\x{17d8}-\x{17da}\x{1800}-\x{180a}\x{1944}\x{1945}'. '\x{2010}-\x{2027}\x{2030}-\x{2043}\x{2045}-\x{2051}\x{2053}\x{2054}\x{2057}'. '\x{207d}\x{207e}\x{208d}\x{208e}\x{2329}\x{232a}\x{23b4}-\x{23b6}\x{2768}-'. '\x{2775}\x{27e6}-\x{27eb}\x{2983}-\x{2998}\x{29d8}-\x{29db}\x{29fc}\x{29fd}'. '\x{3001}-\x{3003}\x{3008}-\x{3011}\x{3014}-\x{301f}\x{3030}\x{303d}\x{30a0}'. '\x{30fb}\x{fd3e}\x{fd3f}\x{fe30}-\x{fe52}\x{fe54}-\x{fe61}\x{fe63}\x{fe68}'. '\x{fe6a}\x{fe6b}\x{ff01}-\x{ff03}\x{ff05}-\x{ff0a}\x{ff0c}-\x{ff0f}\x{ff1a}'. '\x{ff1b}\x{ff1f}\x{ff20}\x{ff3b}-\x{ff3d}\x{ff3f}\x{ff5b}\x{ff5d}\x{ff5f}-'. '\x{ff65}'); class Search extends SearchCore { public static function sanitize($string, $id_lang, $indexation = false, $iso_code = false) { $string = trim($string); if (empty($string)) { return ''; } $string = Tools::strtolower(strip_tags($string)); $string = html_entity_decode($string, ENT_NOQUOTES, 'utf-8'); $string = preg_replace('/(['.PREG_CLASS_NUMBERS.']+)['.PREG_CLASS_PUNCTUATION.']+(?=['.PREG_CLASS_NUMBERS.'])/u', '\1', $string); $string = preg_replace('/['.PREG_CLASS_SEARCH_EXCLUDE.']+/u', ' ', $string); if ($indexation) { //$string = preg_replace('/[._-]+/', ' ', $string); } else { $words = explode(' ', $string); $processed_words = array(); // search for aliases for each word of the query foreach ($words as $word) { $alias = new Alias(null, $word); if (Validate::isLoadedObject($alias)) { $processed_words[] = $alias->search; } else { $processed_words[] = $word; } } $string = implode(' ', $processed_words); //$string = preg_replace('/[._]+/', '', $string); //$string = ltrim(preg_replace('/([^ ])-/', '$1 ', ' '.$string)); //$string = preg_replace('/[._]+/', '', $string); //$string = preg_replace('/[^\s]-+/', '', $string); } $blacklist = Tools::strtolower(Configuration::get('PS_SEARCH_BLACKLIST', $id_lang)); if (!empty($blacklist)) { $string = preg_replace('/(?<=\s)('.$blacklist.')(?=\s)/Su', '', $string); $string = preg_replace('/^('.$blacklist.')(?=\s)/Su', '', $string); $string = preg_replace('/(?<=\s)('.$blacklist.')$/Su', '', $string); $string = preg_replace('/^('.$blacklist.')$/Su', '', $string); } // If the language is constituted with symbol and there is no "words", then split every chars if (in_array($iso_code, array('zh', 'tw', 'ja')) && function_exists('mb_strlen')) { // Cut symbols from letters $symbols = ''; $letters = ''; foreach (explode(' ', $string) as $mb_word) { if (strlen(Tools::replaceAccentedChars($mb_word)) == mb_strlen(Tools::replaceAccentedChars($mb_word))) { $letters .= $mb_word.' '; } else { $symbols .= $mb_word.' '; } } if (preg_match_all('/./u', $symbols, $matches)) { $symbols = implode(' ', $matches[0]); } $string = $letters.$symbols; } elseif ($indexation) { $minWordLen = (int)Configuration::get('PS_SEARCH_MINWORDLEN'); if ($minWordLen > 1) { $minWordLen -= 1; $string = preg_replace('/(?<=\s)[^\s]{1,'.$minWordLen.'}(?=\s)/Su', ' ', $string); $string = preg_replace('/^[^\s]{1,'.$minWordLen.'}(?=\s)/Su', '', $string); $string = preg_replace('/(?<=\s)[^\s]{1,'.$minWordLen.'}$/Su', '', $string); $string = preg_replace('/^[^\s]{1,'.$minWordLen.'}$/Su', '', $string); } } $string = Tools::replaceAccentedChars(trim(preg_replace('/\s+/', ' ', $string))); return $string; } public static function find($id_lang, $expr, $page_number = 1, $page_size = 1, $order_by = 'position', $order_way = 'desc', $ajax = false, $use_cookie = true, Context $context = null) { if (!$context) { $context = Context::getContext(); } $db = Db::getInstance(_PS_USE_SQL_SLAVE_); // TODO : smart page management if ($page_number < 1) { $page_number = 1; } if ($page_size < 1) { $page_size = 1; } if (!Validate::isOrderBy($order_by) || !Validate::isOrderWay($order_way)) { return false; } $intersect_array = array(); $score_array = array(); $words = explode(' ', Search::sanitize($expr, $id_lang, false, $context->language->iso_code)); foreach ($words as $key => $word) { if (!empty($word) && strlen($word) >= (int)Configuration::get('PS_SEARCH_MINWORDLEN')) { $word = str_replace(array('%', '_'), array('\\%', '\\_'), $word); $start_search = Configuration::get('PS_SEARCH_START') ? '%': ''; $end_search = Configuration::get('PS_SEARCH_END') ? '': '%'; $intersect_array[] = 'SELECT si.id_product FROM '._DB_PREFIX_.'search_word sw LEFT JOIN '._DB_PREFIX_.'search_index si ON sw.id_word = si.id_word WHERE sw.id_lang = '.(int)$id_lang.' AND sw.id_shop = '.$context->shop->id.' AND sw.word LIKE '.($word[0] == '-' ? ' \'%'.$start_search.pSQL(Tools::substr($word, 1, PS_SEARCH_MAX_WORD_LENGTH)).$end_search.'%\'' : ' \'%'.$start_search.pSQL(Tools::substr($word, 0, PS_SEARCH_MAX_WORD_LENGTH)).$end_search.'%\'' ); if ($word[0] != '-') { $score_array[] = 'sw.word LIKE \'%'.$start_search.pSQL(Tools::substr($word, 0, PS_SEARCH_MAX_WORD_LENGTH)).$end_search.'%\''; } } else { unset($words[$key]); } } if (!count($words)) { return ($ajax ? array() : array('total' => 0, 'result' => array())); } $score = ''; if (is_array($score_array) && !empty($score_array)) { $score = ',( SELECT SUM(weight) FROM '._DB_PREFIX_.'search_word sw LEFT JOIN '._DB_PREFIX_.'search_index si ON sw.id_word = si.id_word WHERE sw.id_lang = '.(int)$id_lang.' AND sw.id_shop = '.$context->shop->id.' AND si.id_product = p.id_product AND ('.implode(' OR ', $score_array).') ) position'; } $sql_groups = ''; if (Group::isFeatureActive()) { $groups = FrontController::getCurrentCustomerGroups(); $sql_groups = 'AND cg.`id_group` '.(count($groups) ? 'IN ('.implode(',', $groups).')' : '= 1'); } $results = $db->executeS(' SELECT cp.`id_product` FROM `'._DB_PREFIX_.'category_product` cp '.(Group::isFeatureActive() ? 'INNER JOIN `'._DB_PREFIX_.'category_group` cg ON cp.`id_category` = cg.`id_category`' : '').' INNER JOIN `'._DB_PREFIX_.'category` c ON cp.`id_category` = c.`id_category` INNER JOIN `'._DB_PREFIX_.'product` p ON cp.`id_product` = p.`id_product` '.Shop::addSqlAssociation('product', 'p', false).' WHERE c.`active` = 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "search") AND product_shop.indexed = 1 '.$sql_groups, true, false); $eligible_products = array(); foreach ($results as $row) { $eligible_products[] = $row['id_product']; } foreach ($intersect_array as $query) { $eligible_products2 = array(); foreach ($db->executeS($query, true, false) as $row) { $eligible_products2[] = $row['id_product']; } $eligible_products = array_intersect($eligible_products, $eligible_products2); if (!count($eligible_products)) { return ($ajax ? array() : array('total' => 0, 'result' => array())); } } $eligible_products = array_unique($eligible_products); $product_pool = ''; foreach ($eligible_products as $id_product) { if ($id_product) { $product_pool .= (int)$id_product.','; } } if (empty($product_pool)) { return ($ajax ? array() : array('total' => 0, 'result' => array())); } $product_pool = ((strpos($product_pool, ',') === false) ? (' = '.(int)$product_pool.' ') : (' IN ('.rtrim($product_pool, ',').') ')); if ($ajax) { $sql = 'SELECT DISTINCT p.id_product, pl.name pname, cl.name cname, cl.link_rewrite crewrite, pl.link_rewrite prewrite '.$score.' FROM '._DB_PREFIX_.'product p INNER JOIN `'._DB_PREFIX_.'product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl').' ) '.Shop::addSqlAssociation('product', 'p').' INNER JOIN `'._DB_PREFIX_.'category_lang` cl ON ( product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('cl').' ) WHERE p.`id_product` '.$product_pool.' ORDER BY position DESC LIMIT 10'; return $db->executeS($sql, true, false); } if (strpos($order_by, '.') > 0) { $order_by = explode('.', $order_by); $order_by = pSQL($order_by[0]).'.`'.pSQL($order_by[1]).'`'; } $alias = ''; if ($order_by == 'price') { $alias = 'product_shop.'; } elseif (in_array($order_by, array('date_upd', 'date_add'))) { $alias = 'p.'; } $sql = 'SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`name`, image_shop.`id_image` id_image, il.`legend`, m.`name` manufacturer_name '.$score.', DATEDIFF( p.`date_add`, DATE_SUB( "'.date('Y-m-d').' 00:00:00", INTERVAL '.(Validate::isUnsignedInt(Configuration::get('PS_NB_DAYS_NEW_PRODUCT')) ? Configuration::get('PS_NB_DAYS_NEW_PRODUCT') : 20).' DAY ) ) > 0 new'.(Combination::isFeatureActive() ? ', product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.`id_product_attribute`,0) id_product_attribute' : '').' FROM '._DB_PREFIX_.'product p '.Shop::addSqlAssociation('product', 'p').' INNER JOIN `'._DB_PREFIX_.'product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl').' ) '.(Combination::isFeatureActive() ? 'LEFT JOIN `'._DB_PREFIX_.'product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop='.(int)$context->shop->id.')':'').' '.Product::sqlStock('p', 0).' LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `'._DB_PREFIX_.'image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop='.(int)$context->shop->id.') LEFT JOIN `'._DB_PREFIX_.'image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = '.(int)$id_lang.') WHERE p.`id_product` '.$product_pool.' GROUP BY product_shop.id_product '.($order_by ? 'ORDER BY '.$alias.$order_by : '').($order_way ? ' '.$order_way : '').' LIMIT '.(int)(($page_number - 1) * $page_size).','.(int)$page_size; $result = $db->executeS($sql, true, false); $sql = 'SELECT COUNT(*) FROM '._DB_PREFIX_.'product p '.Shop::addSqlAssociation('product', 'p').' INNER JOIN `'._DB_PREFIX_.'product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = '.(int)$id_lang.Shop::addSqlRestrictionOnLang('pl').' ) LEFT JOIN `'._DB_PREFIX_.'manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE p.`id_product` '.$product_pool; $total = $db->getValue($sql, false); if (!$result) { $result_properties = false; } else { $result_properties = Product::getProductsProperties((int)$id_lang, $result); } return array('total' => $total,'result' => $result_properties); } } There are two things I've changed. I've allowed \x{2d} in the preg class, which is the dash, to be taken into account and I've commented 4 lines where the dash and point are ignored. Does someone know how to redo these commented rules without ignoring the dash and the dot ? Is there another way for it to read the dashes, dots and slashes and not explode the words with those signs ? The override I've created, is it safe ? The references with letters seem to work better than the ones with only numbers. Because when searching for "152-2356" it is going to find products with "15.2" "1.52" "23.56" in the description text or features value. So it appears before the reference searched... With letters it's more precised. 2/ Another thing explaining the first problem : Prestashop doesn't index words with dashes, dots... The references are not indexed so even if I have my override, if it's not in the index, it won't be found. I have to enter them myself in the PS_search_word table and link them to the product in the PS_search_index for it to be found when searched with my new override. Does someone know how to get around that so the references with dashes, dots and slashes are indexed ? I can enter them in the table directly but everytime there's a reindexation, the table is truncated and refilled so everything is lost... The weights are : Product 7 Reference 10 Short desc. 4 Long desc. 9 Category 7 Manufacturer5 Keywords 6 Attributes 1 Features 8 Can someone help me ? Did you have this problem

Bonjour a tous, J'ai 908 produits indexés mais presque tous les jours je tombe a 208/908 produits indexés. Je procède alors a ajouter les produits non indexés pour arriver à 908 et le lendemain rebelote seulement 208/908. Je ne sait pas si cela me le fait depuis être passé en https? Je suis la version 1.6.09 Merci de me venir en aide Cordialement Nader https://www.zigzag-import.com

Bonjour, PS1.5 ne semble pas m'indexer les références des déclinaisons ce qui limite considérablement l'inrêt de ces derniers ^^ option à activer ? Bug ? Override à faire qque part ? Je ne cache pas que c'est LA fonction qui me manque pour la mise en ligne de mon client... Cordialement,

Bonjour, Il y a quelques mois, j'ai dû supprimer pas mal de produits de ma boutique. Ce qui a eu pour conséquence de générer plein de pages avec des erreurs comme celle-ci http://boutique-artevino.com/portail/8441-mini-tournevis-refa3643.html J'ai environ 270 pages comme celle là qui sont indexées dans Google et elles ont toutes comme balise meta robots : index, follow... Que faut il faire pour désindexer ces pages des moteurs de recherche ?

Bonjour à tous, J'ai un soucis avec l'indexation des produits. J'ai acutellement seulement 319 produits sur 1155 qui sont indexés. Si je fais "reconstruire l'index", c'est encore pire car mes produits indexés retombent à 144. Si je fais "Ajouter à l'index les produits manquants.", ça se bloque à 319... (avec plusieurs erreur 500 car temps de chargement trop long). J'ai réunitialisé le module " bloc de recherche rapide" mais rien n'y fait. La seule solution que j'ai trouvé, c'est d'enregistrer tous les produits à la main pour qu'ils soient tous indexés Help !

Bonjour, L'indexation de mes produits est incomplète (les 3/4 de mes produits ne s'indexent pas). Les solutions que j'ai essayé : - augmenter les capacités de php pour éviter le timeout et les erreurs 500 - passer tous mes produits en "visible partout" - vider les tables ps_index_search et ps_index_words - ajouter une tâche CRON pour indexer les produits - ajouter les produits manquants à l'index Mais le problème n'a pas changé, quand j'ajoute les produits manquants à l'index, au bout d'une minute environ j'ai une erreur 500. J'ai donc passé le mode debug à true et au bout d'une énième tentative j'ai réussi à avoir cette erreur : Fatal error: Uncaught Deadlock found when trying to get lock; try restarting transaction<br /><br /><pre>INSERT INTO ps_search_index (id_product, id_word, weight) VALUES (918,93978,1),(918,93979,1),(918,93980,1),(918,76594,1),(918,93981,1),(918,33080,1),(918,70177,1),(918,93982,2),(918,86197,1),(918,93983,1),(918,41296,1),(918,38320,1),(918,14576,1),(918,10536,1),(918,10432,1),(918,40599,1),(918,52709,1),(918,38268,1),(918,33053,2),(918,33056,1),(918,18280,1),(918,6775,1),(918,746,1),(918,33057,1),(918,22040,1),(918,38293,1),(918,19374,1),(918,14575,1),(918,54282,1),(918,23220,1),(918,28221,1),(918,33054,1),(918,90506,3),(918,45625,3),(918,6786,4),(918,96048,8),(918,96049,4),(918,6818,4464),(918,91981,4464),(918,6815,4464),(918,91982,4464),(918,91983,4464),(918,52954,2232),(918,19397,1984),(918,85052,2232),(918,31073,496),(918,52990,15),(918,8603,12),(918,833,7),(918,31894,6),(918,96050,7),(918,5292,11),(918,91216,12),(918,10678,12),(918,86574,9),(918,91217,21),(918,96051,16),(918,46361,16),(918,96052,1),(918,91995,1) in /homepages/6/d366098234/htdocs/classes/db/Db.php on line635 Quelqu'un aurait une piste ? ^^ Merci !

Bonjour, L'indexation de mes produits se reconstruit sans que je lui demande, comme si il y avait une tâche CRON automatique... Comme j'ai beaucoup de produits, je me retrouve avec 100/4000 produits indexés... Et pour avoir la totalité de mes produits indexés, je dois cliquer une bonne vingtaine de fois sur "Ajouter à l'index les produits manquants". Ce qui me prend 2 bonnes heures en général.

Hi I have a strange behaviour in my PS 1.5.4 Search Indexation When Looking at the search index information, I have (for exemple) 252/1000. So I rebuild the index and get 1000/1000 and the search works again on frontoffice, for a while... Some time after (a few hours), the search index is going down again to around 977 / 1000 (value vary but never goes more than 300) I tried to use "add product to index" instead of rebuilding, same behaviour... Search index keeps gonig down If anybody can help ??? Thank you very much in advance !

Bonjour, Je craque, après des heures de recherche et d'essais, je ne sais plus ! Tout d'abord, je suis en Prestashop version 1.5.2 , j'ai 245 multi-boutiques contenant entre 300 et 1200 produits, que j'ai injecté une grande partie des produits par le système d'import de presta. Pendant un moment je n'arrivais pas à indexer la totalité de mes produits, par la suite j'ai récupéré le search_cron.php et le search.php de presta 1.5.4 et j'arrive maintenant à indexer tous les produits, j'ai vérifié la table search_word et search_index et elles sont bien pleines. Voici mon problème : lorsque je lance une recherche par le moteur de recherche rapide, je n'ai aucuns résultats, ni en ajax, ni en proposé, pourtant les produits sont bien présents et je tape exactement les requêtes de la table search_word. J'ai quelques résultats en revanche sur la boutique par défaut. J'ai testé plein de chose, j'ai ré-indexé plusieurs fois, j'ai fouillé la forge... rien ni fait ! J'espère vraiment que quelqu'un ou l'équipe de prestashop pourra me venir en aide, car là je bloque sévère. Merci d'avance.

Bonjour, je rencontre un souci avec une boutique Prestashop récemment passée en 1.6. J'ai un problème d'indexation des produits. J'ai beau faire reconstruire l'index ou encore ajouter les produits manquants, aucun article n'est indexé. C'est vraiment très gênant et j'ai beau essayer tous les conseils sur les différents posts du forum, rien ne fonctionne. Merci d'avance.

Bonjour, en multiboutiques sir PS 1.6.0.9 je gère 2 boutiques qui partagent leurs produits sans distinction. L'indexation dénombre 7027 produits indexés. Lorsque je compte le nombre de mots indexés voici le résultat : id_shop count(id_word) 1 56999 2 6399 Malgré plusieurs réindexation le résultat reste le même. Pourquoi tous les produits ne sont-ils pas indexés pour la boutique 2 ?

Hey, i am new to Presta Shop and need some customizing. I added a new field (varchar) to the product table in my database. I modified the template etc. so that the new field is shown on the frontend and that i can edit the value in the backend. All working good! But i cant search for the value of my new field. I know that i have to modify the file Search.php in the classes folder. But I cant make the search saving the values of my new field into the search_word/index tables. I hope someone can explain me which lines have to be modified in order to get the search working. Thanks in advance.. Mathis

Bonjour à tous, Notre Prestashop 1.5 rencontre des difficultés dans l'indexation des produits (Préférences > Recherche), le compteur s'arrête toujours à 804/967 produits. Nous avons essayé "Ajout des produits manquants" et "Re-construire l'index" mais sans succès : le compteur s'arrête toujous à 804 produits Une idée de ce qui pourrait causer ce type de problème ? En vous remerciant par avance, Marc ps. notre site : http://marc-aurele.ru

Hi, I would like to ask for help with a problem we have, we Prestashop 1.6.0.6, with the theme: "Transformer" and have long been problems with some searching, the problem is not with all products but the first to be introduced in platform, it is likely that these products match were when we had version 1.5, the new not exhibit the problem, but were created with 1.6. Basically the problem is that some products do not appear in the search, take one example, sell Barbie China, the word "china" is in the title, description, tags, SEO, or all, is a ubiquitous word in almost any product text, however when writing "china" in the search no results, no matter if it's just the word or within a longer sentence, this does not happen with a new product. All products are indexed, if I see in "preferences / search" no pending indexing products,'ve tried rebuilding the index several times, cleaning cache, I've tried all the solutions listed in this forum, I've also tried disabling options instant search ajax, I've changed weight or priority search texts, but no result. The only solution I see is to delete and re-create products to see if hopefully resolved, but would be more than 150 products and it seems an illogical solution, there must be a way to find the bug and fix it. The URLs that are built in search of this type are: /es/busqueda?controller=search&orderby=position&orderway=desc&search_query=china /en/search?controller=search&orderby=position&orderway=desc&search_query=china Has anyone had this problem or has gone through this? I appreciate any help. Best regards, Victor

Hi forum, I'm experiencing this issue: One week ago the search indexation (activated via backoffice) worked well. This week we've been adding a lot of products via CSV and I've performed a couple changes in Search.php (modified the class and created an override). At this moment, when I try to add the missing products to the index, it does nothing. It remains as it was and after a while it triggers a 504 time out error. The number of indexed products stays the same. I've tried doing this in a development instalation of prestashop that we have using the same Search.php file (original and override) and there it works perfect. I'm afraid to hit "Rebuild entire index" because if it doesn't work we may lose a lot of money (the search won't work). Does anybody know what could be happening? Thank you in advance.

Hello everyone! I have a short question with probably not so easy answer: Should I enable Indexation by search engines in term and conditions, cookies policy etc? Nothing innovative or something that I would care to be found directly by google. Will it generate possibly any advantage / disadvantage? I try to add anchor links in about me, terms etc, mostly for an easy use, but will it bring me a real advantage? Because it's extra work. I will understand an answer "only google knows, do what you can" Thanks!

Hi everybody, I Looking for some help here, since I've upgraded from 1.5.4.1 to 1.5.6.2 Every day I have to rebuild my index, I don't know why, It started after upgrading, I can rebuilt the index at will even though it will never index all of the product: example: -yesteday:found it at 57/558 rebuilt the index up to 512/558 (could not go higher) -today:found it at 37/563 rebuilt up to 504/563 (could not go higher) Can anyone help me on this? Besides since the update I get error 500 several times when indexing products; and traffic to the website decrease 2/3 (HUGE). I'll post separetly about those problems to but they might be related. Thank you for reading, I hope you can help. Best regads

Hi everybody, I Looking for some help here, since I've upgraded from 1.5.4.1 to 1.5.6.2 Every day I have to rebuild my index, I don't know why, It started after upgrading, I can rebuilt the index at will even though it will never index all of the product: example: -yesteday:found it at 57/558 rebuilt the index up to 512/558 (could not go higher) -today:found it at 37/563 rebuilt up to 504/563 (could not go higher) Can anyone help me on this? Besides since the update I get error 500 several times when indexing products; and traffic to the website decrease 2/3 (HUGE). I'll post separetly about those problems to but they might be related. Thank you for reading, I hope you can help. Best regads

Bonsoir a tous, j'ai un problème avec mon sitemaps généré par prestashop. J'ai fouillé le fichier stemaps et je me suis aperçut que des anciennes URL périmé été encore présente ce qui fait que à nouveau Google va mes les indexés. Avez-vous une solution sil vous plait ? Cordialement.