Simpler Solutions for Bookseller Automation

- by Renee Roberts

none


I'm currently using Windows XP Professional, HomeBase, Microsoft Office, and Endicia (Envelope Manager) which pretty much covers all the basic bookstore functions. For accounting I use Quickbooks, a Symantec product. Homebase is free and distributed by ABE, Windows and Office are from Microsoft, and Endicia is a product of www.endicia.com, which I use to create the postage and track packages delivered by the USPS. It also integrates with www.upic.com (U-PIC), my package insurance company. I use eFax Messenger (www.efax.com), a free software package available when subscribing to this internet-based fax service. Adobe Photoshop Elements edits my photographs. None of these products are unusually expensive and I am not married to any of the companies who produce them.

Automation does not necessarily solve business problems. As one bookseller wrote after reading the Monsoon article,
"We have a fairly large inventory and have been talking with Monsoon for several months now, trying to decide if we want to go that direction or not. (There would need to be substantial investments in not only the software but warehouse space and a newer computer system). On one level it seems like the answer and almost too good to be true, but on another level it just doesn't "feel" quite right. We have spent almost 20 years building a quality inventory and I would love to move it faster, but don't want to devalue it."
Don't let any perceived lack of knowledge about automation get in the way of your hard-won knowledge about the book business. The way to get involved with any kind of automation is to narrow down what you are automating, and then do it simply. The market has standardized, computer prices have come down, and software is a lot cheaper. If automation seems too expensive or too complicated, start with the most basic standard application and learn it to your satisfaction before moving on.

You do not want to be at the mercy of the dealer or company that sold you the goods, which is the case when purchasing a custom program, or one with a narrow distribution, like Monsoon. Not only is it ridiculously more expensive, but it is every programmer's dream to have the exclusive rights to and control over an application that you are dependent upon to run your business.

There are better ways to improve sales performance. For example, take the time to read the Help files and figure out how the applications you are using really work. HomeBase is used by many booksellers, but not necessarily as well and effectively as it could be.

When entering data into HomeBase you need to be aware of how people will retrieve it. To figure that out, look at the advanced search screen on www.abebooks.com. Each of these fields can find or eliminate your listing from a search, depending upon how you do the data entry. One small example of this is the Author field. The search engine on ABE does not use fuzzy logic; if somebody misspells a word (or if you do) the search engine will eliminate it from the results presented to the customer. Therefore, if you are dealing with an author who has variant ways of spelling his or her name, or common misspellings, include them in the Author field in order to maximize search engine results.

If you want to make additional automation investments, invest in an external hard drive for backup (and backup frequently) and a battery backup (inconsistent power levels can harm your hard drive and your data). A bigger screen makes all of the bookstore functions much easier and LCD displays are a lot easier on the eyes than CRTs.

If you feel you do need help with automation, then invest in training -- learn how to use standard applications first. If you are still considering non-standard applications insist on speaking to multiple customers as references. Find out what the entire process was like before making a commitment. You may discover that the simplest solutions are not only the best, but will help you avoid making expensive or fatal business mistakes.

Renée Magriel Roberts can be reached at renee@roses-books.com.