"Eye" Q Test–What's Your Color IQ?



Go To Great Panes, Kathryn Maloney ©2012

Time for a little fun! How about a ‘color IQ test’? Move the color swatches into proper order:

http://xritephoto.com/ph_toolframe.aspx?action=coloriq

What’s your score? I got a 16–next time I’m going to brighten my monitor and see if I can do better. 🙂

Blog update: I recently updated the “Figuring Out Your Secondary Shipping Rates” post with details of how to account for the bump to Priority mail that shipping multiple items in the same package can trigger:

“Ship with another item” demystified:
Getting accurate secondary shipping rates doesn’t have to be difficult.

Etsy Shipping for Etsy Direct Checkout


Visit our Etsy shop: GoTo
Go To Great Panes, Kathryn Maloney ©2012
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.

If you’ve been frustrated by not having the easy Paypal shipping link* for your Direct Checkout orders, and have resorted to paying for a label service or copying & pasting the address into the blank shipping label form on Paypal/using the multi-label tool** you might be pleased to learn that US sellers who use Direct Checkout can ship domestic orders through Etsy now–after joining the Shipping Improvements Team:

Purchase & Print USPS Shipping Labels on Etsy

*Don’t have the shipping label link on your Paypal account overview page next to each Paypal transaction? Click here for how to get it to show:

Shipping Through Paypal

**Don’t know how to print Paypal labels without a Paypal transaction? See here for two different ways:

Shipping Through Paypal Without a Transaction

Shipping Update & a Feature for Our Shop

I hope everyone is enjoying their weekend! Just a little news here…

I just updated our Shipping page to include more of the relevant posts I’ve put up over the past few months–you can use the gold link in right side bar of every blog page to get to it.

To go with the fresh Shipping page, I’ve also started a new thread on Etsy for discussion if you need more help:

US Sellers: Shipping Basics–domestic & international shipping help

and lastly, I’m pleased to share that we’ve just been featured on the Etsy Handmade Team‘s new blog! We’re in this week’s

Friday Finds

Thanks to our team leaders for all the hard work & the site looks beautiful!

Can't find UK in USPS' Click-N-Ship? or when using Etsy labels?

Content Go To Great Panes, Kathryn Maloney ©2012
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 see folks asking about this pretty often so I thought I’d put up a quick post:

If you can’t find the “UK” or United Kingdom as a destination in the free USPS program “Click-N-Ship for Business” (formerly the USPS Shipping Assistant) that we use to print our First Class International labels, the online USPS customs form maker, Click-N-Ship online label service (for Priority & faster) or when you’re using Etsy’s label feature, it’s because USPS uses the “Great Britain & Northern Ireland” instead:

For UK use Great Britain & Northern Ireland


USPS’ designation of Great Britain and Northern Ireland includes:

England
Scotland
Wales
Northern Ireland
Guernsey
Jersey
Alderney
Sark
the Isle of Man

See it here on the USPS website.

Hope that makes your next UK mailing a little less stressful. 🙂

Go To Great Panes, Kathryn Maloney ©2012

What can't I mail?


Go To Great Panes, Kathryn Maloney ©2012
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.

Do you know what you can and can’t mail through the US Postal Service?

The USPS guide for prohibited items in domestic packages can be found here:

Can You Mail It?
(https://www.usps.com/send/can-you-mail-it.htm)

Besides the prohibited items listed there, if you click the “Hazmat” tab there’s also restricted items that include perfumes, nail polish and another dozen items.

There’s also a tab for showing you size restrictions and one for “Special Handling” which is about shipping live animals.

Shipping plants or other perishables?
Shipping knives?

You’ll need the more detailed explanation–see this USPS publication:

Publication 52 – Hazardous, Restricted, and Perishable Mail
(http://pe.usps.com/text/pub52/welcome.htm)

For more shipping tips see our main “Shipping” page–see the gold links on the right or click here:
Shipping Basics

Go To Great Panes, Kathryn Maloney ©2012
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.

a href=”http://www.gotogreatpanes.com” target=”_blank”

Auto-sum: Adding Up Your Totals

GoToSupplies on Etsy
Visit our Etsy shop:
GoToSupplies

Go To Great Panes, Kathryn Maloney ©2012
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.

One of the handiest tools in the box for a small business (and personal) finances is the auto-sum feature on spreadsheet programs.

Many use Microsoft Excel for their spreadsheets (need help with that? See here: http://www.gotogreatpanes.com/blog/?p=858) but other programs have that feature too.

If you don’t have software on your computer to create/edit spreadsheets, Open Office is great free program you can download–it has several sections:

Writer: word processor
Calc: spreadsheets
Impress: multimedia presentations
Draw: creates images as simple as diagrams and as complex as 3D illustrations
Base: databases
Math: mathematical equations

Calc is the one to use for spreadsheets & CSV files. I’ve also used the word processor, but haven’t tried the other parts–I’d love to hear how you like them!

Open Office Calc

If you just want to see what the sum is temporarily, you can highlight an entire column by clicking the letter above the column–Calc will show you the sum of all the items in that column in the footer of the window (I’ve shrunk it down to keep it easy to see here, but the window normally fills all/most of the screen):

Click images for a larger view

Before:

Click column header (red arrow):

Sum shows (red arrow):
(The sum won’t be exactly in the right-hand corner of the program, just in the footer. I’ve shrunk the whole thing down for easy viewing in the small images here.)

You can also just highlight a few cells and it will do the same, no need to do the whole column if you want to total only certain entries–even if the entries aren’t next to each other:

Open Office Calc’s Autosum

If you want to add the column up and save the total for quick reference later (without having to reselect the column)/to see how it changes when you add/remove/edit the numbers, you can use the auto-sum button to insert the total into the spreadsheet.

Highlight what you want to add up plus one extra blank space below it, and click the blue “E” (see the red arrow):

and the sum will be put in the extra box; in this example $14.95 is the total:

Go To Great Panes, Kathryn Maloney ©2012
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.

Clarification of New International Mail Rules

Go To Great Panes, Kathryn Maloney ©2012
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.

There’s been a lot of concern about the new international mail rules and shipping international packages from home so I double checked with USPS on the phone and they confirmed that:

If your package is under 13 oz and has a computer-generated label where the customs data was electronically submitted, you can place your package in your mail box for pick up or drop it off in a blue mail box even if you are only using postage stamps to cover the cost of mailing.

To help with where the May 17th bulletin that announced that it is acceptable describes that aspect:

Under “Overview of Work Changes” there’s a statement that excludes packages with electronically submitted info from being required to be presented to a postal clerk if they are less than 13 oz:

…international mailpieces bearing a PS Form 2976-A, Customs Declaration and Dispatch Note CP 72, or PS Form 2976, Customs Declaration CN 22 — Sender’s Declaration, that was not completed and submitted online (e.g., using Click-N-Ship service, Click-N-Ship® for Business service, an authorized PC Postage® vendor, or the USPS Web Tools® system) will only be accepted at a retail service counter at a Post Office™ location…

I don’t know why they used a ‘negative statement’ to make that point, but I think it’s what has really got folks confuted.

The Click-N-Ship® for Business service (formerly the Shipping Assistant) and the USPS Web Tools® system (the online version of Click-N-Ship® for Business which can be used by Mac owners) both submit the customs form online, so packages using these labels can still be dropped in any mail box to be mailed with postage stamps, so long as they are under 13 oz.

I asked a half dozen different ways to be sure the person I spoke with fully understood I was using either “Click-N-Ship for Business service” and/or the “USPS Web Tools system” to create the label & customs form and using peel & stick and postage stamps with those labels (not paying for the postage online or with a meter). She found two different locations in her supporting paperwork that described that it is still ok, but said unfortunately it was not something she could show me on the USPS website.

Q: If I use Click-N-Ship® for Business to create the label, and it submits the customs form, do I have to bring an under 13 oz package to the PO to mail or can I add postage stamps and leave in any mailbox?

A: If the package is under 13 oz (and the customs information has been submitted electronically as this program does), you can ship from home or drop your package in any mail box.

Go To Great Panes, Kathryn Maloney ©2012
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.