Hello,
I am currently using Storefront 9.0 and DNN8.
I have a store that when fully populated will have 150K+ product variants from 700 manufacturers, in 144 different categories. Some manufacturers have hundreds of items across multiple categories.
I want to be able to navigate by manufacturer, then by category within the manufacturer.
In testing I have a Storefront Manufacturer and Category navigation controls on my default product list page, but their operation appears to be exclusive to each other. I have tried combining the url parameters, but that generates a module load error.
I have used the Manufacturer and Category as filterable attributes, which works, but it is my understanding it will be a performance issue when I have a fully populated database.
It is my understanding that expanding the Category navigation, will not encounter the same performance issues. Does that hold true no matter how many categories exist?
If I were to structure my Revindex Categories, to include categories that emulate Manufacturer, for Example:
- Category A
- Category B
- Category C
- Manufacturers
I would then assign each product variant to multiple categories as appropriate, and only use attribute filters after the navigation has filtered the list.
This would give me the navigation options I want, but would that eliminate(minimize?) the performance hit? Because of 1000's of categories.
Thanks,
Jim