Wednesday, February 18, 2009

Etsy Tutorial: A Beginner's Guide to Lets Ets & Google Base

*Update 3/18/10... I'm leaving this information here as a general Google Base reference, but as far as Etsy sellers are concerned, Etsy has begun working with Google directly via Google Marketplace. You may read the Storque article here for more information on this streamlined syndication process. Enjoy!!*

Google Base is a wonderful way to get your Etsy shop listings to come up in Google searches. I do not think I need to belabor the fact that this is a cheap, easy and, in my experience, a very effective tool to increase your exposure and make sales.

Supposing you are starting from scratch, here are the basic steps you will need to complete to make a Google Base account, create an .xml file of your Etsy listings, and upload that file to Google Base. You are now also able to have automatic updates scheduled so you will never need to upload again! What a world we live in :)

Create an .xml file of your Etsy listings

  1. Go to http://letsets.com/

  2. In the box for Google Base formatter, type in the one word version of your Etsy shop's name (for me "thejunebride") and select the appropriate box for whether you sell new, used or both, and click "fetch my items".

  3. A big list will come up with up to the 100 most recent of your Etsy shop listings, including pictures. Scroll down to “Step 2” and click the button “download bulk file”.

  4. In the window that comes up, click the “save” button.

  5. When the “save as” window pops up, name the file “letsetsMM.DD.YY” (do not use spaces!) so you can keep track easily of the last time you downloaded the bulk file. Save the file (as type .xml) to your desktop so you can find it easily (later, make a file folder called “letsets.googlebase” to keep all of these files so future downloads can be saved directly into that file).

Open a Google Base Account

  1. Go to http://base.google.com/base/

  2. Create an account if you do not already have one, or sign in if you do.

Upload your .xml file to Google Base

  1. Still in Google Base, go to the "My Items" tab.

  2. Click "Data Feeds"


  3. Click "New Data Feed"


  4. You will now be required to register your data feed. Select "United States" as your target country (even if you live outside of the US). Select "products" as your item type. The data feed type option will come up already set as googlebase... leave it like that.

  5. For the data feed filename, write the name of the bulk download .xml file as you named it ("letsetsMM.DD.YY.xml")

  6. Click "register data feed". You will now see the data feed in the data feeds tab.

  7. Next to the data feed you just registered, click "upload file".


  8. In the box that pops up, browse for the bulk upload file (on your desktop, remember?) and click "upload and process this file".

  9. That data feed will now have a status of "processing" and, when it's done, will show up as "success" to indicate that your items are now showing up in Google searches.

  10. You can now consider yourself done, if you wish, so long as you make a new data feed and upload it within the next 30 days before the old one expires. Alternatively, you can continue on to set up an RSS feed so you never need to upload again!

Setting up an RSS feed from your Etsy shop to Google Base

  1. Go to your public Etsy shop and copy the url (for me it is http://www.etsy.com/shop.php?user_id=5577306).

  2. In Google Base, click the "settings" tab.

  3. Paste the url in the website box. It must be this url not the version that includes your shop name (for me, not http://www.thejunebride.etsy.com/).

  4. Click "save changes" at the bottom.

  5. Go to the "My Items" tab and click "data feeds". Click "edit" next to your new data feed.

  6. In the page that comes up here, change the "encoding" box to "UTF-8" and click "save changes".

  7. Now, go back to your public Etsy shop and find the blue link for "RSS to shop feed" - it should be on the right, the bottom-most option. Right-click and select whichever option you have to "Copy link address" or similar sounding option.


  8. Back in Google Base, in the "My Items" tab under the "data feeds" option, find your new data feed and click the "create" option next to "schedule".


  9. In the window that pops up, select your desired update frequency in the "upload" box (I chose "daily" since I renew, list and sell daily) then paste the link you copied into the "url of file" box (for me, it was http://www.etsy.com/rss_shop.php?user_id=5577306). Click "update schedule".

  10. Tada! All done! Go ahead and pat yourself on the back and wait for the sales to roll in :)

Some other great tutorials can be found here and here.

Now, go get 'em, Tiger!

2 comments:

sometime proptart said...

You are amazing! thanks for all the info!

Olitopia said...

This is wonderful! So helpful!