This tutorial will show you solutions to some of the most common Magento issues that users face when managing their online shops.

This tutorial covers the following topics:

 

How to reset Magento Admin Password

To change your Magento admin password, go to your cPanel > phpMyAdmin, select your Magento database, click the SQL tab and paste this query:

UPDATE admin_user SET password=CONCAT(MD5('sGnewpass'), ':sG') WHERE username='AdminUsername';

Note: You have to change newpass in the MD5(‘sGnewpass’) with your new password, and change *AdminUsername* to your Magento admin username.

Execute the query by clicking the Go button and your password will be changed.

 

How to enable Search Engine Friendly URLs in Magento

To enable Search Engine Friendly URLs in Magento, you have to log in to the Magento administration area and click on the Configuration button. Under the System navigation menu, switch to Web page from the sub-navigation panel on the left.

When the page loads, you will see blue lines which represent closed options tablets. Click on the Search Engines Optimization tab and turn on the Use Web Server Rewrites (mark as Yes). Click on the Save Config button and your Magento SEF URLs will be enabled.

 

How to speed up Magento

 

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.

 

How to redirect Magento to open through www

For SEO and usability purposes you may want to redirect your visitors to open your site only through www (http://www.yourdomain.com).

To do this in Magento, you should open the .htaccess file in the folder where your Magento is installed. In it locate the RewriteEngine on line and right after it add the following lines:

RewriteCond %{HTTP_HOST} ^yourdomain.com$ [NC]
RewriteRule ^(.*)$ http://www.yourdomain.com/$1 [R=301,L]

Once you do this, save the .htaccess file and log in to the Magento admin area > System > Configuration menu and from the left panel click the Web button.

Unfold the Unsecured set of options and change the Base URL option from http://yourdomain.com to http://www.yourdomain.com.

Save the changes and your Magento will start working through www.yourdomain.com only!

 

How to disable the Compare products functionality

You can disable the Compare products functionality in Magento by following these steps:

• Edit app/code/core/Mage/Catalog/Helper/Product/Compare.php and change the following code:

public function getAddUrl($product){return $this->_getUrl(’catalog/product_compare/add’, $this->_getUrlParams($product));}

to

public
 function getAddUrl($product){//return 
$this->_getUrl(’catalog/product_compare/add’, 
$this->_getUrlParams($product)); return false;}

• Edit ./app/design/frontend/base/default/layout/catalog.xml (if you are using a different Magento theme, enter its name instead of default) and change the following code:

<block 
type="catalog/product_compare_sidebar" before="cart_sidebar" 
name="catalog.compare.sidebar" 
template="catalog/product/compare/sidebar.phtml"/>

to

<!--
 <block type="catalog/product_compare_sidebar" before="cart_sidebar" 
name="catalog.compare.sidebar" 
template="catalog/product/compare/sidebar.phtml"/> -->

 

• Flush the Magento cache from your Magento admin area > System > Cache Management.

 

How to set up a blog in Magento

It is not difficult to set up a blog in Magento. However, note that this functionality is not included by default and you will have to use a custom extension to add it.

You can search Magento Connect for an extension that will fully suit your needs. One of the popular free extensions that you can use is the Magento Blog – Community Edition.

All Magento extensions are installed in a similar way that is thoroughly explained in our Magento Connect Tutorial.

Once the extension is installed, you will have one additional section in the top menu of your Magento admin area called Blog. From there you can adjust the newly-installed Blog settings, add posts etc.

 

How to add a Contact Us form in Magento

Magento includes contact form functionality by default. A link to a contact form can usually be found in the footer of your Magento installation.

Of course, you can add a contact form on any page. All you need to do is:

• Log in to the administrator area.
• Go to CMS > Pages.
• Select the page you want to edit or create a new page.

Paste the following code using the HTML option of the WYSIWYG editor:

<!–
 CONTACT FORM CODE BEGIN–>{{block type='core/template' 
name='contactForm' template='contacts/form.phtml'}}<!– CONTACT FORM 
CODE END–>

Save the changes and the contact form will appear on the desired page.

 

“Access denied” issue

As a solution to the “Access denied” issue, you should log out from the Magento admin area and then log in again.

If the above does not help, you should reset the admin privileges. This can be done through the Magento admin area > System > Permissions > Roles > Administrators.

Click on the Role Resources option from the left menu and make sure that Resource Access is set to All.

Click on the Save Role button and the permissions will be reset.

 

How to set a custom group of users

You can add a new group from the Magento admin area > Customers > Customer Groups > Add New Customer Group.

Once a customer registers, you can change the group he/she belongs to from the Magento admin area > Customers > Manage Customers. Click on the Edit link next to the customer and change the group from the Account Information > Customer Group. Click Save Customer.

Set the discount from Promotions > Catalog Price Rules > Add New Rule.

In the Customer Groups select the customers’ groups for which the promotion is valid. Enter the other details, set the rule actions and conditions.  Finally, click Save Rule.

The above ten tips will hopefully help you resolve at least some of the Magento issues you have faced or are about to face.