I need a dropdown brand filter for Silvershop

Question

How to filter $ Product on additional sites in the template?

I tried:

$Product.filter('AdditionalCategories', $MyFilter) 

But there is no AdditionalCategories column for the product in the database

Answer 1

Using @ 3dgoo

Looks like I need the following:

 <% loop $Products.filter('Product_ProductCategories.ProductCategoryID', $MyFilter) %> 

Answer 2

Product relates many to many to a ProductCategory called ProductCategories .

If we want to filter products by category, we would name the following:

 $Product.filter('ProductCategories.ID', 5) 

I would recommend writing this filter to a function in the controller. Something like that:

 public function getFilteredProducts() { return Product::get()->filter('ProductCategories.Title', 'my-filter'); }