Custom Book Series Management System
Budget: £20 – £250 GBP
Book Series Compiler
Aim
To have a system into which we scan our incoming raw stock of books, check them against a database of book series which we want to keep and tells us if we need the book and if so where it needs to go. It also reports if a full set is made.
User Work-Flow
Scan book ISBN into PC using barcode scanner
Is book needed?
If yes, print locator slip on Star TSP100 label printer (this will be the PC’s default printer)
If no show message on screen to user.
Database Lookup
The books will need to be compared to a database (we will build/populate this, probably as an excel file).
Look up whether it is in the database or not
If yes, do we need it? We need it if we have fewer than 4 copies or that title in stock.
If needed return colour green to user.
If needed it then increases database quantity by 1.
If needed then print locator slip which will contain the following information:
Series Title
Book Title
Place in series (Book 2/8 for example)
If book completes a series then show colour orange to user and print “SET COMPLETE” on locator slip as well as the usual needed information.
If book completes a series then reduce all quantities by 1.
If quantity is at 4 then reject and show colour red to user.
Database Format
The database will have the following format (or something very similar):
Series Title
Series Author
Book Title
Position in Series
ISBNs
Location
Quantity on hand
As an example:
Series Title: Goblins
Series Author: David Melling
Position in Series: 1
Book Title: Stone
ISBN1: 9780340930489
ISBN2: 9780340944080 (depending on the title there may be one ISBN field or 5 or more)
Location: P02-A
Quantity on hand: 3
Notes
Periodically I may want to remove all stock of a certain series and so I would like to be able to easily edit the database so if it was running in excel or sheets rather than access then that would be easier for me.
Aim
To have a system into which we scan our incoming raw stock of books, check them against a database of book series which we want to keep and tells us if we need the book and if so where it needs to go. It also reports if a full set is made.
User Work-Flow
Scan book ISBN into PC using barcode scanner
Is book needed?
If yes, print locator slip on Star TSP100 label printer (this will be the PC’s default printer)
If no show message on screen to user.
Database Lookup
The books will need to be compared to a database (we will build/populate this, probably as an excel file).
Look up whether it is in the database or not
If yes, do we need it? We need it if we have fewer than 4 copies or that title in stock.
If needed return colour green to user.
If needed it then increases database quantity by 1.
If needed then print locator slip which will contain the following information:
Series Title
Book Title
Place in series (Book 2/8 for example)
If book completes a series then show colour orange to user and print “SET COMPLETE” on locator slip as well as the usual needed information.
If book completes a series then reduce all quantities by 1.
If quantity is at 4 then reject and show colour red to user.
Database Format
The database will have the following format (or something very similar):
Series Title
Series Author
Book Title
Position in Series
ISBNs
Location
Quantity on hand
As an example:
Series Title: Goblins
Series Author: David Melling
Position in Series: 1
Book Title: Stone
ISBN1: 9780340930489
ISBN2: 9780340944080 (depending on the title there may be one ISBN field or 5 or more)
Location: P02-A
Quantity on hand: 3
Notes
Periodically I may want to remove all stock of a certain series and so I would like to be able to easily edit the database so if it was running in excel or sheets rather than access then that would be easier for me.