ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Using ProductCart
  New Posts New Posts RSS Feed - Categories and large number of products
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Categories and large number of products

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


Joined: 25-March-2010
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote amscompanies Quote  Post ReplyReply Direct Link To This Post Topic: Categories and large number of products
    Posted: 01-March-2012 at 6:51am

Over the last couple of days I have been using the SUPERB product import wizard (I can't fault it).

I have imported 60,000 of my 130,000 products so far (including categories), each product appears in two categories, but as you can expect, I'm seeing a little slowdown (nothing drastic or that I didn't expect), but I was wondering if anyone had any tips to reduce this.
 
Firstly I would like to remove the dynamic sub-categories from the Browse by Category menu, as I think that would reduce the XML file size and thus performance ?
 
Secondly I would also like to remove the Search results by category: from a search. Try Arsenal and you will see what I mean, as it returns all categories where Arsenal appears and that will be alot (causing un-necessary load on the search)
 
Finally, for the time being (until I finished the upload or see a MASSIVE slowdown), how can I force the user to type at least 4 characters in the searchbox before pressing search, as I see this as a potential killer query if you type just one letter and hit search
 
 
Back to Top
Guests View Drop Down
Guest
Guest
Post Options Post Options   Thanks (0) Thanks(0)   Quote Guests Quote  Post ReplyReply Direct Link To This Post Posted: 01-March-2012 at 8:17pm
Well, one of these is easy, anyways:

1) Removing the subcategories from category navigation: This would require a customization to the function used by the control panel to generate category navigation (pcadmin/genCatNavigation.asp)

2) Remove search results by category: in pc/showsearchresults.asp, find:
pcv_strHideCatSearch = False '// Set to "True" to disable category search

3) Minimum character requirement on search input field: This would require some JavaScript to handle. Here's an example: http://www.webdeveloper.com/forum/showthread.php?t=178782
Back to Top
amscompanies View Drop Down
Newbie
Newbie


Joined: 25-March-2010
Status: Offline
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote amscompanies Quote  Post ReplyReply Direct Link To This Post Posted: 02-March-2012 at 5:04am
Thanks Sean
 
Think I have managed to do point 1 already, I will now attempt points 2 and 3. Thanks for the pointers
 
I've managed to import over 131k products and I still think the performance of both frontend and admin is acceptable, I do have plans for more products so no doubt it will become a problem eventually ?!?


Edited by amscompanies - 02-March-2012 at 5:07am
Back to Top
Guests View Drop Down
Guest
Guest
Post Options Post Options   Thanks (0) Thanks(0)   Quote Guests Quote  Post ReplyReply Direct Link To This Post Posted: 02-March-2012 at 12:29pm
Originally posted by Sean@WMS Sean@WMS wrote:

1) Removing the subcategories from category navigation: This would require a customization to the function used by the control panel to generate category navigation (pcadmin/genCatNavigation.asp)

I don't know what I (wasn't) thinking here. Removing sub-cats from the category navigation is an option in the control panel under Generate Category Navigation. 
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.