Differences

This shows you the differences between two versions of the page.

--- dropship [2026/05/26 18:52] – 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't touch. They are shipped directly from the printer to the backer, and they arrive unsigned.
-//**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're willing to set you up with it."
+Books are drop-shipped via IngramSpark spreadsheet ordering.
-**// This page is only useful once you have access to spreadsheet-based 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're willing to set you up with it."\\
+**This page is only useful once you have access to spreadsheet-based ordering.**
 Information needed:
@@ Line 8: / Line 10: @@
   * ISBN and title of every title included
-You also need shipping method codes. Shipping method depends on where the books are printed and where they're going. (No, there is no "send this via whatever the source country passes off as Media Mail" code.)
+You also need shipping method codes. Shipping method depends on where the books are printed and where they're going.
 **printing in US**
@@ 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., //defenestrated-UK-dropship-2026-02-31.xlsm//.
+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., //defenestrated-UK-dropship-2026-02-31.xlsm//.
  What gets printed where depends on the destination.
-  * UK: EU and UK
+  * UK: UK and EU
   * 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, 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.)
@@ 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: one for UK printing, one for AU printing, one for US printing.
-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.
+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:
@@ Line 40: / Line 42: @@
   * Title
   * Quantity
-  * Customer PO. You will make up this number using the date and autoincrements. (YYYYMMDD001, YYYMMDD002, etc.)
+  * Customer PO. You will make up this number using the date and autoincrements. (YYYYMMDD001, YYYMMDD002, etc. **Note: start with 001 on the first spreadsheet, and then pick up where you left off on the next spreadsheet, and the next**)
   * Customer PO line # (usually 1, might be 2 if the backer gets two different titles. Do not autoincrement!)
   * Customer Alternate Reference # (leave blank)
@@ Line 51: / Line 53: @@
   * Postal Code
   * Country Code
-  * Phone Number -- SPREADSHEET BREAKS COPY AND PASTE, START NEW CHUNK HERE
+  * Phone Number
   * Address Line 3
   * Order Notification Email -- backer's email address
@@ 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.
-//
+// \\
-Copy the rearranged spreadsheet into the Ingram template.
+(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 for MWL.
+**Check for stray or failed autoincrements**\\
+**Check for stray or failed autoincrements**\\
+**Check for stray or failed autoincrements**\\ (No really, MWL, check!)
-Save your spreadsheet.
+Save your spreadsheets.
-You should now have a complete Ingram order spreadsheet! Give it to MWL to send to Ingram.
+You should now have three complete Ingram order spreadsheets! Give them to MWL to send to Ingram.