[1.7.6.8] Prestashop Faceted Navigation issue with lot of categories

[AfterGlow93]

Hi, 

We are opening a huge platform (compared to what exists running prestashop) of car parts.

Our prestashop actually is designed as each category is a specific model of car, giving us a lot of categories (actually 165.000+ categories).

The website works very well and we are proud to test prestashop with as much as categories. We run it on a VPS so we don't have issues with requests, and we use the famous eMagicOne Store Manager, which is helpful !

We need to have some advices regarding the Faceted Navigation module.

We already created faceted models for categories but, as we grow up our catalog since, it is completely UNUSABLE.

The CategoryTreeView from the "add" page can't load our categories and render them correctly, even with maximum timeout request on PHP, the page starts to load and take long time before something appear, then, the rendering is stopped.

We tried to use "Collapse all" but the script can't handle it as it is loading all categories.

 

Is there any script mod we can do to the CategoryTree from the helper, to avoid loading all categories expanded first ? 

Then, our category with 160.000 sub-categories use a filter module, which can be used, but the view is disabled to avoid home page loading time being worst due to number of categories.

Can we add a line in the helper category tree view script to skip loading this specific category, which will never use the faceted navigation module ? (ex. if this category, do nothing, else, get data)

 

Thanks for your help

Edited November 28, 2020 by AfterGlow93 (see edit history)