Post by supak111 » 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

~ OC 3.0.3.2 and OCmods only ~


User avatar
Active Member

Posts

Joined
Fri Feb 13, 2015 12:09 pm

Post by by mona » Tue Jan 14, 2020 11:42 am


DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.


https://www.youtube.com/watch?v=zXIxDoCRc84


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by letxobnav » Tue Jan 14, 2020 3:18 pm

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.

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.


User avatar
Expert Member

Posts

Joined
Fri Aug 18, 2017 4:35 pm
Location - Taiwan

Post by supak111 » Tue Jan 14, 2020 8:54 pm

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

~ OC 3.0.3.2 and OCmods only ~


User avatar
Active Member

Posts

Joined
Fri Feb 13, 2015 12:09 pm

Post by by mona » Tue Jan 14, 2020 10:20 pm

The extension recommended above allows you to combine keyword searches.
595b9e10c7087-resize-500x500.jpg

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

It also is an extremely good search ..

DISCLAIMER:
You should not modify core files .. if you would like to donate a cup of coffee I will write it in a modification for you.


https://www.youtube.com/watch?v=zXIxDoCRc84


User avatar
Expert Member

Posts

Joined
Mon Jun 10, 2019 9:31 am

Post by D3MO » Wed Jan 15, 2020 12:04 am

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

Opencart Expert | voldemaras@gmail.com
Skype - programanija | Gtalk - voldemaras@gmail.com
Extensions for Opencart @ https://www.opencartextensions.eu / or Opencart Marketplace

Need Custom Module? debug third party module or simply have any question related to Opencart? feel free to contact directly for a live chat session:) - INSTANT LIVE CHAT


User avatar
Active Member

Posts

Joined
Mon Apr 04, 2011 6:57 am
Who is online

Users browsing this forum: Google [Bot], niagato, Semrush [Bot] and 649 guests