How to Export Shopify Products to Etsy

- Our extensions, Shopify

how to export shopify products to Etsy

The following article explains how to export Shopify products to Etsy. While both systems offer import and export instruments that support basic data transfers, it is still impossible to establish a direct connection between them. We, however, know a hassle-free approach to the Shopify Etsy integration. Below, you will learn how to sync product data between Shopify and Etsy in just a few clicks. 

First of all, you need to export products from Shopify. We use the Import & Export Tool because it not only creates a file with your product feed in multiple formats suitable for third parties but also lets you automate the mapping of Shopify product data to Etsy listing fields. 

Next, we focus on the import side of the Etsy Shopify integration. While it is true that Etsy does not allow spreadsheet bulk imports via admin, we use Easy Listing Uploader to provide the update. Let’s describe each part of the integration in more detail to master the export of Shopify products to Etsy.

Export Shopify Product Feed Suitable for Etsy

Follow these steps to export product data from Shopify in a format suitable for Etsy. 

Create a New Shopify Product Export Profile

Create a new export profile to extract product data from Shopify with the Import & Export Tool:

Export Shopify Products to Etsy: add new export profile

  1. Proceed to your Shopify admin -> Apps and select Firebear Import & Export Tool.
  2. Choose “Export” and click the “New Profile” button.

Configure Basic Parameters of Shopify Product Export

You are on the “Configure export” screen. Our tool lets you automate product export and configure other parameters important for the Shopify Etsy integration.

export shopify products to Etsy: XLSX format and other basic export configurations

  1. Specify the name for your profile – “Shopify Etsy Product Export”.
  2. Choose products as your export entity.
  3. Enable the On Schedule if you want to automatically export Shopify products to Etsy on a regular basis. 
  4. Configure email notifications to stay informed on the results of your automated exports.
  5. Select your preferred file formatXLSX since it is used by Easy Listing Uploader. You can also export your data as CSV, XML, or Google Sheets files.
  6. Choose an export source: you can opt for file downloads to provide your product CSV to Etsy manually. Also, our app supports FTP transfers and Google Drive exports. 
  7. You can specify a lower bunch size if you have a server with limited resources
  8. Click “Continue”.

Map Your Shopify Product Data to Etsy Listing Fields

Etsy’s Easy Listing Uploader offers a streamlined system for uploading products in bulk, which, however,  requires preparing a comprehensive CSV file with the following key columns: title, description, price, quantity, currency_code, tags, materials, images, and variations. 

Correctly mapping your CSV columns to Etsy’s fields is crucial to ensure accurate product listings. Note that the selection of required fields depends on the tool you use. See the Etsy Listing Fields chapter. 

As for the Import & Export Tool, it lets you easily map Shopify column names to Etsy’s fields. Just specify Etsy’s listing fields to the right of the corresponding Shopify product attributes. 

export shopify products to Etsy: attribute mapping on the Shopify side

Furthermore, it is possible to deselect any columns that should be excluded from your Shopify product export to Etsy.

The Import & Export Tool also lets you arrange columns in the order required for the transfer. Just select a column with a Shopify attribute and drag it to the preferred location.

Save this column order, attribute selection, and mappings for the next exports.  You will reduce the amount of manual interactions used in further exports of Shopify products to Etsy!

Filter Out Your Product Feed

Now, you can add filters to export only particular products from Shopify to Etsy. 

For instance, a filter for out-of-stock products looks as follows:

Export Shopify Products to Etsy: filters

  1. Press the “+” button;
  2. Select a product property – Variant Inventory Qty;
  3. Select an operator – Equals;
  4. Specify a value – 0.

Run Shopify Product Export

Click the Save & Close button to save your Shopify product export profile or hit the Export button to transfer your products immediately. 

Export Shopify Products to Etsy: export progress

Read the Improved Import & Export Tool manual for more detailed information on the enhanced Shopify export capabilities associated with the app.

Upload Shopify Products to Etsy

Now, let’s face the second part of exporting products from Shopify to Etsy. You’ve just exported an XLSX file suitable for upload to Etsy, so use Easy Listing Uploader and follow these steps to finish the synchronization:

  1. Sign up for Easy Listing Uploader, choose your plan (there is a free option), and proceed to the Easy Listing Uploader Worksheet.
    export shopify products to Etsy: XLSX template suitable for Etsy upload
  2. You will find the relevant columns to fill out there. 
  3. Read the Instructions tabs at the bottom of the worksheet.
  4. You can manually change column names and edit other information in the listing data before uploading your XLSX file. 
  5. Proceed to the Easy Listing Uploader Website and find the Upload File Button on your account Dashboard. Upload your XLSX file with Shopify products by clicking the ‘Upload File’ button.
    export shopify products to Etsy: Easy Listing Uploader tool
  6. This will bulk upload your Shopify products to your Etsy Shop.

Etsy Listing Fields

Use the following listing fields to export Shopify products to Etsy with Easy Listing Uploader: 

