To Be implement in magento?

http://www.rapidcommerce.eu/blog/2012/05/magento-product-list-ajax-scroll/
http://bluezeal.in/ccavenue4magento/ccavenue-payment-module-for-magento
http://keertikiran.blogspot.in/2012/05/display-date-in-specified-format-in.html
product question extension....
http://www.magentocommerce.com/magento-connect/cueblocks-zoom.html
Mturbo cache management
http://www.tonecruisers.com/OurMusic.html (to create playlist)
http://www.magentocommerce.com/magento-connect/cueblocks-zoom.html
http://www.magentocommerce.com/magento-connect/gala-color-swatches-free-9787.html
http://www.uniformadvantage.com/

magento base url without index.php (relative url)?

<?php echo Mage::getStoreConfig('web/unsecure/base_url');?>

How to play youtube videos in magento website?

Youtube Videos

social networking links to count likes

<div class="social_share">
    <ul>
        <li>
            <iframe src="//www.facebook.com/plugins/like.php?href=<?php echo $strEncodedProductUrl; ?>&amp;send=false&amp;layout=button_count&amp;width=100&amp;show_faces=false&amp;action=like&amp;colorscheme=light&amp;font&amp;height=21" scrolling="no" frameborder="0" style="border:none; overflow:hidden; width:100px; height:21px;" allowTransparency="true"></iframe>
        </li>
        <li>
            <a href="https://twitter.com/share" class="twitter-share-button" data-url="<?php echo $strProductUrl ?>">Tweet</a>
    <script>!function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id=id;js.src="//platform.twitter.com/widgets.js";fjs.parentNode.insertBefore(js,fjs);}}(document,"script","twitter-wjs");</script>
        </li>
        <li>
            <!-- Place this tag in your head or just before your close body tag. -->
            <script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script>
            <!-- Place this tag where you want the +1 button to render. -->
            <div class="g-plusone" data-href="<?php echo $strProductUrl ?>"></div>
        </li>
        <li>
            <a href="http://pinterest.com/pin/create/button/?url=<?php echo $strEncodedProductUrl; ?>&media=<?php echo $strProductImage; ?>&description=<?php echo $strProductDescription; ?>" class="pin-it-button" count-layout="horizontal">
                <img border="0" src="//assets.pinterest.com/images/PinExt.png" title="Pin It" />
            </a>
        </li>
    </ul>
</div>

How to get Subtotal of current cart in magento?

$objCheckout = $this->getLayout()->createBlock('checkout/cart_sidebar');
        $intTotal = $objCheckout->getSubtotal();

How to implement ajax in magento? (frontend side)

Magento Ajax

How to implement module creater in magento?

Module Creator

How to get attribute details from attribute in magento?

$intAttributeId = '672';
$intAttributeLabel = 'color';
$objAttributeInfo = Mage::getModel('eav/entity_attribute')->load($intAttributeId);           
$strFrontendLabel = $objAttributeInfo->getFrontendLabel();

How to display mysql query in magento?

$objCategoryProducts = Mage::getModel('catalog/category')->load($intCategoryId)->getProductCollection()->addAttributeToFilter(array(array('attribute' => 'product_status','eq' => '126'),array('attribute' => 'product_stock_status','eq' => '486')))->setPageSize(1);

//echo $objCategoryProducts->printLogQuery(true);die;

in_array example

$arrDefaultArray = Array ( [0] => 64 [1] => 66 [2] => 62 [3] => 61 [4] => 60 )
$intProductCategoryId = 66;
if(in_array($intProductCategoryId,$arrDefaultArray))
{}

How to get prarent category id from current category in magento?

$objParentCat = 20;
$objCurrCat = Mage::getModel('catalog/category')->load($objParentCat->getParentId());

How to fetch all categories of product in magento (on product details page)?

$product_model = Mage::getModel('catalog/product');
    $_product = $product_model->load($intCurrentProductId);
    $arrAllCurrentProductCategories = $product_model->getCategoryIds($_product);

How to fetch all root categories and its subcategories in magento?

Fetch Records Magento

Some Useful links

torrent like for download    http://torrentz.eu/

resume format    http://speckyboy.com/2010/05/05/10-free-professional-html-and-css-templates/

for upload n number of files    http://www.mediafire.com/myfiles.php?r=hjyye

torrent like for downloads    http://www.picktorrent.com/

rajesh blog    http://linuxopensourceindia.blogspot.com/

magento extension link    http://www.magentocommerce.com/magento-connect/

vizualize me resume update site    http://vizualize.me/

online recharge    http://www.paytm.com/

for buying domain    http://www.godaddy.com/

jobs website    http://www.jobrapido.co.in/

online shopping link    http://www.homeshop18.com/

xml and rss feed links    http://www.w3schools.com/php/php_ajax_rss_reader.asp

for good sms    http://www.feelings2share.com/

links for download serial keys    http://www.serials.ws/index.php

light box important link    http://orangoo.com/labs/GreyBox/

javascript key event code link    http://www.webonweboff.com/tips/js/event_key_codes.aspx

trace mobile number (check mobile number is of which state and city)    http://trace.bharatiyamobile.com/

websites ratings    http://www.seomoz.org/web2.0

website for download document    http://www.docstoc.com/

mysql cookbook    http://www.freeopenbook.com/mysqlcookbook/mysqlckbk-chp-5.html

calculate internet speed    http://pcnineoneone.com/speedtest.php

sms sending site with no site name come on footer    http://www.site2sms.com/user/send_sms_next.asp

online tshirt purchase    http://www.tshirts.in/

pick torrent    http://www.picktorrent.com/

torrent links for download    http://www.torrentportal.com/

torrent links for download    http://extratorrent.com/

jquery slider carhousies    http://www.designdim.com/2011/01/19-outstanding-jquery-sliders-and-carousels/

http://thomaslanciaux.pro/jquery/jquery_carousel.htm

How to create custom themes in magento ?

Z:\p\app\design\frontend\base\default --- copy all
Z:\angelsincrib\app\design\frontend\default\angelsincrib --- paste to here
Z:\angelsincrib\skin\frontend\default\ create folder ---- angelsincrib
Z:\angelsincrib\skin\frontend\base\default --- copy all
Z:\angelsincrib\skin\frontend\default\angelsincrib ----- paste to all
Z:\angelsincrib\skin\frontend\default\default ---- copy all
Z:\angelsincrib\skin\frontend\default\angelsincrib --- paste to here and overwrite all
Goto admin System->configuration->leftside Design -> themes (translations->angelsincrib, Templates->angelsincrib, Skin (Images / CSS) ->angelsincrib,Layout->angelsincrib)
Now System -> Cache management -> Select All -> Actions=disable->Submit
Now System -> Index Management -> Select All -> Actions=Reindex Data->Submit

How to get number of items in cart in magento?

Mage::helper('checkout/cart')->getSummaryCount()

How to get price symbol of current store in magento?

Mage::app()->getLocale()->currency(Mage::app()->getStore()->getCurrentCurrencyCode())->getSymbol();
Mage::helper('checkout')->formatPrice($this->getSubtotal())

How to redirect in magento?

Mage::app()->getFrontController()->getResponse()->setRedirect($strUrl);

How to get all subcategory details of current category in magento?

function fnGetSubCategories($intParentCategoryId) { $objData = Mage::getSingleton('core/resource')->getConnection('core_write'); $sqlQuery = " SELECT distinct(cce.entity_id) FROM catalog_category_entity cce INNER JOIN catalog_category_entity_int ccei ON cce.entity_id = ccei.entity_id WHERE cce.parent_id = '".$intParentCategoryId."' AND ccei.attribute_id = 119 AND ccei.value = 1 ORDER BY cce.position ASC"; $arrSubCategories = array(); $resSubcategories = $objData->query($sqlQuery); $arrAllSubcategories = $resSubcategories->fetchAll(PDO::FETCH_ASSOC); if(count($arrAllSubcategories)) { foreach($arrAllSubcategories as $aSubCat) { $arrSubCategories[] = $aSubCat['entity_id']; } } return $arrSubCategories;
}

Magento Pagination Without Toolbar?

Add the below code to your end of "template/catalog/product/list.phtml" file
$toolbar = $this->getToolbarBlock();
$toolbar->setCollection($_productCollection);
if($toolbar->getCollection()->getSize() > 0):
echo $toolbar->getPagerHtml(); //Pager
echo $toolbar-> __('Items %s to %s of %s total', $toolbar->getFirstNum(), $toolbar->getLastNum(),
$toolbar ->getTotalNum());
endif;

How to show total shopping cart price in Header Magento?

$count = $this->helper('checkout/cart')->getSummaryCount();  //get total items in cart
$total = $this->helper('checkout/cart')->getQuote()->getGrandTotal(); //get total price
if($count==0)
{
echo $this->__('Items: %s',$count);
}
if($count==1)
{
echo $this->__(' Item: %s',$count);
}
if($count>1)
{
echo $this->__(' Items: %s',$count);
}
echo $this->__(' Total: %s', $this->helper('core')->formatPrice($total, false));

Magento Pagination Without Toolbar?

Add the below code to your end of "template/catalog/product/list.phtml" file
$toolbar = $this->getToolbarBlock();
$toolbar->setCollection($_productCollection);
if($toolbar->getCollection()->getSize() > 0):
echo $toolbar->getPagerHtml(); //Pager
echo $toolbar-> __('Items %s to %s of %s total', $toolbar->getFirstNum(), $toolbar->getLastNum(),
$toolbar ->getTotalNum());
endif;

How to show total shopping cart price in Header Magento?

$count = $this->helper('checkout/cart')->getSummaryCount();  //get total items in cart
$total = $this->helper('checkout/cart')->getQuote()->getGrandTotal(); //get total price
if($count==0)
{
echo $this->__('Items: %s',$count);
}
if($count==1)
{
echo $this->__(' Item: %s',$count);
}
if($count>1)
{
echo $this->__(' Items: %s',$count);
}
echo $this->__(' Total: %s', $this->helper('core')->formatPrice($total, false));

How to remove index.php from URL magento?

If you are using Magento and in your shop URL, if you see “index.php” and wanted to remove it then here is the solution.
- Login to Magento admin panel
- Go to System -> Configuration -> Web -> Search Engines Optimization -> Use Web Server Rewrites
- Select ‘Yes’ from the selection list and Save.
- Goto your site root folder and you can find the .htaccess file. Just edit that. Open it on a text editor and find this line, #Rewrite Base /magento/ . Just replace it with Rewrite Base / .
- Then goto your Cache Management page ( System > Cache Management) and refresh your Cache and also refresh the Web Redirects.
And, you are done. Now, index.php is gone from your Magento shop URL.

How to send email easily in magento?

public function sendEmail()
{
$fromEmail = "from@example.com"; // sender email address
$fromName = "John Doe"; // sender name
$toEmail = "to@example.com"; // recipient email address
$toName = "Mark Doe"; // recipient name
$body = "This is Test Email!"; // body text
$subject = "Test Subject"; // subject text
$mail = new Zend_Mail();
$mail->setBodyText($body);
$mail->setFrom($fromEmail, $fromName);
$mail->addTo($toEmail, $toName);
$mail->setSubject($subject);
try
{
$mail->send();
}
catch(Exception $ex)
{
// If you are using this code in your custom module use 'yourmodule' name.
// If not, you may keep 'customer' instead of 'yourmodule'.
Mage::getSingleton('core/session')
->addError(Mage::helper('yourmodule')
->__('Unable to send email.'));
}
}

Get Customer Shipping/Billing Address

$customerAddressId = Mage::getSingleton('customer/session') ->getCustomer() ->getDefaultShipping();
if ($customerAddressId)
{
$address = Mage::getModel('customer/address')->load($customerAddressId);
}
else
{
$address = Mage::getSingleton('checkout/session')->getQuote()->getShippingAddress();
}

How to speed up Magento?

Many Magento users faces the site loading problem. If we have larger amount of data the magento site becomes down. The recommended way to speed up Magento's performance is to enable its Compilation function. The performance increase is between 25%-50% on page loads.
You can enable Magento Compilation from your Magento admin panel > System > Tools > Compilation.

How to show only first name in magento welcome message?

$customer = Mage::getSingleton('customer/session')->getCustomer()->getData();
if(Mage::getSingleton('customer/session')->isLoggedIn())
{
echo $this->__('Welcome, %s!', $customer['firstname']);
}
else
{
echo $this->__('Welcome Guest');
}

How to get Most Viewed products in Magento?

$productCount = 5;
$storeId    = Mage::app()->getStore()->getId();
$products = Mage::getResourceModel('reports/product_collection') ->addAttributeToSelect('*') ->setStoreId($storeId) ->addStoreFilter($storeId) ->addViewsCount() ->setPageSize($productCount);
Mage::getSingleton('catalog/product_status') ->addVisibleFilterToCollection($products);
Mage::getSingleton('catalog/product_visibility') ->addVisibleInCatalogFilterToCollection($products);
print_r($products);

How to interchange the left and right column sidebar in magento?

images/media/col_left_callout.jpg
Our customer service is available 24/7. Call us at (555) 555-0123.
checkout/cart

how to get all attribute details

$objEavAttribute = Mage::getModel('catalog/product') -> getResource() -> getAttribute('manufacturer');
if($objEavAttribute->getFrontendInput() == 'select' || $objEavAttribute->getFrontendInput() == 'multiselect' || $objEavAttribute->getFrontendInput() == 'boolean')
{
echo $_product->getAttributeText($value);
}
else
{
echo $_product->getData($value);
}

Custom javascript client side validation in magento on individual page

<script type="text/javascript" language="javascript">
var dataForm = new VarienForm('contactForm');
Validation.addAllThese(
[
['validate-number-tel', '<?php echo $this->__('Please Enter Valid telephone number and pincode') ?>', function(v) {
if(document.getElementById("telephone1").value == "" || document.getElementById("telephone2").value == "")
{
return false;
}
else
{
return true;
}
}],
['validate-captcha', 'Your Captcha Entry Mismatch', function(v) {
if(document.getElementById("hdnRandomString1").value != document.getElementById("recaptcha_response_field1").value)
{
return false;
}
else
{
return true;
}
}]
]
);
</script>
<script type="text/javascript">
//<![CDATA[
var contactForm = new VarienForm('contactForm', true);
//]]>
</script>
<script type="text/javascript" language="javascript">
function validateNumberKey(event) {
var key = window.event ? event.keyCode : event.which;
if (event.keyCode == 8 || event.keyCode == 46
|| event.keyCode == 37 || event.keyCode == 39 || event.keyCode == 9) {
return true;
}
else if ( key < 48 || key > 57 ) {
return false;
}
else return true;
}
</script>

How to get special price end date in magento?

$this->formatDate($product->getSpecialToDate())

Default toggle text in input text box magento

<script language="javascript">
var comment = document.getElementById('comment');
comment.onfocus = hideText;
comment.onblur  = showText;
function hideText()
{
if(this.value == this.defaultValue){
this.value = '';
this.style.color = '#666666';
}
}
function showText()
{
if(this.value == ''){
this.value = this.defaultValue;
this.style.color = '#cccccc';
}
}
</script>

How to remove right column sidebar from product view page in Magento?

<catalog_product_view translate="label">
  <label>Catalog Product View (Any)</label>
      <reference name="root">
        <action method="setTemplate"><template>page/2columns-right.phtml</template></action>
      </reference>
</catalog_product_view>

Move or Remove Callouts on the left or right sidebar in magento

images/media/col_left_callout.jpg
Our customer service is available 24/7. Call us at (555) 555-0123.
checkout/cart

Move or Remove Callouts on the left or right sidebar in magento

<reference name="left">
<block name="left.permanent.callout" template="callouts/left_col.phtml" type="core/template">
<action method="setImgSrc"><src>images/media/col_left_callout.jpg</src></action>
<action method="setImgAlt" module="catalog" translate="alt"><alt>Our customer service is available 24/7. Call us at (555) 555-0123.</alt></action>
<action method="setLinkUrl"><url>checkout/cart</url></action>
</block>
</reference>

Add a custom "add to cart" button on Magento CMS pages

<button onclick="location.href ='{{config path="web/unsecure/base_url"}}/checkout/cart/add?product=1&qty=1′">Buy It Now</button>

How to show total shopping cart price in Header Magento?

$count = $this->helper('checkout/cart')->getSummaryCount();  //get total items in cart
$total = $this->helper('checkout/cart')->getQuote()->getGrandTotal(); //get total price
if($count==0)
{
echo $this->__('Items: %s',$count);
}
if($count==1)
{
echo $this->__(' Item: %s',$count);
}
if($count>1)
{
echo $this->__(' Items: %s',$count);
}
echo $this->__(' Total: %s', $this->helper('core')->formatPrice($total, false));

Custom 'Sort by' drop-down menu options Lowest price, Higest price, Name A-Z, Name Z-A, Newest to Oldest & Oldest to Newest in magento

View following url
http://magento-talks.blogspot.in/2011/08/custom-sort-by-drop-down-menu-options.html

How to show total shopping cart price in Header Magento?

$count = $this->helper('checkout/cart')->getSummaryCount();  //get total items in cart
$total = $this->helper('checkout/cart')->getQuote()->getGrandTotal(); //get total price
if($count==0)
{
echo $this->__('Items: %s',$count);
}
if($count==1)
{
echo $this->__(' Item: %s',$count);
}
if($count>1)
{
echo $this->__(' Items: %s',$count);
}
echo $this->__(' Total: %s', $this->helper('core')->formatPrice($total, false));

How to add Quantity Box in the Category Products Listing Page in magento?

http://magento-talks.blogspot.in/2011/08/how-to-add-quantity-box-in-category.html

Delete test products, categories, customers, products reviews and ratings in magento

***************************************
SALES RELATED TABLES
***************************************
TRUNCATE `sales_flat_creditmemo`;
TRUNCATE `sales_flat_creditmemo_comment`;
TRUNCATE `sales_flat_creditmemo_grid`;
TRUNCATE `sales_flat_creditmemo_item`;
TRUNCATE `sales_flat_invoice`;
TRUNCATE `sales_flat_invoice_comment`;
TRUNCATE `sales_flat_invoice_grid`;
TRUNCATE `sales_flat_invoice_item`;
TRUNCATE `sales_flat_order`;
TRUNCATE `sales_flat_order_address`;
TRUNCATE `sales_flat_order_grid`;
TRUNCATE `sales_flat_order_item`;
TRUNCATE `sales_flat_order_payment`;
TRUNCATE `sales_flat_order_status_history`;
TRUNCATE `sales_flat_quote`;
TRUNCATE `sales_flat_quote_address`;
TRUNCATE `sales_flat_quote_address_item`;
TRUNCATE `sales_flat_quote_item`;
TRUNCATE `sales_flat_quote_item_option`;
TRUNCATE `sales_flat_quote_payment`;
TRUNCATE `sales_flat_quote_shipping_rate`;
TRUNCATE `sales_flat_shipment`;
TRUNCATE `sales_flat_shipment_comment`;
TRUNCATE `sales_flat_shipment_grid`;
TRUNCATE `sales_flat_shipment_item`;
TRUNCATE `sales_flat_shipment_track`;
TRUNCATE `sales_invoiced_aggregated`;            # ??
TRUNCATE `sales_invoiced_aggregated_order`;        # ??
TRUNCATE `log_quote`;

ALTER TABLE `sales_flat_creditmemo_comment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_creditmemo_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_creditmemo_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice_comment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_invoice_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_address` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_payment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_status_history` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_payment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_shipping_rate` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_comment` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_grid` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_shipment_track` AUTO_INCREMENT=1;
ALTER TABLE `sales_invoiced_aggregated` AUTO_INCREMENT=1;
ALTER TABLE `sales_invoiced_aggregated_order` AUTO_INCREMENT=1;
ALTER TABLE `log_quote` AUTO_INCREMENT=1;

#########################################
# DOWNLOADABLE PURCHASED
#########################################
TRUNCATE `downloadable_link_purchased`;
TRUNCATE `downloadable_link_purchased_item`;

ALTER TABLE `downloadable_link_purchased` AUTO_INCREMENT=1;
ALTER TABLE `downloadable_link_purchased_item` AUTO_INCREMENT=1;

#########################################
# RESET ID COUNTERS
#########################################
TRUNCATE `eav_entity_store`;
ALTER TABLE  `eav_entity_store` AUTO_INCREMENT=1;

##############################
# CUSTOMER RELATED TABLES
##############################
TRUNCATE `customer_address_entity`;
TRUNCATE `customer_address_entity_datetime`;
TRUNCATE `customer_address_entity_decimal`;
TRUNCATE `customer_address_entity_int`;
TRUNCATE `customer_address_entity_text`;
TRUNCATE `customer_address_entity_varchar`;
TRUNCATE `customer_entity`;
TRUNCATE `customer_entity_datetime`;
TRUNCATE `customer_entity_decimal`;
TRUNCATE `customer_entity_int`;
TRUNCATE `customer_entity_text`;
TRUNCATE `customer_entity_varchar`;
TRUNCATE `tag`;
TRUNCATE `tag_relation`;
TRUNCATE `tag_summary`;
TRUNCATE `tag_properties`;            ## CHECK ME
TRUNCATE `wishlist`;
TRUNCATE `log_customer`;

ALTER TABLE `customer_address_entity` AUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_datetime` AUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_decimal` AUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_int` AUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_text` AUTO_INCREMENT=1;
ALTER TABLE `customer_address_entity_varchar` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity_datetime` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity_decimal` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity_int` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity_text` AUTO_INCREMENT=1;
ALTER TABLE `customer_entity_varchar` AUTO_INCREMENT=1;
ALTER TABLE `tag` AUTO_INCREMENT=1;
ALTER TABLE `tag_relation` AUTO_INCREMENT=1;
ALTER TABLE `tag_summary` AUTO_INCREMENT=1;
ALTER TABLE `tag_properties` AUTO_INCREMENT=1;
ALTER TABLE `wishlist` AUTO_INCREMENT=1;
ALTER TABLE `log_customer` AUTO_INCREMENT=1;

##############################
# ADDITIONAL LOGS
##############################
TRUNCATE `log_url`;
TRUNCATE `log_url_info`;
TRUNCATE `log_visitor`;
TRUNCATE `log_visitor_info`;
TRUNCATE `report_event`;
TRUNCATE `report_viewed_product_index`;
TRUNCATE `sendfriend_log`;
### ??? TRUNCATE `log_summary`

ALTER TABLE `log_url` AUTO_INCREMENT=1;
ALTER TABLE `log_url_info` AUTO_INCREMENT=1;
ALTER TABLE `log_visitor` AUTO_INCREMENT=1;
ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1;
ALTER TABLE `report_event` AUTO_INCREMENT=1;
ALTER TABLE `report_viewed_product_index` AUTO_INCREMENT=1;
ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1;
### ??? ALTER TABLE `log_summary` AUTO_INCREMENT=1;

SET FOREIGN_KEY_CHECKS=1;

How to delete test orders from database in magento?

SET FOREIGN_KEY_CHECKS=0;
TRUNCATE `sales_order`;
TRUNCATE `sales_order_datetime`;
TRUNCATE `sales_order_decimal`;
TRUNCATE `sales_order_entity`;
TRUNCATE `sales_order_entity_datetime`;
TRUNCATE `sales_order_entity_decimal`;
TRUNCATE `sales_order_entity_int`;
TRUNCATE `sales_order_entity_text`;
TRUNCATE `sales_order_entity_varchar`;
TRUNCATE `sales_order_int`;
TRUNCATE `sales_order_text`;
TRUNCATE `sales_order_varchar`;
TRUNCATE `sales_flat_quote`;
TRUNCATE `sales_flat_quote_address`;
TRUNCATE `sales_flat_quote_address_item`;
TRUNCATE `sales_flat_quote_item`;
TRUNCATE `sales_flat_quote_item_option`;
TRUNCATE `sales_flat_order_item`;
TRUNCATE `sendfriend_log`;
TRUNCATE `tag`;
TRUNCATE `tag_relation`;
TRUNCATE `tag_summary`;
TRUNCATE `wishlist`;
TRUNCATE `log_quote`;
TRUNCATE `report_event`;
ALTER TABLE `sales_order` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_datetime` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_decimal` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_datetime` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_decimal` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_int` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_text` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_entity_varchar` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_int` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_text` AUTO_INCREMENT=1;
ALTER TABLE `sales_order_varchar` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1;
ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1;
ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1;
ALTER TABLE `tag` AUTO_INCREMENT=1;
ALTER TABLE `tag_relation` AUTO_INCREMENT=1;
ALTER TABLE `tag_summary` AUTO_INCREMENT=1;
ALTER TABLE `wishlist` AUTO_INCREMENT=1;
ALTER TABLE `log_quote` AUTO_INCREMENT=1;
ALTER TABLE `report_event` AUTO_INCREMENT=1;

How to display price with currency and format?

Mage::helper('core')->currency($this->getProduct()->getFinalPrice())

How to define image on backend editor?

img src="{{skin url='images/footer-img1.png}}" alt=""

How to define block on cms pages on admin

{{block type="cms/block" block_id="my_block" template="cms/content-right "}}

How to define homepagecontent from backend page in magento?

Magento Home Page Define

List of basic magento extensions

Magent Version > 1.5
1. Easy Tabs: http://connect20.magentocommerce.com/community/magento_easy_tabs
2. CueBlock Zoom: http://connect20.magentocommerce.com/community/CueBlocks_Zoom
3. Vert Navigation: http://connect20.magentocommerce.com/community/RicoNeitzel_VertNav
4. Tell A Friend: http://connect20.magentocommerce.com/community/Mp_Tell_A_Friend
5.Multiple Table Reates
http://connect20.magentocommerce.com/community/Pw_Multipletablerates
6. Magento easy lightbox : http://connect20.magentocommerce.com/community/magento_easy_lightbox
FACEBOOK CONNECT:http://inchoo.net/ecommerce/magento/facebook-connect-magento-extension/
http://www.magentocommerce.com/magento-connect/eitai2001/extension/1468/order-status
http://www.magentocommerce.com/magento-connect/FOOMAN/extension/957/fooman_sameorderinvoicenumber
http://www.magentocommerce.com/magento-connect/i960/extension/1477/admin-custom-shipping-rate
http://www.magentocommerce.com/magento-connect/centerax/extension/2927/automatic-db-backups
http://www.magentocommerce.com/magento-connect/plieninger/extension/2586/editable-order
http://www.magentocommerce.com/magento-connect/MageParts/extension/1621/commercial-extension-manager
http://www.magentocommerce.com/magento-connect/bleulliette/extension/7619/bl_customgrid
http://www.magentocommerce.com/magento-connect/ifuel/extension/7302/seevolution_connector
http://www.google.com/support/merchants/bin/answer.py?answer=188494#GB

Change Magento Admin URL

All you need is to properly set your custom admin url in the config file /app/etc/local.xml. In this file change this:

to this:

contact us email settings on magento..

system/configuration/contacts/ --------- contactus and email options
system/configuration/system/ ----------- mail sending settings
app/code/core/mage/core/model/email/template.php

public function getMail() { if (is_null($this->_mail)) { $my_smtp_host = Mage::getStoreConfig('system/smtp/host'); $my_smtp_port = Mage::getStoreConfig('system/smtp/port'); $config = array( 'port' => $my_smtp_port, //optional - default 25 'auth' => 'login', 'username' => 'test@sankhalainfo.co.in', 'password' => 'info#1234' ); $transport = new Zend_Mail_Transport_Smtp($my_smtp_host, $config); Zend_Mail::setDefaultTransport($transport); /*End Hack*/ $this->_mail = new Zend_Mail('utf-8'); } return $this->_mail; }

how to display all countries in magento ?

$countryList = Mage::getResourceModel('directory/country_collection')->loadData()->toOptionArray(false); print_r( $countryList);

how to fetch all states of country in magento?

$countryList = Mage::getResourceModel('directory/country_collection') ->loadData() ->toOptionArray(false);

$regionCollection = Mage::getModel('directory/region') ->getResourceCollection() ->addCountryFilter('IN')->load();

how to view recent products in magento?

Magento Recent Product

how to check home page in magento?

if(Mage::getSingleton('cms/page')->getIdentifier() == 'home' &&Mage::app()->getFrontController()->getRequest()->getRouteName() == 'cms' )

how to view all brands in magento containing products?

View all brands in magento

How to view recent sold product of current category in magento?

load(3);

$_productCollection = $cats->getProductCollection() ->addAttributeToFilter('visibility',4);

$intNumRecord = Mage::getStoreConfig('banner/carousel_configuration/bestseller_number_product');

$_productCollection = $_productCollection ->setPageSize($intNumRecord);

if($_productCollection->count()) { ?>

load($_products->getId());?>

"> getName()) > 20)
{
echo substr($_product->getName(),0,17)."...";
}
else
{
echo $_product->getName();
} ?>

how to view popular products in magento? or maximum sold products in store

getStore()->getStoreId(); $this->_productCollection = Mage::getResourceModel('reports/product_collection');
if ($this->getTimeLimit())
{
$product = Mage::getModel('catalog/product');
$todayDate = $product->getResource()->formatDate(time());
$startDate = $product->getResource() ->formatDate(time() - 60 * 60 * 24 * $this ->getTimeLimit());
$this->_productCollection = $this->_productCollection ->addOrderedQty($startDate, $todayDate);
}
else
{
$this->_productCollection = $this->_productCollection ->addOrderedQty();
}
$intNumRecord = Mage::getStoreConfig('banner/carousel_configuration/bestseller_number_product');
$this->_productCollection = $this->_productCollection ->addAttributeToSelect('*') ->setStoreId($storeId) ->addStoreFilter($storeId) ->setOrder('ordered_qty', 'desc') ->setPageSize($intNumRecord);
$_productCollection = $this->_productCollection ->setPageSize($intNumRecord);
if($_productCollection->count())
{ ?>
load($_products->getId());?>getShortDescription();if(strlen($strproductdescription)>82) $strproductdescription = trim(substr($strproductdescription,0,81)."...");$strProductName = $_product->getName(); ?> 22){$strProductName =  substr($strProductName,0,21)."...";}?>
<a href="getProductUrl() ?>" title="stripTags($_product->getName(), null, true) ?>">

<a href="getUrl('popular-products');?>">__('More...');?>

How to display add to cart url on any page on magento?

<?php if(isSaleable()): ?>

 <button type="button" title="__(‘Add to Cart’) ?>” class=”button btn-cart” onclick=”setLocation(‘getLayout()->createBlock(‘catalog/product_list’)->getAddToCartUrl($objProduct) ?>’)”>__(‘Add to Cart’) ?>

__(‘Out of stock’) ?>

How to display total reviews of product in magento?

$intTotalReviewPerProduct = $objCategoryBanners->fnGetTotalProductReview($_product);

How to display image of current product on magento?

<a href="getProductUrl();?>">
<img src="helper('catalog/image')->init($objProduct, 'small_image')->resize(60,110); ?>" alt="getName();?>">

How to display total reviews of product in magento?

$intTotalReviewPerProduct = $objCategoryBanners->fnGetTotalProductReview($_product);

How to display average ratings of product in magento?

public function fnGetTotalProductReview($objCurrentProduct)
{
$objReview = Mage::getModel('review/review');
return $objReview ->getTotalReviews($objCurrentProduct->getId(),true);
}

$intTotalReviewPerProduct = fnGetTotalProductReview($_product);

if($intTotalReviewPerProduct > 0){echo $this ->getLayout() ->createBlock('catalog/product_list') ->getReviewsSummaryHtml($_product);
}

How to show all the manufactures or brand list in magento?

$product = Mage::getModel('catalog/product');
$attributes = Mage::getResourceModel('eav/entity_attribute_collection')
->setEntityTypeFilter($product->getResource()->getTypeId())
->addFieldToFilter('attribute_code', 'manufacturer');
$attribute = $attributes->getFirstItem()->setEntity($product->getResource());
$manufacturers = $attribute->getSource()->getAllOptions(false);

foreach ($manufacturers as $manufacturer)

{

echo Mage::getBaseUrl(); ?>catalogsearch/advanced/result/?manufacturer[]=$manufacturer['value']

echo Mage::getBaseUrl(); ?>catalogsearch/advanced/result/?manufacturer[]=$manufacturer['label']

}

How to get the customer login, logout, register and checkout url?

Mage::getUrl('customer/account/login'); //login url
Mage::getUrl('customer/account/logout'); //logout url
Mage::getUrl('customer/account'); //My Account url
Mage::getUrl('customer/account/create'); // Register url
Mage::getUrl('checkout/cart'); //Checkout url

How to show all the manufactures or brand list in magento?

$product = Mage::getModel('catalog/product');
$attributes = Mage::getResourceModel('eav/entity_attribute_collection')
->setEntityTypeFilter($product->getResource()->getTypeId())
->addFieldToFilter('attribute_code', 'manufacturer');
$attribute = $attributes->getFirstItem()->setEntity($product->getResource());
$manufacturers = $attribute->getSource()->getAllOptions(false);

foreach ($manufacturers as $manufacturer)

{

echo Mage::getBaseUrl(); ?>catalogsearch/advanced/result/?manufacturer[]=$manufacturer['value']

echo Mage::getBaseUrl(); ?>catalogsearch/advanced/result/?manufacturer[]=$manufacturer['label']

}

How to get the customer login, logout, register and checkout url?

Mage::getUrl('customer/account/login'); //login url
Mage::getUrl('customer/account/logout'); //logout url
Mage::getUrl('customer/account'); //My Account url
Mage::getUrl('customer/account/create'); // Register url
Mage::getUrl('checkout/cart'); //Checkout url

set or get magento session

//Setting session
Mage::getSingleton('core/session')->setMySessionVariable('value');
//Getting session
Mage::getSingleton('core/session')->getMyDesignProductVariable()
//Unset session
Mage::getSingleton('core/session')->setTestingMagento();

//(Use customer or core session in frontend. Use adminhtml session in the backend.)
Core Session:- Mage::getSingleton(‘core/session’)
Customer Session:- Mage::getSingleton(‘customer/session’)
Admin Session:- Mage::getSingleton(‘adminhtml/session’)

How to get cms content from cms id in magento?

$objCmsPage = Mage::getModel('cms/page')->getCollection()->addFieldToFilter('identifier','next-day');
foreach($objCmsPage as $objCmsPageContent)
{
break;
}
$objCmsHelper = Mage::helper('cms');
$objProcessor = $objCmsHelper->getPageTemplateProcessor();
echo $objProcessor->filter($objCmsPageContent->getContent());

How to get cms content from cms id in magento?

$objCmsPage = Mage::getModel('cms/page')->getCollection()->addFieldToFilter('identifier','next-day');
foreach($objCmsPage as $objCmsPageContent)
{
break;
}
$objCmsHelper = Mage::helper('cms');
$objProcessor = $objCmsHelper->getPageTemplateProcessor();
echo $objProcessor->filter($objCmsPageContent->getContent());

How To fetch all categories and subcategories in magento?

$_helper = Mage::helper(‘catalog/category’)
$_categories = $_helper->getStoreCategories()
$currentCategory = Mage::registry(‘current_category’)
if (count($_categories) > 0)
{
foreach($_categories as $_category)
{
echo $_category->getName()
$_category = Mage::getModel(‘catalog/category’)->load($_category->getId())
$_subcategories = $_category->getChildrenCategories()
if (count($_subcategories) > 0)
{
foreach($_subcategories as $_subcategory)
{
echo $_subcategory->getName()
}
}
}
}

How to define custom layout in magento like 1column,2-column right,3-columns

template/page/2columns-aboutus.phtml

-----------------------------------------------------------------------

layout/page.xml

-----------------------------------------------------------------------

find All Two-Column Layout Pages (Left Column) and place

-----------------------------------------------------------------------

<page_two_columns_aboutus translate="label">
<label>All Two-Column Layout Pages (About us Column)</label>
<reference name="root">
<action method="setTemplate"><template>page/2columns-aboutus.phtml</template></action>
<!-- Mark root page block that template is applied -->
<action method="setIsHandle"><applied>1</applied></action>
</reference>
</page_two_columns_aboutus>

-----------------------------------------------------------------------

now define global object in xml

app/code/local/companyname/modulename/etc/config.xml

<two_columns_aboutus module="page" translate="label">
<label>2 columns with About Us</label>
<template>page/2columns-aboutus.phtml</template>
<layout_handle>page_two_columns_aboutus</layout_handle>
</two_columns_aboutus>

Now go to admin login pages/ -----> 2 columns with About Us

How to define store path on backend side while create static block

{{store url='company-history'}}

How to get request on magento?

echo $this->getRequest()->getParams())

How to get cms page title in magento?

$pageTitle = Mage::getSingleton('cms/page')->getTitle();

How to get product details from product id in magento?

$model = Mage::getModel('catalog/product');
$_product = $model->load($productId);
echo $_product->getShortDescription();
echo $_product->getDescription();
echo $_product->getName();
echo $_product->getPrice();
echo $_product->getSpecialPrice();
echo $_product->getProductUrl();
echo $_product->getImageUrl();
echo $_product->getSmallImageUrl();
echo $_product->getThumbnailUrl();

How to get category details from category id on magento?

$category = Mage::getModel('catalog/category')->load($_category);
echo $category->getUrl();// category url
echo $category->getName();
echo $category->getImageUrl();
$categoryImage = $category->getImage();

Custom 'Sort by' drop-down menu options Lowest price, Higest price, Name A-Z, Name Z-A, Newest to Oldest & Oldest to Newest in magento

View following url

http://magento-talks.blogspot.in/2011/08/custom-sort-by-drop-down-menu-options.html

Magento all paths.

Mage::getBaseUrl() => Gets base url path e.g. http://my.website.com/

Mage::getBaseUrl(‘media’) => Gets MEDIA folder path e.g. http://my.website.com/media/

Mage::getBaseUrl(‘js’)                => Gets JS folder path e.g. http://my.website.com/js/

Mage::getBaseUrl(‘skin’)              => Gets SKIN folder path e.g. http://my.website.com/skin/

Mage::getBaseDir()             => Gives you your Magento installation folder / root folder e.g. /home/kalpesh/

Mage::getBaseDir(‘app’)             => Gives you your Magento’s APP directory file location e.g. /home/kalpesh/

Mage::getBaseDir(‘design’)            => Gives you your Magento’s DESIGN directory file location e.g. /home/kalpesh/wo

Mage::getBaseDir(‘media’) => Gives MEDIA directory file path

Mage::getBaseDir(‘code’) => Gives CODE directory file path

Mage::getBaseDir(‘lib’) => Gives LIB directory file path

Get Current URL – whole URL path
Mage::helper(‘core/url’)->getCurrentUrl()

How to change default image white space(background) on magento?

app/code/core/mage/catalog/model/Product/image.php

How to display product price with currency on magento?

$formattedPrice = Mage::helper('core')->currency($objProduct->getPrice(),true,false);

How to change default image white space(background) on magento?

app/code/core/mage/catalog/model/Product/image.php

How to display product price with currency on magento?

$formattedPrice = Mage::helper('core')->currency($objProduct->getPrice(),true,false);

How to get products available stock quantity in magento?

echo $qtyStock = (int) Mage::getModel('cataloginventory/stock_item') ->loadByProduct($_product) ->getQty();

How to display static block content on front side?

$this->getLayout()->createBlock('cms/block')->setBlockId('identifier')->toHtml()

How to check customer is login or not?

Mage::getSingleton('customer/session')->isLoggedIn());

How to Get current Url of the page in magento?

$this->helper('core/url')->getCurrentUrl();

How to display product with specific height and width in magento?

$productId = 1;
$product = Mage::getModel('catalog/product') ->load($productId);
$path = Mage::helper('catalog/image') ->init($product, 'image') ->resize(75, 75);

How to set number of columns on product listing page?

<?php $_columnCount = $this->getColumnCount(); ?>

              and replace it with:

<?php $_columnCount = 4; ?>

How to create module in magento?

app/etc/modules/Custom_Manufacturerlogo.xml

app/code/local/Custom/Manufacturerlogo/Block/Manufacturerlogo.php

app/code/local/Custom/Manufacturerlogo/controllers/IndexController.php

app/code/local/Custom/Manufacturerlogo/etc/config.xml

app/code/local/Custom/Manufacturerlogo/Model/Manufacturerlogo.php

app/code/local/Custom/Manufacturerlogo/Model/Mysql4/Manufacturerlogo.php

app/code/local/Custom/Manufacturerlogo/Model/Mysql4/Manufacturerlogo/Collection.php

app/code/local/Custom/Manufacturerlogo/Model/Status.php

app/code/local/Custom/Manufacturerlogo/sql/manufacturerlogo_setup/mysql4-install-0.1.0.php

app/design/frontend/default/default/layout/manufacturerlogo.xml

app/design/frontend/default/default/template/manufacturerlogo/manufacturerlogo.phtml

app/code/local/Custom/Manufacturerlogo/Block/Adminhtml/Manufacturerlogo.php

app/code/local/Custom/Manufacturerlogo/Block/Adminhtml/Manufacturerlogo/Edit.php

app/code/local/Custom/Manufacturerlogo/Block/Adminhtml/Manufacturerlogo/Grid.php

app/code/local/Custom/Manufacturerlogo/Block/Adminhtml/Manufacturerlogo/Edit/Form.php

app/code/local/Custom/Manufacturerlogo/Block/Adminhtml/Manufacturerlogo/Edit/Tabs.php

app/code/local/Custom/Manufacturerlogo/Block/Adminhtml/Manufacturerlogo/Edit/Tab/Form.php

app/code/local/Custom/Manufacturerlogo/controllers/Adminhtml/ManufacturerlogoController.php

app/code/local/Custom/Manufacturerlogo/Helper/Data.php

app/design/adminhtml/default/default/layout/manufacturerlogo.xml

Sample valid credit card numbers for testing

Here is a list of sample/dummy/test credit card numbers, which are safe to use when you test credit card functionality on a website or application that involves credit card transactions. These credit card numbers validate properly but they are not actually in use.

American Express:

378282246310005
3111111111111117
343434343434343
370000000000002
340000000000009
371449635398431
378734493671000

Visa:

4111111111111111
4007000000027
4222222222222
4012888888881881

MasterCard:

5105105105105100
5111111111111118
5454545454545454
5500000000000004
5555555555551111
5555555555554444

Discover:

6011111111111117
6011000000000004
6011000990139424
6011601160116611
6111111111111116

Hope this helps. Thanks.

Magento Blog Links

Magento Extension to be implement:
http://www.magentocommerce.com/magento-connect/cart-items-preview-on-mouseover.html

HTML5 Links:
http://www.htmldrive.net/

Core PHP Hints :
http://bmehla.wordpress.com/

Create loading image through script :

http://ajaxload.info/
http://picasion.com/upload-pictures/

Magento For Beginners:
http://dbhoopendra.blogspot.in/ 
http://xhtmlandcsshelp.blogspot.in/
http://spenserbaldwin.com/
http://subesh.com.np/category/google/google-maps/
http://sanjoyroy.wordpress.com/author/sanjoyroy
http://www.khemissi.com/2010/07/09/magento-diagram-website-store-store-view/

Magento Query Conditions :

http://fishpig.co.uk/blog/addattributetofilter-conditionals-in-magento.html

Jquery Slider Links

http://www.freshdesignweb.com/80jquery-image-slideshow-and-content-slider-tutorial.html

http://www.jquery4u.com/plugins/100-jquery-sliders-part1/#.T-safpHHFhp

Javascript Hints

http://www.javascriptkit.com/script/script2/3slide.shtml 

http://www.dhtmlgoodies.com/

http://jquerybyexample.blogspot.com/ 

Magento Blog Links

http://shamimcse05.wordpress.com/
http://dx3webs.com/front/category/magento/
http://www.pethemes.com/weblog/
http://www.blog.magepsycho.com/
http://www.inacode.com/
http://www.developersupports.com/category/2/magento/page/3/
http://www.excellencemagentoblog.com/magento-create-custom-shipping-method
http://sapnandu-magento.blogspot.in/search?updated-max=2011-09-28T22:23:00-07:00&max-results=7&start=21&by-date=false
http://developer.practicalecommerce.com/topics/33-Code
http://blog.decryptweb.com/

http://phpmysqlscript.wordpress.com

http://www.fontis.com.au/blog/magento/

http://ommune.com/adding-new-currency-symbol-of-indian-rupee-inr-in-magento/

http://magentosnippet.blogspot.in/

http://magento-talks.blogspot.in/2011_09_01_archive.html

http://xhtmlandcsshelp.blogspot.in/2011/02/absolute-path-of-base-directory-in.html

http://magentocookbook.wordpress.com/category/magento-coding/

http://www.designer-daily.com/magento-tips-17085

http://www.learnmagento.org/page/4/

http://magebase.com/

http://www.magthemes.com/magento-blog/

http://amilan.wordpress.com/2008/05/

http://www.catgento.com/

http://spenserbaldwin.com/2010/03

http://magentoexpert.blogspot.in/2010/02/restrict-access-to-magento-during.html

http://keertikiran.blogspot.in/search/label/Magento

http://blog.baobaz.com/en

http://mydons.com/category/framework/magento/

http://www.justwebdevelopment.com/blog/category/magento/

http://magento-talks.blogspot.in/

http://phptalks.wordpress.com//?s=magento&search=Go

http://www.endreywalder.com/blog/magento/
http://fishpig.co.uk/magento-tutorials/custom-tabs-magento-product-admin
http://magento4u.wordpress.com/2009/06/08/create-new-module-helloworld-in-magento/
http://www.e-commercewebdesign.co.uk/blog/magento-tips/creating-a-custom-theme-in-magento-1-5.php
http://www.webspeaks.in/search/label/magento?max-results=10

Magento Themes Link

http://www.design4magento.com/free-magento-themes/

http://www.smashingmagazine.com/2010/06/03/download-a-free-magento-theme-hellowired/

http://www.tmdhosting.com/templates/free-magento-themes.html

http://pelfusion.com/freebies/15-free-high-quality-magento-templates/

http://www.modny73.com/inspiration/27-free-magento-themes-for-download/

http://www.tmdhosting.com/templates/free-wordpress-themes.html

http://www.magento-templates.com/free-magento-templates/

http://www.freewebtemplates.com/

http://www.expertmagentodevelopers.com/blog/6-exclusive-free-magento-1-7-themes/
http://www.expertmagentodevelopers.com/blog/download-free-magento-1-7-themes/

Free Wordpress Themes Link

http://www.freewebtemplates

http://www.freewebtemplates.com/download/free-wordpress-theme/customize-774829566/download/.com/download/free-wordpress-theme/customize-774829566/download/

http://www.queness.com/wordpress-theme

http://www.freewebtemplates.com/website-templates/

Free Magento Extension link

http://www.fmeextensions.com/free-stuff/free-themes.html?mode=grid
http://www.magentheme.com/magento-extensions/free.html?limit=30

Free HTML Templates link

http://www.freewebsitetemplates.com/templates/page-9
http://www.freewebtemplates.com/shop-templates/
http://www.metamorphozis.com/
http://www.templatesbox.com/templates.htm
http://www.siteground.com/
http://www.themesbase.com/?free=1&order=&page=11

http://pligg2u.com/

http://myfreetemplatehome.com/ws4/10-administration-panel-html-templates-best-of-this-week.php

http://ginva.com/2012/05/admin-html-css-website-templates/
http://www.templatemo.com/preview/templatemo_354_simple_grid

Free And paid magento links important

http://www.mage-world.com/

http://www.magikcommerce.com/

Free Jquery Block UI link

http://dreamerslab.com/blog/en/jquery-blockui-alternative-with-jquery-msg-plugin/

Javascript email validation

Javascript email validation

Add Remove Class through Javascript

Add Remove class javascript