The following article will outline the steps and commands involved to successfully transfer Magento from one server to another.
1. Make a MySQL dump file of the database by phpMyAdmin and save as .sql file
2. Open .sql file, replace all related data before being imported
3. Once you have adjusted the options above you should restore the database at the new location.
A good practice is to add several options in the MySQL backup file prior to uploading it. The following should be added in the beginning of the SQL file:
SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;
SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;
SET NAMES utf8;
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, …

If you ant to have it so that it only shows quantity on the product page on items that are currently on sale,  use the following. There will also be an alert for customers when there is only 1 remaining in stock. Then use the following code:
<?php
$_finalPrice = $this->helper(‘tax’)->getPrice($_product, $_product->getFinalPrice());
$_regularPrice = $this->helper(‘tax’)->getPrice($_product, $_product->getPrice());
if ($_regularPrice != $_finalPrice):
$sku = nl2br($_product->getSku());
$to = $_product->getResource()->formatDate(time());
$from = $_product->getResource()->formatDate(time() - 60 * 60 * 24 * 1);
$_productCollection = Mage::getResourceModel(‘reports/product_collection’)
->addOrderedQty($from, $to, true)
->addAttributeToFilter(‘sku’, $sku)
->setOrder(‘ordered_qty’, ’desc’)
->getFirstItem();
$product = $_productCollection;
echo ’Already Bought Today ’.(int)$product->ordered_qty;
endif;
?>
<?php if ((int) Mage::getModel(‘cataloginventory/stock_item’)->loadByProduct($_product)->getQty()==1): ?>
<p style=”color:#990000; padding:5px 0; text-align:right;”><strong>ONLY 1 LEFT IN STOCK!</strong></p>
<?php endif; ?>
Or if you want to show stock sold on the product page for the entire duration the product has been active, use the following:
<?php
$sku = nl2br($_product->getSku());
$_productCollection = Mage::getResourceModel(‘reports/product_collection’)
->addOrderedQty()
->addAttributeToFilter(‘sku’, $sku)
->setOrder(‘ordered_qty’, ’desc’)
->getFirstItem();
$product = $_productCollection;
echo ’Already Bought ’.(int)$product->ordered_qty;
?>
and finally if you want to just on the page how many have been sold of product for today, use the …

So something that isn’t included on the frontend of Magento. You Saved xx%. So, here’s a little something you can copy and paste into your price.phtml
<?php
$_finalPrice = $this->helper(‘tax’)->getPrice($_product, $_product->getFinalPrice());
$_regularPrice = $this->helper(‘tax’)->getPrice($_product, $_product->getPrice());
if ($_regularPrice != $_finalPrice):
$getpercentage = number_format($_finalPrice / $_regularPrice * 100, 2);
$finalpercentage = 100 - $getpercentage;
echo ’<div class”savingbox”>YOU SAVE ’.number_format($finalpercentage,0).’% </div>’ ;
endif;
?>

By default, the currency selector is displayed in the left sidebar. Here, I will show you how you can show it in header just below the language selector.
<?php if($this->getCurrencyCount()>1): ?>
<div class=”box language-switcher” style=”margin-left:15px”>
<label for=”select-language”>Your Currency: </label>
<select name=”currency” onchange=”changeCurrency(this)”>
<?php foreach ($this->getCurrencies() as $_code => $_name): ?>
<option value=”<?php echo $_code ?>”<?php if($_code==$this->getCurrentCurrencyCode()): ?> selected=”selected”<?php endif; ?>>
<?php echo $_name ?> – <?php echo $_code ?>
</option>
<?php endforeach; ?>
</select>
</div>
<script type=”text/javascript”>
//<![CDATA[
function changeCurrency(sObject){
if(sObject.value){
setLocation('<?php echo $this->helper('directory/url')->getSwitchCurrencyUrl() ?>currency/'+sObject.value);
}
//]]>
</script>
<?php endif; ?>
Add currency_top block after store_language block inside header block of page.xml present around line #66 :-
<block type =”page/html_header” name=”header” as=”header”>
<block type=”page/template_links” name=”top.links” as=”topLinks”/>
<block …

Spam reports get 4 times priority in the spam queue at Google.
Google knows there has been more web spam in the search results and it is due to moving web spam resources to other projects. Those resources are coming back and Google will be working on patching up that issue.
Google reduced the number of hacked sites showing up in Google’s search results by 90%
Google will soon be offering specific notifications via Webmaster Tools informing webmasters of spam on their site. Specifically, Google will warn of doorway pages, parked domains and …