Differences

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

--- dropship [2026/05/27 14:38] – 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.
+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're willing to set you up with it."\\
@@ 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. 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.)
@@ 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.
-//
+// \\
+(Future kickstarters won't have this step, because future MWL will have learned better.)
 **Check for stray or failed autoincrements**\\
@@ Line 68: / Line 70: @@
 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.