photo

Category Archives: Home

Blog Home Page

Little Known Fact about Vacation Mode & Your Etsy Shop’s Syndication


Go To Great Panes, Kathryn Maloney ©2010
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

Special thanks for flandersfield for sharing this important info with me so I could share it with you!

When you put your Etsy shop in vacation mode your items are removed from Etsy’s syndication feed which removes them from Google’s special Shopping/Product Search (as they should be, since Google only wants items currently available in Google Shopping).

When you bring your shop out of vacation mode your currently listed items won’t be placed back in the feed automatically. You’ll need to re-enable your current stock for upload to get them back on Google’s Shopping Search, see here for OhFaro’s quick tip to enable your items.

All items you list, renew, relist or edit will still be added automatically once you are out of vacation mode, this is just about items you had listed when you put your shop in vacation mode.

There does seem to be another small downside to going in to vacation mode besides your items being pulled from Google Shopping & the hassle of re-enabling:

When the new feed from Etsy was coexisting with the RSS feeds sellers had done themselves, items in the older feeds (RSS done by sellers) were coming up close to the top of the search results and the newer feed (Etsy’s syndication) were coming up later in the results for the very same listings. This leads me to believe that older feeds have a little more weight for better search results.

When you go in to vacation mode and come back out, you delete your old sub-account syndication feed and get a new one which might result in less-good results in Google Shopping searches.

That also means if you’ve bookmarked search results for your old author id, you’ll need to update it with your feed’s new author id when you come out of vacation mode or it won’t show you the items you currently have in Google Shopping.

Warning: There’ve been several syndicated sellers who used vacation mode and cannot get their shop back in to syndication even after re-enabling their items. Admin LisaJune has said that this is not happening to all sellers who have used vacation mode, it’s on an individual basis and that you should contact admin for help getting it fixed–here’s where you can find her post: http://www.etsy.com/forums_thread.php?thread_id=6498948&page=16&#post-50567894

I am hoping it’s a temporary bug that the admin will fix, but if you’re only going to need it for a few days it may be better just to put a notice in your shop, avatar and message to buyer for now.

Go To Great Panes, Kathryn Maloney ©2010
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

We’re featured on Celebrate Odd Etsy!

Go To Great Panes, Kathryn Maloney ©2010
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

I’m thrilled to announce that our Etsy shop has been featured on

Celebrate Odd Etsy

See the feature here:

Go To’s Stained Glass


Visit their Etsy shop:

Etsy
Buy Handmade
celebratetheodd

Image Cropping for Etsy

Bats from GoTo's Etsy shop

Go To Great Panes, Kathryn Maloney ©2010
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

Been wondering how to get images that look good in both the gallery and list view on Etsy?

For the perfect Etsy image you need an image with a 1.25 to 1 ratio, with the important part of your image in the center left to right, leaving .125 of the left and right sides without any necessary content.

What does that mean?

A small example–because it is easy to see the ratio in small numbers:

1.25 to 1.00 ratio:
125 pixels wide by 100 pixels high

Unnecessary content area:
12.5 pixels on each side that don’t have necessary content

What does that look like?

Here’s a blue & white image that is 125 pixels wide by 100 pixels high.

Blue & White Example
+
12.5 pixels wide white bar
100.0 pixels wide blue square
_12.5 pixels wide white bar
125.0 pixels wide

The blue square portion is 100 pixels wide by 100 pixels high, centered in the image left to right. Everything in the square will be visible in gallery or list view thumbnails.

On each side of the square is a white bar that is 12.5 pixels wide–consider that the unnecessary content area. Anything that falls into those bars won’t be seen in list view thumbnails, but will show in gallery view.

In these images the areas with the dotted lines show you what will be cut off the picture in list view:


125 x 100 pixels

125 by 100

430 x 344 pixels

Click image to see at 430 x 344 pixels
430 by 344

700 x 560 pixels

Click image to see at 700 x 560 pixels
Click for 700 by 560



Your “blue square area” will always be a square based on the height of the image, and you want the blue square centered left to right.


Examples of images with this ratio: Unnecessary content area on each side:

430 wide by 344 high
(Etsy’s minimum width for images*)
43 pixels
500 wide by 400 high 50 pixels
600 wide by 480 high 60 pixels
700 wide by 560 high 70 pixels
800 wide by 640 high 80 pixels
900 wide by 720 high 90 pixels
1000 wide by 800 high
(Etsy’s maximum for the longest side of images is 1,000 pixels**)
100 pixels

*Your images will be pixelated or blurry in the listing if they are smaller than 430 pixels wide.
**Very important info about over-sized images here: Google Shopping & Large Images

The sides: To find how many pixels you need to leave without important content for other image sizes, just subtract the height from the width and divide by 2:

430 wide by 344 high:
430-344=86
86÷2=43
43 pixels on each side
1000 wide by 800 high:
1000-800=200
200÷2=100
100 pixels on each side

If your images are already cropped and don’t meet the 1.25 wide to 1 high ratio, you can edit them in your photo editor to fit by adding white space around the image to create an overall image with the right dimensions with the important part in the “blue square area”. It’s only really important for the first image in a listing since that’s the one folks will see in search results.

Need more help? Join us in this forum thread (opens in a new tab/window):

http://www.etsy.com/forums_thread.php?thread_id=6489290

Go To Great Panes, Kathryn Maloney ©2010
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

Google Shopping–Pictures Missing?


Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2010
(This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.)

Now you’re syndicated, you’ve searched Google Shopping and found your items there but you’ve got no pictures–just this graphic?


Then your pictures are most likely too big.

If you are selling on Etsy, they have made these recommendations:

Minimum: 430 pixels wide
Maximum: 800 to 1,000 pixels wide or long on the largest side

Narrower images will be pixelated/blurry in the item listing because Etsy will stretch them to fit the 430 pixel-wide space on the listing page.

Larger images are slow to load which is:

bad for folks with older computers
bad for folks with dial-up connections

and now, it’s also

bad for uploading to Google Merchant Center which provides data for Google’s Shopping/Product search.

What to do?

You can either lower the setting on your camera or use photo editing program to make them smaller. If you don’t have photo editing software, you try these two free ones:

Picasa (from what I hear it’s relatively simple)
http://picasa.google.com

GIMP (more advanced)
http://www.gimp.org/windows

Need help getting the image sizes right for cropping on Etsy?

See this post:

Image Cropping for Etsy
http://www.gotogreatpanes.com/blog/2010/04/08/image-cropping-for-etsy

Go To Great Panes, Kathryn Maloney ©2010
(This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.)


Download Your Paypal History


Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2010
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

Looking for your Paypal fees history or sales tax you collected through Paypal? It’s all in the history download from Paypal!

To download your history:

1. Log in to your Paypal account & hover over the History link, click the Download History link from the pop up menu.



2. On the right there’s a box with links, click Customize Download Fields.

That allows you to control the information you get & how you get it. Be sure to select shipping amount, insurance amount, sales tax and any other information you need. Click save at the bottom of that page.

I like to download it all and save it for my business records.



3. Select Custom Date Range and put in the dates you need records from.

If you have hundreds of transactions during the time frame you select you may have to change the dates and download a few months at a time so the download won’t time out.



4. From the drop down File Types for Download menu select Tab Delimited.

I like the all activity version.



5. At the bottom click the “Download History” button.



6. When download box pops up click to save the file to your computer.

We have a folder where we keep all our business transactions, I save it there, some folks save items to “My Documents”, wherever you’ll be able to find it is fine. I give it a name that reflects the contents and the date range, for example my March 2010 file name will be: PP history 03 10.txt



7. Once you’ve saved the file, go to the folder on your computer where you saved it and change the file extension from .txt to .xls so that Excel can open it and will automatically put all the data in separate columns for you.

To change the extension right click on the file name and select rename, edit it then hit enter (on a Mac, use ctrl + click for the right click):

From: PP history 03 10.txt
To: PP history 03 10.xls



8. Double-click the file name to open it. All your transaction data should be there now, separated into individual columns.



To add up a column, for example, your sales tax:

9. Click once on the first sales tax collected entry–that selects that box (I’m not sure what the column header is as we can’t use Paypal to accurately collect NY sales tax so our file doesn’t have that column).



10. Hold down the shift key and then hold down the down-arrow key to highlight the cells until you reach the end of the numbers you want to add, then click the down arrow one more time, highlighting one empty box at the end of the column. It should look like this:



11. At the top of the page click the big funny looking E in the menu bar–that will “auto-sum” the column. It will put the total in the empty box you highlighted at the bottom of the column. It should look like this:



12. All added up! In this example the total was $3.75.



This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.



Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2010

Help for Filing your Federal Income Taxes
for Your Small Business


Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2010
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

This time of year many folks seem to have questions about where different business expenses go in your annual income taxes.

Generally, you should get your answers from people in the know–that means directly from the IRS or from an accountant or tax preparer that has experience with small business taxes.

Non-official websites and forums are not a good place to get answers. You’ll never know if the person supplying the info actually has a good understanding of the laws or if they just talk a good game if you don’t go to the source.

In that vein, I offer a few official IRS website links that I have found very helpful. (Links open in a new window or tab depending on your browser settings.)

This one might be a little late for this year, but will help you get records in order for your 2010 income taxes:

Recordkeeping Info from the IRS
http://www.irs.gov/businesses/small/article/0,,id=98575,00.html

For sole proprietorships (info), we report our income and expenses on the Schedule C and submit it with our 1040 to the IRS (and to the state where required).

Form 1040, Schedule C
http://www.irs.gov/pub/irs-pdf/f1040sc.pdf

This is the IRS’s instructions for the Schedule C:

Instructions for the 1040 Schedule C
http://www.irs.gov/instructions/i1040sc/index.html
(PDF version)

and the following one answers some of the questions for the Schedule C that the instructions for the Schedule C seem to ignore–it has saved me from many a headache:

