Skip to main content

Google Sitemap XML creation in Magento

Recently for a website, I made code for Google Sitemap. This script creates product xml which we need to list our products in Google. To create this follow below process:

  • Create a php file and put it on root. Lets name the file Googlexml.php 
  • This file will create an xml file whenever we hit the file. 
  • We also needs to make a destination directory for output xml file inside media folder. Let's say the folder name is /GMC. Output file would be automation.xml.
That's it, let's start the coding part. Please copy and paste below script in Googlexml.php file.

     

<?php

if($_SERVER["DOCUMENT_ROOT"]) {

    $documentRoot = $_SERVER["DOCUMENT_ROOT"];

} else {

    $pathArray = explode('Googlexml.php', $_SERVER["SCRIPT_NAME"]);

    $documentRoot = $pathArray[0];

}



require_once $documentRoot.'/ROOT_FOLDER/app/Mage.php';

Mage::app();



$products = Mage::getModel('catalog/product')->getCollection()

        ->setStoreId(Mage::app()->getStore()->getId())

        ->addAttributeToFilter('status', 1)

        ->addAttributeToSelect(array('sku', 'name', 'short_description', 'small_image', 'url_path', 'news_from_date', 'news_to_date', 'special_from_date', 'special_price', 'special_to_date', 'price', 'manufacturer'))

        ->setOrder('entity_id', 'DESC');



$feed_data = '<?xml version="1.0" ?>'."\n";

$feed_data .= '<rss xmlns:g="http://base.google.com/ns/1.0" version="2.0">'."\n";

$feed_data .= "\t".'<channel>'."\n";

$feed_data .= "\t\t".'<title>STORENAME</title>'."\n";

$feed_data .= "\t\t".'<link>STOREURL</link>'."\n";

$feed_data .= "\t\t".'<description>This is a sample feed containing the required and recommended attributes for a variety of different products</description>'."\n";



foreach($products as $product)

{

    foreach($product->getCategoryIds() as $catId)

    {

        $productType = $categoryTree = array();

        $path = Mage::getModel('catalog/category')->load($catId)->getPath();

        if($path != '')

        {

            $ids = array_slice(explode('/', $path), 2);

            if(!empty($ids))

            {

                foreach($ids as $id)

                    $productType[] = $categoryTree[] = Mage::getModel('catalog/category')->load($id)->getName();

            }

        }

        break;

    }

    

    if(strlen($product->getShortDescription()) > 45)

        $shortDescription = $product->getShortDescription();

    else

        $shortDescription = "Buy ".$product->getAttributeText('manufacturer')." ".$product->getName()." at Rs. ".((number_format($product->getFinalPrice(),2) != number_format($product->getPrice(),2))?number_format($product->getFinalPrice(),2):number_format($product->getPrice(),2))." online in India. Set Of ".$product->getBoughtas()." Pieces: ".$product->getShortDescription().": Urbandazzle";

    

    array_pop($productType);

    if($product->getAttributeText('manufacturer') != '' && $product->getPrice() != 0) {

        $feed_data .= "\t\t".'<item>'."\n";

        $feed_data .= "\t\t\t".'<g:id><![CDATA['.$product->getId().'/'.$product->getSku().']]></g:id>'."\n";

        $feed_data .= "\t\t\t".'<title><![CDATA['.$product->getName().']]></title>'."\n";

        $feed_data .= "\t\t\t".'<description><![CDATA['.$shortDescription.']]></description>'."\n";

        $feed_data .= "\t\t\t".'<g:google_product_category><![CDATA['.implode('>', $categoryTree).']]></g:google_product_category>'."\n";

        $feed_data .= "\t\t\t".'<g:product_type><![CDATA['.implode('>', ((count($productType))?$productType:$categoryTree)).']]></g:product_type> '."\n";

        $feed_data .= "\t\t\t".'<link><![CDATA['.$product->getProductUrl().']]></link>'."\n";

        if(file_exists(Mage::getBaseDir('media').DS.'catalog/product'.$product->getSmallImage()))

            $feed_data .= "\t\t\t".'<g:image_link><![CDATA['.Mage::getBaseUrl('media').'catalog/product'.$product->getSmallImage().']]></g:image_link>'."\n";

        $feed_data .= "\t\t\t".'<g:condition>'.$new.'</g:condition>'."\n";

        $feed_data .= "\t\t\t".'<g:availability>'.(($product->getIsInStock())?'in stock':'out of stock').'</g:availability>'."\n";

        $feed_data .= "\t\t\t".'<g:price>'.sprintf('%0.2f', $product->getPrice()).' INR</g:price>'."\n";

        if(sprintf('%0.2f', $product->getFinalPrice()) != sprintf('%0.2f', $product->getPrice()))

            $feed_data .= "\t\t\t".'<g:sale_price>'.sprintf('%0.2f', $product->getFinalPrice()).' INR</g:sale_price>'."\n";

        $feed_data .= "\t\t\t".'<g:brand><![CDATA['.$product->getAttributeText('manufacturer').']]></g:brand>'."\n";

        $feed_data .= "\t\t".'</item>'."\n";

    }

}



