Convert Magento Database to Innodb

Share
Posted on March 31st, 2013 | Posted by admin

Convert Magento Database to Innodb

ALTER TABLE `admin_assert` ENGINE=InnoDB;
ALTER TABLE `admin_role` ENGINE=InnoDB;
ALTER TABLE `admin_rule` ENGINE=InnoDB;
ALTER TABLE `admin_user` ENGINE=InnoDB;
ALTER TABLE `adminnotification_inbox` ENGINE=InnoDB;
ALTER TABLE `api_assert` ENGINE=InnoDB;
ALTER TABLE `api_role` ENGINE=InnoDB;
ALTER TABLE `api_rule` ENGINE=InnoDB;
ALTER TABLE `api_user` ENGINE=InnoDB;
ALTER TABLE `catalog_category_entity` ENGINE=InnoDB;
ALTER TABLE `catalog_category_entity_datetime` ENGINE=InnoDB;
ALTER TABLE `catalog_category_entity_decimal` ENGINE=InnoDB;
ALTER TABLE `catalog_category_entity_int` ENGINE=InnoDB;

Some Code Samples In Magento

Share
Posted on March 30th, 2013 | Posted by admin

Some Code Samples In Magento

Get CMS Page ID
$pageId = Mage::getBlockSingleton(‘cms/page’)->getPage()->getIdentifier();

How to get product attributes?
<?php echo $_product->getResource()->getAttribute(‘attribute name’)->getFrontend()->getValue($_product) ?>

How to show breadcrumbs in magento?
<?php echo $this->getLayout()->getBlock(“breadcrumbs”)->toHtml(); ?>

How to show Static Blocks?

Magento:Alphabetical category sorting

Share
Posted on March 29th, 2013 | Posted by admin

If you are dealing with magento category i am very sure that you’ll face this problem .Magento category fetching is not an issue its a child play but sorting thse categories is little tricky , so here the is SQL part by which you can sort the categories in alphabetical order

SET @i=0;
SET @j=0;
DROP TABLE IF EXISTS AAA_NEW_POSITION;
CREATE TABLE AAA_NEW_POSITION
SELECT e.entity_id AS 'entity_id',

Customize Design of order success page in Magento

Share
Posted on March 28th, 2013 | Posted by admin

Some time we need to some design changes on order success page in Magento and we face problem when we try to customize the design of order success page. Because, success page appear when we place an order. Once we refresh the page success page gone away. To see success page again we need to place an order again. Its is a big hassle for developer.

To view order success page just comment out few lines of code in successAction.(/app/code/core/Mage/Checkout/controllers/OnepageController.php).

Search public function successAction()

Uniqueness of Magento Templates Found In Utter Comparison

Share
Posted on March 27th, 2013 | Posted by admin

Magento has already captured the mind and have catch the eye of website developers after it was launched as an Open Source web application in the field of e-commerce. On the fast growth of the e-commerce platform,Magento templates hold a major role on the market. Depicted as highly creative e-commerce application these templates are also easy to customize and configure as per the aspirations and needs of any user or individual. Offering an innovative vista of reflective horizon both to the administrators as well to the website owners, Magento templates are remarkably distinguishable and striking. Moreover the features are open and flexible as per the customized format of application before implementing those in a website. Solution to any great e-commerce site is primarily based on proper themes and appealing templates. These templates from Magento are already supporting the traits of beautiful, effective and impressive factors in various applications.

Page 1 of 612345»...Last »