Magento 1.9 – How to Get All Magento URLs by Store View

magento-1.9sitemapsurl

I'm looking to retrieve all URLs of a Magento website (CMS pages, categories, products…) subdivided by store view.
Something like the default Magento Sitemap, but with a different format: specifically I'm trying to get a "one URL per row" plain text file, one for each store view.

Best Answer

Take a look at how Magento generates it's sitemap.xml file.

Specifically the Mage_Sitemap_Model_Sitemap class method generateXml. For example, following snippet generates them for the categories, I've rewritten it a little to export to a flat text file.

$ioWrite = new Varien_Io_File();
$path = ''; 
$ioWrite->open(array('path' => $path));
$ioWrite->streamOpen($path.'urls.txt');

$storeId =  Mage::app()->getStore()->getId();
$date    = Mage::getSingleton('core/date')->gmtDate('Y-m-d');
$baseUrl = Mage::app()->getStore($storeId)->getBaseUrl(Mage_Core_Model_Store::URL_TYPE_LINK);

/**
 * Generate categories sitemap
 */
$changefreq = (string)Mage::getStoreConfig('sitemap/category/changefreq', $storeId);
$priority   = (string)Mage::getStoreConfig('sitemap/category/priority', $storeId);
$collection = Mage::getResourceModel('sitemap/catalog_category')->getCollection($storeId);
$categories = new Varien_Object();
$categories->setItems($collection);
Mage::dispatchEvent('sitemap_categories_generating_before', array(
    'collection' => $categories
));
foreach ($categories->getItems() as $item) {
    $ioWrite->streamWrite(htmlspecialchars($baseUrl . $item->getUrl()));
}
unset($collection);
$ioWrite->close();

Add the code from the class to your own script to generate a text file

Related Solutions

Magento – Multistore – Prevent product from having multiple urls

On the no duplicate URL part you can dis- and enable products on website level by going to the BE > Catalog > Manage products and then in a product the Website tab and select the website you want.

Optionally if you only want to show the product on only one website but make it searchable on all make sure the product is assigned to all websites but set the visibility of the product to search only for all shops but one.

Now having them redirect from all shops search results to just one url will require you to hack that into the search result page and quite frankly that will be quite an undertaking. I'm no SEO expert but it might be better to just use a canonical tag for this to make sure Google indexes the right domain and url.

[UPDATE] I took a quick look and it seems that the search results are filtered by store ID from the Mage_CatalogSearch_ResultController controller (line 49) so commenting that out would give you all the products from all the stores. However, you might run into issues with URL's not being displayed right or any other property that is store level dependent.

Magento 1.9 Product URLs – How to Get Product URLs of Each Store View

Better approach imo would be to look up product url using core_url_rewrite table. At least you avoid full product load.

    $productUrls = array();
    $idPath = 'product/887';

    $rewrite = Mage::getResourceModel('core/url_rewrite');
    $read = $rewrite->getReadConnection();

    $select = $read->select()
        ->from($rewrite->getMainTable(), array('store_id', 'request_path'))
        ->where('id_path = ?', $idPath);
    $data = $read->fetchPairs($select);

    foreach (Mage::app()->getStores() as $store) {
        if (isset($data[$store->getId()])) {
            $baseUrl = $store->getBaseUrl(Mage_Core_Model_Store::URL_TYPE_LINK, null);
            $productUrls[$store->getId()] = $baseUrl . $data[$store->getId()];
        }
    }

    Zend_Debug::dump($productUrls);

Best Answer

Related Solutions

Magento – Multistore – Prevent product from having multiple urls

Magento 1.9 Product URLs – How to Get Product URLs of Each Store View

Related Topic