How to configure Magmi and export product

How to configure Magmi and export product

August 24, 2026 · Illustrated author avatarBy Stefan Bogdanescu
How to configure Magmi and export product

Configuring Magmi for Magento Product Export and Import

The Magmi application is a powerful tool that simplifies the process of importing and exporting large volumes of data in Magento. It provides an easy-to-use interface to manage your product catalog efficiently.

Configure Your Magmi Environment

Before you start, ensure your server meets the requirements:

  • Apache or Nginx
  • PHP 5.3+
  • MySQL/MariaDB

Download the latest version of Magmi from their official repository and extract it into your Magento root folder (usually public_html if you’re using cPanel).

Connecting to Your Database

Magmi uses a separate database for its operations. Create a new MySQL database and user via your cPanel or PHPMyAdmin.

CREATE DATABASE magmi;
GRANT ALL PRIVILEGES ON magmi.* TO 'magmi_user'@'localhost';
FLUSH PRIVILEGES;

Open the magmi/conf/magmi.ini file in a text editor. Locate the [general] section and update the database details:

[general]
; Database
db_type=mysql
db_host=127.0.0.1
db_name=magmi
db_user=magmi_user
db_pass=mypassword

Save your changes.

Accessing the Magmi Interface

Open a web browser and navigate to http://yourdomain.com/magmi/. You should see the Magmi login screen. Log in using the credentials you set earlier (by default, it’s ‘admin’ for both username and password).

Exporting Products with Magmi

  1. Click on the Export tab.
  2. Choose your source table—usually catalog_product_entity.
  3. Select the fields you want to export by clicking on the Select All button at the top right of the field selection grid.
  4. Choose a format: CSV or XML.
  5. Set the output file path and name (relative to the Magmi root directory).
  6. Click Launch.

Magmi will begin processing your export request. Once complete, you can download the generated file from the specified location.

Importing Products with Magmi

  1. Click on the Import tab.
  2. Choose your target table—again, catalog_product_entity.
  3. Select a CSV or XML file using the Select File button.
  4. Map each column in the import file to the corresponding Magento attribute field.
  5. Set any special options like whether to update existing products or create new ones.
  6. Click Launch.

The import process starts, and Magmi will log progress and errors in real-time.

Conclusion

Magmi is an invaluable tool for managing your product catalog at scale. With proper configuration of the database connection and careful selection of export/import options, you can streamline your workflow significantly.

Remember to keep your Magmi files up-to-date with the latest version from their GitHub repository: https://github.com/magmi/Magmi

Additionally, consider using Laravel Company’s managed Magento hosting for a stable and secure environment optimized for Magmi operations.

Catalog Database Admin Configuration

Our network