Listings exported from Etsy come in a slightly different format than we use to import them and require some modifications before they can be imported. This guide will walk you through that process.
This video will walk you through the process, and written instructions can be found below.
Step One: Download your Etsy listings
To export your listings from Etsy go to your dashboard, then click on “Settings” and then “Download Data”.
If you are comfortable working with spreadsheets, you can relatively easily make the conversions needed to make your file compatible for import.
Many of the columns in the Etsy export file are used with some minor modifications. Any unused columns should be deleted.
Step Two: Grab a copy of the Stockabl template
We recommend transferring the data from your Etsy export file to the official Stockabl template. Not only will you know for sure you have all the information you need, but we have included helpful dropdown menus and info notices to help you make sure it’s done correctly.
Step Three: Match the columns
Etsy Column Name | Stockabl Column Name |
Title | Name |
Description | Description |
Price | Retail Price |
Currency Code | not used (remove from file) |
Quantity | Stock (optional) |
Tags | Tags |
Custom Attribute | Attribute Name Attribute Value(s) |
Image 1… Image 10 | Images |
Variation # Type | Attribute Name |
Variation # Values | Attribute Value(s) |
Step Four: Edit the columns
Once you’ve moved or renamed everything, it’s time to clean up the information in the columns a little bit to prepare it for importing.
Correcting Etsy Tag Exports
Etsy exports tags with underscores ( _ ) instead of spaces. Use the “Find & Replace” function to replace _ with spaces. Replace all and you’re good to go.
Check out the video tutorial (at 8:18) above to see an example of how to do this.
Combining Images
Etsy lists each image link in its own column, while Stockabl imports them in the same column but separated by a comma.
If you are comfortable with using formulas in a spreadsheet the appropriate formula is: =CellID &","& CellID &","& CellID &","& CellID
Check out the video tutorial (at 10:03) above to see an example of how to do this.
CellID
represents the cell each URL lives in (ex. A3
). In the video walkthrough the formula we used was: =A2 &","& B2 &","& C2
because there were only three columns with image links in them. If you have all ten images in use you will have a longer formula!
We recommend copying and pasting the entire column to a new tab, adding your formula in a new column, and then copying and pasting (values only!) back to the original spreadsheet and deleting the old columns. (See the tutorial video for a visual explanation)
Rather we handle this for you? We offer a $25 conversion service where a member of our team will convert your file for you, and assist you in filling in the missing pieces.
Variations, Custom Attributes, and Attributes…. oh my
Etsy categorizes attributes and variations separately in their system. However, we use attributes to create variations and to filter products in our system.
Attributes are optional for simple products.
Custom attributes
Custom attributes that you created on Etsy are exported as individual columns. For example, if you used the attribute “MATERIALS” you would find a column for “MATERIALS” and each row would list the materials in the product separated with commas. It is up to you if you want to use these on your Stockabl listings or not.
To use these custom attributes, the column title “Materials” becomes the attribute name listed under Attribute Name and the materials listed become the values under “Attribute Value(s).
Check out the video tutorial (at 12:20) above to see an example of how to do this.
Variations
Variations look a little more like attributes do on our system. Variation type becomes “Attribute Name” while Variation Value becomes “Attribute Value(s).
Adding attributes alone does not create a variable product though, so if you are interested in learning how to do this see our article on variable products.
Step Five: Fill in the columns Etsy doesn’t include
There are few columns missing from the Etsy export file that you will need in the import file to have a complete listing. For a list and explanation of each column on the file please see our CSV import guidelines article.
- Type (simple, variable, variation – simple is most common)
- Wholesale Price
- Published
- Short Description
- Weight (lbs) OR Length (in), Width (in), and Height (in) – only if you need these for calculating shipping rates
Feeling overwhelmed? Don’t worry, we’re here to help! Schedule a file conversion and a member of our team will do all the heavy lifting and help you get set up for success.
Ready to Submit
Once your file is ready to be imported, submit it via our import request form and a member of our staff will import your file for you within a few days. You will receive an email confirming your submission and another letting you know when the process is complete.