I want to list the vendors when selecting a category from the TopMenu. Only vendors with products in that category should be listed. When clicking a vendor, all products from that vendor in the selected category will be shown.
Yes, I know. I am doing this already. By default, I get the products by category.
What my customer needs to have are the vendors by category instead, and when selecting a vendor, all the products of that vendor in the selected category.
I asked myself, what is the best way to do this, mainly performance-wise.
I very appreciate any suggestions, because I am quite new to nopCommerce, but not to c# dev :-)
what is the best way to do this, mainly performance-wise.
Simply create new stored procedure for getting product by category and vendor.
The second way is to use ProductLoadAllPaged stored procedure (default nopCommerce's SP) and pass category Id and vendor Id so you get correct results.