Bookstore POS: ISBN Barcodes, Catalog Imports and Distributor Returns

A bookstore POS should let you scan the ISBN barcode on the back of a book and ring it up at once, and it should help you decide which unsold copies to send back to the distributor before the return window closes. Scanning is the easy part. The money is in the second job, because unreturned books are cash sitting on a shelf.

This post covers the two parts of bookselling that trip up general retail systems: ISBN barcodes and catalog setup, and returns to distributors. It ends with how Retailer OS handles the parts it covers, and where you should treat the advice as questions to put to any system. If you want the wider buying view first, read our guide to the best bookstore POS.

How do ISBN barcodes work at a bookstore register?

An ISBN is a number that identifies one edition of one book, and the barcode on the cover is that number printed in a form a scanner can read. Most modern books carry an ISBN-13 inside an EAN-13 barcode, and the number begins with 978 or 979. Barcode standards are maintained by GS1, the same body behind the barcodes on grocery packaging.

For a bookstore, that gives you a real advantage over most retailers. The barcode already exists on almost every new book. You do not print labels for new stock. You scan, and the number must match a record in your catalog.

What this means for setup:

• Store the ISBN-13 as the barcode on each item, so a scan finds the right title instantly.
• Treat each edition as its own item. The hardcover and the paperback have different ISBNs, different prices and different costs.
• Keep the title, author and format in the item name so staff can search by words when a barcode is missing or worn.
• Use your own stock number or a label for used books, because they do not share an ISBN with a clean copy on a shelf.

Test the scanner before opening day. Scan twenty books of different ages, including a paperback with a price add-on barcode beside the main one. If the wrong code ever gets read, fix your scanner settings and your training before customers see it.

How do you get a book catalog into a POS?

You rarely type thousands of titles by hand. Most stores start from a file: an export from an old system, a distributor’s inventory feed, or a spreadsheet of what is on the shelves. The job is to clean that file and import it once, correctly.

A clean import file has one row per edition and these columns at least:

• ISBN-13, as text. Spreadsheets turn long numbers into scientific notation, so format the column as text before you paste.
• Title, with author and format in the name.
• Cover price and your selling price.
• Your cost per copy, which is the cover price less your trade discount.
• Quantity on hand and a reorder point for steady sellers.
• Vendor, so you know which distributor to reorder from or return to.

Check leading zeros and duplicates before you import. Sort by ISBN and look for repeats. Then spot-check ten rows against the actual books. For a longer walk through file prep, see our CSV prep guide for new POS imports.

Why do returns to distributors matter so much?

Books are one of the few retail categories where the supplier often takes unsold stock back. That changes how you buy. You can order a little deeper on a title you think will sell, because you have a path to get your money back if you are wrong. Terms vary by publisher and distributor, so read yours, but the pattern is a window of some months after you receive the book in which you can return unsold copies for credit.

Here is why it matters in dollars. Say a title costs you $12 and you bought 30 copies. If 18 sell and 12 sit, you have $144 on the shelf. Return them inside the window and you recover the $144 as credit. Miss the window and it is a markdown or a write-off. Across a few hundred titles, that is the gap between a store that turns its inventory and one that slowly fills up.

The number to watch is sell-through: copies sold divided by copies received over a period. If you received 30 and sold 18, sell-through is 60 percent. Titles under about 30 percent after a quarter are your return candidates. Pick your own cut-off, but pick one and apply it on a schedule.

What does a good returns process look like?

Run it as a monthly routine, not a panic before a deadline. A simple version:

• Pull a list of items with stock on hand and no sales in the last 60 to 90 days.
• Filter that list to the vendors who accept returns, and check each one’s window against the date you received the stock.
• Walk the shelves with the list. Pull only the copies that are in saleable condition, because damaged books are usually refused.
• Record the quantities you are sending and remove them from stock the day they leave.
• Keep the shipping paperwork until the credit appears, then match the credit to what you sent.

Two traps catch new stores. The first is returning a book and leaving it in your stock count, so the system says you still hold it. The second is losing track of when each shipment arrived, so you find out a title is out of window only after you packed the box. Ask any POS you look at how it shows the age of stock by receiving date and how it records stock leaving without a sale.

What about used books, special orders and events?

Used books need their own handling. You buy them from the public, usually for store credit or a small cash payment, and each copy has its own condition and price. Treat them as unique items with your own label, a cost equal to what you paid, and a category so you can see used sales apart from new. Store credit is useful here, because many sellers prefer it and you keep the money in the shop.

Special orders for customers are a service, not a stock item. Record who ordered, the ISBN, the date promised and whether a deposit was taken. Events, such as an author night, bring a spike of sales of one title, so raise your order and set the reorder point back down afterwards. None of these should require a second system, but check how each one is recorded before you buy.

How does Retailer OS handle a bookstore?

Retailer OS is one system for the counter, the stockroom and the team. For a bookstore, these parts apply.

• Barcode scanning at checkout. It supports barcode scanners and receipt printers, plus catalog search for items with a damaged barcode. It also prints barcode labels, which is useful for used books.
• CSV import of items, customers and vendors, plus full data export. Keep the hardcover and the paperback as separate items, each with its own barcode.
• Purchase orders and receiving. Order from a distributor, receive against the PO, and keep cost per item.
• Per-location stock and a movement ledger. Every sale, receipt, transfer and adjustment leaves a row, so a stock adjustment for a return to a distributor is visible in the history.
• Reorder points on steady sellers, and reports that include dead stock, inventory valuation and top products, which give you the raw list for a returns review.
• Vendor bills you can record, pay and track as overdue, plus store credit, gift cards and a loyalty program for regular readers.
• Offline mode in the desktop app only, so a bookstore with unreliable internet can keep ringing sales and sync later. The iOS app has no offline mode.

Be clear about the limits. This post only describes what is listed above. Distributor return paperwork, ISBN lookup that fills in titles for you, and special-order or event tools for bookstores are questions to put to any system, including this one. What the inventory side gives you is the data to run returns well: age, quantity and cost per title.

With a Messaging & AI plan (from $39.99 a month), Retailer OS can also autofill product details from a photo and suggest reorders. You decide what to buy. Reorder points and dead stock reports work without it.

Pricing is $99.99 a month per store plus $9.99 a month per user seat, so the smallest bill is $109.98 a month. Card payments run on your own Stripe account, with no platform fee and no cut of sales. The online store is a separate paid add-on at $99.99 a month. Details are on the pricing page.