How to export data from Magento 1.X

Modified on Tue, 7 Jan, 2020 at 12:34 PM

This article will show you how to export your client and product data from Magento 1.X, ready to be cleaned and re-uploaded to a new platform.


You will need to export all product and client data, so applying filters may stop your full inventory or client list from exporting.




These are the steps you'll need to take once you have logged in to Magento:


1.On the Admin menu, select System > Import/Export > Export.
2.In the Export Settings section, do the following:
Export Settings
a.Set Entity Type to one of the following:
  • Products
  • Customers Main File
  • Customer Addresses
b.Accept the default Export File Format of “CSV.”
3.In the Entity Attributes section, you can include or exclude data to be exported according to the entity attribute values.
  • To include records with specific attribute values, set the required values of the attributes in the Filter column.
  • To omit an attribute from the export, select the Skip checkbox at the beginning of the row.
Export Customers Based on Attribute Value
4.Scroll down and click the Continue button in the lower-right corner of the page. Look for the download prompt in the lower-right corner of your browser.


Note: If you are having any issues while exporting your data from Magento, you'll need to contact Magento support. They will be able to help you through these steps.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article