Etsy and Google Base (Let's Ets)
Let's Ets is a tool for Etsy Sellers, their Google Base formatter takes item details from your Etsy store and converts them into a format that Google understands.
I already had a Googlebase account set up when these print screens and instructions were done. If you are setting everything up for the first time, they may be slightly different or in a different order, but should be close enough for you to follow.
I already had a Googlebase account set up when these print screens and instructions were done. If you are setting everything up for the first time, they may be slightly different or in a different order, but should be close enough for you to follow.
If you have not yet registered your Google account and set up your Google Base settings, return to my Etsy and Google Base lens first.
Preparing Data Feed File from Etsy Listings
Go to the Let's Ets website.
Complete the Google base formatter section on the left (not the Custom Etsy search on the right).
1. Enter your Etsy username or ID number.
2. Click on "Fetch My Items".
Scroll way down to the bottom of the page, the end of your listings.
At this time only the 100 latest items in your shop will be added. They are currently working on a way to lift this cap without stressing Etsy's servers, so stay tuned.
Note: be sure all the items load on the page BEFORE you click the Download Bulk File button. I have high speed cable and it still takes a minute or so for everything to load on the page.
Click on "Download Bulk File".
Click on "Save".
Save this file to your computer. i.e. I save mine in my GoogleBase folder.
Click on "Save".
Note: This is the data file that you will be uploading to GoogleBase later.
Complete the Google base formatter section on the left (not the Custom Etsy search on the right).
1. Enter your Etsy username or ID number.
2. Click on "Fetch My Items".
Scroll way down to the bottom of the page, the end of your listings.
At this time only the 100 latest items in your shop will be added. They are currently working on a way to lift this cap without stressing Etsy's servers, so stay tuned.
Note: be sure all the items load on the page BEFORE you click the Download Bulk File button. I have high speed cable and it still takes a minute or so for everything to load on the page.
Click on "Download Bulk File".
Click on "Save".
Save this file to your computer. i.e. I save mine in my GoogleBase folder.
Click on "Save".
Note: This is the data file that you will be uploading to GoogleBase later.
Important Update
Removal of USD from your XML file
Back in May Etsy added USD to our prices. Unfortunately this is now included in the xml file that we download from Let's Ets and by doing so, makes this file impossible to upload to GoogleBase. But wait, there's an easy fix!
To fix this problem, just open your xml file in an HTML editing file (I use Cute FTP Pro) or a regular text file such as Word or Notepad.
I find most people have Notepad, so will use that for the following instructions. Depending on what you use as a text editor, instructions may vary slightly.
To fix this problem, just open your xml file in an HTML editing file (I use Cute FTP Pro) or a regular text file such as Word or Notepad.
I find most people have Notepad, so will use that for the following instructions. Depending on what you use as a text editor, instructions may vary slightly.
- Open your xml file using Notepad
- Click on "Edit" and select "Replace"
- Under the 'Find what', enter "USD"
- Leave 'Replace with' blank
- Click on "Replace All" and you will see it working through the file
- When finished, close the "Replace" box
- Save the file
- Upload this file to Googlebase
Register your Data Feed
Go to Google Base from the main page, click on "Data feed" link over the the right side of your screen.
Be sure you are on the Data feeds page, if not, click on the "Data feeds" link.
Click on the "New Data Feed" button.
1. Select target country. If it is not already there (from your information entered in Settings), select it from the drop down menu.
2. Select "Products" and "googlebase" from the drop down menu for item type.
3. Enter your data feed file name. This is the file that you saved from the Let'sets website.
Click on "Register data feed".
Be sure you are on the Data feeds page, if not, click on the "Data feeds" link.
Click on the "New Data Feed" button.
1. Select target country. If it is not already there (from your information entered in Settings), select it from the drop down menu.
2. Select "Products" and "googlebase" from the drop down menu for item type.
3. Enter your data feed file name. This is the file that you saved from the Let'sets website.
Click on "Register data feed".
Upload your Data Feed
On the data feeds page, you will now see the filename that you just registered.
Click on Manual "upload file" link.
Click on "Browse" and locate your data feed file on your computer.
Then click on "Upload and process this file".
Click on Manual "upload file" link.
Click on "Browse" and locate your data feed file on your computer.
Then click on "Upload and process this file".
You're Finished!
The upload may take several minutes to several hours. Time depends on the size of your file and the speed of your Internet connection.
Once your file has been uploaded, you'll see notification on your screen if the upload was a success.
Your Etsy items will start showing up in Google's search results.
The status of any feed can be found on your Data feeds tab. It can take up to 24 hours for your file details to be updated in your account.
Once your file has been uploaded, you'll see notification on your screen if the upload was a success.
Your Etsy items will start showing up in Google's search results.
The status of any feed can be found on your Data feeds tab. It can take up to 24 hours for your file details to be updated in your account.
Upload Monthly
Listings expire on Google Base every 30 days!
And if you list a lot of new items, go through this process again (before the 30 days)
Hints and Tips
When it is time to go through this process again, you have to do repeat all steps:
- Prepare new data feed from Let's Ets
Note: I use a different file name each time, awelldressedbullet2.xml, aswelldressedbullet3.xml, and so on. - Register new data feed
- Upload new data feed
Main Google Base Lens
-
Etsy and Google Base
-
Help drive traffic and sales to your Etsy Shop for free! Get your Etsy Shop items to the top of Google search results. Google Base is a service that lets you "tell" Google about what you have for sale. After your items have been uploaded to Google Ba...
Etsy Shop Feeds Tutorial
-
Etsy and Google Base (Shop Feeds)
-
As announced in Etsy News Tech Updates, Shop feeds now come pre-formatted for easy upload to Google Base! Uploading items to Google Base is a great way for sellers to help Google - specifically Google Product Search - find their items. Shoppers will...
Guestbook Feedback
submit
-
Reply
- Happiegrrrl Happiegrrrl Feb 23, 2009 @ 8:35 pm
- Thank you for joining the Etsy Informationals Group
A few things from our Etsy Shop
LOL Come on, you knew I would do this LOL
You need to select some items to show.
About Me on Squidoo
awelldressedbullet has been a member since June 14 2007, has rated 1,863 lenses, favorited 841, and has created 157 lenses from scratch. This member's top-ranked page is "Shotgun Shell Bar and Party Lights". See all my lenses
Check out these great lenses...
-
- Squidoo Orange Guy Visits Canada
When I first found the Adventures of Squid Contest I knew I just had to take the little Squidoo Orange Guy out for a spin, and show him what Canada is all about. I had to make sure to get written permission from his adopted parents, Seth and Megan,... view lens -
- About A Well Dressed Bullet Website
Our website offers you custom handmade Belt Buckles, Bolo Ties, Bullet Pens, Card Guard Protectors, Clocks, Keepsake Urns, Key Chains, Shotgun Wedding Bar & Party Lights, Zipper Pulls and so much more.Unique gift ideas for hunters, rifle, handgun... view lens -
- Pretty Lenses by Pretty Bullet
We already have so many incredible "How To" lenses on Squidoo, explaining what Squidoo is, what a lens is, what the different modules are and how to use them, how to get more traffic, how to make more money, and so on. So I thought I would make a len... view lens -
- Kathy's Squidoo Help Library
This is a quick reference lens with a few of my favorite Squidoo lenses that I often refer new lensmasters to. Of course, I've tried to organize them so you can find what you are looking for easily. I've offered a selection of lenses on the same top... view lens -
- Lensography of Kathy aka Pretty Bullet
Hello! It seems I've been a wee bit busy on Squidoo! This lens is a list of all my Squidoo lenses and lensography's, a way to keep track of all my lenses and to allow folks to view my lenses by category. So, grab a cup of coffee, browse around, I kn... view lens
Quick Links Back Up
by awelldressedbullet
A Well Dressed Bullet offers handmade Belt Buckles, Bolo Ties, Bullet Pens, Card Guards, Clocks, Earrings, Key Chains, Party Lights & more, made with...
(more)
