Category | Magento snippets

In many of my projects faced problem like session timeout in magento i.e. when i am importing products when those are of greater then count 5000 so i came up with the solution given below hope this could help you also Session SQL INSERT INTO core_config_data(path, value) VALUES ('web/cookie/cookie_lifetime', 86400) ON DUPLICATE KEY UPDATE value = 86400; From Admin Panel: System -> Configuration General > Web Session Cookie management Cookie Lifetime: 86400

---

Megento does not allow to delet orders created, but even sometime we nee to delete orders, for deleting particular order we must know the order id, i.e. we can get order id from magento admin section now execute sql query given below remember change your order id with increment_id. SET @increment_id='43290'; SELECT @order_id:=entity_id FROM sales_order_entity WHERE increment_id=@increment_id; DELETE FROM sales_order_entity WHERE entity_id=@order_id OR parent_id=@order_id; DELETE FROM sales_order WHERE increment_id=@increment_id;

---

set default base, thumb, small image to first image. If you have multiple images per product from your import, Magento might have set the LAST one as the default base, small, and thumb image for all of your products! This can be an issue if you want the FIRST image to be the default! SQl given below updates your images and makes the FIRST image (order 1) your default BASE, SMALL, and THUMB image for ALL products in your database. UPDATE catalog_product_entity_media_gallery AS mg, catalog_product_entity_media_gallery_value AS mgv, catalog_product_entity_varchar AS ev SET ev.value = mg.value WHERE...

---

Adding a custom comment box for each item in the cart is actually very easy. First lets add the textarea field for each item. open file: template/checkout/cart.phtml Add the new heading along with other heading for cart items. <th><?php echo $this->__('Comments') ?></th> Open file: template/checkout/cart/item/default.phtml Add a new column <td class="a-center"> <textarea name="cart[<?php echo $_item->getId() ?>][comments]" rows="3" cols="20"><?php echo $_item->getItemcomment() ?></textarea> </td> new...

---

Magento sends the credit card number openly by email, which is not secured at all. Here is how we can remove it. Step 1: Open the file app/design/frontend/default/your_theme/template/payment/info/cc.phtml Step 2: Find the lines that read: <?php echo $this->__('Credit Card Number: xxxx-%s', $this->htmlEscape($this->getInfo()->getCcLast4())) ?> <?php echo $this->__('Expiration Date: %s/%s', $this->htmlEscape($this->getCcExpMonth()), $this->htmlEscape($this->getInfo()->getCcExpYear())) ?> Step 3: Comment this code out, so it looks like this: <!–<?php...

---

Creating a store view for a language is not too hard in magento follow the steps given below and you are done with it. Step 1: Download the language pack you need and then unpack it to your Magento install folder. It copies two folders: one goes to app\design\frontend\default\default\locale and the other one to app\locale. Step 2: Go to System > Configuration in your admin. On the left top corner in Current Configuration Scope dropdown box, you can see Default Config, and Main Store in English store view. Step 3: Now let’s go and add the French store view. Under the dropdown box, there’s...

---

Some time we need to display custom option of product on category list page to achive this task we only need to paste the code given below in your list.phtml file $productSku = $_product->getSku(); $product = Mage::getModel('catalog/product'); $productId = $product->getIdBySku( $productSku ); $product = Mage::getModel("catalog/product")->load($productId); $attVal = $product->getOptions(); $optStr = ""; // loop through the options foreach($attVal as $optionKey => $optionVal) { //$optStr .= "<br/>"; //$optStr .= $optionVal->getTitle().":...

---

To open compare item page in modal window we need to edit file ‘sidebar.phtml’ path given below template/catalog/product/compare/sidebar.phtml add the following js at the end of sidebar.phtml <script type="text/javascript">// <![CDATA[ function showCompare(url) { winCompare = new Window({className:'magento',title:'Compare Products',url:url,width:820,height:600,minimizable:false,maximizable:false,showEffectOptions:{duration:0.4},hideEffectOptions:{duration:0.4}}); winCompare.setZIndex(100); winCompare.showCenter(true); } // ]]></script> we also...

---

To get child product of configrable product. Firstly we need parent product id to load product and to get child products we need to call getUsedProducts() function to get child products. $product = Mage::getModel('catalog/product')->load($product_id); $childProducts = Mage::getModel('catalog/product_type_configurable')->getUsedProducts(null,$product);

---

So here is a little bit of code, that allows you and other you set to work on the site while everyone else sees its maintenance mode. All we need to do it edit 3 lines. Open: index.php in root and above line 57 add (remembering to edit the ‘allowed’ array to contain the IP’s you want to be able to access the site); $ip = $_SERVER['REMOTE_ADDR']; $allowed = array('182.186.0.134''); // IP's that are allowed to view the site. then change the line if (file_exists($maintenanceFile)) { to if (file_exists($maintenanceFile) && !in_array($ip, $allowed)) { Simple. Now you can access the site,...

---