Magento

From an CMS Page I would like to display a List of Products filtered by an Attribute (e.g. brand).

I can easily display a list of products within a CMS Page, but I cannot find an existing way of specifying a filter based on the value of an attribute.

In the CMS Page I enter:

You can add the category_id="123" tag within the block like:
{{block type="catalog/product_list" category_id="123" template="catalog/product/list.phtml"}}
but this will only show products under the category with id 123
Not Sure for attributes? Also looking for the same solution

hi,

did you find a solution to this?

regards
brendan

I did not manage to find good solution.

For the time being this is what I do for creating Brand pages with related products and the Layered Navigation:

1) in the brand CMS page I use the following, as explained in my original post:

2) the links to the brand page have the attribute+value parameter into it. For instance:

http://www.site.com/brand-name?brand=123

What the does is to apply the filter “brand=123” into the product list call (1) that selects all the products in the site.

In fact, if you call http://www.site.com/brand-name without the parameter it will show ALL the products.

In order to implement (2) easily, I had an Admin Brand module developed so that it links a CMS page to a Brand, so it knows how to build the links to the Brand CMS pages etc… I hope it makes sense.

It does all I need well and use all the useful features of a CMS page, such as Meta Data. However, the links have a parameter in it, which is not ideal, but not a big issue either.

Alternatively there is a Magento Extension to help woth brands: http://www.magentocommerce.com/extension/1289/shop-by-brands

I am not sure whether it deals with the issue of displaying a full Layered Navigation. Here is an example, but it only shows the Categories: http://www.shearup.com/brands/avena/ It could be that this site only uses the categories in the Layered Navigation.

For Shop by brands you can also look here for a solution

http://www.magentocommerce.com/magento-connect/shop-by-manufacturers.html

For someone who wants to add a complete brand options;

-First, create an image and link to brands in product page:
http://www.magentocommerce.com/wiki/4_-_themes_and_template_customization/catalog/how_to_add_a_brand_or_manufacturer_logo_to_your_product_pages

-Then, create a cms page with a product list, not only from category, but using an attribute: 
http://yoast.com/landing-pages-module-magento/
Using layered navigation:
http://www.sonassi.com/knowledge-base/magento-kb/yoast-landing-pages-module-with-layered-navigation/

You can see it in http://www.todoslot.es

Have a look at the new extension released by FME where you can add the products filtered by certain attributes, category or even SKU

http://www.fmeextensions.com/magento-add-products-to-cms.html

ADD PRODUCTS TO CMS in MAGENTO

Hi guys

check this post
http://www.magentocommerce.com/boards/viewthread/308574/
i hope it helps you

try use extension Shop By Brands!!!

Visit Extension Page: http://www.magebay.com/shop/shop-by-brands.html

Live Demo: http://magebay.com/livedemo/opc/index.php/brands/

Backend Demo: http://magebay.com/livedemo/opc/index.php/admin

Try using Landing Pages Extension.

Good landing pages give you better sales conversion and pages with unique content, which improve your site rankings in search engines. The module lets you decide which content to display on the pages - selected products, banners, text info, CMS blocks. You can specify custom meta tags and short SEO url for each landing page.
-Improve your site SEO to rank higher in search engines
-Landing pages with nice SEO urls and custom meta tags
-Create pages for NEW products
-Pages based on categories and product attributes
-ON SALE products with layered navigation

For userguide and live demo please follow the link http://amasty.com/landing-pages.html