Book Inventory Template

Track titles, ISBNs, copies on the shelf and margins for a bookstore or library, with low-stock flags and cover gallery.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Inventory

Tables

Books

Fields

17

Views

grid, cards, dashboard

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

1 tab17 fields6 sample rows

Views
  • Inventory (Grid view)
  • Shelf (Cards view)
  • To reorder (Grid view)
  • Stock overview (Report view)
17 fields
Books: 6 sample rows
RowTitle (Text)Cover (Attachment)Author (Text)ISBN (Barcode)Genre (Single select)Format (Single select)Publisher (Text)Year (Number)Shelf (Text)Copies in stock (Number)Reorder at (Number)Stock status (Formula)Cost price (Currency)Selling price (Currency)Margin (Formula)Stock value (cost) (Formula)Rating (Rating)
1
The God of Small Things
Arundhati Roy
9780006550686
Fiction
Paperback
Penguin
1,997
F-03
12
4
In stock
₹280
₹450
38%
₹3,360
2
Sapiens
Yuval Noah Harari
9780099590088
Non-fiction
Paperback
Vintage
2,015
NF-01
3
5
Reorder
₹360
₹599
40%
₹1,080
3
The Gruffalo
Julia Donaldson
9781509804757
Children
Paperback
Macmillan
1,999
K-02
0
3
Out of stock
₹220
₹399
45%
₹0
4
Zero to One
Peter Thiel
9780753555200
Business
Paperback
Virgin Books
2,014
B-04
7
3
In stock
₹300
₹499
40%
₹2,100
5
A Brief History of Time
Stephen Hawking
9780857501004
Science
Hardcover
Bantam
1,988
S-01
5
2
In stock
₹520
₹799
35%
₹2,600
6
Milk and Honey
Rupi Kaur
9781449474256
Poetry
Paperback
Andrews McMeel
2,015
P-01
9
3
In stock
₹250
₹399
37%
₹2,250
Field details
Title · Text
Cover · Attachment
Author · Text
ISBN · Barcode
Genre · Single select
Fiction, Non-fiction, Children, Business, Science, Poetry, Comics
Format · Single select
Hardcover, Paperback, Box set
Publisher · Text
Year · Number
Shelf · Text
Copies in stock · Number
Reorder at · Number
Stock status · Formula
IF({Copies in stock} <= 0, 'Out of stock', IF({Copies in stock} <= {Reorder at}, 'Reorder', 'In stock'))
Cost price · Currency
INR
Selling price · Currency
INR
Margin · Formula
IF({Selling price} > 0, ({Selling price} - {Cost price}) / {Selling price}, BLANK())
Stock value (cost) · Formula
{Copies in stock} * {Cost price}
Rating · Rating

Book Inventory Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates