Import a file
Open Import Order File from the Dashboard, or New Order → Import Order File on the Orders page.
- Drag a file onto the page, or click Choose File. book by book accepts
.pdf,.xlsx,.xls,.csv,.tsvand.txt. - book by book detects the format and shows Detected: with the source. If the file holds several orders, it says how many it found.
- Click Import Books. Each order in the file becomes an order in book by book, with quantities and costs from the file.
Imported invoices are named after the invoice, for example "Ingram Invoice 12345678 (PO 4471)".
Need a starting point? Download template gives you a spreadsheet with the right columns.
Import needs a paid plan after the trial.
Supported sources
book by book recognizes files from:
- Ingram: invoice PDFs, iPage order exports, and supplier or catalog exports. See the guide on receiving Ingram orders.
- Ingram Publisher Services (IPS) invoice PDFs
- Edelweiss order exports
- Pubeasy order exports
- BookNet CataList
- Penguin Random House
- Gardners
- Hachette Book Group Canada
- Scholastic Canada
- UTP Distribution
- La Panoplia invoice PDFs
- Orca Scan exports
- Used bookstore spreadsheets, with condition and price columns
Anything else works as long as it's a spreadsheet with an ISBN column. Quantity, price and cost columns are picked up when present. View expected file formats on the import page lists the columns for each format.
If the format isn't detected
Check that the file has a header row and an ISBN column, or start from Download template. If a distributor's file still won't import, send it to us through Help and we'll add support for it.