ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Customizing ProductCart
  New Posts New Posts RSS Feed - Customizing search
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Customizing search

 Post Reply Post Reply
Author
Message
bp_travis View Drop Down
Newbie
Newbie


Joined: 27-June-2008
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote bp_travis Quote  Post ReplyReply Direct Link To This Post Topic: Customizing search
    Posted: 24-November-2009 at 12:08pm
Which file contains the query that ProductCart uses to conduct searches? I want to customize the search so that it DOES NOT search the description of each product. I also want to customize the query so it searches the metatag field of the product table in the DB.

Thanks
Back to Top
blackey View Drop Down
Newbie
Newbie


Joined: 11-November-2008
Location: Livermore, CA
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote blackey Quote  Post ReplyReply Direct Link To This Post Posted: 28-November-2009 at 6:37pm
It is Showsearchresults.asp in the PC folder.  Removing the search of the description field took our search speed from 35 seconds to 2-3 seconds.  We have about 40K products with a lot of information in the description field.

Bill Lackey
www.lpiracing.com



Edited by blackey - 28-November-2009 at 6:39pm
Back to Top
bp_travis View Drop Down
Newbie
Newbie


Joined: 27-June-2008
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote bp_travis Quote  Post ReplyReply Direct Link To This Post Posted: 30-November-2009 at 10:12am
Thanks. What exactly do I need to remove in the file? There is a lot in the file and I've tried to edit some of it to remove it and have not succeeded yet. 
Back to Top
blackey View Drop Down
Newbie
Newbie


Joined: 11-November-2008
Location: Livermore, CA
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote blackey Quote  Post ReplyReply Direct Link To This Post Posted: 30-November-2009 at 12:56pm
What version of the store are you using?  If you send me your email I will send you my modified one (3.12 or 3.51).  I took out short description and long description.

Bill

Back to Top
bp_travis View Drop Down
Newbie
Newbie


Joined: 27-June-2008
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote bp_travis Quote  Post ReplyReply Direct Link To This Post Posted: 30-November-2009 at 3:03pm
I am using 3.51. My email is travis@barkleigh.com

Thanks
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.078 seconds.