Running a bookshop on ISBNs, editions and returns

Stock a bookshop by ISBN so each edition is counted on its own, and track sale-or-return stock party by party so returns go back before the window closes.

Bookstore inventory management in India works best when every book is stocked against its ISBN, not its title, and every sale-or-return lot is tracked against its supplying party with a return-due date. Done this way, each edition is counted on its own, reorders go out for the right version, and unsold copies go back before the return window closes rather than becoming dead stock you have already paid for.

Why is a bookshop harder to stock than most shops?

There are more distinct items and fewer copies of each. A grocery shop may have a few hundred items that each sell daily. A bookshop can carry thousands of titles where most sell one or two copies a month. On top of that, the same title often exists in several versions, and some stock is bought outright while other stock arrives on sale-or-return.

So the hard part is not counting. It is knowing exactly which edition is on the shelf, who supplied it, and whether you still have the right to send it back.

Why key stock on ISBN rather than title?

Because the ISBN identifies an edition, and a title does not. A hardback, a paperback, a revised edition and a new-format reissue of the same book usually each have their own ISBN. They may have different prices, different suppliers and different return terms.

If your stock list says "one title, 9 copies", you cannot answer simple questions. How many are the old edition? Which ones can go back? Which one should you reorder? Keying on ISBN answers all three. Practical rules:

One ISBN, one item code. Scan the barcode on the back cover at receiving and at billing, so you never type the number by hand.
Record edition details against the ISBN: format, edition or reprint where shown, language, publisher and MRP.
Link versions of the same title so a customer search for the title shows every edition you hold, with stock for each.
Give books without an ISBN an internal code in one fixed pattern, and never reuse it.

What does edition-level stock with return dates look like?

Here is a stock view for one title held in three versions. All figures are illustrative.

Edition (format)	ISBN	Supply terms	In stock	Received	Return due
2nd edition, paperback	978-X-XXXX-XXXX-1	Sale-or-return, Party A	6	Lot 1	End of month 4 after receipt
2nd edition, hardback	978-X-XXXX-XXXX-2	Bought outright, Party A	2	Lot 2	Not returnable
1st edition, paperback	978-X-XXXX-XXXX-3	Sale-or-return, Party B	3	Lot 3	Due this month, review now

The last row is the one that costs money. The first edition has been replaced, it will not sell, and its return window is about to close. Without a return-due column it simply sits on the shelf.

The return windows here are placeholders. Your real dates come from the terms agreed with each party, so always record them from the supplier's own documents.

How do I track sale-or-return stock?

Treat every sale-or-return receipt as a lot. When copies arrive, record:

The ISBN and quantity.
The supplying party and the purchase document reference.
Whether the lot is sale-or-return or bought outright.
The return-due date under that party's terms.

When a copy sells, reduce the oldest returnable lot for that ISBN first. That way the copies closest to their return date are the ones counted as sold, and newer lots stay available to return. It is the same first-in-first-out thinking explained in FIFO, LIFO and FEFO explained, with the return date taking the place of the expiry date.

Then run a weekly return list: every lot with unsold copies whose return date falls in the next few weeks, grouped by party. Pull those copies, check their condition, pack them against a return document, and adjust stock only once the return has been recorded. Your accountant will want the return document to match the party's credit note, so keep the references together. For how returns are treated for GST, ask your CA rather than following a rule of thumb.

A worked example: one week's return run

Illustrative numbers only. A shop receives 10 paperbacks of a new edition on sale-or-return from Party A. Over the following months it sells 7. The system reduces Lot 1 by 7, leaving 3 copies. Two weeks before the return date, those 3 copies appear on the return list. Staff find 2 on the shelf and 1 in the window display. All 3 are in returnable condition, so they go back on one return document. Stock for that ISBN falls to zero, and the reorder decision is made on actual sales of 7, not on a vague memory of "it sold quite well".

How should I reorder in a bookshop?

Reorder by ISBN, and only for editions the supplier still has in print. For steady sellers such as textbooks, reference books and long-running children's titles, a simple reorder point works: see the reorder point formula. For new releases, place a small first order, preferably on sale-or-return, and reorder from real sales.

Expect seasonal peaks around the academic year for school and college titles. Plan those from last year's sales for the same weeks, edition by edition. A syllabus change can make last year's edition worthless.

Common mistakes

Counting by title. Old and new editions get mixed up, and the old one is the one left on the shelf.
Mixing outright and returnable stock. Copies you own outright end up on a return list, or returnable copies are kept after the window closes.
Not recording the return-due date at receiving. If it is not written down on the day the stock arrives, it gets missed.
Adjusting stock before the return is documented. The shelf and the books stop agreeing.
Ignoring damaged copies. Shop-soiled books often cannot be returned. Keep them in a separate location so they are not counted as returnable.

When does this not apply?

If you deal mainly in used or antiquarian books, each copy is effectively unique, and condition matters more than edition. Track by individual copy instead. If everything you stock is bought outright with no right of return, you can drop the lot tracking, but keying on ISBN still matters.

Spreadsheet or software?

A small shop can run ISBN stock in a sheet if one person keeps it updated every day. Once barcode billing, several parties and weekly return lists are involved, it becomes hard to keep a sheet in step with the shelf. Excel vs inventory software sets out where that line usually falls, and choosing inventory software in India covers what to check before you buy, including ISBN barcode scanning and lot-level tracking.

FAQ

Why should I key stock on ISBN instead of the book title? A title can exist as a hardback, a paperback, a revised edition and a reprint with a new cover. Each of these usually has its own ISBN, price and return terms. If you count by title, these versions get mixed together, and you end up selling, reordering or returning the wrong one.

What if a book has no ISBN? Some local publications, regional titles and used books come without one. Give each of them an internal code that follows one fixed pattern, print a shelf label for it, and record the publisher and edition against that code. Never reuse a code, even after the book goes out of print.

How do I know which copies can still be returned? Record each sale-or-return receipt as its own lot, with the supplying party, the receipt date and the date the return is due under that party's terms. Then count unsold copies against each lot. Copies bought outright stay in a separate lot, so they never land on a return list by mistake.

Can I run this in a spreadsheet? A small shop with a few hundred titles can, as long as one person keeps the sheet up to date every day. Once you have thousands of ISBNs, several sale-or-return parties and billing at the counter, it becomes hard to keep the sheet in step with the shelf. That is usually when software starts to pay for itself.