$feed_data .= "\t".'</channel>'."\n";

$feed_data .= '</rss>'."\n";



$fileDir = Mage::getBaseDir('media').DS.'GMC';

$filePath = Mage::getBaseDir('media').DS.'GMC'.DS.'automation.xml';



if(file_exists($filePath))

    unlink($filePath);



if(!file_exists($fileDir)) {

    mkdir($fileDir);

    chmod($fileDir, 0777);

}



if(is_dir($fileDir)) {

    $fp = fopen($filePath, 'w');

    fwrite($fp, $feed_data);

    fclose($fp);

}

Comments

Post a Comment

Popular posts from this blog

Add Products to cart Programmatically in Magento

Sometimes we need to add products into cart programmatically in controller. Below is the code which you can use to add product to cart.   1) For Simple Products If you are working in magento controller and wants to add a simple product programmatically then here is the code: Suppose our product id value stored in $productId.         // Below code will create instance of cart         $cart = Mage::getModel('checkout/cart');         // This will initialize cart         $cart->init();         // Get the product collection by passing product id         $productCollection = Mage::getModel('catalog/product')->load($productId); This product collection will be required as we have to pass it at the time of adding product to cart. For adding the product we have to call addProduct() function. In this function we have to pass two parameters first is productcollection and second is an array. This array contains product id and quantity which we are going
10 comments
Read more

Magento Multiple Store Setup

Many times we need to create multiple stores in magento website. In magento we create different stores to make it more local. We can access different stores using below ways: 1) Domain (e.g. www.store1.com and www.store2.com) 2) Subdomain (e.g. store1.mystore.com and store2.mystore.com) 3) Folder (e.g. mystore.com/store1/ and mystore.com/store2/) Its all upto to you which way you prefer. For all these we need to follow below steps: Step 1: Add new Magento store: It might be possible that both store have different  catalogue so to manage this. We need to make two different Base Categories. To create a new base category follow below steps: Log in to your Magento admin panel. Go to Catalog -> Manage Categories . If you want both your websites to share same “ Default Category ”, select it by clicking on it on the left. Or click Add Root Category to create a new root category different from the existing one. Once the category is selected, under the General
6 comments
Read more

Quick Order Placement Form

If we want to place fast and quick order. We want to list all the product along with their categories  and price. For achieving this goal we have to follow these steps: 1) Create Template File : Create a template  file at /app/design/frontend/default/blanco/template/catalog/product/list_fast_order.phtml which will the list of all products along with their categories and Price listing. 2) Edit Layout : Before this we have to add the phtml file in catalog.xml file. 3) Get Result :  In list_fast_order.phtml file we have to show the product category wise /*assume we want to get all products of category id 5 */ $catid_1 = 5; /*we are loading all the products from category id 5 */ $_category = Mage::getModel('catalog/category')->load($catid_1); $subs = $_category->getAllChildren(true); /* Use for loop for making result array */ $result = array(); foreach($subs as $cat_id) { $category = new Mage_Catalog_Model_Category();
9 comments
Read more