Search engine in the shop does not work

[Kst]

Hello,

As in the title - the search engine is not working in the shop. The problem appears with every template also with classic, I have already tried rebuilding the index and disabling and enabling the search module.

Has anyone had a similar problem?

[ps8modules]

Hi, if there are problems like this, it might be causing a lot of indexing.
This is solved by deleting (not deleting) the tables in the database.

 

[ps8modules]

SQL sample:

TRUNCATE `ps_search_index`;
TRUNCATE `ps_search_word`;

After clean database tables, just start a new indexing in the search module and fill in all the missing prices ....

[ps8modules]

Admin->Configure->Shop Parameters->Search

find blue text "Re-build the entire index"

[Inter Svetainė]

In rare cases items/products are not indexed because of missing category ids in database.

Please make sure that in table

• `ps_product` column `id_category_default` is not 0 (make value at least 2 - main shop category).
• `ps_product_shop` column `id_category_default` is not 0 (make value at least 2 - main shop category). Best set for all shops.
• `ps_category_product` product has at least one row / at least one category is assigned to product.