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.
- Log in to your Magento Admin Panel and click System -> Tools -> Backups.
- 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.
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
- Go to System -> Import/Export -> Export.
- In the Export Settings section, specify the following:
- Choose Entity Type
- Accept the default Export File Format of “CSV”
- 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.
- Scroll down and click the Continue button. Look for the file in the download location for your web browser.
- On your Magento 2 Admin sidebar, go to System -> Data Transfer -> Export.
- In the Export Settings section, set Entity Type to one of the following:
- Customers Main File
- Customers Addresses
- 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.
- In your Magento Admin Panel, go to Sales -> Orders.
- From the Export to drop-down list, choose CSV file.
- Click Export. After that, check order details to make sure that everything was completed smoothly.
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.
How to import CSV files to WooCommerce?
- Go to: WooCommerce > Products.
- Select Import at the top. The Upload CSV File screen displays.
- Select Choose File and the CSV file you wish to use.
- Click Continue.
- Use dropdown menus on the right side to adjust fields or indicate ‘Do not import.’
- Select Run the Importer. Wait until the Importer is finished and do not refresh or touch the browser while in progress.
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.
The Column Mapping screen displays, and WooCommerce automatically attempts to match or “map” the Column Name from your CSV to Fields.
*Please note that any unrecognized columns will not be imported by default.
After that, you can follow the same procedure for the rest of your CSV files.
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.