How to import your Etsy products to your Shopify store

How to import your Etsy products to your Shopify store

If you have an Etsy shop with a couple of pages of items or products, the thought of opening a Shopify storefront and transferring all of your products over may feel a bit overwhelming. If you are really serious about doing so, don’t fret because there is a much easier way to do it other than manually entering all the data one listing at a time. Yup, you can easily import your Etsy products to your Shopify store with just a few steps!

First things first, you need to back up all your data and information

Whether or not you are happy with your current Etsy listings, it is a must that you backup all your information into a CSV file. Better safe than never. If something were to happen to your shop, either accidentally, your choice, or not, this CSV file will collect all your information as a backup and the process will only take a few minutes.

I suggest that you back up everything a couple of times a year, even if you don’t intend to transfer them to Shopify or to any other shopping carts.  You have invested a lot of time and effort in creating your listings, so this will ensure that you won’t lose any of this valuable stuff.

Next step, is to learn how to create a CSV file from Etsy

You can download all your listing information from Etsy (a CSV file that includes the listing title, description, price, currency code, quantity, tags, materials, and image URLs).

This file can also be imported into most spreadsheet applications, including Microsoft Excel, Numbers, and Google Spreadsheets.

To download your listing information, sign in and go to Your Etsy shop > Go to Shop settings > Then Options and click the Download Data tab. From here, click the Download CSV button to save the file onto your computer.

You may also download your Etsy bill history and sold order history as CSV files.

Etsy CSV Download Screenshot 1

Etsy CSV Download Screenshot 2

Now, here’s how to import your CSV file into your Shopify Store

Shopify’s navigation menu is quite easy to understand. Since this import file is for your products, you will find the link in the PRODUCT section of your Admin Page.

Once on your product section, you’ll see three choices in the top right corner: Export, Import, Add a Product. You just have to click the IMPORT button and a pop-up box will appear to ask you to browse for the file that you want to import.

Honestly, as I walked through these importing a CSV process myself for the first time, I kept wondering if I was really doing it right. It’s a good thing that Shopify understands that. And once I clicked on the Etsy file for downloading, another pop-up box appeared and asked if this file (showing me a preview) looked somewhat familiar. Yeah…..I did it right!!

Import CSV Screenshot 1

Import CSV Screenshot 2

Step by step process:

  1. From your Shopify admin, click Products (or press G P P):
  2. Click Import
  3. Click the Etsy icon to get the free importer from Shopify. On these pages, you will find instructions detailing what you need to do to import your products into your Shopify store
  4. If you have an existing CSV file, click Choose File
  5. Locate your CSV file, then click Open.
  6. Click Upload file.

Note: Your CSV file can’t exceed 15MB. If you get an error when trying to upload a new CSV file, most likely it has exceeded the size limit.

If your CSV file was successfully uploaded, you should receive an email from Shopify to the email account used to setup your Shopify web store, saying that the process was completed and successful.

How to edit your Imported Information

At first, I was kind of hesitant to show all my Etsy information on my brand new Shopify website because I have not checked if everything looked good. It’s a good thing that Shopify makes editing product information easy to do. While you are still on the PRODUCT section, you just need to check the box of all the newly imported products. This will activate a menu with a “bulk actions” option. When you click “hide selected products,” your customers won’t be able to see any of these listings, until you are done making your changes or you are fully ready to make them available.

Import Bulk Options

I appreciate finding out tips and tricks that make it easier for me to handle my daily tasks of keeping my online business running smoothly. If you have an online Etsy & Shopify store and have any business tips that help you, I’d love to hear about them.


No Comments

Post a Comment