Tax Guide for Small Business, Publication 334
(For Individuals Who Use Schedule C or C-EZ)
http://www.irs.gov/publications/p334/index.html
(PDF version: http://www.irs.gov/app/vita/globalmedia/p334.pdf)

Now don’t get overwhelmed by all this, these additional links will come in handy if you get stuck….

Some more tough topics in detail:

Business Expenses, Publication 535
http://www.irs.gov/publications/p535/index.html

Inventories—see Publication 538
http://www.irs.gov/publications/p538/index.html

Travel, Entertainment, Gift & Car Expenses, Pub 463
http://www.irs.gov/publications/p463/index.html

How To Depreciate Property, Publication 946
http://www.irs.gov/publications/p946/index.html

Business Use of Your Home, Publication 587
http://www.irs.gov/publications/p587/index.html

This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.



Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2010

Google Analytics Set up for Etsy Shops


Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2009
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

1. Log in to Google Analytics, click the “Analytics Settings” link on the left in the orange bar. That should put you on this page:
https://www.google.com/analytics/settings

a. If you haven’t set up your account already, you’ll need to put your shop address in on the “Add Website Profile” page. Click the “Add Website Profile” link below the “Website Profiles” section.

b. Select “http://” from the drop down menu and put in your shop address, for example goto.etsy.com or gotosupplies.etsy.com

2. On that page in the darkest gray bar, in the center, you’ll see it says “Website Profiles”. Below it lists your website followed by a number that starts with UA. That is your Google Analytics Tracking ID. I’ve outlined the number location in a green square on this image, click it for a larger view:

You need to copy that tracking ID into the box on the Web Analytics page in Your Etsy, so…

3. Log in to Etsy, and on the left side of “Your Etsy” under “Shop Setup” click the link for “Web Analytics”. That should put you on this page:
http://www.etsy.com/shop_analytics.php

4. Under “Step 2: Enter Tracking ID”, put the ID you just copied in the box, be sure the UA is capitalized and click the save changes button.

Done! Google will start tracking your shop now.

Looking for more help?

Etsy’s PDF file on Google Analytics:
http://www.etsy.com/storque/media/bunker/2009/03/GoogleAnalyticsForSellers.pdf

Now that you are tracking your traffic, it’s time to improve your search engine results:

Etsy: Meta Tags
http://www.gotogreatpanes.com/blog/2009/07/21/etsy-meta-tags

Search Engine Optimization (SEO) info straight from Google:
http://www.gotogreatpanes.com/blog/2009/06/22/search-engine-optimization

This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.



Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2009

Etsy GM Feed/Syndication Update


Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2009
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

Etsy Google Merchant Center Feed/Syndication Update

Sean11 just posted an update (02/25/10) on the syndication roll out–here’s the main gist:

  • Most active sellers now have it.
  • The reason not everyone is syndicated yet is because of Google limitations and they are working on expanding it, as they do Etsy is adding more shops.
  • Etsy is the largest site adding items through the new special Google Product Search Marketplace Partner.
  • 10,000 shops were syndication yesterday, they expect everyone will be syndicated soon.

See his two posts in the forums here:

http://www.etsy.com/forums_thread.php?thread_id=6448041&page=7

This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.



Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2009

More Sellers Added to Ety’s GM Feed


Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2009

This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

Admin have just announced that more sellers have been added to Etsy’s Google Merchant Center Feed:

http://www.etsy.com/forums_thread.php?thread_id=6365505&page=44

See here for help checking if it was your shop that was added, and what to do if it was!

FAQs for the Etsy GM Product Search Feed


FAQs about the new Etsy GM feed


Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2009
This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.

NEW: Disappearing Syndication Link on Etsy 04/15/10

NEW-ish: Sean11 just posted an update (02/25/10), see here:
http://www.gotogreatpanes.com/blog/2010/02/25/etsy-gm-feedsyndication-update

FAQs about the new Etsy GM feed

  1. What is syndication?
  2. Syndication is Etsy uploading our items to Google Merchant Center to get into Google’s special shopping/product search, and all shops will eventually have it (you don’t need to do anything to get it). Etsy has been rolling it out in stages to sellers since December.

  3. What is Google Merchant Center/Google’s special shopping/product search?
  4. See this post: What is Google Base/Merchant?

  5. Is my shop in it?
  6. See this post: Etsy has Started to Syndicate Shops

  7. If my shop is syndicated, do I need to do anything else?
  8. Yes–you need to enable your current stock for upload, see here for OhFaro’s quick trick:

    Etsy’s GM Syndication: Enable your items

    Any listings/edits/renewals you make from here on out will be added to Google Merchant automatically.

  9. I had the RSS feed set up with the scheduler, but my syndication page doesn’t say active.
  10. Unfortunately there are some folks who didn’t get added. Sean11 (an admin) said they included folks based on a list of active Google Merchant account users that Google provided them with, other than that I don’t know why some have been added and some haven’t. See his post here: http://www.etsy.com/forums_thread.php?thread_id=6365505&page=12

  11. My shop isn’t syndicated yet, what can I do?
    My shop says “pending”, what now?
  12. The only thing you can do now is wait for Etsy add your shop to the syndication–please see the entries below for more general info.

  13. How soon will my items show up in Google’s Shopping/Product search?
  14. Once your shop is syndicated, items will be sent to Google immediately after listing/editing, but may take 24 to 48 hours to show in their Shopping/Product search:
    http://www.etsy.com/forums_thread.php?thread_id=6365505&page=21

  15. Will it show anything in my Google Merchant Account?
  16. No, your merchant account will only show your current feeds, and the new uploads are Etsy’s feed–so it will only show in their account.

  17. Do I need to do anything with the feed I set up for the RSS uploads?
  18. Your individual feed will stop working shortly if it hasn’t already (Google had said sellers could no longer submit items as of December). Most RSS feeds for Etsy shops have already stopped working (see here).

    Unless you delete the feed or stop the email messages you will continue to get notices about the upload failures. I chose to delete the feeds since they are dead now anyway.

  19. How do I find my items in the shopping search to know if they are uploading?
  20. It’s not as easy as when we were able to do our own uploads…

    a. You have to search for your items on Google’s shopping search like a buyer–I start with searching an item name. Search here: http://www.google.com/products

    b. Go to a page where you see your items in results shown as sold by Etsy – USERNAME (USERNAME being your Etsy username). On the left side of the page you’ll also see links all the sellers on that page (click “more” if you don’t see it). Click the link on the left for your shop.

    I searched stained glass bat, clicked the link on the left for my shop.

    c. In the address bar you’ll find the address for that page–most of it will be gobbledy-gook, mine looked like this:

    http://www.google.com/products?q=stained+glass+bat&hl= en&authorid=6901101&cdn=Etsy+-+GoTo&lnk=storesugg&show
    =li&ei=pEC9S_yoO6XaxAWToqmzCA&sa=X&ved=0CGwQhggoCA

    Copy the address for your page to a word processor and find the author id number like is highlighted in purple in my address.

    Take that number put it in the webpage address below instead of the XXXXXX and you should be taken to a page with just your items uploaded by Etsy:

    http://www.google.com/products?q=&authorid=XXXXXX

    Mine looks like this:

    http://www.google.com/products?q=&authorid=6901101

    d. Once you have that address working for finding your items, bookmark it in your browser for easier finding in the future. Please note: If you put your shop in vacation mode your number might change so you may have to create a new bookmark after coming out of vacation mode. You’ll also need to re-enable your items for upload or they won’t be in the feed.

  21. When will the rest of the shops to be added?
  22. The gradual roll out to the rest of Etsy is in the works and will continue over the next few months–the admin say they can’t give us a deadline for when it is happening:
    http://www.etsy.com/forums_thread.php?thread_id=6365505&page=23

  23. Why does my Google Merchant Account still only show 100 items uploading–I thought Etsy was removing the 100 item limit?
  24. Your merchant account will only show your current feeds, and the new uploads are on Etsy’s feed–it will only show in their account. Your feed may still be uploading your 100 most recent items, but Etsy’s feed will upload them all and it won’t be reflected in your GM account, it will only be shown in Etsy’s GM account.

    Once your feed is retired (see here), you won’t get notifications of items that aren’t inserted anymore:
    http://www.etsy.com/forums_thread.php?thread_id=6365505&page=3

    A few items not inserted won’t effect the rest of the items Etsy uploads.

  25. Why is it taking so long for the rest of the shops to be added?

    Because Etsy is part of a new Marketplace Partner Program that is different than the RSS uploads we used to have. It’s also different than the way most other venues upload their goods:

    • Immediate upload to GM, not sent in batches like on other sites–see here. (It may still take 24 to 48 hours for items to show once Google has the info.)
    • Items are listed as being sold by:
      Etsy – USERNAME
      other venues list only their business name.
    • Our feedback on Etsy will be linked to our listings,

  26. When will our feedback show on GM?
  27. Update: It’s currently showing for some sellers.
    When Google sets it up–according to admin sean11 “in the coming weeks”, as stated here:
    http://www.etsy.com/forums_thread.php?thread_id=6365505&page=23

  28. What else should I know?
    • Newer feeds generally seem to be weaker initially as far as search results go, so it will probably take a little time for our items to get really good search results. Well-established feeds get better search results, and we’ll get there.
    • Etsy will be adding product type values for us! Using the first three tags of each item, Etsy will create product types for the Google Merchant submission–make sure your first three tags are in a good order and be sure to keep anything that prevents items from being inserted out of the first three tags.
    • If your items aren’t being inserted after you’ve enabled your items, you need to check that they don’t conflict with GM’s rules. Some tips for that can be seen in the first entry of:
      FAQ 3.
    • GM gets item titles, the entire item description and the first three Etsy tags, so if you want to include things that Google doesn’t want in the feed (like free shipping), be sure it isn’t in those places.

  29. How can I see the stats coming from the Google Merchant hits now that it doesn’t show in my Google Base/Merchant account?
  30. You need to set up your Google Analytics account to show them: http://bloghandmade.blogspot.com/2009/10/tracking-your-traffic-from-google-base.html

  31. Where can I find Etsy’s Google Product Search help?
  32. http://help.etsy.com/app/answers/list/c/8,30/noIntercept/1

This post is copyrighted–you do not have permission to repost this content elsewhere but you are welcome to link to it if you’d like to share the information.



Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2009