What information and format for book data is required for your service?
Book data information and format:
We can handle just about any file format to upload and display your books on our web site including Access, Excel and FileMaker Pro. We recommend that you use our own inventory free management software HomeBase. However, if you have your own book list already or you wish to use your own inventory management system we can set this up for you. The data must be tab or tilde (~) delimited, and must be saved as a text file (file type = .txt).
There are 3 things that we require in order to convert your books to our format:
1. The data must be consistently arranged in a file. All book records must contain exactly the same number of fields, in exactly the same order; each field must be separated with the same type of delimiter. If you are using a database or spreadsheet package then this is quite easy to accomplish.
2. It is essential that each book record has a unique identifier. These can be numeric or alphanumeric, as long as they are unique. When you delete or sell a book, it is necessary to "retire" the associated ID number and use only new numbers for your new books. AbeBooks cannot guarantee the accuracy of a listing if a book number is re-used. A re-used book ID is any ID number that was previously assigned to a different book. Re-using book ID numbers may result in discrepancies. If you have more than one copy of a single you can include a quantity field in your book data to state how many copies of the title you have.
3. You will need to remove the books when they are sold (through other venues). You can do this by sending a file containing only the books you want to remove, by using a link on our Members Menu, or by adding a status code or a quantity field to your database or spreadsheet. For example: you can indicate that you have a book for sale with the number 1, and then when the book has been sold you can update the quantity to 0.
If your book records had the following field structure:
field 1: Book ID
field 2: Author
field 3: Title
field 4: Publisher
field 5: Illustrator
field 6: Publisher Date
field 7: Publisher place
field 8: Edition
field 9: Book Condition
field 10: Description
field 11: Jacket Condition
field 12: Binding
field 13: Catalogue
field 14: Keywords
field 15: ISBN
field 16: Price
field 17: Signed (“y” or “n”, or “yes” or “no”, etc..)
field 18: Quantity (to determine if the book will be put online or removed from the web site - use a “1” to indicate that the item is available, and a “0” when the item has been sold)
You may wish to use an Excel template that we have already set up for you:
For Mac users please click [here] to view an example.
Note: If you decide to use the template to catalogue your book with, please remember that before you send your book list to us to save the file as tab delimited text (.txt) format:
1. Open the Excel sheet
2. Select [File]
3. Select [Save as]
4. From the [Save as type] menu select “Text (Tab delimited)(*.txt)”
We can manipulate your data just about any way to fit into our database, so please feel free to set up your database to suit your needs. We will make your data fields flow in an appropriate fashion when viewed on AbeBooks.
Book terms and attributes:
If your book data does not have separate fields for attributes and only use the description field then AbeBooks searches this field of the book data you send to us. This is known as parsing. We check for the specific attributes that can be searched for using the Advanced Search function. This helps buyers to find your books on AbeBooks! These attributes and their various abbreviations are listed below. If you are not sure if parsing is switched on or off for your account please contact us.
Note: If you are using HomeBase to manage your inventory, you have the option of including attributes in the description field or by using the drop down menus. Please do not add attributes using both the description field and drop down menus. Adding information to both places may result in the attributes being displayed incorrectly. If you use the description field then we will switch on parsing for your account.
The description field of your book data file is checked for the following terms:
1. Jacket Condition: New, As New, Fine, Very Good, Fair, Poor
2. Book Condition: New, As New, Fine, Very Good, Good, Fair, Poor
3. Book Type: Hardcover, Paperback
4. Edition: First, Second, Third, Fourth, Fifth or later
5. Inscription Type: Signed by Author, Inscribed by Author, Signed by Illustrator, Inscribed by Illustrator
Note: It is necessary to distinguish between signed books and inscribed books as both will be searchable using the Signed attribute. If you do not wish to have inscribed books displayed as signed by the author, we kindly ask that you reword the book description to either “inscription in ink” or “hand-written note” instead
of “inscribed” or “inscription”.
Please review the AbeBooks Glossary for help with book terms.
