Today, ‪Magesolution‬ comes back with the ‪Magento‬ ‪‎tutorial about some effective methods to show Products on Homepage Using Magento Filter Collection By Attribute,Field


First, explain how Magento filter a collection. Use this to explain how Magento filter a collection by attribute, field in a model, so that people can learn to write their own collections.

addAttributeToFilter() is a function that can be called on a collection in Magento. In
short, it adds a condition to the WHERE part of the MySQL query used to extract a collection from the database.
For example:

Name: Untitled.png Views: 220 Size: 12.8 KB

The above code would get a product collection, with each product having it’s name, url,
price and small image loaded in it’s data array. The product collection would be filtered and contain only products that have an SKU starting with UX.

Filtering


We can filter our collections with the addFieldToFilter() function. In SQL you can think of these as your WHERE clauses.
Lets say we want to get a product by the sku PRODUCT001

CLICK HERE FOR FULL LESSION : Show Products on Homepage Using Magento Filter Collection By Attribute,Field

View more threads in the same category: