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:
- Importing and Managing Quantity
- Importing Variation Listings
- A Breakdown of the Data That Imports From Etsy
- Importing Your Shipping Profiles
- An Important Note About Etsy Product Attributes!
- Related Articles
Importing and Managing Quantity
TIP:
Etsy inventory updates may increase visibility of your listings according to various Etsy seller resources. 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
Variations import so long as a child SKU is provided and the items don't use custom variation types. Parent SKUs will import with the listing id. See Variation Listings on Etsy for more information.
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 |
Your Etsy SKU. If you do not use a SKU, we import your listing id. |
|
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 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: fields |
Details specific to the Etsy marketplace import into fields that begin with etsy:. The complete list of etsy: Marketplace Level fields is: 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.
Comments
Article is closed for comments.