Differences

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

--- dropship [2026/05/20 12:51] – mwlucas
+++ 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 "cause IS enough pain 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
-Orders from US, UK, and AU each require a separate spreadsheet. Simplest thing is to grab the prior version. 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//.
+You also need shipping method codes. Shipping method depends on where the books are printed and where they're going.
-Make a copy of the backer report. Trim it down to drop shipments only. Make a copy of that for each printing location and trim it to books we want to print there. What gets printed where depends on the destination.
+**printing in US**
+  * USPSMMDC for US destination
+  * ECONROW for non-US destination
+**printing in UK**
+  * ECONOMY for UK destinations
+  * STANDARD for mainland Europe destinations
+**printing in AU**
+  * ECONAU for Australia
+  * don't ship from Australia to anywhere outside Australia. You cannot reach Australia. You cannot escape Australia. Just be glad you can print in Australia.
+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.
+(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.)
-You should now have three spreadsheets, by print location. We can now rearrange each to fit the IS order spreadsheet.
+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.
-Each combination of recipient and book version gets its own line in the spreadsheet. The columns are:
+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:
   * ISBN (beware autoincrement!)
   * Title
   * Quantity
-  * Customer PO (YYYYMMDD001, do autoincrement)
+  * 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)
-  * Shipping Method depends on country, see the list below.
+  * Shipping Method depends on country, see the list above.
   * Name/Recipient
   * Address Line 1
@@ Line 39: / Line 56: @@
   * Address Line 3
   * Order Notification Email -- backer's email address
-  * Nine blank fields because TWP doesn't do enough
+  * Nine blank fields because TWP doesn't do enough business in EU to have customs there.
-  * Actual Selling Price -- get number from MWL
+  * Actual Selling Price -- always fill this in even if it seems stupid, get numbers from MWL
-  * Commercial Invoice Currency -- always USD -- filling in customs for in-country shipments is fine, better that than miss a customs line that needs to be there
+  * Commercial Invoice Currency -- always USD
-Copy the rearranged spreadsheet into the Ingram template.
+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 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.
-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.
-**printing in US**
-  * USPSMMDC for US destination
-  * ECONROW for non-US destination
-**printing in UK**
-  * ECONOMY for UK destinations
-  * STANDARD for mainland Europe destinations
-**printing in AU**
-  * ECONAU for Australia
-  * don't ship from Australia to anywhere outside Australia. You cannot reach Australia. You cannot escape Australia. Just be glad you can print locally.
-You should now have a complete Ingram order spreadsheet!
+You should now have three complete Ingram order spreadsheets! Give them to MWL to send to Ingram.