This document will address the requirements for making use of the Booksrun automated Inventory and Order processing systems.
Order and Confirmation delivery is done via FTP (ftp.booksrun.com) with credentials provided by Booksrun after your approval. Using this method, multiple orders are combined into a single text file and Retrieved by the seller via FTP. A seller then sends a text file back to Booksrun that includes confirmations and cancellations. The text Confirmation file is then processed by Booksrun and the status of the orders is updated. This document will address the requirements for making use of the FTP method for Booksrun Automated Order Processing.
All the dates in this guide, as well as the dates in the seller panel and buyer panel belong to Eastern Time Zone.
Inventory files must be placed in the following directory:
You must be consistent and follow certain conventions in the way you name the inventory files you provide.
Below we describe our naming conventions:
marketUserName - your seller name on Booksrun
- YYMMDD - for daily uploads
- _YYMMDDHHMM - for multiple uploads a day
- ".part" for partial replacement and partial updates
- ".full" or ".purge" for purge and replace
- If left empty a partial replacement or partial update is assumed.
- ".csv" - comma ',' separated fields
- ".txt" - tab '/t' separated fields
- If left empty or unknown, file is treated like a ".csv"
Use the following as a guide:
|File Naming Convention||Example||Comments|
|membername_YYMMDD.part.csv||bookworld_040916.part.csv||This is a partial upload file for Sept. 16, 2004.|
|membername_YYMMDD_HHMM.part.csv||bookworld_040901_2145.part.csv||This is a partial upload file for Sept. 1, 2004, 9:45pm.|
|membername_YYMMDD.full.csv||bookworld_040901.full.csv||This is a full upload file for Sept. 1, 2004.|
|membername_YYMMDD_HHMM.full.csv||bookworld_040815_2145.full.csv||This is a full upload file for Aug. 15, 2004, 9:45 p.m.|
If you provide just one inventory update file per day, you should include the date in your file name. If you provide multiple updates in a day, you should include a time stamp. Note that embedded spaces within a filename are not acceptable. Separate values within the filename with an underscore "_" character as in the examples above.
Full Replacements must include ".full" or ".purge" in the file name and we strongly suggest including ".part" in Partial Replacements in the filename. If nothing is specified we assume a Partial Replacements.
If there is no file extension in the file name comma delimited is assumed.
|A||9780471749554||12345||17.99||15||Like New||Book is used and in great shape|
|Field Name||Data Type||Max Field Length, Max Value||Example||Notes|
|add-modify-delete||Text||1||A||Possible values: A, M, D|
|isbn13||Text||13||9780471749554||ISBN10 is supported too (auto translated to ISBN13)|
|sku||Text||40||12345||Must be unique|
|price||Number||20000000||14 or $14.00 or $14|
|item-condition||Text||Like New||Required Values: New, Like New, Very Good, Good, Acceptable|
|item-note||Text||2048||Still in shrink wrap!||Displays with your listing|
Additional formatsOther supported inventory formats:
Order files are generated in the following directory:
Data formatData format is the same as Amazon Fulfillment Report File Format
|Field Name||Data Type||Example||Notes|
|payment-status||Text||paid_ship_now||Should be paid_ship_now always|
|order-item_id||Number||12||Order item ID|
|payments-date||Date||2019-02-23 04:22:37||Date the order was paid|
|item-name||Text||Campbell Biology (11th Edition)|
|price||Number||17.99||Total of item price and shipping compensation|
|quantity-purchased||Number||3||Quantity of items ordered|
|purchase-date||Date||2019-02-23 04:22:37||Date the order was placed|
|ship-address-1||Text||8 West Main|
|ship-method||Text||standard||Possible values: standard, expedited|
File exampleDownload orders file example: orders.csv
Confirmation files must be placed in the following directory:
|1||3||Cancel||Out of stock|
|Field Name||Data Type||Max Field Length||Example||Notes|
|ORDER_STATUS||Text||40||Confirm||Must be Cancel or Confirm|
|REPLY||Text||255||Out of stock||Shown to customer (or should be)|
- Fillz confirmation format (not advised, use default confirmation file format for better precision)
Support of 3rd party inventory management systems
The Art of Books
ArtOfBooks integration can be configured with Custom Venues feature.
In ArtOfBooks dashboard Go to "Settings" > "Venue settings" and use the following settings for any free Custom Venue slot:
|Custom Venue X FTP Display Name||Any meaningful name (e.g. Booksrun, Booksrun.com, Booksrun Marketplace etc.)|
|Custom Venue X FTP Host||ftp.booksrun.com|
|Custom Venue X FTP Username||Your FTP username on Booksrun Marketplace|
|Password||Your FTP password on Booksrun Marketplace|
|Password (Re-enter)||Your FTP password on Booksrun Marketplace|
|Custom Venue X FTP Directory||ArtOfBooks|
Monsoon integration is fully supported.
Ask Monsoon support for assistance.