dropship
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| dropship [2026/05/26 18:59] – alex | dropship [2026/05/29 09:16] (current) – alex | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | Books are drop-shipped via IngramSpark spreadsheet ordering. | + | This is for books that MWL doesn' |
| + | |||
| + | Books are drop-shipped via IngramSpark spreadsheet ordering. | ||
| If you're visiting this page in hope of learning how to get access to IS spreadsheet ordering: I can't help you. The method seems to be "order so many titles through the web interface that they' | If you're visiting this page in hope of learning how to get access to IS spreadsheet ordering: I can't help you. The method seems to be "order so many titles through the web interface that they' | ||
| Line 21: | Line 23: | ||
| - | Orders from US, UK, and AU each require a separate spreadsheet.\\ Simplest thing is to grab the version you used the last time you attempted to fulfill a Kickstarter. Keep the column names but erase the data. You now have a template you can use. Make sure the //Lightning Source Pubid// field gives the right code for TWP in the chosen country. Save them as campaign-IngramLocation-dropship-YYYY-MM-DD as an XLSM, i.e., // | + | Orders from US, UK, and AU each require a separate spreadsheet.\\ Simplest thing is to grab the version you used the last time you attempted to fulfill a Kickstarter. Keep the column names but erase the data. You now have a template you can use. \\ Make sure the //Lightning Source Pubid// field gives the right code for TWP in the chosen country. |
| What gets printed where depends on the destination. | What gets printed where depends on the destination. | ||
| - | * UK: EU and UK | + | * UK: UK and EU |
| * AU: Australia Only | * AU: Australia Only | ||
| - | * US: North and South America, Japan, Asia, New Zealand (Yes, it's cheaper to ship to NZ from the US than Australia. Yes, this is ridiculous) | + | * US: North and South America, Asia, New Zealand (Yes, it's cheaper to ship to NZ from the US than Australia. Yes, this is ridiculous) |
| (If you're in doubt, go to the IS web interface. Fill out an order for that book to that destination. See how much it costs to ship there from each printer location. Compare the cheapest shipping from each location.) | (If you're in doubt, go to the IS web interface. Fill out an order for that book to that destination. See how much it costs to ship there from each printer location. Compare the cheapest shipping from each location.) | ||
| Line 33: | Line 35: | ||
| Make a copy of the backer report. Trim it down to drop shipments only. Delete everything else. This new sheet will be sorted into into three **separate** spreadsheets: | Make a copy of the backer report. Trim it down to drop shipments only. Delete everything else. This new sheet will be sorted into into three **separate** spreadsheets: | ||
| - | Now that you have three spreadsheets for three printing locations, you can rearrange each to fit the IS order spreadsheet. The spreadsheet has columns defined for you. Cut and paste the information you have to fit the template IS gave you. There will be a lot of cutting and pasting, one column at a time. And when you finish the first sheet, you get to do it again! And again! :!: | + | Now that you have three spreadsheets for three printing locations, you can rearrange each to fit the IS order spreadsheet. The spreadsheet has columns defined for you. Cut and paste the information you have to fit the template IS gave you. There will be a lot of cutting and pasting, one column at a time. And when you finish the first sheet, you get to do it again :!: And again :!: |
| The columns are: | The columns are: | ||
| Line 40: | Line 42: | ||
| * Title | * Title | ||
| * Quantity | * Quantity | ||
| - | * Customer PO. You will make up this number using the date and autoincrements. (YYYYMMDD001, | + | * Customer PO. You will make up this number using the date and autoincrements. (YYYYMMDD001, |
| * Customer PO line # (usually 1, might be 2 if the backer gets two different titles. Do not autoincrement!) | * Customer PO line # (usually 1, might be 2 if the backer gets two different titles. Do not autoincrement!) | ||
| * Customer Alternate Reference # (leave blank) | * Customer Alternate Reference # (leave blank) | ||
| Line 51: | Line 53: | ||
| * Postal Code | * Postal Code | ||
| * Country Code | * Country Code | ||
| - | * Phone Number | + | * Phone Number |
| * Address Line 3 | * Address Line 3 | ||
| * Order Notification Email -- backer' | * Order Notification Email -- backer' | ||
| Line 59: | Line 61: | ||
| Check for extra copies or other books ordered as add-ons. Add lines and adjust quantities for them. //Remind MWL to never offer extra print copies as add-ons, because this step keeps tripping him up. | Check for extra copies or other books ordered as add-ons. Add lines and adjust quantities for them. //Remind MWL to never offer extra print copies as add-ons, because this step keeps tripping him up. | ||
| - | // | + | // \\ |
| + | (Future kickstarters won't have this step, because future MWL will have learned better.) | ||
| - | **Check for stray or failed autoincrements**, and leave this line bolded | + | **Check for stray or failed autoincrements**\\ |
| + | **Check | ||
| + | **Check for stray or failed autoincrements**\\ (No really, | ||
| Save your spreadsheets. | Save your spreadsheets. | ||
| - | You should now have three complete Ingram order spreadsheets! Give thenm to MWL to send to Ingram. | + | You should now have three complete Ingram order spreadsheets! Give them to MWL to send to Ingram. |
dropship.1779836353.txt.gz · Last modified: by alex