@musicmaster I have noticed 2 anomalies and I am wondering if this is a problem with my shop or general.
1. I did a mass change to name of about 9000 products in 2 different languages (replaced one word with other). The process looked like this:
- I have set a view of 1000 products.
- I have replaced a word in the name of the product.
- I have a multistore so I have applied changes to all shops.
- After succesful replacement I wen to the next page of products (next 1000 products) and did the same process until I changed all products.
After the change I had a notification that I need to re-inder products. So I went to Back Office - Shop Parameters- Search and I clicked on Add missing products to the index. Unfortuantely, the products are not adding to the search anymore. I can see in the processes of the database that one process is woking until timeout: "DELETE si FROM `ps_search_index` si INNER JOIN `ps_product` p ON (p.id_product = si.id_product)". When this process is current I cannot do any modification to a product. In many cases wile this process is runnng I am not able to access front office as well. I have a message that states SQL LOCK while the process is active. I have to either wait until the process will be killed by my server after a while or kill the process myself in order to access my shop again. This is not the first time I have such situation. This always happens when I do a mass update of couple thousand products in the Prestools. When I do a small mass change (for example 600-800 products) then this problem does not occur which is strange. And this applies not only to changing name. Last time I have did a huge mass replacement of a few words in the description and short description and I also had the same problem. If I recall I changed ~5000 products. Adding missing products to the search index is possible using Prestools but it adds about 30 products until the server stops the query (indexation in the Back Office indexes about 600 products in the same time as it takes prestools to add 30 products). The only way to fix indexation in the Back Office again is to rebuild entire search index. After that everytihng is working flawlessly until next mass change. Strange situation. Right now I either have to change for example 500 products, add mising products to the index and then change another 500 products, or I can make a huge mass change of a few thousand products and then rebuild entire index which takes a few days because I have a lot of products. It's a little bit annoying and I do not know why this issue happens in such strange behaviour.
2. This issue is linked to the search indexing in prestools. I have enabled "indexes" column to check it everything is ok when all od my products are fully indexed because I noticed that some of the products does not appear in search results despite full indexation. I have noticed that some of the products have "0" in the "indexes" column. I went to "Product Search Words" section for the product with 0 indexes and I hit Re-Index button. As a result I have a following error:
NW
Warning: Undefined array key "id_shop" in /XXXXX/prestools/utilities-proc.php on line 515
Time=00:56:00 [starttime was 00:56:00]
I checked a few products with 0 values in the indexes columnt and all gave me the same error. But when I go to the back office, open this product and save it, the "indexes" column is now filled with values and the product appears in the search results. I am not sure what I can do to make a mass updated of that column in prestools. Going into each product in the back office is kinda a slow option to create indexes for search results.