StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
6007641
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2011-05-15T09:46:08.010
FavoriteCount
0
LastActivityDate
2011-05-15T09:46:08.010
LastEditDate
LastEditorUserId
0
OwnerUserId
508134
ParentId
6003465
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<p>I found a way to get my desired result.</p> <p>Apparently my attribute wasn't loaded in my collection so I re-wrote my code and got things done my own way.</p> <p>My task was to create an attribute "Feature in Category?" so products with a "Yes" would appear prior to the category listing. The field Contrast Ratio was being used as an example.</p> <p>I'm willing to share this, so here's my code...</p> <p>Thanks all for your help you led me into the right direction :))</p> <pre><code><?php Mage::getSingleton('catalog/layer')->setData("product_collection",NULL); $this->_productCollection = null; $_productCollection=$this->getLoadedProductCollection(); $currentCategory = Mage::registry('current_category'); $_products = Mage::getModel('catalog/product') ->getCollection() ->addAttributeToSelect(array('name','short_description','product_url','small_image')) ->addAttributeToFilter('seen_first', array('like' => '%1%')) ->addCategoryFilter($currentCategory) ->load(); $_collectionSize = sizeof($_products); ?> <?php if(!sizeof($_products)): ?>  <?php else: ?> <?php // Grid Mode ?> <div class="listing-type-grid catalog-listing padder">  <?php $_items = $_productCollection->getItems(); shuffle($_items); ?> <div class="price_omg_random_products_container"> <table class="price_omg_random_products" cellspacing="0" class="generic-product-grid" id="product-list-table"> <?php $i=0; foreach ($_products as $_product): ?> <?php if ($i++%4==0): ?> <tr> <?php endif ?> <td> <p class="product-image"> <a href="<?php echo $_product->getProductUrl() ?>" title="<?php echo $this->htmlEscape($_product->getName()) ?>"> <img src="<?php echo $this->helper('catalog/image')->init($_product, 'small_image')->resize(110, 110); ?>" alt="<?php echo $this->htmlEscape($_product->getName()) ?>"/> </a> </p> <h5><a href="<?php echo $_product->getProductUrl() ?>" title="<?php echo $this->htmlEscape($_product->getName()) ?>"><?php echo '<span class="price_omg_random_products_title">'.$this->htmlEscape($_product->getName()).'</span>' ?></a></h5> <?php if($_product->getRatingSummary()): ?>  <?php echo $this->getReviewsSummaryHtml($_product) ?> <?php endif; ?> <?php ?> <div class="clear"></div> <ul class="add-to"> <?php echo nl2br($_product->getShortDescription()); if($_additional = $_product->getAdditionalData()): ?> <h2><?php echo $this->__('Additional Information') ?></h2> <table class="data-table" id="product-attribute-specs-table"> <col width="25%" /> <col /> <tbody> <?php foreach ($_additional as $_data): ?> <tr> <th class="label"><?php echo $this->htmlEscape($this->__($_data['label'])) ?></th> <td class="data"><?php echo $_helper->productAttribute($_product, $_data['value'], $_data['code']) ?></td> </tr> <?php endforeach; ?> </tbody> </table> <script type="text/javascript">decorateTable('product-attribute-specs-table')</script> <?php endif;?> <? if($_product->isSaleable()): ?> <li class="add-to-cart-textlink"> <p> <?php echo '<span class="price_omg_random_products_price" >&euro;'.number_format($_product->getPrice(), 2, '.', '').'</span>'; ?>  <button type="button" title="<?php echo $this->__('Add to Cart') ?>" class="button" onclick="setLocation('<?php echo $this->getAddToCartUrl($_product) ?>')"><span><span><?php echo $this->__('Add to Cart') ?></span></span></button> </p>  </li> <?php else: ?> <li><?php echo $this->__('Out of stock') ?></li> <?php endif; ?> <?php if ($i==4) break; // show 4 products max ?> <?php endforeach ?> <?php for($i;$i%4!=0;$i++): ?> <td class="empty-product">&nbsp;</td> <?php endfor ?> <?php if ($i%4==0): ?> </tr> <?php endif ?> </table> </div> <script type="text/javascript">decorateTable('product-list-table')</script> </div> <?php endif; ?> </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POMagento fetch an attribute
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USOliver M Grech
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COYou have a lot of redundancy. `$_productCollection` is never used except to make `$_items`, which is never used. The collection is loaded twice, once as `getLoadedProductCollection()` and again in your custom `$_products`. You can avoid the whole mess by going to _Catalog > Attributes > Manage Attributes_ in the admin and turning on _Used in Product Listing_ for "Feature in Category". This will make the original collection contain your attribute without all the extra programming.
  singulars
  PostPostId
  PO
  UserUserId
  USclockworkgeek

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.