Before you get started you need to set-up a Google Base account, which can be done here: www.google.com/base/
The following step-by-step instructions will automatically upload all of your Etsy items to Google Base. These instructions are probably the longest instructions I will ever post here -- If they are overwhelming I would suggest printing it out and checking off each step as you complete it. You will only have to do this once.
Note: If you have previous items in Google Base from manual uploads or from LetsEts, you need to delete these before you begin.
- Log into Google Base
- Click on the "Settings" tab
- Fill in your information. When entering your website address use the address with your shop number not your shop name.
- a. Enter shopname.etsy.com into a browser (e.g., MagnetGames.etsy.com)
- b. Press "return" on your keyboard
- c. The website address in the browser should now be different.
- d. Copy that address, it is what you should use for step 3.
- Click "Save Changes"
- Click the "My Items" tab
- Click the "Data feeds" tab
- Click the "New data feed" button
- Select your country
- For "Select the type of item in your data feed" select "Products"
- For "Select the type of the data feed you're registering" select "google base"
- Your data feed file name is your Etsy user name followed by .xml. Example: MagnetGames.xml
- Click the register data feed button
- Refresh the webpage
- Click blue text displaying "edit" right next to your xml name
- Change the File format to XML, all the other settings can be left the same
- Go to your Etsy shop and scroll down to the bottom right. Click "Subscribe to shop feed." Copy the address of the page
- Back on Google Base, click on "create" right next to "Schedule"
- Click daily, and then pick a time that will be happening in 1-2 hours from the current time (you can change this later)
- Paste the address you copied from step 16 into "Url of file." You can also choose how often you would like it to upload your items.
- Click "Update Schedule"
Follow these added steps only if you are not sure what your shop address is
If you followed all of these instructions and you ended up with a "Failed" under recent uploads please post the failed message in the comments and I will be sure to help you get it all sorted out.
To set the time and frequency of your uploads follow these instructions:
- Log in to Google Base
- Click on "Data feeds"
- Click "edit" under uploads, it is right next to "Schedule"
- Choose the frequency, time, and timezone of your uploads.
- Click "Update Schedule"
Don't understand something I wrote about? Have a related question? Post a comment and I will be sure to answer it. Have an unrelated question? Submit it here and I will feature it on my blog!
xoxo
susan.
11. Your data feed file name is your shop address followed by .xml. Example: MagnetGames.xml
ReplyDeleteAm I supposed to use the one with my store name, or numbers? It won't let me use the one with numbers, says ?/ aren't allowed.
In step 11, you use your actual shop name. My shop name is MagnetGames, so my file was MagnetGames.xml
ReplyDeleteIn step 3, you use the address with the number not the shop name.
Please let me know, if you are still getting errors ..
<3
Hi there. I found this after contacting Etsy with problems uploading feed correctly. I have followed this procedure several time. I do manage to get and active feed but it fails upload with the following details.
ReplyDeleteFeed status details
Outcome: Data feed upload failed. No items are live. help
Number of items processed: 0
Number of inserted items: 0
Uploaded at: May 12, 2009 10:58 am CDT
Processed at: May 12, 2009 10:58 am CDT
In clicking on help I receive this page:
Failure
This message is displayed when a data feed hasn't successfully processed or when no items in the feed were valid. Please make sure your feed is saved in one of our supported formats and try uploading it again.
Also, if you're trying to upload a compressed (.zip, .gz, .z, or .bz2) file, please make sure the file is compressed correctly, and that you're attempting to submit the feed in binary FTP mode (for users sending their feed via FTP). If the problem persists, please contact us.
I am not sure what I am supposed to do with it.
I previously did a manual posting of many of my Etsy items but not all, onto google base. I have not deactivated them (I was waiting to get the feed working). Could this be causing any conflict?
I appreciate any help.
HeartsomeHalos
Wow!
ReplyDeleteManual updates should not cause a problem with the scheduled uploads as long as they are not the same.
Have you tried using my steps? I would just start over from the beginning -- follow each step .. if it still is giving you errors please contact me again.
Good Luck!
susan.
Hi,
ReplyDeleteI'm new to Etsy, with just one sale, so far. Yippee!!, so I'm exploring Google Analytics and Base,hoping it'll help with traffic and eventual sells. I've printed off your G-Base instructions, but I'm already stuck on step #2...what the heck is my shop number, and how do I find it? My shop name is shocdesigns.etsy.com. Thank you for your assistance.
Regards,
SHOC.
Enter shocdesigns.etsy.com into your browser and hit your "return key"
ReplyDeleteThe address should now be different at the top, showing an address with a number instead. Copy and use that address.
<3
susan.
Great!
ReplyDeleteThis is what popped up>>
http://www.etsy.com/shop.php?user_id=7052353.
Use all/some??
Sorry for not understanding.
Thanks much!
Its totally cool!
ReplyDeleteYup, you use the whole address.
susan.
Thank you very much for these instructions.
ReplyDeleteThank you Susan for helping me! It is all loaded now!!
ReplyDeleteIs there anything else to do with it now, to help be seen?
Nope thats it, you are good to go! heh.
ReplyDelete<3
Argh, I've tried it twice (your instructions are very clear), but it still says "failed." Help!
ReplyDeletesilverenso.etsy.com
SilverEnso, I just sent you a convo ..
ReplyDeletesusan.
Hi Susan,
ReplyDeleteI was loading my shop items into Google Base using LetsEts just fine before they did the whole USD thing, and now it doesn't work. I tried editing my xml file to replace the USD with three spaces, and that didn't work either. Any advice?
HI SUSAN
ReplyDeleteI MAKE ALL THE PROCEDURE TO END UP WITH FAILED RESULT , my shop name is MOONSTONEJEWEL
please advise if something wrong there
Oh! It worked this time. :-) Now off to figure out how to make it automatic (RSS feed).
ReplyDeletedear susan
ReplyDeletei don't know if you need the following details:
NUMBER OF ITEMS PROCESSED : 0
Number of items inserted :0
uploaded at : jun2,2009 4:41 am PDT
processed at : Jun2, 2009 4:41 am PDT
MY SHOP IS MOONSTONEJewel
MOONSTONEjewelry, I just sent you a convo ..
ReplyDeletesusan.
Its so nice to see I am not alone in this process of "on the job trainging" I LOVE all the support that ETSY gives to each other. AND those of you in the know, wow thanks for sharing.
ReplyDeleteMicheale Thompson
Just opened shop on ETSY (cameowhite)
This is such a new world to me
The Best To All of US
info@cameowhite.com
can i get a convo too? i thought everything was working but i got the failed status.
ReplyDeletemy etsy name is dyll
sent!
ReplyDeleteI did everything and got the failed message. I am at TheEccentricLady.etsy.com
ReplyDeleteHi,
ReplyDeleteHaving a problem getting this to work:
Re: "Change the encoding settings to UTF-8 and change the File format to XML, all other settings can be left the same"
I don't seem to have the option to do both. If I choose XML, then I am not given the option of UTF-8. In this case, I get an error message that says "We didn't understand some of the XML formatting in your file ..." see last part of http://www.handmadefusedglass.com/blog/how-to-get-your-etsy-shop-in-google-base/
The only way to have the UTF-8 encoding option is if I select File Format = autodetect, i.e. - no tXML. When I do that I get a error saying "didn't understand delimiter".
What am I missing? Thanks.
http://wwooding.etsy.com/
Hi,
ReplyDeleteI am sorry about that, I recently updated the instructions because some people were having trouble getting it to autodetect their file as XML .. so choose XML and don't worry about the encoding, I will edit the instructions.
Thanks so much for your comment!
<3
I also have a question & you are a gem for all your help! How do I load up my 2nd shop. Do I add somewhere or start with a new? thanks!
ReplyDeletecorrcreations
new shop: corrnucopia
Hi Ilena,
ReplyDeleteIf you want to set-up a google base for another shop you need to create another google base account. You cannot just create another feed on the same account since all feeds from an account have one main website. If you do not already have a separate e-mail for your second shop I would create a new one .. then just follow the same instructions for your new shop.
Good luck!
susan.
ps if you really wanted them on the same account, you could create a multi-client account .. there are details here: http://base.google.com/support/bin/answer.py?hl=en&answer=29893
ReplyDelete<3
thanks for your help, I've requested a multi-client. I can't stand the thought of another account!!
ReplyDeleteHi, and thanks for your blog. I have my feed all set up through #19 of your instructions, then I have this issue: Schedule reads active. I went to 'edit', put in my shop feed url, hit update schedule, and get "Domain name must match home page's domain". I have no idea what that means. I named my file my shop name plus .xml. Thanks for any help you can give!
ReplyDeleteHi Jennifer,
ReplyDeleteClick the settings tab (to the right of your items tab), is this what is in your website url box: http://www.etsy.com/shop.php?user_id=5972046 ?
If not change that first, then go back and finish up with 19 ..
If you are still having problems, post another comment please.
<3
I am stuck on step 19
ReplyDeleteI go to etsy-hit subscribe to feed and copy this address
feed://www.etsy.com/rss_shop.php?user_id=7001211
Everytime I get "invalid URL"
I am keywestdesigning.etsy.com - please help
Hi,
ReplyDeleteTry this url instead: http://www.etsy.com/rss_shop.php?user_id=7001211
<3
OK - I did - says active. Supposed to upload in 45 minutes, will let you know if it works!
ReplyDeleteMost went live - these did not:
ReplyDeleteOutcome: Data feed has some errors. Some items contained errors and were not processed successfully, but all other items are active. help
Number of items processed: 32
Number of inserted items: 28
Uploaded at: Jun 8, 2009 4:00 pm EDT
Processed at: Jun 8, 2009 4:19 pm EDT
Errors:
Error Bad data Line #
There is a problem with the character encoding of this attribute. help
description:$16.00 "Each moment that you are happy is a gift to the rest of the world."--Harry Palmer, author of the Avatar® Materials. I began with 20 G Sterling Silver wire and hand-twisted a oval adding three beautiful metallic crystals to each oval. I joined the oval by a sterling silver ring that I formed. So pretty when the light dances as one with the crystals!The crystals are vitrail-a very reflective, color changing crystalThe ear wires are also sterling silver. Hand formed, polished, burnished by me.Dimensions:1 and a half inches from top of ear wire to lowest crystalGift BoxFree Ship
121
The item is missing a required attribute. help
description
157
The item is missing a required attribute. help
description
92
The item is missing a required attribute. help
description
40
Try taking the registered trademark symbol out of this listing: http://www.etsy.com/view_listing.php?listing_id=23445427 (you could replace it with text saying its a registered trademark)
ReplyDeleteI cant tell what the other items were that you got errors on, if you click the help, or look at the particular item, then post the links I can look at those too.
<3
Thanks - I think that change fixed my problem. I changed the upload to 3 minutes from now.....so I have my fingers crossed it'll work this time!
ReplyDeleteJennifer -
Wood Pond Designs
Given that I had to chose target country = US because of language and currency, and the lack of a New Zealand option, will I ever see my own products in a search result?
ReplyDeleteElisabeth,
ReplyDeleteThey will probably still show up but Google might get mad at you at some point .. "Currently, the Google Base Store Connector is only available in the US and UK." Anyways, I am off to catch my flight .. good luck!
<3
susan.
Oh, I hope they don't get mad at me! I signed up disclosing that I was in NZ, and it didn't stop me, but it only gave me US, UK and Germany to choose from. It did say that the language and currency had to match, which it does as it's on etsy, and I ship to the US, so I don't think I broke any rules???
ReplyDeleteIf they do get mad at me, I'll come back and post as a warning to others! :-)
I'm getting the error message: Domain name must match homepages domain.
ReplyDelete???? Thanks!
Hi Liz,
ReplyDeleteIt sounds like you are not using the right addresses. Did you use: http://www.etsy.com/shop.php?user_id=5280739 for step 3? Did you use http://www.etsy.com/rss_shop.php?user_id=5280739 for step 19?
Keep me updated.
<3
susan.
Help. This isn't working for me. I followed your directions and I'm getting this message.
ReplyDeleteFeed Level Messages
Warning: missing reccomended attribute weight
Item Errors 34 items with errors
duplicate attribute price
Item Warnings 34 items with warning
Too many attribute values for attribute price
Those are the best instructions EVER! Easier than pie - thanks so much! I'm Indiscretion.etsy.com and Hauteindscretion.etsy.com.
ReplyDeleteCould my errors listed above be because I use the ~ symbol in my listings? My etsy address is www.llstudios.etsy.com
ReplyDeleteAny suggestions?
Hi Lori,
ReplyDeletePossibly, if you click the help link next to your errors it should give you a specific reason why. This is what google says about symbols: "Use Standard Spelling and Grammar. Avoid any repeated and unnecessary use of punctuation, capitalization or symbols. Don't use exclamation points in your item titles. The use of symbols, numbers, and letters should adhere to the true meaning of the symbol."
<3
OMG - For some reason it works now. I didn't change anything, but it works.
ReplyDeleteI did everything in the tutorial, I think, and it says I have "No active items for this country".
ReplyDeleteI'm in the US.
katarinacouture
Hi,
ReplyDeleteThanks a lot for these instructions! I have a question about #14.
"14. Change the encoding setting to UTF-8 and change the File format to XML. All other settings can be left the same."
When I change the file format to XML, the option to choose UTF-8 under Encoding disappears. If I want to choose UTF-8, I have to use Autodetect for the file format. Do you know which combination of settngs is correct?
Thanks!
Lauren/AntiGenre
Lauren,
ReplyDeleteI have since changed my directions. Were you following them off of this blog? 14. which has now become 15. is: "Change the File format to XML, all the other settings can be left the same" You do not need to worry about an encoding setting.
susan.
Thanks, Susan! I was following the directions off of another site (maybe an old Storque article?) that took them from this blog a while ago. I'll see if I can get GB to work for me now.
ReplyDeleteHi everybody,
ReplyDeletethe Susan's instructions are the BEST to get easily on google base even for outside countries Etsy members, just wait few hours when you have the message " error...." then it will be ok.
Great THANKS Susan for your help and giving your time and knowlegde, I appreciated very much.
from Paris France, FascinatingHobbies
Oh wow Thank-you you soo much for going though that I was stumped with how to do it!
ReplyDeleteThank-you
awww .. thanks guys!
ReplyDeleteI just cannot seem to make this work. I have followed the instructions and put in the proper informaiton and I still cannot get it to load.
ReplyDeleteI have this for my "webstie url"
http://www.etsy.com/shop.php?user_id=7053587
I have this in the "schedule"
http://www.etsy.com/rss_shop.php?user_id=7053587
my "file" is
BuggyD.xml
I have no idea what I am doing wrong. Any light you may be able to shed on what the issue is would be greatly appreicated.
BuggyD,
ReplyDeleteI sent you a convo on etsy.
<3
Hi, Iam still stumped on Google Base. It says active but with an error. Error is as follows," xml tag mis match", Go to help and you get the fooling"Your data feed contains a pair of opening/closing XML tags that don't match. A closing tag must always match the most recent opening tag in the feed. For example, this XML would generate an "XML Tag Mismatch" error.
ReplyDeleteThe XML generates an error because the attribute tag doesn't have a matching end-tag Each attribute tag must be terminated by the matching end-tag:
The item containing this error will be skipped. However, other properly-formatted products in your feed will still process." I have no idea what to do. Please Help.auroraoriginalsjewel.
This is so helpful!! Thanks so much
ReplyDeleteOk! Nothing shows up on my data base? Where is it? I did just as you said and it said it was successful, so where's my stuff?
ReplyDeleteCould you please be more specific? Do you mean how do you log back in or where on Google they are?
ReplyDeleteNothing downloaded! When I hit active items, there's nothing there. I did follow all the instructions, but where is everything?
ReplyDeleteDoes it take up to 24 hours to download on the base? If that's the case, I need to bee more patient don't I?
ReplyDeleteHey same thing happened to me....nothing downloads. From what I can tell I did everything right. Does it not do it until the next day or something?
ReplyDeleteYeah...that's what I want to know. It seems that I should be seeing something by now.
ReplyDeleteHey Guys,
ReplyDeleteIt can take up to 24 hours to process your scheduled time. Make sure your scheduled time is set to daily at least until it first uploads.
If you log into google base and look in the last upload status column what does it say? If there is no date there then that means it has not tried to upload yet. Try setting your scheduled date and time to an hour from now.
susan.
ps deshawn marie, I am not going to reply to your email since I mostly answered your question here -- if you would like more details through email please let me know.
What does this mean?
ReplyDelete"Missing recommended attribute: weight"?
The way etsy has your rss feed set-up does not include any information about your product (other than new or used) -- so google has no idea what the product is. Weights tell google what the product isl color, size, type .. etc. These are not required. Your uploads will still process fine. You can add them by hand be going into each item -- but note that these updates are lost once a new uploaded finishes.
ReplyDeleteOk. Thanks so much!
ReplyDeleteThank you so much for these clear instructions. You just saved me hours of time and tons of frustration. - Cath
ReplyDeleteoops went to my etsy shop and suscribe to shop feed up to step 16 but stupidly didn;t copy the address of the page. Now i can't seem to go back and get it, is it lost forever?
ReplyDeleteThanks
heres you shop feed address: http://www.etsy.com/rss_shop.php?user_id=6099177
ReplyDeletesusan.
Thank you Susan it now says "Feed fetch successfully scheduled" Awesome
ReplyDeleteug. This is what I received after I went thru all the steps again. :(
ReplyDeleteHelp?
Feed status summary
Internal error, feed was not fully processed - Processed on Sep 14, 2009 8:18 am PDT
Detected file format: XML
Feed Level Messages
Error: XML formatting error
Our system encountered an error when processing your data feed.
Learn more.
Error: Mismatched XML tag.
Your data feed contains a pair of opening/closing XML tags that don't match.
Learn more.
Examples:
Item Nr. Line Nr.
16
Thank you so much for these instructions! I was beginning to think that Google Base was useless!
ReplyDeleteOK. I just tried to follow your instructions and these are some of the issues I ran into on googlebase:
ReplyDeleteFor "Select the type of item in your data feed," select "Products."
***Products is not an option
For "Select the type of the data feed you're registering," select "googlebase."
***this option is not there
Your data feed filename is your shop name followed by .xml. Example: EtsyLabs.xml
***when I do find this step, does that mean my shop name: misodaglass.etsy.xml???
Thanks for any help!
Hi Melissa,
ReplyDeleteGoogle Base has recently changed and I currently do not have the time or resources to correct my tutorial. For your last question -- no, do not use .etsy. Your xml file should be misodaglass.xml
<3
susan.
OK, thanks. I'll try to figure it out on my own.
ReplyDeleteHi. I'm trying to set up my shop in Google Base and everything went along fine until I got to step 19 - I've pasted in the address (url of file), hit schedule - I then got - invalid url. I then changed feed to http and got - domain name must match home page's domain - so now I am confused.
ReplyDeleteCan you help, please?
Scott
Quilts By Design
OOps - I think I fixed it.
ReplyDeleteScott
Quilts By Design
Yay!!
ReplyDeleteI just set up to sell my art at http://spiritualanimal.etsy.com
Thanks for the great instructions on this tricky issue!
Hi, thanks so much for this instruction. I went through the steps and all were well. However, on the next day, I found there is error on the feed. The message is:
ReplyDelete0 of 13 items inserted - Processed on Nov 10, 2009 11:16 pm ICT
Detected file format: XML
Invalid encoding (13 errors)
When I went into details, I found this message;
Some of the characters in your data feed seem to be invalid. Please verify all the characters in your feed are valid for your selected encoding. Examples:
Item Nr. Line Nr.
1 17
3 45
4 59
5 73
6 87
An invalid encoding was specified for the data feed
I don't have idea how to correct the encoding but have tried to change the setting by clicking edit on the data feeds but I think the current setting of feed format (googlebase) and File format (XML)is already correct. Please suggest what kind of encoding I should change. Thanks for help!
I am kimbalee9.etsy.com
Hi, everything worked well for a while. Now it doesn't work and I have tried to start over and reload. When I get to the schedule upload part and put my shop feed url in it now says "To schedule a fetch, a valid home page is needed" so I am unable to schedule anything. It doesn't work because of this. Did they change something?
ReplyDeleteYes, they changed it. It is all now done directly through Etsy. Click Your Etsy > Syndication (Under promote), check the check box and click save.
ReplyDelete<3
susan.
I am stuck on step 3. In internet explorer I typed this:
ReplyDeletehttp://digichromia.etsy.com
and it returned:
http://www.etsy.com/shop/digichromia
Next I opened up the source code of my storefront front page and found this:
shop_id:12232086
and I formed the following URL:
http://www.etsy.com/shop.php?user_id=12232086
I then entered this into the general section of google base and it returned this:
URL unavailable.
Help! What can I do? Thanks in advance.