This is an old revision of the document!
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 “cause IS enough pain 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
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.
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.
- UK: EU and UK
- 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)
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.
Each combination of recipient and book version gets its own line in the spreadsheet. The columns are:
- ISBN (beware autoincrement!)
- Title
- Quantity
- Customer PO (YYYYMMDD001, do autoincrement)
- 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.
- 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
- Actual Selling Price – get number 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
Copy the rearranged spreadsheet into the Ingram template.
Check for stray or failed autoincrements, and leave this line bolded for MWL.
Save your spreadsheet.
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!