Here is what I did to import over 100 product listings on Etsy to my Woocommerce site last night:
- installed WooCommerce CSV Import
- downloaded my product listings CSV from Etsy
- formatted the spreadsheet using OpenOffice. I had to rename and delete various columns. This required a few tries before I got it right! The most difficult thing was importing the product images, because I had to figure out how to merge columns while keeping the data, and having that data separated by |
- to merge the columns, I created a new column called picture (as per the sample csv provided by the plugin) and used the formula =CONCATENATE( O2; “|”; P2; “|”; Q2; “|”; R2; “|”; S2 ) - In a google search, I found this forum post and this forum post on OpenOffice, which gave me the idea to use this spreadsheet forumla.
- then, I copied the formula and hit “paste special” for the other 109 cells in the column…
- at this point, I saved the csv as new, so I wouldn’t lose where I was at, incase of failure
- after saving, I deleted Etsy’s picture columns which were columns O,P, Q, R, & S in my spreadsheet…. I also deleted the columns not specified by the spreadsheet
- to make the tags pretty, I hit “find and replace” and replaced Etsy’s _ with spaces, and I had to replace Etsy’s commas with | as per the plugin’s example spreadsheet data.
- I saved and uploaded my spreadsheet and waited for a few minutes…
… when I got a 404 error, I wanted to pull my hair out… but just incase, I checked my products. It worked, and all my Etsy products were in Woocommerce! I hadn’t categorized them on the spreadsheet, so just used the wordpress bulk edit tool to place them in appropriate categories. This took about 2 minutes.
The main product photos are a little messed up, but I’m thinking this is just a spreadsheet formatting issue.
The hardest part was figuring out how to format the csv spreadsheet correctly, after having not really done anything with spreadsheets since 2007-ish.
Anyway, this saves me a bunch of time in listing Etsy items and keeping my self hosted ecommerce site updated! It was taking me approximately 5-10 minutes per product to manually copy/paste and upload pictures into my ecommerce site from Etsy, or visa versa… and that little bit of extra time adds up, and doesn’t make sense for cheaper/lower profit items! Because of that, I was thinking that I’d just switch to selling exclusively on Etsy, turning VintageReveries into a blog with maybe a few featured products… but I’m so happy to change that plan!