Google Android 4.0 Ice Cream Sandwich
February 2, 2012 – 6:23 pm | No Comment

Just how tasty is Android 4.0?

WHAT’S COOL
Android 4.0 is one of the most awaited android versions. It has many new cool features. Lets view some of these features. The virtual keyboard may not look that …

Read the full story »
Gadgets

Gadgets review by our get gadget group bloggers. Know it before you buy it. Featuring the Top Rated reviews

Google

Our passionate Googlers talking about everything interesting with the universal search engine GOOGLE.

Internet

All about the internet, Answers to a lot How To’s. Our internet savvy bloggers digging out the unexplored possibilities of the world wide web.

Life

Life strategies, thoughts on Life, good experiences and ideas that worth spreading

Sports

Our Sports column on sports news, reviews, fan space and more

Home » Ecommerce, Headlines, Technology

How to install Magento on Wamp Server (Windows XP) with sample data.

Submitted by on July 6, 2010 – 4:47 am22 Comments

Hello techies,

I was trying to install Magento on my local server using WAMP. Well, Magento is an award winning open source ecommerce application. This will help a newbie on installing Magento on your system using WAMP.

Here is it how?

1. Download and install WampServer 2.0f which contains Apache Version: 2.2.11, PHP Version: 5.2.8, MySQL Version: 5.1.30, phpmyadmin 3.1.1.
[Latest versions of WampServer contain PHP 5.3. But Magento doesn’t work with PHP 5.3. If you want to use a latest version (e.g.: WampServer 2.0i), then you must download & install PHP 5.2.8 add-on to the WampServer2.0i and load it via WampServer -> PHP -> Version -> 5.2.8]
2. Download magento-1.4.1.1.zip and magento-sample-data-1.2.0.zip.
3. Extract magento-1.4.1.1.zip. Copy and paste Magento (or folder name) folder in to www directory of the WampServer.
4. Make a database for Magento demo store at your WampServers phpmyadmin interface as shown below. Write down the database name, user name, and password as you will need these later.
a)    Create New Database.
Phpmyadmin -> Create new database – Database name –> Create.

b)    Add New User and User Password.
Server: localhost -> Privileges-> Add a new User -> Select appropriate drop downs as shown below; put your username & password -> Check all privileges -> GO.

c)    Add User to Database.
Server: localhost -> Privileges -> Select username -> Edit privileges

Database specific privileges -> Select Database name from drop down

The page will refresh-> Check all privileges -> Go.
5. Extract your Sample Data package magento-sample-data-1.2.0.zip. You will get a SQL file and a “media” folder.
6. In the leftmost column of your Phpmyadmin click on the database name that you created, now click on Import in the central menu bar at your database and select that SQL file, which came in unpack of Sample Data package. Then click Go. A list of your new tables will appear below your database name in the left-hand column. Now you can close phpMyAdmin.
7. Go back to the sample data folder. Copy catalog folder inside the ‘media’ folder to the Magento ‘media’ folder on the www directory.
8. Load the php extensions mcrypt.dll and curl.dll.
WampServer -> PHP -> PHP extensions -> Click on php_curl & php_mcrypt.
In addition to this, you may also need to make sure you are loading: php_pdo, php_pdo_mysql.
9. Now enter http://localhost/magento(or folder name)/ on your browser for installation Step-by-Step Wizard.  Just proceed as explain below.

a.    First step, Click on the check box “I agree to the above terms and conditions” and click on the Continue button.
b.    In Second step, leave localization to its default values and Click on Continue.
c.    In the Third step, enter the database name, database user name, database user password, & check-Skip Base URL Validation before the Next Step and click on Continue. (This step will take 1 minute or more, since that step stores the tables in the database).
d.    In Fourth step enter your personal information and login information (admin name & password for dashboard) and don’t forget to write down admin password. (Leave encryption key). Click on Continue.
e.    In the Final step, please make a note of your encryption key and make sure you keep it in a safe place. (Magento uses it to encrypt passwords, credit cards and more).

