Magento Export: Easy Steps to Export your Data

Are you facing difficulties with your daily Magento data exports? Do you find it gruelling to perform all the work? Well, look no further! This article will answer all your queries & relieve you of the stress of finding a truly efficient solution. Follow our easy step-by-step solution to help you master the Magento Export and easily export your data in various formats.

It will help you take charge in a hassle-free way without compromising efficiency. This blog aims at making the data export process as smooth as possible.

Upon a complete walkthrough of the content, you will be able to carry out a successful data export to a data warehouse or any destination of your choice for a fruitful analysis. It will further help you build a customized ETL pipeline for your organization. Through this article, you will get a deep understanding of the tools and techniques being mentioned & thus, it will help you hone your skills further.

Table of Contents

• Introduction to Magento
• Introduction to Content Management System
• What are the different types of Magento products?
• How to export data from Magento?
  • Performing a Magento Export for exporting product data as a CSV file
  • Performing a Magento Export for exporting product data as an XML file
  • Performing a Magento Export for exporting order data as a CSV file
• Conclusion

Introduction to Magento

Magento is an eCommerce platform that allows businesses to sell their products or services online. Magento is one of the most popular open-source software with a customer base of 240000+ customers and a market share of 30%. Magento eCommerce platform provides the correct tools to create excellent prospects to attract more customers, which allows selling more products.

Magento is open-source. Its source code is available under OSL (Open Software License), which can be easily modified by the developers to enhance the functionality according to their needs. The Magento software is mostly used by small businesses to power their online stores. There are several extensions available in Magento Marketplace that can help developers to customize the code.

Key features of Magento:

• Simple Design: Magento has an easy-to-use UI and provides a lot of customization options. You need not have a strong knowledge of any programming language or technical background to use its features or extensions.
• Easy Management: You can easily manage your products, services, contents, or offerings with Magento. You can add, edit, delete, and manage your online products easily without any technical assistance.
• Product Listing: Magento allows you to list an unlimited number of products and categories that you wish to sell. If you’re using the Enterprise edition, Magento customer support will help you set up a monthly/yearly plan, providing you access to thousands of customizable templates and plugins to help you build your website smoothly.
• Management & Maintenance: Magento has a pre-built user management system that allows you to manage the users (add/modify/delete) at your end. You can also provide them with access to your clients with adequate permissions, allowing them to manage their users. 
• Customizable Theme: Magento has a vast library of bundled themes and is readily available for you to use and customize to build beautiful websites. The available themes are easy to customize and can be done with basic programming knowledge.
• Optimized Search Engine: Magento provides an excellent and optimized search engine to use right out of the box. Magento allows you to combine your design with the SEO services offered for optimal search engine results. 
• Own Your Data: Magento allows you to own your data so that you can easily migrate. It would be traumatic if the services you’re using disappeared suddenly, and all of your data vanished in no matter of time. With Magento, you will own your data, your website and your content.

For further information on Magento, you can check the official website here.

Introduction to Content Management System

A content management system (CMS) is an application used to modify, edit, and publish content. It also allows organizing, deleting, and maintaining your content from a central interface. The Content Management System will enable you to manage your work in a collaborative environment

Magento provides flexible CMS solutions to its users. Users can choose either of the following as per their business needs:

• Magento Community Edition: The Community Edition allows you to download the open-source Magento Software from their website free of cost. The open/community version enables small businesses and developers to develop their online stores by modifying the contents as per their needs.
• Magento Enterprise Edition: The Enterprise Edition is the paid version with more features than the community version. This edition houses excellent customer support from Magento and is most suited for big businesses to power their online stores.

You can learn more about the Content Management System here.

Prerequisites

• Working knowledge of Magento.
• A Magento account.
• A general idea of working with text-based files.
• A general idea of products and listings.

What are the different types of Magento products?

Magento allows its users to list the following six types of products on their websites:

1. Simple Product: These are the products that don’t require users to configure them and are directly usable such as televisions, refrigerators, etc.  
2. Configurable Product: These are the products that require users to configure them. For example, if a user is planning to buy shoes, they can customize various configurations such as size, colour, design, etc. 
3. Grouped Product: Magento grouped products contain several products that are bundled together for selling. It can be a mobile phone with cases and chargers, a combination of tables and chairs, bedsheets and pillows, etc. You can define the specific price for the grouped product or shell out some discounts when the user purchases them.
4. Bundled Product: Users can choose various types of products and bundle them for purchasing. For example, if a user decides to buy a camera, they can choose from different lens options, memory card options, cover cases, etc., to customize their product. The price of the bundled products may vary according to the options chosen by the customer.
5. Virtual Product: Virtual products are the ones that cannot be shipped. It is usually a service that you can purchase, such as gym membership, events, tickets, restaurant bookings, etc.
6. Downloadable Product: These can be downloaded on your system and do not require shipping, such as eBooks, audiobooks, software, etc.

You can easily retrieve data about all of these products by performing a Magento Export.

How to export data from Magento?

Magento allows you to export the product and orders data in any text-based format, allowing you to manage and customize your products, data related to orders, etc. You can also migrate to other website providers (provided they have an option to import). CSV, txt, XML, Excel-XML, JSON, SQL, etc. are some of the formats that Magento supports.

