Magento – How to exclude inactive categories/pages from generated google sitemap.xml

categorymagento-1.7sitemapsxml

Through Catalog > Google sitemap I have just generated a sitemap.xml file.

The file itself works perfect.
My problem though is, that the file also contains inactive categories.

I can't seem to find any options to exclude these inactive categories from my generated sitemap.xml file.

Do anyone know how this can be solved?

I am using Magento ver. 1.7.0.2

Best Answer

Try this.

Edit the app/design/frontend/your_package/your_theme/template/catalog/seo/tree.phtml file in your theme. Add an if condition just after the foreach loop which checks for activeness of the $_item.

<?php $_items = $this->getCollection(); ?>
<?php if($_items->getSize()): ?>
    <ul class="sitemap">
        <?php foreach ($_items as $_item): ?>
          <?php if( $_item->is_active ) : ?> 
            <li class="level-<?php echo $this->getLevel($_item) ?>" <?php echo $this->getLevel($_item)?'style="padding-left:' . $this->getLevel($_item, 2) . '0px;"':'' ?>><a href="<?php echo $this->getItemUrl($_item) ?>"><?php echo $_item->name ?></a></li>
        <?php endif; ?> 
        <?php endforeach; ?>
    </ul>
<?php else: ?>
    <p class="note-msg">
        <?php echo $this->__('There are no %s available.', $this->getItemsTitle()); ?>
    </p>
<?php endif ?>

Related Solutions

Magento-1 Sitemaps – Exclude Certain Products from Magento Sitemap.xml Generation

Out of the box, no, there's no way to exclude certain products from the sitemap generated by Magento's Catalog -> Google Sitemap feature.

If I was going to go about doing this programmatically, modern versions of Magento (checked in the 1.7.x branch, this might be around in earlier/EE versions) use the following resource model class

Mage_Sitemap_Model_Resource_Catalog_Product

to fetch a list of products.

#File: app/code/core/Mage/Sitemap/Model/Sitemap.php
$collection = Mage::getResourceModel('sitemap/catalog_product')->getCollection($storeId);

This is not a standard Magento CRUD model, and getCollection does not return a collection object. Instead, getCollection manually queries the database for these products.

If I was going to implement functionality that prevented certain products from showing up in the site map, I'd try to either

A class rewrite the getCollection method which calls the parent::getCollection, and then manually filters out any products from the array
A class rewrite on _addFilter which calls the parent::_addFilter method, and then adds an additional WHERE clause(s) to the _select to exclude the specific product(s). Sort of a hack, but it's the only method where you have access to the _select object used to query the database. Ideally you'd want to have some sort of global/static flag so you only added your new WHERE clause(s) once.

Magento – Google sitemap.xml generates product url’s without category path

This is not a bug, It's a feature.
take a look at how the products are retrieved for generating the xml sitemap.
Mage_Sitemap_Model_Resource_Catalog_Product::getCollection()

    $urCondions = array(
        'e.entity_id=ur.product_id',
        'ur.category_id IS NULL',
        $this->_getWriteAdapter()->quoteInto('ur.store_id=?', $store->getId()),
        $this->_getWriteAdapter()->quoteInto('ur.is_system=?', 1),
    );

The code above represents the join condition with the url rewrites table.
So the url retrieved is the one that has the category_id set to NULL.
This translates into www.somewebsite.com/product-url.html.

If you want to change this functionality, you can try to rewrite this piece of code to include a url rewrite where the category_id is not NULL. but this may lead to strange results, because the products can be places in 0 to all categories.

Best Answer

Related Solutions

Magento-1 Sitemaps – Exclude Certain Products from Magento Sitemap.xml Generation

Magento – Google sitemap.xml generates product url’s without category path

Related Topic