TWP Docs

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
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."\\
**This page is only useful once you have access to spreadsheet-based ordering.**

Information needed:
  * KS Backer Report Spreadsheet
  * 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. 

**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: UK and EU
  * AU: Australia Only
  * 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.)

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. 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. 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 above.
  * Name/Recipient
  * Address Line 1
  * Address Line 2
  * City
  * State
  * Postal Code
  * Country Code
  * Phone Number
  * Address Line 3
  * Order Notification Email -- backer's email address
  * Nine blank fields because TWP doesn't do enough business in EU to have customs there.
  * Actual Selling Price -- always fill this in even if it seems stupid, get numbers from MWL
  * Commercial Invoice Currency -- always USD

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**\\
**Check for stray or failed autoincrements**\\
**Check for stray or failed autoincrements**\\ (No really, MWL, check!)

Save your spreadsheets.

You should now have three complete Ingram order spreadsheets! Give them to MWL to send to Ingram.