-- first our items table:
CREATE TABLE `items` ( `id` int(11) NOT NULL auto_increment, `item_name` varchar(50) default NULL, PRIMARY KEY (`id`) );
-- now our item attributes
CREATE TABLE `item_attributes` ( `id` int(11) NOT NULL auto_increment, `item_id` int(11) NOT NULL default '0', `attribute_name` varchar(50) default NULL, PRIMARY KEY (`id`), KEY `item_id_attribute_name` (`item_id`,`attribute_name`) );
-- now finally our attribute values
CREATE TABLE `attribute_values` ( `attribute_id` int(11) NOT NULL default '0', `attribute_value` varchar(100) default NULL, UNIQUE KEY `attribute_id` (`attribute_id`,`attribute_value`) );
Step 1:

$attributes = array('name'=> $name'store_id'=> store_id);

$model = mage::getmodel('module/modelname')->loadbyattributes($attributes);

Step 2:

public function loadbyattributes($attributes)

{

$this->setdata($this->getresource()->loadbyattributes($this,$attributes));

return $this;

}

Step 3:

public function loadbyattributes(Custom_Ccms_Model_Ccms $ccmsObj, $attributes)

{

$adapter = $this->_getreadadapter();

$where = array();

foreach ($attributes as $attributecode=> $value) {

$where[] = sprintf('%s=%s', $attributecode, '"'.$value.'"');

}

$select = $adapter->select()->from($this->getmaintable())->where(implode(' and ', $where));

$binds = $attributes;

$id=$adapter->fetchOne($select,$binds);

if($id){

$this->load($ccmsObj, $id);

}

return $this;

}

Reference : https://huztechbuzz.wordpress.com/2014/04/26/complete-list-of-all-events-in-magento/
Module name

Mage::app()->getRequest()->getModuleName();

Route name

Mage::app()->getRequest()->getRouteName();

Controller name

Mage::app()->getRequest()->getControllerName();

Action name

Mage::app()->getRequest()->getActionName();

Consider extension 'Redirect Visitors by Country IP'

  • Get this extension key from the http://www.magentocommerce.com/magento-connect/redirect-visitors-by-country-ip.html
  • Go System -> Magento connect -> Magento Connect Manager
  • Paste your extension key in the 'Paste extension key to install' text box and click instal button
  • After clicking install button, you can view 'Extension dependencies' table with 'Cancel installation' and 'Proceed' button
  • Click the 'Proceed' button.
  • Now you can see the 'black' section at the end of the 'Magento connect Manager' page in which you see installing progress
  • After you getting 'cache cleaned successfully' message in 'black' section, click refresh button
  • Now logout admin panel and login.
  • Now you can this extension in your admin panel.
  • Thanks for viewing this post
1. Go System -> Permissions -> Roles
2. Give Role Name in the 'Role Name' Text field.
3. Select 'Custom' from the Resource Access drop-down and select 'CMS' from the list of resources
4. In First three steps, we created Roles and selected resources to those role.
5. The next steps explain about create user from admin and assign Role to those user.
6. Go System -> Permissions -> Users
7. Give Information of Username,email... in the Account Information form
8. Then select newly created role from the list of roles.
Reference: http://magento.stackexchange.com/questions/8444/how-to-get-shipping-address-by-shipping-address-id
Reference: http://www.w3bdeveloper.com/how-to/how-to-get-customer-address-in-magento-by-cutomer-id/
Reference : http://www.arscommunity.com/wiki/magento/default-address-for-shipping-estimation
$product = Mage::getModel(“catalog/product”)->load($product_id);
$theoptions = $product->getOptions();
foreach($theoptions as $opkey=> $opval)
{
echo $opval->getOptionId().’|’.$opval->getTitle();
}