Importing Live Listings From Etsy (Including What Data Imports and How SKUs are Assigned)

We have the ability to import all of your Etsy product and listing details when we import your live listings. This article details how that information is stored in Solid Commerce. It also describes how SKUs import.

 

What's we'll cover:

  1. How SKUs Import
  2. Importing and Managing Quantity
  3. Importing Variation Listings
  4. A Breakdown of the Data That Imports From Etsy
  5. Importing Your Shipping Profiles
  6. An Important Note About Etsy Product Attributes!
  7. Related Articles

 

How SKUs Import

Etsy doesn’t use SKUs. To import a SKU with your listings, we recommend adding your SKUs to the bottom of the descriptions on Etsy. During import, we will extract the SKUs from the descriptions and use them as the Product Custom SKUs and Warehouse IDs. That will allow us to associate the imported listings with items that already exist in your account—providing proper inventory management.

 

To Add SKUs to Your Etsy Listings:

Create a new line at the bottom of your description and enter: [SKU:<your SKU>] (Replace <your SKU> with the correct SKU of your item).

 

If You Don't Add SKUs

If you don’t add a SKU to the description, we will assign the Etsy listing ID as your SKU during import. We won't recognize the items as they import, even if they already exist in your account. We will create them as new products and add them to your Warehouse.

In order to properly manage inventory after importing, you will need to use our PO Source merge functionality to merge the new items with your existing products.

Please keep in mind that the product merge actually deletes the product you don't want to keep. You will lose any product details associated with the imported Etsy listings, such as images or data in the etsy attr: product attribute fields. For more info about the PO Source merge feature, see Merging Imported Listings With Different SKUs Into One Product (Merging PO Sources).

 

Variations Use Listing IDs Instead of SKUs

Etsy doesn't allow child items on variation listings. Due to this limitation, we cannot assign your SKUs to parent or child items when we import variations. Adding [SKU:<your SKU>] to your description won't work for variations. Instead, we assign the Listing ID as the SKU of the parent item and add additional information to create a unique SKU for each child item. For full details, please see Variation Listings on Etsy.

 

Importing and Managing Quantity

IMPORTANT!
According to Etsy's documentation, any quantity updates we submit may trigger a fee.

While that is the official word from Etsy, we haven't been charged when we've updated the quantity on our test listings. We also haven't heard of clients being charged. However, that's no guarantee that Etsy won't charge you.

When we import your listings from Etsy, we set the Listing Quantity Expression to lq. An expression of lq instructs us to submit the entire quantity from your Warehouse to Etsy. Any sales on other marketplaces, or inventory updates you make, will cause us to submit new quantities to Etsy, which could result in fees.

To try and minimize quantity updates, we recommend updating the Listing Quantity Expression to the formula IIF(lq>x,y,lq). It will hide your true inventory from Etsy. To update it in bulk, use the etsy:qty exp field in Excel. The other minimum required columns are: results, product custom sku, warehouse id, list name. To learn how to populate the x and y values in the formula, see Using the Listing Quantity Expression to Control the Quantities on Your Listings.

Additionally, when you list an item with a quantity of greater than one, your listing will auto renew when someone places an order on Etsy. The renewal will result in a relisting fee. For more information, see https://www.etsy.com/legal/fees and https://www.etsy.com/help/article/2552.

 

Importing Variation Listings

Variation listings also import. However, Etsy doesn't use SKUs or allow child items, so Etsy variations cannot be managed in Solid Commerce the same way as variations from other marketplaces. For more details, see Variation Listings on Etsy.

 

A Breakdown of the Data That Imports From Etsy

NOTE: Most of these fields can be viewed through the Solid Commerce user interface. However, most of them can only be edited through Excel.

Field Name Field Description and Valid Values

product custom sku

Etsy does not use SKUs. We will save Etsy's Listing IDs as your Product Custom SKU unless you add SKUs to your listings.

For full details, please see the How SKUs Import section at the top of the article.

warehouse id

We save the Product Custom SKU as the Warehouse ID too.

etsy description

The description of your item.

etsy:sell price exp

The price of your item.

etsy:qty exp

This field controls the quantity we submit to Etsy. By default, it is populated with lq during the import. We recommend updating this field to the formula IIF(lq>x,y,lq) to try and minimize listing update or relisting fees.

To learn more, see the Importing and Managing Quantity section of this article.

etsy:shippingtemplateid

The ID number Etsy assigned to your shipping profile. It can also be found in the URL when you edit your profile through Etsy.

etsy:categoryid

The ID number Etsy assigned to the category on the marketplace.

 image file

Your main Etsy image.

alternate image file 1, 2, 3, 4

Up to four alternative Etsy images.

product weight

The weight of the product.

product dimensions

The width, height, and length of the item.

ShopSectionID

The ID number of the section of your shop where the item is listed.

NOTE: This field is currently only visible in the User Interface. It cannot be edited in Solid Commerce or Excel. We also don't support shop sections during listing and you aren't able to update them on live listings through Solid Commerce.

etsy attr: product attributes

Information about your products imports into product attribute fields that begin with etsy attr:. For full information, see the next section An Important Note About Etsy Product Attributes!

The complete list of etsy attr: Product Level fields is:
etsy attr:who_made, etsy attr:when_made, etsy attr:materials, etsy attr:is_customizable, etsy attr:occasion, etsy attr:recipient, etsy attr:style, etsy attr:tags

etsy: fields

Details specific to the Etsy marketplace import into fields that begin with etsy:.

The complete list of etsy: Marketplace Level fields is:
etsy:etsytitle, etsy:issupply, etsy:nontaxable, etsy:currencycode, etsy:processingmin, etsy:processingmax, etsy:listinglanguage,

and covered in this table already: etsy:sell price exp, etsy:qty exp, etsy:shippingtemplateid, etsy:categoryid

 

Importing Your Shipping Profiles

When we import your listings, we add the Profile IDs of your shipping profiles to your products. If you offer flat rate shipping on your listings, this works perfect. You are good to go!

Unfortunately, Etsy doesn't support calculated shipping through the API. If you offer calculated shipping on your listings, we still import the shipping profile. However, if you click the Update Listings button or relist imported items, Etsy doesn't recognize the calculated shipping profile. As a result, Etsy removes the product weight and dimensions from your listings.

Until Etsy adds support for calculated shipping, best practice is to assign the Profile ID of a flat rate shipping profile to your imported listings.

To learn how to find a Shipping Profile ID and populate it in a spreadsheet, see Listing a Product to Etsy Using a Spreadsheet . If you ever use the Update Listings button or relist closed items, you will need to manually reassign your calculated shipping profile through Etsy's user interface. Our listing article also explains how to do that.

 

An Important Note About Etsy Product Attributes!

IMPORTANT!
The fields that begin with etsy attr: are created as Solid Commerce product attributes during import. These are Product Level details, not Marketplace Level.

When we import an item for the first time, we create the product and add it to a Warehouse. If we encounter that same SKU when importing from another marketplace in the future, we only import the Marketplace Level listing details. We don't update the Product and Inventory Level information that is already stored in the system.

This process affects Etsy imports. When we import an item that already exists in your Solid Commerce account, we aren't able to add the etsy attr: Product Level fields. If you need to relist the item in the future, you will need to populate any attributes that are required.

The full list of Etsy product attributes is:
etsy attr:who_made, etsy attr:when_made, etsy attr:materials, etsy attr:is_customizable, etsy attr:occasion, etsy attr:recipient, etsy attr:style, etsy attr:tags

Fields that begin with only etsy: are marketplace specific. They import whether an item already exists in Solid Commerce or not.

 

Related Articles

 

Back to top

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.