When the user is not logged in, the message appears as ‘Default welcome msg!‘.

To change the message text, follow steps below:-

- Go to
System -> Configuration -> GENERAL -> Design -> Header -> Welcome Text = YOUR WELCOME TEXT

That’s all. Now, the default welcome message is changed with your custom welcome message :)

Hope this helps. Thanks.

Related posts:

1. Magento: Setup Multiple Website
2. Magento: How to change Currency symbol ?
3. Magento: Setup multiple currency shop

Create a new phtml file (template/page/switch/stores-top.phtml) and write the following code in it :-

<?php if(count($this->getGroups())>1): ?>
<div class="language-switcher" style="margin-left:15px">
    <label for="select-store"><?php echo $this->__('Select Store') ?>: </label>
    <select id="select-store" onchange="location.href=this.value">
    <?php /*foreach ($this->getStores() as $_store): ?>
        <option value="<?php echo $_store->getUrl('') ?>"<?php if($_store->getId()==$this->getCurrentStoreId()): ?> selected="selected"<?php endif; ?>><?php echo $_store->getName() ?></option>
    <?php endforeach;*/ ?>
    <?php foreach ($this->getGroups() as $_group): ?>
        <?php $_selected = ($_group->getId()==$this->getCurrentGroupId()) ? 'selected="selected"' : '' ?>
        <option value="<?php echo $_group->getHomeUrl() ?>" <?php echo $_selected ?>><?php echo $this->htmlEscape($_group->getName()) ?></option>
    <?php endforeach; ?>
    </select>
</div>
<?php endif; ?>

Add store_switcher_top block after store_language block inside header block of page.xml present around line #66 :-

<block type="page/html_header" name="header" as="header">
	<block type="page/template_links" name="top.links" as="topLinks"/>
	<block type="page/switch" name="store_language" as="store_language" template="page/switch/languages.phtml"/>
	<block type="page/switch" name="store_switcher_top" as="store_switcher_top" template="page/switch/stores-top.phtml"/>
	<block type="core/text_list" name="top.menu" as="topMenu"/>
</block>

Add getChildHtml(’store_switcher_top’) below getChildHtml(’store_language’) in template/page/html/header.phtml like below :-

<?php echo $this->getChildHtml('store_language') ?>
<?php echo $this->getChildHtml('store_switcher_top') ?>

That’s all. Now, you can see store selector in header and footer both.

Hope this helps. Thanks.

Related posts:

1. Magento: Show Currency Selector in header
2. Magento: Show Currency Selector in right sidebar
3. Magento: How to call static block from template file?

By default, the currency selector is displayed in the left sidebar. Here, I will show you how you can show it in header just below the language selector.

Create a new phtml file (template/directory/currency-top.phtml) and write the following code in it :-

<?php if($this->getCurrencyCount()>1): ?>
<div class="box language-switcher" style="margin-left:15px">
    <label for="select-language">Your Currency: </label>
        <select name="currency" onchange="changeCurrency(this)">
        <?php foreach ($this->getCurrencies() as $_code => $_name): ?>
            <option value="<?php echo $_code ?>"<?php if($_code==$this->getCurrentCurrencyCode()): ?> selected="selected"<?php endif; ?>>
                <?php echo $_name ?> - <?php echo $_code ?>
            </option>
        <?php endforeach; ?>
        </select>
</div>
<script type="text/javascript">
//<![CDATA[
function changeCurrency(sObject){
    if(sObject.value){
        setLocation('<?php echo $this->helper('directory/url')->getSwitchCurrencyUrl() ?>currency/'+sObject.value);
    }
}
//]]>
</script>
<?php endif; ?>

Add currency_top block after store_language block inside header block of page.xml present around line #66 :-

<block type="page/html_header" name="header" as="header">
	<block type="page/template_links" name="top.links" as="topLinks"/>
	<block type="page/switch" name="store_language" as="store_language" template="page/switch/languages.phtml"/>
	<block type="directory/currency" name="currency_top" template="directory/currency-top.phtml"/>
	<block type="core/text_list" name="top.menu" as="topMenu"/>
