Page 1 of 1

⛔ any way to avoid duplicate logged customer searches in oc3* under reports->reports->customer searches?

Posted: Tue Jan 14, 2020 11:38 am
by supak111
Is there any way to prevent duplicate searches under: reports->reports->customer searchers reports?

I had an extension in oc2 that logged them but it did not save duplicates. It would state how many times that search keyword was searched and it would update the date when it was last searched.

Was wondering if the code could be easily modified to avoid multiple duplicates

Re: ⛔ any way to avoid duplicate logged customer searches in oc3* under reports->reports->customer searches?

Posted: Tue Jan 14, 2020 11:42 am
by by mona

Re: ⛔ any way to avoid duplicate logged customer searches in oc3* under reports->reports->customer searches?

Posted: Tue Jan 14, 2020 3:18 pm
by letxobnav
the problem is not the search function but the search keyword recording for reporting.
That default function records the same keyword as separate records instead of checking if the record exists and up the count.

The reason is probably because it wants to show the number of resulting products over time for a keyword, but it is nonsense to do it for every individual search (show the last result if you must) as well as destructive as any bot can do a million searches for the same keyword which would result in a million records in your customer search table.

Re: ⛔ any way to avoid duplicate logged customer searches in oc3* under reports->reports->customer searches?

Posted: Tue Jan 14, 2020 8:54 pm
by supak111
I get bots now doing many searches for example for keyword "image". This results in a bunch on searches in my customer searches reporting.

It would make more sense if the keywords "image" only appeared once my DB instead of 200 different times like now

Re: ⛔ any way to avoid duplicate logged customer searches in oc3* under reports->reports->customer searches?

Posted: Tue Jan 14, 2020 10:20 pm
by by mona
The extension recommended above allows you to combine keyword searches.
595b9e10c7087-resize-500x500.jpg

595b9e10c7087-resize-500x500.jpg (92 KiB) Viewed 214 times

It also is an extremely good search ..

Re: ⛔ any way to avoid duplicate logged customer searches in oc3* under reports->reports->customer searches?

Posted: Wed Jan 15, 2020 12:04 am
by D3MO
supak111 wrote:
Tue Jan 14, 2020 11:38 am
Is there any way to prevent duplicate searches under: reports->reports->customer searchers reports?

I had an extension in oc2 that logged them but it did not save duplicates. It would state how many times that search keyword was searched and it would update the date when it was last searched.

Was wondering if the code could be easily modified to avoid multiple duplicates
if you didnt yet solved it describe what exactly you need i will make it as a module:) (for you as idea author for free) and later put it on marketplace (as i am a bit of lack of ideas at the moment):)) contact me directly by email: voldemaras@gmail.com