Field Name Label Name Accepted Values Example Required?
state The Listing State create‘, ‘update‘, ‘don’t_update update +
listing_id New Listing = Leave Blank Existing Listing = Required* Numerical Value 49389028 +
sku (Product Identifier) A SKU helps you identify your product Example- Product-Name-001 +
title Product Title (Maximum 140 characters, no special characters, and no HTML tags) Pet Cat Bowl (Personalised Name) +
description Product Description Maximum 5000 characters allowed

(No HTML tags and No symbols allowed)

A customizable bowl for your cat. +
price Product Price Price of your product 99.99 +
currency_code Currency USD, GBP, EUR, AUD, CAD, NZD USD +
quantity Product Quantity A Whole Number 100 +
language Listing Language en, de, fr, it, es, nl en +
tags Tags / Keywords Up to 20 characters per tag; up to 13 tags separate by comma. cat bowl, pet bowl, pet accessories, pet toys +
who_made Who made the product? i_did / collective / someone_else someone_else +
is_customizable Can the item be personalized? No = 0 | Yes = 1 1 +
when_made made_to_order When was the product made? made_to_order, 2020_2020, 2010_2019, 2001_2009, before_2001, 2000_2000, 1990s, 1980s, 1970s, 1960s, 1950s, 1940s, 1930s, 1920s, 1910s, 1900s, 1800s, 1700s, before_1700 before_2021 +
Category Name The name of the category the product will be listed in Dropdown Select Menu PetSupplies +
taxonomy_id The numeric ID of the listing’s category The seller taxonomy ID of the listing.

(The taxonomy ID will automatically Generate when you select the appropriate Category)

85834938 +
shipping_template_id The numeric ID of the shipping The numeric ID of the shipping template associated with the listing. 85849302 +
is_supply Is the product a supply item or a finished product? If your item is a supply item, Select TRUE

If your item is a finished product, Select FALSE

TRUE +
Main Image URL Main Image URL Recommended Size for Images of at least 2000 pixels wide for best clear results.  Images must be supplied as a URL. Each URL must be publicly accessible via the internet. www.product-img-main.com +
Image 2 Image 2 URL Recommended Size for Images of at least 2000 pixels wide for best clear results.

(Images must be supplied as a URL.

Each URL must be publicly accessible via the Internet)

www.product-img-002.com
Image 3 Image 3 URL www.product-img-003.com
Image 4 Image 4 URL www.product-img-004.com
Image 5 Image 5 URL www.product-img-005.com
Image 6 Image 6 URL www.product-img-006.com
Image 7 Image 7 URL www.product-img-007.com
Image 8 Image 8 URL www.product-img-008.com
Image 9 Image 9 URL www.product-img-009.com
Image 10 Image 10 URL www.product-img-010.com
materials What material is the product made from? ceramic, concrete, cotton, fiber, foam, glass, leather, metal, natural textiles, nylon, paper, plastic, polyester, rubber, stone, synthetic textiles, vinyl, wood, Other cotton
occasion Select Occasion (If no occasion is relevant, select ‘Empty’) EMPTY, anniversary, birthday, christmas, easter, eid, engagement, fathers_day, graduation, halloween, hanukkah, mothers_day, new_baby, new_years, retirement, st_patricks_day, sympathy, thanksgiving, valentines, wedding anniversary

Final Words

Exporting Shopify products to Etsy requires using various third-party tools that optimize data transfers and editing. However, using the proper solutions may help you reduce the time and effort necessary to exchange product data between the two systems. In the case of the Import & Export Tool and instruments similar to Easy Listing Uploader, it is even possible to automate some routine processes, such as field mapping. Furthermore, you may use the Import & Export Tool in combination with Etsy exporters to import product reviews from Etsy to Shopify. Our solution ensures your product feeds are accurate, up-to-date, and optimized for better visibility and sales across multiple channels. Please follow these links for detailed information on the Import & Export Tool for Shopify and its ability to automatically export product feeds to any external system:

FAQ: Shopify Product Export to Etsy

Can you export products from Shopify to Etsy?

By default, you can easily export products from Shopify, but importing them to Etsy is not possible. You have to recreate your catalog manually unless you use a combination of tools like the Import & Export Tool and Easy Listing Uploader.

How to sync products from Shopify to Etsy?

You need to use a couple of additional tools on both sides to sync products from Shopify to Etsy and back. Install the Import & Export Tool on your Shopify website. It will help you automate product data imports and exports on Shopify’s side. Next, use Easy Listing Uploader and Etsy’s default exporter to import the feed from Shopify and provide the actual data back.

Can I sell Shopify products on Etsy?

Yes, you can sell Shopify products on Etsy. However, you will need to spend some time and effort synchronizing your products between the two systems. Note that the built-in tools are not enough for flawless synchronization. If you want to reduce repetitive tasks associated with the Shopify Etsy integration, use the Import & Export Tool and similar apps.

Can you import listings to Etsy?

Unfortunately, Etsy doesn’t offer a way to import listings. You have to manually create each product and it doesn’t seem that Etsy is going to add the missing functionality since it is supposed to be a place where unique items are represented.