You can use the following methods to export your Magento data in your desired format:

• Performing a Magento Export for exporting product data as a CSV file
• Performing a Magento Export for exporting product data as an XML file
• Performing a Magento Export for exporting order data as a CSV file

Performing a Magento Export for exporting product data as a CSV file

Launch Magento on your system and log in to your account with your credentials. Once you have logged in, select the system option from the panel on the top. Click on the System option, then dataflow and finally select the “export all products” option.

A new window will now open up. From the profile wizard choose the desired data store, where you want to export your data.  

Fill in the following details carefully:

• Data Transfer: Select the Local/Remote server option from the drop-down list.
• Data Format: Select the CSV/Tab separated option from the drop-down list.

Once you’ve selected the correct options, save your settings. Click on the run profile tab. A new pop-up will now open up, click on the run profile button.  

You’ll see various messages appear when the run profile option is selected. The run profile will save a file with the name export_all_products.csv under the var/export/ directory of your Magento installation. 

Use an FTP application to download the exported CSV data file to your system. You can now modify the CSV file to add, remove or edit your Magneto data using any spreadsheet application such as MS Excel, Google Sheets, etc.

This is how you can export your product data using the in-built Megento Export option.

Performing a Magento Export for exporting product data as an XML file

The in-built Magento Export option allows exporting data only in the CSV and Excel formats. To export your product data from Magento in the XML format, you need to use a programming interface and write code in the PHP language.
Create a PHP file called exportProduct.php. Once you’ve created the file, copy and paste the following lines of code in your file:

<?php
require 'app/Mage.php';
Mage::app();
$storename = 'default';
$file = "products-top10.xml";
if (file_exists($file)) {
    unlink($file);
}
try {
    $products = Mage::getModel('catalog/product')
        ->getCollection()
        ->addAttributeToSelect('*')
        ->setPageSize(200)
        ->setCurPage(1)
        ->setOrder('id', 'ASC')
        ->addAttributeToFilter('status', array('eq' => '1'));
    $doc = new DOMDocument();
    $doc->encoding = 'utf-8';
    $doc->formatOutput = true;
    $root = $doc->createElement("root");
    $doc->appendChild($root);
    $productsX = $doc->createElement("catalog");
    $root->appendChild($productsX);
     foreach ($products as $_product) {
            $product = $doc->createElement("product");
            $id = $doc->createElement("id");
            $id->appendChild(
                $doc->createTextNode($_product->getId())
            );
            $product->appendChild($id);
            $url = $doc->createElement("url");
            $url->appendChild(
                $doc->createTextNode(trim($_product->getData('url_key')))
            );
            $product->appendChild($url);
            $urlPath = $doc->createElement("url_path");
            $urlPath->appendChild(
                $doc->createTextNode(trim($_product->getProductUrl()))
            );
            $product->appendChild($urlPath);
            $title = $doc->createElement("title");
            $title->appendChild(
                $doc->createTextNode(trim($_product->getName()))
            );
            $product->appendChild($title);
            $sku = $doc->createElement("sku");
            $sku->appendChild(
                $doc->createTextNode($_product->getSku())
            );
            $product->appendChild($sku);
            $price = $doc->createElement("price");
            $price->appendChild(
                $doc->createTextNode(trim((int)$_product->getPrice()))
            );
            $product->appendChild($price);
            $formatedprice = $doc->createElement("formated_price");
            $formattedPrice = Mage::helper('core')->currency($_product->getPrice(), true, false);
            $formatedprice->appendChild(
                $doc->createTextNode(trim($formattedPrice))
            );
            $product->appendChild($formatedprice);
            $productsX->appendChild($product);
    }
    file_put_contents($file, $doc->saveXML(), FILE_APPEND);
} catch (Exception $e) {
    echo 'Eroror : - ';
    echo $e->getMessage();
}

Save the file and place it in the directory of your Magento server. Once you’ve saved the file, Magento will automatically generate a file called products-top10.xml in your directory.

This is how you can export your product data using the in-built Megento Export option.

Performing a Magento Export for exporting order data as a CSV file

Launch Magento on your system and log in to your account with your credentials. Once you have logged in, select the sales option from the panel on the top. Click on the Sales option, then select the export as CSV option.

Once the data export process is complete, a new CSV file containing order data will start downloading. Save the file in your desired folder. You can now modify the CSV file to add, remove or edit your Magneto data using any spreadsheet application such as MS Excel, Google Sheets, etc.

This is how you can export your order data using the in-built Megento Export option.

Conclusion

This article introduces you to the various methods that can be used to set up Magento Export. It also provides in-depth knowledge about the concepts behind every step to help you understand and implement them efficiently. These methods, however, can be challenging especially for a beginner & this is where Hevo saves the day. 

Visit our Website to Explore Hevo

Hevo Data, a No-code Data Pipeline helps you transfer data from a source of your choice in a fully-automated and secure manner without having to write the code repeatedly. Hevo with its strong integration with 100+ sources & BI tools, allows you to not only export & load data but also transform & enrich your data & make it analysis-ready in a jiffy.

Want to take Hevo for a spin? Sign Up for the 14-day free trial! and experience the feature-rich Hevo suite first hand.

Tell us about your experience of exporting your Magento data! Share your thoughts with us in the comments section below.