Magento Archives - Bogiecom.com

If you are having a little trouble getting the top navigation to ignore the sort order and use alphabetical sort, here is one option you can use…

Consider the following code for a navigation menu…

   <ul id="custom-menu">
    <?php $_helper = Mage::helper('catalog/category') ?>
<?php $_categories = $_helper->getStoreCategories(true, true, false) ?>
<?php $currentCategory = Mage::registry('current_category') ?>
<?php if (count($_categories) > 0): ?>
    <ul style="width:940px;">
        <?php foreach($_categories as $_category): ?>
            <li>
                <b><a class="drop" href="<?php echo $_helper->getCategoryUrl($_category) ?>">
                    <?php echo $_category->getName() ?>
                </a></b>
                <?php $_category = Mage::getModel('catalog/category')->load($_category->getId()) ?>

                <?php
  		    $collection = $_category->getCollection();
                    $_subcategories = $_category->getChildrenCategories() ?>
                
                <?php if (count($_subcategories) > 0): ?>
                    <div class="dropdown_1column" style="width:235px;">
                        <?php foreach($_subcategories as $_subcategory): ?>
                            <div class="col_1">
                                <a href="<?php echo $_helper->getCategoryUrl($_subcategory) ?>">
                                    <?php echo $_subcategory->getName() ?>
                                </a>
                            </div>
                        <?php endforeach; ?>
                        <div class="clr" clear="all"></div>
                    </div>
                <?php endif; ?>
            </li>
        <?php endforeach; ?>        	
        </ul>                           
               
<?php endif; ?>

<?php $_helper = Mage::helper('catalog/category') ?>

<?php $_categories = $_helper->getStoreCategories(true, true, false) ?>

<?php $currentCategory = Mage::registry('current_category') ?>

<?php if (count($_categories) > 0): ?>

<?php foreach($_categories as $_category): ?>

<li>

<b><a class="drop" href="<?php echo $_helper->getCategoryUrl($_category) ?>">

<?php echo $_category->getName() ?>

</a></b>

<?php $_category = Mage::getModel('catalog/category')->load($_category->getId()) ?>

<?php

$collection = $_category->getCollection();

$_subcategories = $_category->getChildrenCategories() ?>

<?php if (count($_subcategories) > 0): ?>

<?php foreach($_subcategories as $_subcategory): ?>

<a href="<?php echo $_helper->getCategoryUrl($_subcategory) ?>">

<?php echo $_subcategory->getName() ?>

</a>

</div>

<?php endforeach; ?>

</div>

<?php endif; ?>

</li>

<?php endforeach; ?>

</ul>

<?php endif; ?>

The problem is when you get down to the secondary level where it you use the getChildrenCategories(). This function only seems to respect sort order and doesn’t seem to have an option to sort by name. So if you look at the first call for the top level categories $_helper->getStoreCategories(true, true, false). The first parameter tells that section to sort by name.

Seeing as this only traverses the top level, the remaining subcategories are left unchanged. After searching all of the forums for a way around it, some people suggested changing the core file /Mage/Catalog/Model/Resource/Category.php and directly editing the getChildrenCategories() function. While this works… the best option would be to copy the contents of that function directly into the template, to keep it upgrade safe.

So this what that would like:

    <ul id="custom-menu">
    <?php $_helper = Mage::helper('catalog/category') ?>
<?php $_categories = $_helper->getStoreCategories(true, true, false) ?>
<?php $currentCategory = Mage::registry('current_category') ?>
<?php if (count($_categories) > 0): ?>
    <ul style="width:940px;">
        <?php foreach($_categories as $_category): ?>
            <li>
                <b><a class="drop" href="<?php echo $_helper->getCategoryUrl($_category) ?>">
                    <?php echo $_category->getName() ?>
                </a></b>
                <?php $_category = Mage::getModel('catalog/category')->load($_category->getId()) ?>

                <?php
								$collection = $_category->getCollection();

								$_subcategories = $collection
								->addAttributeToSelect('name')
								->addAttributeToSelect('all_children')		
								->addAttributeToSelect('is_anchor')
								->addAttributeToFilter('is_active', 1)
								->addAttributeToSort('name','ASC')
								->addIdFilter($_category->getChildren())
								->setOrder('name', Varien_Db_Select::SQL_ASC)
								->joinUrlRewrite()
								->load();
								
								//$_subcategories = $_category->getChildrenCategories() ?>
                
                <?php if (count($_subcategories) > 0): ?>
                    <div class="dropdown_1column" style="width:235px;">
                        <?php foreach($_subcategories as $_subcategory): ?>
                            <div class="col_1">
                                <a href="<?php echo $_helper->getCategoryUrl($_subcategory) ?>">
                                    <?php echo $_subcategory->getName() ?>
                                </a>
                            </div>
                        <?php endforeach; ?>
                        <div class="clr" clear="all"></div>
                    </div>
                <?php endif; ?>
            </li>
        <?php endforeach; ?>        	
        </ul>                           
               
