{"id":894,"date":"2026-06-29T16:25:52","date_gmt":"2026-06-29T13:25:52","guid":{"rendered":"https:\/\/presta.site\/blog\/?p=894"},"modified":"2026-06-29T16:25:52","modified_gmt":"2026-06-29T13:25:52","slug":"utiliser-la-recherche-sphinx-dans-prestashop","status":"publish","type":"post","link":"https:\/\/presta.site\/blog\/fr\/utiliser-la-recherche-sphinx-dans-prestashop\/","title":{"rendered":"Utiliser la recherche Sphinx dans PrestaShop"},"content":{"rendered":"

PrestaShop a un bel outil de recherche, mais parfois il ne r\u00e9pond pas \u00e0 tous vos besoins. De plus, il n’est pas vraiment rapide et sur les grandes boutiques, la recherche et l’indexation peuvent \u00eatre tr\u00e8s lentes.<\/p>\n

Si vous voulez quelque chose de mieux, vous pouvez utiliser un excellent remplacement – Sphinx.<\/p>\n


\nDe Wikipedia :<\/p>\n

Sphinx est un moteur de recherche en texte int\u00e9gral (Fulltext) open source\/logiciel libre con\u00e7u pour fournir des fonctionnalit\u00e9s de recherche en texte int\u00e9gral aux applications clientes.<\/p><\/blockquote>\n

Site web de Sphinx – http:\/\/sphinxsearch.com\/<\/a><\/p>\n

Installation de Sphinx<\/h2>\n

J’ai utilis\u00e9 Debian 8.1. Dans d’autres distributions Linux (et en particulier sous Windows), l’installation peut diff\u00e9rer l\u00e9g\u00e8rement.
\nSi Sphinx est disponible dans les d\u00e9p\u00f4ts, installez-le simplement :<\/p>\n

1
2
3
<\/div><\/td>
su<\/span>
\napt-get update<\/span>
\napt-get install<\/span> sphinxsearch<\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Si Sphinx n’est pas disponible dans les d\u00e9p\u00f4ts, vous pouvez t\u00e9l\u00e9charger un programme d’installation depuis le site officiel et installer les d\u00e9pendances :<\/p>\n

1
2
3
<\/div><\/td>
apt-get install<\/span> mysql-client unixodbc libpq5
\nwget<\/span> http:\/\/<\/span>sphinxsearch.com\/<\/span>files\/<\/span>sphinxsearch_2.2.9-release-1<\/span>~wheezy_i386.deb
\ndpkg<\/span> -i<\/span> sphinxsearch_2.2.9-release-1<\/span>~wheezy_i386.deb<\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Vous devez remplacer le nom et l’URL du programme d’installation par les versions actuelles pertinentes. Elles sont toutes disponibles sur le site officiel.<\/p>\n

Configuration de Sphinx<\/h2>\n

Ouvrez la configuration de Sphinx et modifiez-la :<\/p>\n

1
<\/div><\/td>
nano<\/span> \/<\/span>etc\/<\/span>sphinxsearch\/<\/span>sphinx.conf<\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Vous devez modifier le bloc par d\u00e9faut existant “source src1” (ou ajouter un nouveau bloc). Le r\u00e9sultat devrait ressembler \u00e0 ceci :<\/p>\n

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
<\/div><\/td>
source PrestaSite
\n{<\/span>
\ntype<\/span> =<\/span> mysql<\/span>
\nsql_host<\/span> =<\/span> localhost<\/span>
\n# PrestaShop database username
\nsql_user<\/span> =<\/span> DBUSER<\/span>
\n# PrestaShop database password
\nsql_pass<\/span> =<\/span> DBPASSWORD<\/span>
\n# PrestaShop database name
\nsql_db<\/span> =<\/span> DBNAME<\/span>
\nsql_port<\/span> =<\/span> 3306 # optional, default is 3306<\/span>
\nsql_query_pre<\/span> =<\/span> SET NAMES utf8<\/span>
\n
\n# MySQL query with list of fields for indexation
\nsql_query<\/span> =<\/span>
\nSELECT id_product, name, description, description_short
\nFROM ps_product_lang
\n}<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Tout d’abord, vous pouvez voir les param\u00e8tres de connexion \u00e0 la base de donn\u00e9es (n’oubliez pas de les modifier en cons\u00e9quence<\/span>). Le param\u00e8tre sql_query<\/span> contient une requ\u00eate avec les champs \u00e0 indexer.<\/p>\n

Ce sont tous les param\u00e8tres de ma configuration. Fondamentalement, le fichier de configuration est bien document\u00e9 et toutes les options y sont d\u00e9crites, vous pouvez donc facilement personnaliser votre configuration.<\/p>\n

Ensuite, dans le bloc “index definition”, vous devez configurer l’index :<\/p>\n

1
2
3
4
5
6
7
8
9
10
11
12
13
14
<\/div><\/td>
index PrestaSite
\n{<\/span>
\n# data source for indexation
\nsource<\/span> =<\/span> PrestaSite<\/span>
\n
\n# location for index data
\npath<\/span> =<\/span> \/var\/lib\/sphinxsearch\/data\/prestasite<\/span>
\n
\n# morphology preprocessors
\nmorphology<\/span> =<\/span> stem_en<\/span>
\n
\n# minimal word length for indexation
\nmin_word_len<\/span> =<\/span> 1<\/span>
\n}<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Ensuite, vous pouvez voir les blocs “indexer settings” et “searchd settings”. Habituellement, ils sont corrects, vous pouvez simplement les ignorer.<\/p>\n

Nous avons donc configur\u00e9 la source de donn\u00e9es (source PrestaSite) et l’index (index PrestaSite).<\/span><\/p>\n

Indexation<\/h2>\n

Lancez l’indexeur pour indexer votre base de donn\u00e9es :<\/p>\n

1
<\/div><\/td>
indexer --all<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Lancement de Sphinx<\/h2>\n

N’oubliez pas de d\u00e9marrer\/red\u00e9marrer searchd :<\/p>\n

1
<\/div><\/td>
searchd<\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Et d’ajouter l’indexeur \u00e0 la crontab :<\/p>\n

1
<\/div><\/td>
15<\/span> *<\/span> *<\/span> *<\/span> *<\/span> root indexer --all<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

L’indexation sera lanc\u00e9e toutes les heures.<\/p>\n

Configuration de PrestaShop<\/h2>\n

Ci-dessous, vous pouvez voir le code pour PrestaShop 1.6. Pour les autres versions de PrestaShop, cela peut diff\u00e9rer l\u00e9g\u00e8rement.<\/p>\n

Cr\u00e9ez (ou modifiez) la surcharge de la classe Search :
\n\/override\/classes\/Search.php<\/p>\n

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
<\/div><\/td>
<?php<\/span>
\nclass<\/span> Search extends<\/span> SearchCore {<\/span>
\n    public<\/span> static function<\/span> find(<\/span>$id_lang<\/span>,<\/span> $expr<\/span>,<\/span> $page_number<\/span> =<\/span> 1<\/span>,<\/span> $page_size<\/span> =<\/span> 1<\/span>,<\/span> $order_by<\/span> =<\/span> 'position'<\/span>,<\/span>
\n        $order_way<\/span> =<\/span> 'desc'<\/span>,<\/span> $ajax<\/span> =<\/span> false<\/span>,<\/span> $use_cookie<\/span> =<\/span> true<\/span>,<\/span> Context $context<\/span> =<\/span> null<\/span>)<\/span>
\n    {<\/span>
\n        if<\/span> (<\/span>!<\/span>$context<\/span>)<\/span> {<\/span>
\n            $context<\/span> =<\/span> Context::<\/span>getContext<\/span>(<\/span>)<\/span>;<\/span>
\n        }<\/span>
\n        $db<\/span> =<\/span> Db::<\/span>getInstance<\/span>(<\/span>_PS_USE_SQL_SLAVE_)<\/span>;<\/span>
\n
\n        \/\/ TODO : smart page management<\/span>
\n        if<\/span> (<\/span>$page_number<\/span> <<\/span> 1<\/span>)<\/span> $page_number<\/span> =<\/span> 1<\/span>;<\/span>
\n        if<\/span> (<\/span>$page_size<\/span> <<\/span> 1<\/span>)<\/span> $page_size<\/span> =<\/span> 1<\/span>;<\/span>
\n
\n        if<\/span> (<\/span>!<\/span>Validate::<\/span>isOrderBy<\/span>(<\/span>$order_by<\/span>)<\/span> ||<\/span> !<\/span>Validate::<\/span>isOrderWay<\/span>(<\/span>$order_way<\/span>)<\/span>)<\/span>
\n            return<\/span> false<\/span>;<\/span>
\n
\n        if<\/span> (<\/span>!<\/span>Validate::<\/span>isOrderBy<\/span>(<\/span>$order_by<\/span>)<\/span> ||<\/span> !<\/span>Validate::<\/span>isOrderWay<\/span>(<\/span>$order_way<\/span>)<\/span>)<\/span> {<\/span>
\n            return<\/span> false<\/span>;<\/span>
\n        }<\/span>
\n
\n        $start<\/span> =<\/span> (<\/span>$page_number<\/span> -<\/span> 1<\/span>)<\/span> *<\/span> $page_size<\/span>;<\/span>
\n
\n        \/\/ Sphinx search, get ids of found products<\/span>
\n        $sphinx_results<\/span> =<\/span> self<\/span>::<\/span>getSphinxResults<\/span>(<\/span>$expr<\/span>,<\/span> $start<\/span>,<\/span> $page_size<\/span>)<\/span>;<\/span>
\n
\n        $result<\/span> =<\/span> null<\/span>;<\/span>
\n        $total<\/span> =<\/span> 0<\/span>;<\/span>
\n        \/\/ get products by id if something found<\/span>
\n        if<\/span> (<\/span>is_array<\/span><\/a>(<\/span>$sphinx_results<\/span>)<\/span> AND sizeof<\/span><\/a>(<\/span>$sphinx_results<\/span>)<\/span> AND isset<\/span><\/a>(<\/span>$sphinx_results<\/span>[<\/span>'total'<\/span>]<\/span>)<\/span> AND $sphinx_results<\/span>[<\/span>'total'<\/span>]<\/span> ><\/span> 0<\/span>)<\/span> {<\/span>
\n            $sql<\/span> =<\/span> 'SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity,
\n                    pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`name`,
\n                    MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` manufacturer_name, MAX(product_attribute_shop.`id_product_attribute`) id_product_attribute,
\n                    DATEDIFF(
\n                        p.`date_add`,
\n                        DATE_SUB(
\n                            NOW(),
\n                            INTERVAL '<\/span>.<\/span>(<\/span>Validate::<\/span>isUnsignedInt<\/span>(<\/span>Configuration::<\/span>get<\/span>(<\/span>'PS_NB_DAYS_NEW_PRODUCT'<\/span>)<\/span>)<\/span> ? Configuration::<\/span>get<\/span>(<\/span>'PS_NB_DAYS_NEW_PRODUCT'<\/span>)<\/span> :<\/span> 20<\/span>)<\/span>.<\/span>' DAY
\n                        )
\n                    ) > 0 new
\n                    FROM '<\/span>.<\/span>_DB_PREFIX_.<\/span>'product p
\n                    '<\/span>.<\/span>Shop::<\/span>addSqlAssociation<\/span>(<\/span>'product'<\/span>,<\/span> 'p'<\/span>)<\/span>.<\/span>'
\n                    INNER JOIN `'<\/span>.<\/span>_DB_PREFIX_.<\/span>'product_lang` pl ON (
\n                        p.`id_product` = pl.`id_product`
\n                        AND pl.`id_lang` = '<\/span>.<\/span>(<\/span>int)<\/span>$id_lang<\/span>.<\/span>Shop::<\/span>addSqlRestrictionOnLang<\/span>(<\/span>'pl'<\/span>)<\/span>.<\/span>'
\n                    )
\n                    LEFT JOIN `'<\/span>.<\/span>_DB_PREFIX_.<\/span>'product_attribute` pa ON (p.`id_product` = pa.`id_product`)
\n                    '<\/span>.<\/span>Shop::<\/span>addSqlAssociation<\/span>(<\/span>'product_attribute'<\/span>,<\/span> 'pa'<\/span>,<\/span> false<\/span>,<\/span> 'product_attribute_shop.`default_on` = 1'<\/span>)<\/span>.<\/span>'
\n                    '<\/span>.<\/span>Product::<\/span>sqlStock<\/span>(<\/span>'p'<\/span>,<\/span> 'product_attribute_shop'<\/span>,<\/span> false<\/span>,<\/span> $context<\/span>-><\/span>shop<\/span>)<\/span>.<\/span>'
\n                    LEFT JOIN `'<\/span>.<\/span>_DB_PREFIX_.<\/span>'manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
\n                    LEFT JOIN `'<\/span>.<\/span>_DB_PREFIX_.<\/span>'image` i ON (i.`id_product` = p.`id_product`)'<\/span>.<\/span>
\n                Shop::<\/span>addSqlAssociation<\/span>(<\/span>'image'<\/span>,<\/span> 'i'<\/span>,<\/span> false<\/span>,<\/span> 'image_shop.cover=1'<\/span>)<\/span>.<\/span>'
\n                    LEFT JOIN `'<\/span>.<\/span>_DB_PREFIX_.<\/span>'image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = '<\/span>.<\/span>(<\/span>int)<\/span>$id_lang<\/span>.<\/span>')
\n                    WHERE p.`id_product` IN('<\/span>.<\/span>implode<\/span><\/a>(<\/span>','<\/span>,<\/span> $sphinx_results<\/span>[<\/span>'results'<\/span>]<\/span>)<\/span>.<\/span>')
\n                    GROUP BY product_shop.id_product'<\/span>;<\/span>
\n            $result<\/span> =<\/span> $db<\/span>-><\/span>executeS<\/span>(<\/span>$sql<\/span>)<\/span>;<\/span>
\n
\n            \/\/ results count<\/span>
\n            $total<\/span> =<\/span> $sphinx_results<\/span>[<\/span>'total'<\/span>]<\/span>;<\/span>
\n        }<\/span>
\n
\n        if<\/span> (<\/span>!<\/span>$result<\/span>)<\/span> {<\/span>
\n            $result_properties<\/span> =<\/span> array<\/span><\/a>(<\/span>)<\/span>;<\/span>
\n        }<\/span> else<\/span> {<\/span>
\n            $result_properties<\/span> =<\/span> Product::<\/span>getProductsProperties<\/span>(<\/span>(<\/span>int)<\/span>$id_lang<\/span>,<\/span> $result<\/span>)<\/span>;<\/span>
\n        }<\/span>
\n
\n        return<\/span> array<\/span><\/a>(<\/span>'total'<\/span> =><\/span> $total<\/span>,<\/span> 'result'<\/span> =><\/span> $result_properties<\/span>)<\/span>;<\/span>
\n    }<\/span>
\n
\n    protected<\/span> static function<\/span> getSphinxResults(<\/span>$search_query<\/span>,<\/span> $page_number<\/span>,<\/span> $page_size<\/span>)<\/span>
\n    {<\/span>
\n        $results<\/span> =<\/span> array<\/span><\/a>(<\/span>)<\/span>;<\/span>
\n        $total<\/span> =<\/span> 0<\/span>;<\/span>
\n
\n        if<\/span>(<\/span>!<\/span>$search_query<\/span>)<\/span>
\n            return<\/span> null<\/span>;<\/span>
\n
\n        \/\/ connect to Sphinx database<\/span>
\n        $link<\/span> =<\/span> mysqli_connect<\/span><\/a>(<\/span>'127.0.0.1'<\/span>,<\/span> ''<\/span>,<\/span> ''<\/span>,<\/span> ''<\/span>,<\/span> '9306'<\/span>)<\/span>;<\/span>
\n        if<\/span>(<\/span>$link<\/span>)<\/span>
\n        {<\/span>
\n            $query<\/span> =<\/span> 'SELECT * FROM `PrestaSite` WHERE MATCH('<\/span>'.pSQL($search_query).'<\/span>') limit '<\/span>.<\/span>(<\/span>int)<\/span>$page_number<\/span>.<\/span>', '<\/span>.<\/span>(<\/span>int)<\/span>$page_size<\/span>.<\/span>';'<\/span>;<\/span>
\n            if<\/span> (<\/span>$result<\/span> =<\/span> $link<\/span>-><\/span>query<\/span>(<\/span>$query<\/span>)<\/span>)<\/span>
\n            {<\/span>
\n                while<\/span>(<\/span>$query_results<\/span> =<\/span> $result<\/span>-><\/span>fetch_array<\/span>(<\/span>)<\/span>)<\/span>
\n                {<\/span>
\n                    $results<\/span> =<\/span> array_merge<\/span><\/a>(<\/span>$results<\/span>,<\/span> $query_results<\/span>)<\/span>;<\/span>
\n                }<\/span>
\n
\n                \/* clear result *\/<\/span>
\n                $result<\/span>-><\/span>close<\/span>(<\/span>)<\/span>;<\/span>
\n            }<\/span>
\n
\n            \/\/ get count of results<\/span>
\n            $query_total<\/span> =<\/span> 'SELECT count(*) FROM `PrestaSite` WHERE MATCH('<\/span>'.pSQL($search_query).'<\/span>');'<\/span>;<\/span>
\n            if<\/span> (<\/span>$result<\/span> =<\/span> $link<\/span>-><\/span>query<\/span>(<\/span>$query_total<\/span>)<\/span>)<\/span>
\n            {<\/span>
\n                $total<\/span> =<\/span> (<\/span>int)<\/span>$result<\/span>-><\/span>fetch_array<\/span>(<\/span>)<\/span>[<\/span>0<\/span>]<\/span>;<\/span>
\n                if<\/span>(<\/span>$total<\/span> ><\/span> 1000<\/span>)<\/span>
\n                    $total<\/span> =<\/span> 1000<\/span>;<\/span>
\n            }<\/span>
\n
\n            mysqli_close<\/span><\/a>(<\/span>$link<\/span>)<\/span>;<\/span>
\n        }<\/span>
\n
\n        return<\/span> array<\/span><\/a>(<\/span>'results'<\/span> =><\/span> $results<\/span>,<\/span> 'total'<\/span> =><\/span> $total<\/span>)<\/span>;<\/span>
\n    }<\/span>
\n}<\/span><\/div><\/td><\/tr><\/tbody><\/table><\/div>\n

Fondamentalement, le code est assez simple. Nous surchargeons la fonction “find”, dans laquelle nous rempla\u00e7ons la recherche de PrestaShop par la recherche Sphinx. Sphinx renvoie les ID des produits et, en utilisant ces ID, nous interrogeons les donn\u00e9es des produits. La deuxi\u00e8me fonction (getSphinxResults) effectue directement la recherche.<\/p>\n

\u00c0 la fin, vous devez vider le cache et supprimer le cache de classe (\/cache\/class_index.php). Tout est termin\u00e9 !<\/p>\n","protected":false},"excerpt":{"rendered":"

PrestaShop a un bel outil de recherche, mais parfois il ne r\u00e9pond pas \u00e0 tous vos besoins. De plus, il n’est pas vraiment rapide et sur les grandes boutiques, la recherche et l’indexation peuvent \u00eatre tr\u00e8s lentes. Si vous voulez quelque chose de mieux, vous pouvez utiliser un excellent remplacement – Sphinx.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[100],"tags":[],"class_list":["post-894","post","type-post","status-publish","format-standard","hentry","category-tutoriels-et-guides"],"_links":{"self":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/894","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/comments?post=894"}],"version-history":[{"count":1,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/894\/revisions"}],"predecessor-version":[{"id":938,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/posts\/894\/revisions\/938"}],"wp:attachment":[{"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/media?parent=894"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/categories?post=894"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/presta.site\/blog\/wp-json\/wp\/v2\/tags?post=894"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}