How to Increase Performance for Stores with Large Categories and Products

Last Updated: Dec 11, 2018 03:09PM EST

Fine Tuning your Search Fields

If you are using ProductCart and your store falls into any of the following scenarios, then additional tuning methods may apply to you and may allow you to further improve performance.

  • Complex Category Structure
  • Apparel Add-on in use and thousands of sub-products in the database
  • Thousands of product with large HTML descriptions

Complex Category Structure

If your store has dozens of categories containing dozens of sub-categories and the search results hang, then you may want to disable category search results. Follow these instructions to turn off category search results:

  1. Download the file "pc/showsearchresults.asp" using your favorite FTP software
  2. Save a back-up copy
  3. Open the file in a text editor
  4. Replace the word False on line 19 with True
  5. Save the file and upload it back to the server

Thousands of Sub-Products

You may want to disable sub-product search to increase site performance.

  1. Download the file "pc/showsearchresults.asp" using your favorite FTP software
  2. Save a back-up copy
  3. Open the file in a text editor
  4. Replace the word False on line 24 with True
  5. Save the file and upload it back to the server
  6. Now download the file "pc/inc_srcPrdQuery". Save a back-up copy
  7. Open the file in the text editor
  8. Replace the word False on line 5 with True
  9. Save the file and upload it back to the server
 

Thousands of Products with Large HTML Descriptions

  1. Download the file “pc/showsearchresults.asp” using your favorite FTP software.
  2. Save a back-up copy.
  3. Open the file in a text editor.
  4. Replace all occurrences of the word A.details with A.pcProd_MetaKeywords. It is helpful to use a text editor with a good Find and Replace feature, such as Dreamweaver.
  5. Save the file and upload it back to the server.
  6. Now download the file “pc/inc_srcPrdQuery”. Save a back-up copy.
  7. Open the file in a text editor.
  8. Replace all occurrences of the word A.details with A.pcProd_MetaKeywords
  9. Save the file and upload it back to the server.

Menu

  • Support Forums
  • Video Tutorials
  • Support Request
  • Support Policy
647e99095133bd6d1ae916f97dc7f92f@productcart.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete