Magento Themes and Magento Extensions

Tools – Magento Responsive Theme

Share
Posted on December 31st, 2014 | Posted by admin

Tools Magento Responsive Theme is designed for tools, auto spare-parts, electronics, mobile and multi purpose stores. Tools Magento Responsive Theme is looking good with colors combination. All sub pages are customized. It is very nice with its clean and professional look.

Tools - Magento Responsive Theme

Features

  • HTML5 and CSS3
  • Fully Responsive Theme
  • Using Google Fonts
  • Support Multiple Language
  • No Core Modifications

Magento – Add Facebook Share and Twitter Tweet

Share
Posted on December 30th, 2014 | Posted by admin

Adding a Facebook “Share” button and a Twitter “Tweet” button to your Magento pages and products is quite simple and good for adding the share buttons directly to a page or product detail page you want to share.

Use this for sharing/tweeting specific CMS pages or product detail pages in Magento. This code should go inside the/app/design/frontend/default/yourtheme/template/catalog/product/view.phtml. You can put this in various locations, but I like having it directly after the product description on my product detail page.

<div>
     <?php if ($this->canEmailToFriend()): ?>
         <div><a href="<?php echo $this->helper('catalog/product')->getEmailToFriendUrl($_product) ?>"><?php echo $this->__('Email to a Friend') ?></a></div>
     <?php endif; ?>

The Better Way to Modify Layouts in Magento

Share
Posted on December 18th, 2014 | Posted by admin

In this article, I’m going to be covering what I believe to be a very effective way of modifying the layout of any Magento theme.

For several of the first Magento themes I built, I copied the layout files from the default or blank theme into the custom theme layout folder. I would then modify the layout files directly, editing or commenting out content in files like: catalog.xml, page.xml, checkout.xml, etc… I never liked editing these files directly, as I knew that when it came time to upgrade to a newer version of Magento that had upgraded the layout files, I’d have to merge the changes into the new layout files.

One day, I was digging through the Magento code relating to layout files and discovered a bit of code that made me realize that it was possible to just place a local.xml file in my custom theme’s layout folder and have it loaded automatically by Magento. (this code is on line 283 in /app/code/core/Mage/Core/Model/Layout/Update.php in the fetchFileLayoutUpdates() method).

Due to Magento’s brilliant tags, it’s possible to do just about anything you want without having to edit any of the default layout files.

RESOLVING AMBIGUOUS COLUMN FILTER WITH CUSTOM MAGENTO GRID – SQLSTATE [23000]: INTEGRITY CONSTRAINT VIOLATION: 1052 COLUMN ‘STORE_ID’ IN WHERE CLAUSE IS AMBIGUOUS

Share
Posted on December 17th, 2014 | Posted by admin

We have situations with maintaining a  custom magento grid by adding one or more custom columns for retrieving meaningful and expanded details. Suppose we have built a custom grid and the source collection has an ambiguous column in the where / group by clause when applying a filter option i.e., we may have stuck with the following exception in magento backend.

  • code
  • source
  1. SQLSTATE [23000]: Integrity constraint violation: 1052 Column 'store_id' in where clause is ambiguous
  2. ../lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
  3. ../lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
  4. ../lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
  5. ../lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT DISTINCT...', Array)

How to speed up Magento

Share
Posted on December 15th, 2014 | Posted by admin

Many Magento issues are caused by slow performance. 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.

Page 1 of 3123»