preparing_address_labels
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| preparing_address_labels [2026/05/29 10:51] – alex | preparing_address_labels [2026/05/29 11:26] (current) – alex | ||
|---|---|---|---|
| Line 22: | Line 22: | ||
| **On the “I Ship” copy of the spreadsheet: | **On the “I Ship” copy of the spreadsheet: | ||
| - | * Sort by reward\\ | + | Sort by reward\\ |
| - | * Delete any rows that are for ebook only\\ | + | Delete any rows that are for ebook only\\ |
| - | * Delete any rows that are for unsigned books\\ | + | Delete any rows that are for unsigned books\\ |
| - | * Delete any rows for people who never completed their survey. (Shake your head and wonder what’s wrong with them, but delete their rows anyway.)\\ | + | Delete any rows for people who never completed their survey. (Shake your head and wonder what’s wrong with them, but delete their rows anyway.)\\ |
| - | * Check for add-ons (but future you won’t have this problem!)\\ | + | Check for add-ons (but future you won’t have this problem!)\\ |
| - | * Delete any columns that are not needed, i.e. rewards that nobody took\\ | + | Delete any columns that are not needed, i.e. rewards that nobody took\\ |
| - | * Cut any other columns that aren’t necessary for shipping. For example: backing minimum, reward ID, backer number, backer user ID, pledged status, notes, bonus support, survey response, etc.\\ | + | Cut any other columns that aren’t necessary for shipping. For example: backing minimum, reward ID, backer number, backer user ID, pledged status, notes, bonus support, survey response, etc.\\ |
| - | * Save this “clean” spreadsheet | + | Save this “clean” spreadsheet |
| **Here is the list of tasks that fall under the category of “I Ship.”** Each task has its own distinct workflow. They are arranged here in order of least complicated to most complicated. | **Here is the list of tasks that fall under the category of “I Ship.”** Each task has its own distinct workflow. They are arranged here in order of least complicated to most complicated. | ||
| - | Domestic Paperbacks\\ | + | * Domestic Paperbacks\\ |
| - | Domestic Hardcovers\\ | + | * Domestic Hardcovers\\ |
| - | Overseas Paperbacks\\ | + | * Overseas Paperbacks\\ |
| - | Overseas Hardcovers\\ | + | * Overseas Hardcovers\\ |
| - | Other small add-ons (thank you, future MWL, for not including these!)\\ | + | * Other small add-ons (thank you, future MWL, for not including these!)\\ |
| - | Print Bundles\\ | + | * Print Bundles\\ |
| - | The Full Michael\\ | + | * The Full Michael\\ |
| ===== Domestic Postage ===== | ===== Domestic Postage ===== | ||
| Line 48: | Line 48: | ||
| Delete anything that isn’t US paperbacks\\ | Delete anything that isn’t US paperbacks\\ | ||
| Delete duplicate columns\\ | Delete duplicate columns\\ | ||
| - | Check the phone number column to make sure the numbers are real numbers and not a formula (thanks, excel! /s)\\ | + | Check the phone number column to make sure the numbers are real numbers and not a formula (thanks |
| Turn the spreadsheet back into a .csv file\\ | Turn the spreadsheet back into a .csv file\\ | ||
| Important! Make note of how many orders you have!\\ | Important! Make note of how many orders you have!\\ | ||
| Line 54: | Line 54: | ||
| Go to Shippo.com\\ | Go to Shippo.com\\ | ||
| Log into shipping app\\ | Log into shipping app\\ | ||
| - | Go through and map all the components of your spreadsheet to what they are on Shippo’s template. For example, shipping address = Street line 1 (See screenshot 1) \\ | + | Under “package, |
| + | Set that to the default package. Sometimes that works, sometimes it doesn' | ||
| + | Go through and make sure all the components of your spreadsheet | ||
| Hit “upload.” \\ | Hit “upload.” \\ | ||
| - | Shippo will say “Your orders are being imported.” | + | Shippo will say “Your orders are being imported.” |
| Click “orders.” Verify that you have the correct number of orders. \\ | Click “orders.” Verify that you have the correct number of orders. \\ | ||
| - | Change anything that says “ignore” in Shippo to what the things | + | Change anything that says “ignore” in Shippo to what the thing actually is. For example “quantity” needs to be changed to “quantity.” There is a dropdown menu. It’s hella annoying. Go through it anyway. \\ |
| - | Under “package, | + | Repeat for every entry. \\ |
| - | Use US Priority Mail envelopes. They' | + | |
| - | Set that to the default package. Sometimes that works, sometimes it doesn' | + | |
| - | Repeat for every entry. Note that Shippo is slow. Drink some water while you wait. You’re probably dehydrated anyway. \\ | + | |
| Select all\\ | Select all\\ | ||
| Buy postage (upper right corner) for $NUMBER of labels (verify, verify!) \\ | Buy postage (upper right corner) for $NUMBER of labels (verify, verify!) \\ | ||
| Labels will be downloaded as a PDF to your computer.\\ | Labels will be downloaded as a PDF to your computer.\\ | ||
| - | Now it’s time to print them.\\ | + | //(Note: if you have a Director of Analog Distribution, |
| + | When you're ready to print:\\ | ||
| Check that you have the correct number of labels.\\ | Check that you have the correct number of labels.\\ | ||
| Make sure your computer knows what size paper you’re printing on\\ | Make sure your computer knows what size paper you’re printing on\\ | ||
| - | Argue with the printer. Check the preview. Argue some more. Tell the computer, again, what size\\ | + | Argue with the printer. Check the preview. Argue some more. Tell the computer, |
| MWL signs the books\\ | MWL signs the books\\ | ||
| DAD packages and labels them, puts them in a box to go to the post office\\ | DAD packages and labels them, puts them in a box to go to the post office\\ | ||
| Line 78: | Line 78: | ||
| ===== Overseas Postage ===== | ===== Overseas Postage ===== | ||
| - | **International orders are a whole level up! (Woot! You’re leveling up! High five!)**\\ | + | **International orders are a whole level up! **(Woot! You’re leveling up! High five!)\\ |
| Make yet another copy of the “clean” spreadsheet.\\ | Make yet another copy of the “clean” spreadsheet.\\ | ||
| Delete anything that isn’t international paperbacks\\ | Delete anything that isn’t international paperbacks\\ | ||
| Line 123: | Line 123: | ||
| - | ===== Some Important | + | ===== Some Important |
| Shippers do not check addresses until you try to buy. If Shippo can't identify an address, they complain now. Look for obvious typos. Don't assume you can figure it out via Google Maps or whatever. You can't. Packages will be lost. Contact the recipient with the address and tell them USPS can't figure it out. | Shippers do not check addresses until you try to buy. If Shippo can't identify an address, they complain now. Look for obvious typos. Don't assume you can figure it out via Google Maps or whatever. You can't. Packages will be lost. Contact the recipient with the address and tell them USPS can't figure it out. | ||
| Line 132: | Line 132: | ||
| Yes, these packages get **four** address labels. | Yes, these packages get **four** address labels. | ||
| - | ===== The Vital Importance of The Manifest ===== | + | ===== The Vital Importance of the Manifest ===== |
| **At the end of the day, print goshippo manifest!** Manifests are only available for a couple days, so this is vital to avoid angering the postal folks. (Do not anger the postal folks. They can crush you with a thought.)\\ | **At the end of the day, print goshippo manifest!** Manifests are only available for a couple days, so this is vital to avoid angering the postal folks. (Do not anger the postal folks. They can crush you with a thought.)\\ | ||
preparing_address_labels.1780066318.txt.gz · Last modified: by alex