How to display breadcrumbs on Magento Sitemap ?

You can easily add the breadcrum in sitemap using below 2 ways

1. <?php 
       echo $this->getLayout()->getBlock("breadcrumbs")->
                 ->addCrumb('CrumbName', array('label' => 'this will appear as link text', 'title' => 'title attribute of link', 'link' => 'url to the page)
                 ->toHtml()
   ?>

   OR

2. <reference name="root">
       <action method="setTemplate"><template>page/1column.phtml</template></action>
       <action method="unsetChild"><alias>breadcrumbs</alias></action>
       <block type="page/html_breadcrumbs" name="breadcrumbs" as="breadcrumbs">        
         <action method="addCrumb"><crumbName>Name</crumbName><crumbInfo><label>Test</label><title>Test</title><link>/test.html</link></crumbInfo></action>
       </block>
   </reference>

How to run Magento Cron Jobs manully?

Here is the simple solutions very easy to run magento cron jobs!

use your browser to run http://yourdomain.com/cron.php 
 or 

php-cli to execute cron.php in the root of the application.

How to Run re-indexing through comman prompt in Magento?

Here is the solution to re-index easily.

First you need open command prompt and go to respective magento path.
Example: I have git in my local then myproject. I have been to git/myproject

Then you can following commands:

1.        php indexer.php --reindex catalog_product_attribute
2.        php indexer.php --reindex catalog_product_flat
3.        php indexer.php --reindex catalog_category_flat 
4.        php indexer.php --reindex catalog_category_product 
5.        php indexer.php --reindex catalogsearch_fulltext
6.        php indexer.php --reindex cataloginventory_stock
7.        php indexer.php --reindex catalog_product_price
8.        php indexer.php --reindex catalog_url

How to find the Magento website admin login url of your Magento?

Here is the quick find out magento admin url:

If you’re stuggling to remember or have forgotten what your Magento ecommerce websites, there is a simple way of finding out what this is.

1. Downloaded the file app/etc/local.xml to your computer and open the file.
2. Locate the line of code – <frontName><![CDATA[admin]]></frontName>
3. “admin” – is the current path to the admin login screen here, change this to something more memorable, save and upload the file.

Here your admin url is : <yourdomainname>/admin

How to delete all Magento’s sample products in Magento’s database

Please run the below queries to delete the data from your magento.

TRUNCATE TABLE `catalog_product_bundle_option`;

delete from catalog_product_bundle_option where option_id >0;

TRUNCATE TABLE `catalog_product_bundle_option_value`;

TRUNCATE TABLE `catalog_product_bundle_selection`;

TRUNCATE TABLE `catalog_product_entity_datetime`;

TRUNCATE TABLE `catalog_product_entity_decimal`;

TRUNCATE TABLE `catalog_product_entity_gallery`;

TRUNCATE TABLE `catalog_product_entity_int`;

TRUNCATE TABLE `catalog_product_entity_media_gallery`;

delete from catalog_product_entity_media_gallery where value_id < 373;

TRUNCATE TABLE `catalog_product_entity_media_gallery_value`;

TRUNCATE TABLE `catalog_product_entity_text`;

TRUNCATE TABLE `catalog_product_entity_tier_price`;

TRUNCATE TABLE `catalog_product_entity_varchar`;

TRUNCATE TABLE `catalog_product_link`;

delete from catalog_product_link where link_id >0;

TRUNCATE TABLE `catalog_product_link_attribute`;

delete from catalog_product_link_attribute where product_link_attribute_id>0;

TRUNCATE TABLE `catalog_product_link_attribute_decimal`;

TRUNCATE TABLE `catalog_product_link_attribute_int`;

TRUNCATE TABLE `catalog_product_link_attribute_varchar`;

TRUNCATE TABLE `catalog_product_link_type`;

delete from catalog_product_link_type where link_type_id >0;

TRUNCATE TABLE `catalog_product_option`;

delete from catalog_product_option where option_id > 0;

TRUNCATE TABLE `catalog_product_option_price`;

TRUNCATE TABLE `catalog_product_option_title`;

TRUNCATE TABLE `catalog_product_option_type_price`;

TRUNCATE TABLE `catalog_product_option_type_title`;

TRUNCATE TABLE `catalog_product_option_type_value`;

delete from catalog_product_option_type_value where option_type_id > 0;

TRUNCATE TABLE `catalog_product_super_attribute`;

delete from catalog_product_super_attribute where product_super_attribute_id>0;

TRUNCATE TABLE `catalog_product_super_attribute_label`;

TRUNCATE TABLE `catalog_product_super_attribute_pricing`;

TRUNCATE TABLE `catalog_product_super_link`;

TRUNCATE TABLE `catalog_product_enabled_index`;

TRUNCATE TABLE `catalog_product_website`;

TRUNCATE TABLE `catalog_product_entity`;

delete from catalog_product_entity where entity_id>0;

 

TRUNCATE TABLE `cataloginventory_stock`;

TRUNCATE TABLE `cataloginventory_stock_item`;

TRUNCATE TABLE `cataloginventory_stock_status`;







After you run above queries, please run below ones to insert the some deafult data.

insert  into `catalog_product_link_type`(`link_type_id`,`code`) values (1,'relation'),(2,'bundle'),(3,'super'),(4,'up_sell'),(5,'cross_sell'); insert  into `catalog_product_link_attribute`(`product_link_attribute_id`,`link_type_id`,`product_link_attribute_code`,`data_type`) values (1,2,'qty','decimal'),(2,1,'position','int'),(3,4,'position','int'),(4,5,'position','int'),(6,1,'qty','decimal'),(7,3,'position','int'),(8,3,'qty','decimal'); insert  into `cataloginventory_stock`(`stock_id`,`stock_name`) values (1,'Default'); If the queries give any errors, that might be the version issues, then just go open the Magento sample data script you used to creat all the tables in Magento’s database, find and run the queries used to inserting data to those tables: catalog_product_link_type, catalog_product_link_attribute, and cataloginventory_stock.

Magento Extensions -

Mageworld is Leading Provider of Magento Extensions.
It is providing best services to the magento clients.
There are lot of extensions here i am listing some of top sellers.

1. Reward Points Pro

2.One Step Checkout Pro

3.Free Gift Pro

4.Affiliate Pro

5.Follow Up Email Pro

6.Help Desk Pro

7.Daily Deal Pro

8.Photo Gallery Pro

9.Mega Menu 

10.CMS Pro (News / Blog)

 

Ofcourse it has other extensions also. please click here to see all available extensions from the mage-world.