Magento officially announced that they’re no longer supporting Magento 1 and encouraging merchants to perform the difficult task of upgrading their stores to the latest version as soon as possible. If you decide not to go through the challenging migration process, your site and customer data are at risk as there will be no further security updates and quality fixes. Additionally, many of the Magento 1 extensions that you currently rely on would be outdated and you will not have access to new essential features.

Whether you’re using Magento 1 or Magento 2 for your online business, you might consider moving your website to a more user-friendly shopping cart. And WooCommerce would be a worth-considering option, as this platform is much more easier to use and also the most popular eCommerce platform in the world with a larger community.

In this article, we will provide you with step-by-step instructions on how to export Magento files to WooCommerce. Let’s get started!

Backup data before the import process

Great attention should be paid to the data backup process, as it can ensure the security of your business-critical data when unwanted contingency happens or in case the migration doesn’t go smoothly. The below instructions will guide you to accomplish this significant task.

  1. Log in to your Magento Admin Panel and click System -> Tools -> Backups.
  2. Magento - Backup Admin Site
    Magento – Backup Admin Site
  3. Depending on the type of Magento backup you need to create, select one of the following data backup types:
    • System Backup: create a complete backup of the database and the file system. You can also back up the media folder in the process.
    • Database and Media Backup: create a backup of the database and the media file.
    • Database Backup: create a backup of the database.
    Magento - Select Backup Type
    Magento – Select Backup Type
  4. A warning box will appear after that, read it carefully then click OK to proceed to the next step.
  5. If you want to put your store into maintenance mode during the Magento backup process, select the check box. You will receive a notification when the backup process is complete.
  6. Magento - Backup Options
    Magento – Backup Options

For more information about the backup process, check out this detailed How To Do Magento Backup Before Magento Migration.

How to export CSV files from Magento?

Export Products & Customers

Magento 1

  1. Go to System -> Import/Export -> Export.
  2. Magento 1 - Export Data
    Magento 1 – Export Data
  3. In the Export Settings section, specify the following:
    • Choose Entity Type
    • Accept the default Export File Format of “CSV”
  4. Magento 1 - Export Products & Customers
    Magento 1- Select Entity Type
  5. After that, the table Entity Attributes table will appear at the bottom. This section can be used to include or exclude data according to the entity attribute values.
    • To export only records with specific attribute values, select the required values in the Filter column.
    • To exclude an attribute from your report, choose the Skip checkbox at the beginning of the row.
  6. Magento 1 - Entity Attributes Section
    Magento 1 – Entity Attributes Section
  7. Scroll down and click the Continue button. Look for the file in the download location for your web browser.

Magento 2

  1. On your Magento 2 Admin sidebar, go to System -> Data Transfer -> Export.
  2. Magento 2 - Export Magento Files To WooCommerce
    Magento 2 – Export Data
  3.  In the Export Settings section, set Entity Type to one of the following:
    • Products
    • Customers Main File
    • Customers Addresses
    Magento 2 - Select Entity Type
    Magento 2 – Select Entity Type
  4. Select the Export File Format as CSV (the default option).
  5. Check the Fields Enclosure box if you want to enclose any special characters that might be found in the data as an ‘escape sequence’.
  6. Magento 2 - Export Settings
    Magento 2 – Export Settings
  7. Change the display of the entity attributes if necessary. The Entity Attributes section lists all the available attributes in alphabetical order. You can use the standard grid controls to search for specific attributes and to sort the list.
  8. Magento 2 - Filtered Entity Attributes
    Magento 2 – Filtered Entity Attributes
  9. The Entity Attributes section can be used to include or exclude data according to the entity attribute values.
    • To include specific attribute values, select the required values in the Filter column.
    • To omit an attribute from your report, choose the Exclude checkbox to the left of the attribute.
    Magento 2 - Exclude Attributes
    Magento 2 – Exclude Attributes
  10. After that, scroll down and click Continue in the lower-right corner of the page.
  11. Upon completion of the task, look for the file in the download location of your web browser. Now you can save or open the exported file as a spreadsheet. 

Export Orders

  1. In your Magento Admin Panel, go to Sales -> Orders.
  2. Magento - Export Orders
    Magento – Export Orders

    Please be noted that in order to export all your order data, click the Reset Filter or Clear All button to clear any unnecessary filters.

  3. From the Export to drop-down list, choose CSV file.
  4. Magento - Select File Format
    Magento – Select File Format
  5. Click Export. After that, check order details to make sure that everything was completed smoothly.

How to import CSV files to WooCommerce?

  1. Go to: WooCommerce > Products.
  2. Select Import at the top. The Upload CSV File screen displays.
  3. Import Products From A CSV File
    WooCommerce – Import Products from a CSV File
  4. Select Choose File and the CSV file you wish to use.
  5. CSV delimiter (Advanced option): Generally CSV elements are separated by a comma. If you are using a different delimiter in your file, you can set it here.

  6. Click Continue.
  7. The Column Mapping screen displays, and WooCommerce automatically attempts to match or “map” the Column Name from your CSV to Fields.

    Map CSV Fields to Products
    WooCommerce – Map CSV Fields to Products
  8. Use dropdown menus on the right side to adjust fields or indicate ‘Do not import.’
  9. Adjust Fields from Dropdown Menus
    WooCommerce – Adjust Fields from Dropdown Menus

    *Please note that any unrecognized columns will not be imported by default.

  10. Select Run the Importer. Wait until the Importer is finished and do not refresh or touch the browser while in progress.

After that, you can follow the same procedure for the rest of your CSV files.

Final words

Through this article, we believe that now you can clearly understand how to export Magento files to WooCommerce. However, this process can cause you a great deal of time and effort, as you will have to compare the database structure of both platforms to ensure a proper import. There’s also a high chance of unexpected errors you might encounter throughout the process.

If you are looking for an optimal solution for your store transfer, LitExtension is there for you. With our service, all of your important data will be migrated to your new WooCommerce store automatically, accurately and securely.

Our support team is available 24/7, do not hesitate to contact us if you have any questions.