Magento - Steps to moving magento from one server to other

magento from one server to other

Magento - Store Information

Store Information

Magento - Import Manufacturers

Import Manufacturers

Magento Set, Retrieve and Unset Session Variables

Retrieve and Unset Session Variables

How to add product programmatically in magento 1.7.0 with image andcustom field

Magento add product script

Magento script to make is anchor yes to all categories.

isanchoryesIs anchor yes to all categories in magento

Magento important tables

sales_flat_quote -> magento cart master table.
sales_flat_order -> magento order master table.
eav_attribute -> magento attribute master table.
catalog_product_entity -> product master table.
catalog_product_entity_varchar -> product master table values.
catalog_category_entity -> category master table.
catalog_category_entity_varchar -> category master table values.
core_resource -> plugin table.
newsletter_subscriber -> newsletter subscriber master table.
review -> review master table.
review_detail -> review detail table.
customer_entity -> customer main table
wishlist -> wishlist main table.
admin_user -> admin user master table.
cms_block -> cms block master table.
cms_page -> cms page master table.

Magento: How to delete test orders in magento

delete test orders in magento

How to change the Magento Admin Panel Title?

If you want to change default title of Magento Admin, there is an easy solution:

Just open the main.xml file, which is located in app/design/adminhtml/default/default/layout folder.

Find line like below:

<action method="setTitle" translate="title"><title>Magento Admin</title></action>

 and replace the words Magento Admin with the words you like to be in default title.

Hide Attributes which have no value in Magento

no value in Magento

Magento: How to view Magento version

Create file versionTest.php parallel to index.php in root folder.
Now copy and paste following code in versionTest.php:
<?php
include_once(‘App/Mage.php’);
Mage::app();
echo Mage::getVersion();
?>

Magento - Reset the admin password

UPDATE admin_user SET password=CONCAT(MD5('admin123')) WHERE username='admin';

Script for to remove the cache - Magento

getCache()->clean(); exit("done"); ?> can call that file with :http://yourdomainname/cache-clear.php

Magento Add Free Shipping promotions to the sidebar my cart block

Add Free Shipping promotions

Customizing Onepage Checkout - Remove login

removelogin_oncheckout

Billing same as Shipping Address / Remove Billing Options

removeshippingsteps

 

bilingshipping

Delete all product from cart

Delete all product from cart

Redirecting www to non-www Using .htaccess

non-www Using .htaccess

Magento product details store tablename

Product name store in : catalog_product_entity_varchar
product id store in : catalog_product_entity_int
product price store in : catalog_product_entity_decimal

How to Call Newsletter in footer in Magento

footer in Magento