</block>

Add getChildHtml(‘currency_top’) below getChildHtml(’store_language’) in template/page/html/header.phtml like below :-

<?php echo $this->getChildHtml('store_language') ?>
<?php echo $this->getChildHtml('currency_top') ?>

That’s all. Now, you will be able to see currency selector in the header of your site.

Hope this helps. Thanks.

Related posts:

1. Magento: Showing Store Selector / Switcher in header and footer
2. Magento: Show Currency Selector in right sidebar
3. Magento: How to get Currency Rates?

By default, the currency selector is displayed in the left sidebar. Here, I will show you how you can show it in right sidebar.

Showing currency selector in product view detail page

Put the following code in layout/directory.xml

<!--
Product default layout
-->

<catalog_product_view>
	<reference name="right">
		<block type="directory/currency" name="currency" before="-" template="directory/currency.phtml"/>
	</reference>
</catalog_product_view>

Showing currency selector in homepage

Go to Admin Panel -> CMS -> Manage Pages -> Edit Homepage

Click Custom Design tab in left sidebar

Write the following code in Layout Update XML box.

<reference name="right">
	<block type="directory/currency" name="currency" before="-" template="directory/currency.phtml"/>
</reference>

Hope this helps. Thanks.

No related posts.

I was transfering Magento files and database from one server to another. I did complete all the transfer process of files and also exported and imported the database. After that, when I tried to access the site, I got the following error:-

Recoverable Error: Argument 1 passed to Mage_Core_Model_Store::setWebsite() must be an instance of Mage_Core_Model_Website, null given, called in /path/app/code/core/Mage/Core/Model/App.php on line 427 and defined in /path/app/code/core/Mage/Core/Model/Store.php on line 279

Solution:

It’s very simple. Although I had to search for sometime for the solution. :)

Delete the following file:-

app/etc/use_cache.ser

That’s it. You are done. Now, you can access your site.

After doing this, you might get the next error which says:-

Notice: Undefined index: 0 in /srv/www/vhosts/javra.com/htdocs/munchad2/app/code/core/Mage/Core/Model/Mysql4/Config.php on line 92

If you get this error then please have a look at the solution for this error over here:-

http://blog.chapagain.com.np/magento-error-%E2%80%93-notice-undefined-index-0-appcodecoremagecoremodelmysql4config-php-on-line-92/

Hope this helps. Thanks.

Related posts:

1. Magento Error – Notice: Undefined index: 0 app/code/core/Mage/Core/Model/Mysql4/Config.php on line 92
2. Magento: Product Edit Warning: Invalid argument supplied for foreach()
3. Magento Admin login problem

Suppose, I have a database table named ‘news‘ with the following fields:-

id : int, auto increment, primary key
title : varchar
content : text
status : 0 or 1

Suppose, I have a module named ‘mynews‘. Here follows the code to select, insert, update, and delete data from the ‘news‘ table.

INSERT DATA

$data contains array of data to be inserted. The key of the array should be the database table’s field name and the value should be the value to be inserted.

$data = array('title'=>'hello there','content'=>'how are you? i am fine over here.','status'=>1);
$model = Mage::getModel('mynews/mynews')->setData($data);
try {
		$insertId = $model->save()->getId();
		echo "Data successfully inserted. Insert ID: ".$insertId;
	} catch (Exception $e){
	 echo $e->getMessage();
}

SELECT DATA

$item->getData() prints array of data from ‘news’ table.
$item->getTitle() prints the only the title field.
Similarly, to print content, we need to write $item->getContent().

$model = Mage::getModel('mynews/mynews');
$collection = $model->getCollection();
foreach($collection as $item){
	print_r($item->getData());
	print_r($item->getTitle());
}

UPDATE DATA

$id is the database table row id to be updated.
$data contains array of data to be updated. The key of the array should be the database table’s field name and the value should be the value to be updated.

// $id = $this->getRequest()->getParam('id');
$id = 2;
$data = array('title'=>'hello test','content'=>'test how are you?','status'=>0);
$model = Mage::getModel('mynews/mynews')->load($id)->addData($data);
try {
		$model->setId($id)->save();
		echo "Data updated successfully.";

	} catch (Exception $e){
		echo $e->getMessage();
}

DELETE DATA

$id is the database table row id to be deleted.

// $id = $this->getRequest()->getParam('id');
$id = 3;
$model = Mage::getModel('mynews/mynews');
try {
		$model->setId($id)->delete();
		echo "Data deleted successfully.";

	} catch (Exception $e){
		echo $e->getMessage();
}

In this way you can perform select, insert, update and delete in your custom module and in any magento code.

Hope this helps. Thanks.

Related posts:

1. Magento: Create, read, delete cookie
2. Magento: How to delete System Attribute?
3. How to Install Sample Data for Magento?

Creating or setting up multiple stores in Magento is somehow easy but creating/setting up multiple website in Magento is a bit difficult task :).

This step-by-step tutorial will guide you to do so.

I suppose that you have installed Magento in folder named ‘magento’. So, your website URL will be http://yourwebsite.com/magento/

- Create Website, Store, and Store View

- Create Website
- Go to System –> Manage Stores
- Create Website
- Name = My Website
- Code = mywebsite
- Sort Order = 10
- Save Website

- Create Store
- Go to System -> Manage Stores
- Create Store
- Website = My Website
- Name = Main Store
- Root Category = Root Catalog

- Create Store View
- Go to System -> Manage Stores
- Create Store View
- Store = My Website -> Main Store
- Name = English
- Code = English
- Status = Enabled
- Sort Order = 10

- Change Link URL
- Go to System -> Configuration -> GENERAL -> Web
- Change ‘Current Configuration Scope’ to ‘My Website’
- Unsecure -> Base URL = http://yourwebsite.com/magento/
- Unsecure -> Base Link URL = http://yourwebsite.com/magento/mywebsite/

- Change Theme (Optional: If you want different design for your new website)

- Suppose your new design template and skin folder is named ‘mywebsite’
- Copy ‘mywebsite’ template folder to magento/app/design/frontend/default/
- Copy ‘mywebsite’ skin folder to magento/skin/frontend/default/

- Go to System -> Configuration -> GENERAL -> Design
- Change ‘Current Configuration Scope’ to ‘My Website’
- Themes -> Default = ‘mywebsite’
- Uncheck ‘Use Default’
- Save Config

- Create a new folder named ‘mywebsite’ inside ‘magento’ folder.

- Copy index.php of magento folder into mywebsite folder.