<?php endif; ?>

<?php $_helper = Mage::helper('catalog/category') ?>

<?php $_categories = $_helper->getStoreCategories(true, true, false) ?>

<?php $currentCategory = Mage::registry('current_category') ?>

<?php if (count($_categories) > 0): ?>

<?php foreach($_categories as $_category): ?>

<li>

<b><a class="drop" href="<?php echo $_helper->getCategoryUrl($_category) ?>">

<?php echo $_category->getName() ?>

</a></b>

<?php $_category = Mage::getModel('catalog/category')->load($_category->getId()) ?>

<?php

$collection = $_category->getCollection();

$_subcategories = $collection

->addAttributeToSelect('name')

->addAttributeToSelect('all_children')

->addAttributeToSelect('is_anchor')

->addAttributeToFilter('is_active', 1)

->addAttributeToSort('name','ASC')

->addIdFilter($_category->getChildren())

->setOrder('name', Varien_Db_Select::SQL_ASC)

->joinUrlRewrite()

->load();

//$_subcategories = $_category->getChildrenCategories() ?>

<?php if (count($_subcategories) > 0): ?>

<?php foreach($_subcategories as $_subcategory): ?>

<a href="<?php echo $_helper->getCategoryUrl($_subcategory) ?>">

<?php echo $_subcategory->getName() ?>

</a>

</div>

<?php endforeach; ?>

</div>

<?php endif; ?>

</li>

<?php endforeach; ?>

</ul>

<?php endif; ?>

So instead of calling $_subcategories = $_category->getChildrenCategories()… you just set the $_subcategories variable to the following:

								$_subcategories = $collection
								->addAttributeToSelect('name')
								->addAttributeToSelect('all_children')		
								->addAttributeToSelect('is_anchor')
								->addAttributeToFilter('is_active', 1)
								->addAttributeToSort('name','ASC')
								->addIdFilter($_category->getChildren())
								->setOrder('name', Varien_Db_Select::SQL_ASC)
								->joinUrlRewrite()
								->load();

$_subcategories = $collection

->addAttributeToSelect('name')

->addAttributeToSelect('all_children')

->addAttributeToSelect('is_anchor')

->addAttributeToFilter('is_active', 1)

->addAttributeToSort('name','ASC')

->addIdFilter($_category->getChildren())

->setOrder('name', Varien_Db_Select::SQL_ASC)

->joinUrlRewrite()

->load();

Lately, there certainly has been a lot of buzz around the thought of combining WordPress and Magento. If you enjoy using WordPress for your CMS, but want to use Magento as your E-Commerce platform here are some options for you.

Lucky for most Magento users, there is an extension that will integrate Magento and WordPress with minimal effort. You may find the extension as well as the installation instructions here: Lazzymonks WordPress Integration 2.61

Personally, the extension did not offer what I was looking for, which was control over the SEO permalinks function in WordPress. However, in the future the Lazzymonks extension may offer the ability to pick whatever permalinks setting you want in WordPress.

So, where I started was at the following tutorial: Tutorial: Integrating 3rd Party CMS Content Within Magento.

The tutorial was originally written for Expression Engine, but could be used for any CMS, including WordPress. I was able to successfully integrate Magento and WordPress starting with the tutorial above. However, there were some additional changes that had to be incorporated to meet the needs of my organization.

For one, I needed to make sure the RSS feeds out of WordPress could be easily viewed from the integration. With the default integration above, this was not necessarily possible depending upon your site’s folder structure. However, with a few lines of code, I was able to easily navigate from the header links generated by WordPress.

Another issue was the WordPress header information. This required editing the Magento template to accomodate for the WordPress header information. Most importantly for me, I wanted the WordPress page title to be the title of the Magento page. This was possible by altering the Magento page template that would house the WordPress section of the website by excluding the title tags. At this point the WordPress title would begin to show up in the browser.

Then lastly, I had to find a WordPress template to fit the Magento template. Then edit the WordPress template until it looked good inside Magento.

And that was it. Not so bad. I’m sure there are some more/better possibilites on how to integrate WordPress and Magento, but for the time being this has worked for me.

Category Archives: Magento

Magento Top Navigation Sort Alphabetically

Magento Custom Form Field Validators using Prototype (MySQL Date Format)

Magento and WordPress Integration – A Couple of Options