:::: MENU ::::

Magento installation on wamp server with sample data

Magento is a revolutional ecommerce software product. Magento is an open-source eCommerce web application. Magento has become one of the most popular open source ecommerce application in the industry. It was developed by Varien (now Magento Inc) with help from the programmers within the open source community but is owned solely by Magento Inc. Magento was built using the Zend Framework.  The Magento Community Edition is the only free version of Magento available.


Magento installation on localhost LAMP server.
Magento installation on localhost WAMP server.
Magento installation on localhost LAMP server with sample data.

Here is the steps for a beginner to install magento e-commerce with sample data on Windows7 platform.

  1. Download and install latest version of  WAMP server.

    [ Tested Version: WAMP server 2.2e 32bit for Windows7 which contains Apache Version: 2.2.22, PHP Version: 5.4.3, MySQL Version: 5.5.24, phpmyadmin 3.5.1 ].

  2. Download latest versions of magentocommerce and magento sample data from magento community edition download page.
    [ Tested Version: magento- and magento-sample-data- ].

  4. Extract magento- Copy and paste Magento (or folder name) folder in to www directory of the WAMP server.

    ( You can access Windows7 local web server root directory by hitting ‘www directory’ on the menu of of the tray (extreme right side of the task bar) icon or C:\wamp\www . Tray icon will be green on the case of wamp is online. Otherwise you can put it online through menu. )

  5. Create a MySQL database support for Magento installation on your wampserver phpMyAdmin interface as shown below.

    ( You can access phpmyadmin interface on Windows7 by hitting ‘phpMyAdmin’ in the wamp menu or by entering http://localhost/phpmyadmin/ on your favorite web browser. )

    Write down the database name, user name, and password as you will need these later.

    a) Create New Database.
    phpMyAdmin -> Click on Databases menu -> Create database – Enter database name –> Create.


    b) Add a new database user with password.

    NB: It is not a good practice to use ‘root’ user for all databases. Read SQL injection attacks.

    phpMyAdmin -> Click on Users menu -> Hit Add user-> Add user pop up box appears -> Enter database username and password, select ‘Local’ on Host: dropdown option -> Drag down hit ‘Check All’ on Global privileges -> hit on ‘Add User’ button.


    c) Add user to the Database.

    phpMyAdmin -> Click on Users menu -> Select username -> Edit privileges


    Edit privileges pop up box appears, Drag down to Database-specific privileges menu -> Select Database name from drop down -> ‘Go’.


    The page will refresh-> Check all Database-specific privileges -> ‘Go’.

  6. Extract your Sample Data package (magento-sample-data- You will get a SQL file (magento_sample_data_for_1.6.1.0.sql) and a “media” folder.

  8. In the leftmost column of your phpMyAdmin you can see all databases. Click on the database name that you created for magento install, now click on ‘Import’ menu on the menu bar. Select the SQL file, which came in unpack of Sample Data package. Then click Go. Please be patient about 2 minutes, the file is being uploaded. Completion you will get a message, ‘Import has been successfully finished’. A list of your new tables will appear below your database name in the left-hand column. Now you can close phpMyAdmin.

  10. Go back to the sample data folder. Copy catalog folder inside the ‘media’ folder to the Magento ‘media’ folder on the www directory.

  12. Load the php extension curl.dll.

    WAMP server menu -> PHP -> PHP extensions -> Click on php_curl.
    In addition to this, you may also need to make sure you are loading: php_ mcrypt , php_pdo, php_pdo_mysql.

    You can check this under Loaded Extensions on WAMP server home page ( http://localhost/ ) or WAMP server menu -> PHP -> PHP extensions.

  13. Now enter http://localhost/magento(or folder name)/ on your browser for installation Step-by-Step Wizard or Enter http://localhost/ on your favorite web browser and select ‘magento’ folder under Your Projects.

    NB: Magento installation takes more time on each step installation in comparison with other CMS. Because magento uses a configuration based MVC on Zend framework, the setup contains approximately 350 tables on database.

    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 this 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).

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

NB: If your Magento demo store doesn’t show any products on frontend. Then resolve this problem via 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.

All the best!!!

Leave a comment

Before hitting COMMENT button, please fill * marked fields and the correct reCAPTCHA response.