Hello
This was odd and hard to detect, really a lot of products looked alike “ghosts” in the database, however finally I found the culprit and “fixed it” (just a workaround I would say, but a clean one at least as it is done in the configuration of the product module), seems to work now.
I went to settings>modules> product module, there at the bottom of the page in the “user interface” section I settled the configuration as follows:
Wait until you press a key before loading content of product combo list (This may increase performance if you have a large number of products, but it is less convenient) >>> NO
Maximum number of products to show in combo select lists (0=no limit) >>> 0 (I settled to no limits, was at 1000)
How to use the description of the products when adding a product as a line of a document >>> Auto fill the description…
Display product descriptions in forms (otherwise shown in a tooltip popup) >>> YES
The 1000 limit was the culprit, but I do not see which kind of logic causes this odd behaviour!
In fact, if it is true that I added more than 1000 products to the catalogue, it is also true that the products I was searching for could not be found nor using the reference code, nor using a word contained in the title or description
Despite the fact that in the products catalogue there cannot be 2 products with same reference code (or ID) and the fact that I do not have a catalogue in which more than 1000 products do contain same keywords in the title or the description the search box refused to show me a lot of them…
This is a pretty odd behaviour…
Therefore I presume/imagine that something must be fixed in this respect.
That limit “Maximum number of products to show in combo select lists (0=no limit)” should be there to avoid to load a huge list of products sharing same keywords in the title or description, but seems that now this filter does something else in fact …
I begun to notice this kind of behaviour when upgrading an older installation to version 11 (if I am not wrong, maybe was to version 9, however with earlier versions I never saw something like that), at that time I did not dig much to solve this issue as it happened only for some products I did not need often and taken by the rush I used to add it manually in the proposal, de facto neglecting to take care to see why it happened…
However, now seems to work fine, I will write more about this issue if I notice further oddities
If anyone at Dolibarr wants to check this maybe it is something that can be fixed or arranged in a better way
Thank you
Best regards
