During the development and testing process we create different customer and different order in Magento , after the site goes live we need to delete that . So  here are the simple ways to do it with the query below Customer detail can be deleted from the magento admin > Manage Customer. http://www.magentocommerce.com/wiki/import-export_and_data_manipulation/deleting_order_and_customer_data_with_sql

Move related products from default sidebar location into main product page in Magento. 1. Open catalog.xml, found in app/design/frontend/default/YOURTEMPLATEFOLDER/layout/ 2. In catalog.xml find the catalog_product_view section, around line 205. In the section, remove or comment out: and replace with: 3. Now in your catalog/product/view.phtml you can print out the related products using To edit the

Steps to add static block into the header area of Magento Site Steps for adding block in Admin Panel Steps for changing in page.xml file Steps for changing in header.phtml file Source : http://bmehla.wordpress.com/2011/05/04/magento-steps-to-add-static-block-into-the-header-area-of-magento-site/

To activate and deactivate widgets in Magento like the Newsletter option, it’s pretty easy. You just go to System/Configuration/Advanced and select ‘disable’ next to the ‘Mage_Newsletter’ item. But what if you want to disable something that has no apparent widget control? I couldn’t find a widget that controlled the ‘Shop By’ option in the left

Following is the code to get the login & logout link. Here are more variable’s that may you need to get the customer data on the frontend. Source : www.adeelishfaq.com/blog/how-to-get-the-login-logout-url-in-magento/ </pre

If you want to remove the “Help Us to Keep Magento Healthy – Report All Bug” from footer, navigate to of your theme assuming that you are using default magento theme . Otherwise navigate to your related theme file and remove the following line If you want to remove the menus seens in the footer

Magento have own standard of query, If we want to add the other condition like for random case, for to limit