How to Move Data from Etsy to Magento
Importing products from Etsy to Magento is a way-out if you have goods at both places individually and want to copy listings from a marketplace to your shop, without the need to do it manually.
If you already have products at this unique sales channel, you can export your listings from Etsy. Magento has built-in import method, but it has the list of mandatory columns for import and what is more, their names should be identical to database names, otherwise you will get the error.
Export from Etsy
After logging in to your Etsy account, go to: Your Shop -> Settings -> Options -> Download data tab.
Press ‘Download CSV’ button to get your listing exported into spreadsheet.
Import to Magento
You can edit your file received from Etsy shop to make it fit shopping cart requirements and get ready for import via Admin. Check default file format and requirements for columns at:
Get ready to spend a few minutes/hours or even days on additional modifications (depending on your skills and patience 🙂
Once the file is ready, upload it from your back-end.
Alternatively, you can use more flexible product upload tool to import from Etsy into Magento shop. Using Store Manager for Magento application, you are able to overcome the difficulties connected to file adjusting.
To import Etsy file to Magento with Store Manager you have to do the following:
- Download zip with settings. - https://emagicone.com/file_examples/Magento/etsy_import.zip
- Having Store Manager for Magento installed at your PC, run Import/Export Wizard - (or download free version and proceed with no fees)
- Load settings from .cfg file you have downloaded at the first step and load your exported file from Etsy marketplace.
- Click ‘Next’ a few times till you see ‘Finish’ page reporting that products were imported. You do not need to make any changes, all settings are pre-set and saved into configuration file.
- Check the results at your site.
Unzip it and you will see there CSV file example as well as file with settings.
If you do not have it installed:
Download Store Manager and import from Etsy to Magento FREE!Download Now!
Your products were imported to category ‘Etsy’ at your site. You can find your goods there and if you need massively re-categorize using ‘Assign Categories’ option.
Import via Store Manager offers you the following benefits:
Using built-in import wizard of Store Manager allows you to link csv columns to database fields. So your ‘Title’ CSV column from Etsy can be assigned to ‘Name’ database field right during import without the need to return and edit your spreadsheet.
Price and Other On-The-Fly Data Adjustments
You can maintain separate prices on every sales channel or change them right during import using the application, setting up margins (mark-ups) on-the-fly. This concerns not only prices, but other data that you want to be modified. Contact us and we will advise you on your particular case.
No Manual Work
Best part of it is that we have made the needed settings for you. So you just need a few simple clicks to load pre-saved configuration and upload the file you received from Etsy.