10. Installation completed. Now you can open Frontend (http://localhost/magento (or folder name)/) and Backend (http://localhost/magento (or folder name)/index.php/admin/dashboard) on your browser.

11. If you can’t Log in to Admin Panel after installation, that’s a cookie problem. The solution for this problem is to modify the core Magento code as explain below.

Copy the Varien.php file from:
C:\wamp\www\magento\app\code\core\Mage\Core\Model\Session\Abstract\Varien.php and
Paste in to the C:\wamp\www\magento\app\code\local\Mage\Core\Model\Session\Abstract\Varien.php (create folders Mage\Core\Model\Session\Abstract\). Open the same file and go to line 96 or locate the code similar below:

Replace the code found in line 96 with this one.

The purpose of this code change is to disable the Magentos domain checking only if it is accessed via localhost and run as usual if it is being accessed through a valid domain.
Now you can Login to Admin Panel http://localhost/magento/index.php/admin/ with your admin username and password.
12. If you browse through the Magento demo store; store doesn’t show any products. To resolve this problem Log in to Admin Panel go to System—>Index Management.  Select fields in Status — ‘REINDEX REQUIRED’, then choose ‘Reindex Data’ from drop down and click Submit.
13. If you want to change Header, navigate through Admin Panel > System > configuration > design > header > Welcome Text > Change default welcome message, Save.
To change footer; find the page footer file from magento\var\cache\ folder, change footer and save it.
All the best!!!

22 Comments »

  • Minu says:

    Oh this is working.
    Thanks for your article.

  • Jamall says:

    hei there, ive done the process but saddly the whole products ecc wont appear even after the reindex data process. any guess?

    thx in advance for any support ;)

  • Mike says:

    A good “current” description of how to quickly set up on a local Windows server. This article saved alot of time. Thanks!

  • Robin Pakkarambel says:

    Hi Jamall cross check steps 6 & 7. (Step 6 will take some time, since that step creates the tables)…

  • Tino says:

    Robin, you are my hero… Spent days and days and days trying to set this up. You were the only one I found mentioning the PHP 5.2.8 add on, which was the key to a successfull installation. Now I only need to bounce my head for a while to get WAMP and Magento work toguether to send emails (another nightmare).
    I´ll pass on the link to ur post. You might save too many headaches to docens of people.
    A million thanx buddy

  • Terror says:

    This worked in a single go!!Unbeleivable..

  • Joaquim afonso da silveira says:

    Robin, I’m in Brazil, and many thanks for your contribution, it was very important and came at a crucial moment. Because I was trying to install magento on localhost for 7 days without success and nearly gave up. The tips are absolutely perfect. Peace, health and full success for you and your family.
    Sorry the words because I am using a translation program.

  • Roberto says:

    You’re my Hero!!! Saludos desde México :D

  • Techyuva says:

    Techyuva…

    [...] something about techyuva[...]…

  • koenraad says:

    Hi there,

    excellent explanation on how to install. took me ages to work it out, until I found this help.

    thanks mate!

  • mani says:

    Thanks man!

    I have been trying to setup magento on my local machine for past several days but not successful. Your blog post came to my rescue and now it all working fine – Thank a lot. going to tweet your article!

  • stela says:

    You are great…i have 2weeks that i tried to install magento….

  • Sonia says:

    Hi
    Thanks a lot. I felt this is as the best explanation for installing majento. Explained each and every step clearly. Thanks again and one thing I would like to add to step 9. That is in the base url only when I gave ‘http://127.0.0.1/majento‘ instead of default ‘http://localhost/majento‘ I could pass that stage.

  • Som says:

    On the navigation bar when we click on any last node category then it will says “There are no products matching the selection”.

    Please tell why the products are not showing while there are products added in database?

    Also please tell from where the home page products(Best Selling Product) are coming?

  • Biju says:

    Anybody can help me out here

    thanks for the steps which helps me lot following the installation of magento, but when it comes to magento installtion which you have specified at step 9, i am getting an error Please enter a valid URL. Protocol is required (http://, https:// or ftp://) but i left the default value which is http://localhost/magento/, i am not able to move to next step, anybody can help me here what is the actual error and how i should overcome it, thanks

  • Ambarish Hazarnis says:

    Hey there was an error “Please enter a valid URL. Protocol is required (http://, https:// or ftp://)” at step 9c.

    Solution:
    Follow this link ” http://futureplanmedia.com/how-to-install-magento-on-localhost-without-url-validation-error/ “.

  • bryan says:

    Thank you for the post. The reindex worked great! In this time of learning Magento, oh what a time, it is nice to find nuggets of useful information from people who care enough to share.
    Thanks!

  • Hira Kayani says:

    It was really helpful! Thanks a bunch :D

  • aj says:

    step 5. Extract your Sample Data package magento-sample-data-1.2.0.zip. You will get a SQL file and a “media” folder.

    How do u do this? Where do u extract your sample data package magento-sample-data-1.2.0.zip?

  • Debesh says:

    even after following step 11 i couldn’t login to magento. it gives the following error

    There has been an error processing your request
    Exception printing is disabled by default for security reasons.

    Error log record number: 1488078831

  • debesh says:

    After following step 11 i still can’t login to magento.
    I’m getting following error

    There has been an error processing your request

    Exception printing is disabled by default for security reasons.

    Error log record number: 573339882

    i’m using WampServer2.2a-x32 and megento 1.6.1.0

  • ovika says:

    Dear Robin,

    you saved my brain cells my life my time.
    I really appreciate your work.
    Thank you!

    Greetings from Hungary!

Leave a comment!

Add your comment below, or trackback from your own site. You can also subscribe to these comments via RSS.

Be nice. Keep it clean. Stay on topic. No spam.

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.