- Open index.php of mywebsite folder.
- Change $compilerConfig = ‘includes/config.php’; to $compilerConfig = ‘../includes/config.php’;
- Change $mageFilename = ‘app/Mage.php’; to $mageFilename = ‘../app/Mage.php’;
- Change Mage::run(); to Mage::run(‘mywebsite’,'website’);

- Copy .htaccess file from magento folder to mywebsite folder

Finally, you have created a new website for your magento shop. Your base installation can be browsed by http://yourwebsite.com/magento/ and your new website can be browsed by http://yourwebsite.com/magento/mywebsite/

Hope this helps. Thanks.

Related posts:

1. Magento: Setup multiple currency shop
2. ASP.NET Error : An HtmlSelect cannot have multiple items selected when Multiple is false.
3. Magento: Load store specific product

I am having problem in displaying PayPal payment method in payment method section of onepage checkout in Magento.

I am using “PayPal Website Payments Standard“.

I have enabled this module from backend (System -> Configuration -> SALES -> Payment Methods -> PayPal Website Payments Standard).

I have also entered the Business Name and Business Account at “Website Payments Standard” (System -> Configuration -> SALES -> PayPal Accounts -> Website Payments Standard). I have set Sandbox Flag = Yes and Debug Flag = Yes. I am using Sandbox business name and account.

After doing all this, I think I should see the PayPal payment method option in my Checkout page on Payment methods section. But PayPal payment option is not displayed there.

Cause:

The possible cause is because base currency of your shop is not supported by PayPal.

Solution:

PayPal supports the following currencies:-

protected $_allowCurrencyCode = array('AUD', 'CAD', 'CZK', 'DKK', 'EUR', 'HKD', 'HUF', 'ILS', 'JPY', 'MXN', 'NOK', 'NZD', 'PLN', 'GBP', 'SGD', 'SEK', 'CHF', 'USD');

The above code is present in the class Mage_Paypal_Model_Standard. You can add your shop’s base currency code to the array.

Like, I have base currency code as NPR. To show PayPal payment method in my shop, I need to add NPR in the array. Like the following way:-

protected $_allowCurrencyCode = array('AUD', 'CAD', 'CZK', 'DKK', 'EUR', 'HKD', 'HUF', 'ILS', 'JPY', 'MXN', 'NOK', 'NZD', 'PLN', 'GBP', 'SGD', 'SEK', 'CHF', 'USD', 'NPR');

Now, PayPal payment option is displayed in payment methods section of onepage checkout.

And, to change the data sent from your site to paypal, you have to modify getStandardCheckoutFormFields() function of Mage_Paypal_Model_Standard class. This function returns an array ($rArr) with some necessary parameters. You need to change the value of ‘currency_code‘ and ‘amount‘ of the array. Currency_code can be any currency code that is supported by PayPal and Amount must be converted from your base currency to that particular currency code.

Hope this helps. Thanks.

Related posts:

1. Magento: Authorize.net not displayed in Payment Information section while Checkout
2. Magento: How to get Currency Rates?
3. Magento: Setup Multiple Website

From the admin panel, you can only add attributes to product. To add attributes to category, you need to write sql query in your phpmyadmin or a better way would be creating a new custom module and adding attributes to category from the mysql setup file of the module.

By mysql setup file, I mean the file inside the directory YourNamespace/YourModule/sql/yourmodule_setup/

Create a new module and write the following in your module’s mysql setup file.

$installer = $this;
$setup = new Mage_Eav_Model_Entity_Setup('core_setup');
$installer->startSetup();

$setup->addAttribute('catalog_category', 'my_attribute', array(
	'group'     	=> 'General',
	'input'         => 'text',
    'type'          => 'varchar',
    'label'         => 'My Attribute',
	'backend'       => '',
	'visible'       => 1,
	'required'		=> 0,
	'user_defined' => 1,
    'global'        => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
));

$installer->endSetup();

The above code will create a category with the code ‘my_attribute‘ and lable ‘My Attribute‘. You can view it under Admin Panel –> Catalog –> Manage Categories –> General Information

Hope this helps. Thanks.

Related posts:

1. Magento: Adding attribute from MySql setup file
2. Magento: Get category name and url from product
3. Magento: How to filter product collection using 2 or more category filters?

You have created a custom module.
You have entered certain data in your database.
You need to show the data randomly.

Solution:

In MySQL the rand() function helps the select query to fetch data randomly. In Magento, you can select random rows from MySQL table using Zend_Db_Expr(‘RAND()’).

You have to create a new function in your module’s collection class (YourNamespace/YourModule/Model/Mysql4/YourModule/Collection.php)

public function setRandomOrder()
{
	$this->getSelect()->order(new Zend_Db_Expr('RAND()'));
	return $this;
}

Now, you can fetch random data from your table using the above create setRandomOrder function. The code below can be kept in the block or template (.phtml) file of your module.

$collection = Mage::getModel('yourmodule/yourmodule')
					->getCollection()
					->setRandomOrder();

echo "<pre>"; print_r($collection->getData()); echo "</pre>";

Hope this helps. Thanks.

Related posts:

1. Random number, string generation in PHP
2. Generating random image
3. Magento: Very Useful Collection Functions