Marketplaces like Etsy, eBay, and Gumroad make it easy to start and grow physical goods businesses online. While Etsy is awesome because it includes a built-in community of buyers, you might decide to choose a self-hosted solution to avoid the fees they charge to keep their service running. If you’re migrating to WooCommerce from Etsy, you can do it using these 3 straightforward steps.
Step 1: Download a Spreadsheet of Etsy Listings and Sold Orders
Etsy makes it easy to download listings and orders from your web store. The official documentation for how to download your data is here.
Step 2: Install WP All Import and add-ons on the destination WooCommerce site
Now it’s time to import all of the data into WooCommerce. While you might think the native product import functionality of WooCommerce would be sufficient, it might have a hard time with the way image URLs are formatted from Etsy’s CDN. Instead, WP All Import (Import Pro Package) is more than up for the task. Make sure to install WP All Import, WooCommerce Add-On, and User Add-On.
Tip: If you don’t want to pay for WP All Import, it’s free as a part of Nexcess Managed WooCommerce plans.
Step 3: Import data files into WooCommerce
Now that you have WP All Import installed, it’s time to start mapping fields and importing the data. Order of operations is important. Make sure to import products, then users, then orders. Doing it in any other order may lead to products, users, and orders not being linked correctly. While mapping fields from your data export is mostly straightforward, I’ll be providing some gists below to help as you’re migrating to WooCommerce from your Etsy store. You might have to tweak field mappings a little for your particular situation.
A quick note on importing customers / orders: Because of the way Etsy’s exports are formatted, you’ll need to process the customer / order spreadsheet once to create customers, and then a second time to create orders, and associate those orders with existing customers.
Tip: Before importing orders, make sure to set up your WooCommerce payment, shipping, and tax options.
Finish Migrating to WooCommerce from Etsy
That’s it! Hopefully these tips have helped you save some time and frustration. I’m forever a huge fan of using open source software because of the extensibility and community that often comes along with it.
Thanks to Pragmatic Agency for providing sample data for this article.