This article will show you how to use a spreadsheet to quickly and efficiently list to Etsy.
IMPORTANT!
Etsy listings expire after four months. We will automatically relist your items when they expire unless you select them in your Solid Commerce Market List and click the Close Listings button. Etsy's listing fees will apply to relisted items.
What we'll cover:
- Downloadable Excel Template & List of Etsy Category IDs
- Managing Quantity
- Offering Calculated Shipping and Populating Product Dimensions and Weights
- How to Find Shipping Profile IDs Inside Etsy
- Required Fields
- Optional Fields
- Variation Listings
- Uploading Your Spreadsheet
- Related Articles
Downloadable Excel Template & List of Etsy Category IDs 
The following Excel template includes the columns required to list to Etsy through Solid Commerce. You can add Optional Fields if you like. The file also includes an example item.
To post your items in the correct category, you need to provide the ID number Etsy assigned to that category. Here is a list of IDs:
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.
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.
Offering Calculated Shipping and Populating Product Dimensions and Weights
Etsy hasn't added support for calculated shipping to their API yet. That means you cannot use a calculated shipping profile when you list items from Solid Commerce.
If you want to offer calculated shipping, you can easily add it after your items list:
1) Use a standard shipping profile when you list your items through Solid Commerce. Include product dimensions and a weight.
2) Upload your spreadsheet.
3) Wait for the item to list on Etsy.
4) From Etsy's Listings page, click the Quick edit button. Select a calculated shipping profile from the drop-down under Shipping Profile and add it to each listing.
How to Find Shipping Profile IDs Inside Etsy
The shipping template ID is found in the URL of the shipping profile.
1) Log into Etsy
2) Go the Shop Manager menu -> Settings -> Shipping settings
3) Find your Fixed prices shipping profile. Click on the number in the Active listings column.
NOTE:
If your shipping profile is not assigned to any active listings, you need to assign the profile to an existing listing first.
Required Fields
Column Header | Field Description and Valid Values |
results |
Leave this field blank. It will automatically populate if you upload the file using the Solid Commerce Excel Add-In Tool. |
product custom sku |
Etsy doesn't have a SKU field. We will automatically add the SKU to the bottom of your Etsy description. This allows us to maintain control over the listing. EXAMPLE: [SKU:Funky-Socks-01] |
warehouse id |
The Warehouse ID of your product. |
etsy:etsytitle |
The title of your Etsy listing. * The maximum length for a title is 140 characters. * The following characters may not be used: $ ^ ` |
etsy description |
The description of your product. Avoid using HTML. |
etsy:price exp |
The price of your item. One option is to enter a number with up to two decimal places. The other option is to enter the word cost, or simple formulas with the word cost, such as cost*1.5 or cost+5. More complex formulas like cost*1.2+5 or ((cost*1.2)+5) work as well. Don't enter currency symbols in this field. |
etsy:qty exp |
This field controls the quantity we submit to Etsy. In order to minimize the update fees that Etsy charges, we recommend using the formula: IIF(lq>x,y,lq). For more info, see Using the Listing Quantity Expression to Control the Quantities on Your Listings. |
etsy:shippingtemplateid |
The ID number Etsy assigned to your shipping profile. When you edit a shipping profile, the ID number appears in the URL, as described in the How to Find Shipping Profile IDs Inside Etsy section of this article. As mentioned earlier, Etsy doesn't support calculated shipping through their API. |
etsy:categoryid |
The ID number Etsy assigned the category you want to list in. For a full list, download Etsy Category IDs.xlsx. |
etsy:taxonomy_id |
Enter the value Yes to use the Category ID. |
etsy attr:who_made |
Use this field to specify whether or not an item is handmade. Remember, Etsy doesn’t allow newer items unless they are supplies. Valid Values: You can only enter someone_else for vintage items or supplies. That means you must also enter a date that is at least 20 years old in the etsy attr:when_made field. |
etsy attr:when_made |
The date range or decade the item was made. Anything over 20 years old is considered vintage. Valid Values: |
etsy:processingmin |
The minimum number of days before you ship the order. |
etsy:processingmax |
The maximum number of days before you ship the order. |
etsy:issupply |
Specifies whether or not your item is an arts and crafts supply. Valid Values: |
market auto rule |
The name of the Etsy Listing Rule you want to use on your listing. For more info, see Creating an Etsy Pricing Rule. |
list name |
The name of your Etsy Market List in Solid Commerce. |
po sources |
The name of the Warehouse(s) Solid Commerce should use as the inventory source for your listings. |
etsy:run |
Enter Yes to turn the automation on. If the automation is turned on, new items will list automatically. Enter No to turn the automation off. If you turn the automation off on an existing item, we will not communicate with Etsy about it anymore, not even if there is a price or quantity update. |
Optional Fields
NOTE:
We don't support listing into Shop Sections at this time. We plan to build support in the future. We also import the Shop Sections assigned to any live listings that import automatically.
If you want to use any of these optional fields, simply add columns to your spreadsheet.
- Column headers that begin with etsy: are Etsy Marketplace Level details. Add them to the Etsy tab.
- Column headers that begin with etsy attr: are Product Level attributes. Add them to the Products & Inventory tab.
Column Header | Field Description and Valid Values |
etsy:nontaxable |
Specifies whether or not taxes should be charged to the buyer when the item is sold. Valid Values: |
etsy attr:materials |
Add a short description of the materials used. Enter up to 13, separated by double colons. "::" EXAMPLE: wood:: varnish:: oak |
etsy attr:tags |
Enter tags to describe what the item looks like and what it does. Separate each tag double colons. "::" MAX amount of characters is 20 EXAMPLE: red:: rococo:: frame |
etsy attr:occasion |
Pick an occasion from the list valid values. Valid Values: |
etsy attr:style |
You can enter up to two styles Separate each tag double colons. "::". Etsy currently doesn't use this attribute but may relaunch it in the future. Valid Values: Example: Abstract::Art Deco |
etsy attr:is_customizable |
If your shop accepts customizable orders, you can specify whether or not you want to allow custom requests on individual items. Valid Values: |
etsy attr:recipient |
The target audience of your item. Valid Values: |
etsy attr:isprivate |
Specifies whether or not your item is reserved for a buyer. Valid Values: |
etsy attr:is_digital |
Specifies whether or not your item is a digital download. Valid Values: |
etsy:listinglanguage |
The language your listing is in. |
etsy:currencycode |
If your items aren't sold in USD, enter your currency here. |
Variation Listings
Variations cannot be listed through Solid Commerce. You can list them directly on Etsy and then automatically import them into Solid Commerce. For more details, see Variation Listings on Etsy.
Uploading Your Spreadsheet
The etsy description and all 9 etsy attr: column headers are Product Level fields. We included them with the rest of the product information on the Products & Inventory tab of our template. If you include the Etsy Description and/or Etsy Attribute columns on your Etsy specific worksheet, you need to check the Update Product during upload.
To use our Excel Add-In Tool to upload the Etsy tab of the attached template, click the Upload Data button, and check only the Update Marketplace box.
To upload the Etsy tab through our web uploader instead, go to the Products menu -> Import Products and Inventory. Check the Import Marketplace box, and select Etsy from the Select marketplace drop-down.
Related Articles
- Connecting to Etsy
- Creating an Etsy Pricing Rule
- Importing Live Listings From Etsy (Including SKU Formation and a Description of the Data That Imports)
- Variation Listings on Etsy
- Updating a Live Etsy Listing
The attachments from the Downloadable Excel Template & List of Etsy Category IDs section:
Comments
Article is closed for comments.