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
Related products on product page in Magento
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 look of that list, edit … Continue reading …
Adding static block into the header area of Magento Site
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/
How to remove the ‘Shop By’ box from the left column in Magento
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 column. If there is a … Continue reading …
How to get the login & logout url in magento?
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/
Remove magento footer links.
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 like “Site Map, Search Terms, … Continue reading …
Query in Magento
Magento have own standard of query, If we want to add the other condition like for random case, for to limit
Vi commands: Simple and Quick tutorial
VI is a display oriented interactive text editor originally created for the Unix operating system. It is available by default on all UNIX systems. It is supplied with all Linux distributions. Here is a simple and quick VI command tutorial. Note: VI commands are CASE SENSITIVE. Modes There are two modes in vi: command mode and insert mode. All vi … Continue reading …
Custom image size and autocrop options
WordPress provides different sizes of images , the size of the uploaded image can be edited form Setting > Media and give the required value .But sometime we may need other sizes imaged too so for that purpose we can use the function.php of the theme for custom options. I found it from Just add
Limit excerpt length by characters (Multiple excerpt)
I wanted to have multiple excerpt for my site in wordpress . I googled and find numerious one but http://wordpress.org/support/topic/limit-excerpt-length-by-characters helped me alot. We can simple add and it by echo get_excerpt(125);