Getting a Read on Book Inventories
At Boekhandels Groep Nederland's Selexyz bookstores, taking an inventory typically requires closing the doors for a day and paying 25 employees to take every book off the shelf and scan each one individually. With a new system that takes advantage of RFID technology, two workers can inventory a store in just two hours. RFID scanners can read each book's RFID tag without employees removing it from the shelf -- and the store can remain open during the inventory process.
Jan Vink, IT director at Selexyz
While other retailers are experimenting with RFID or are tagging pallets or boxes, Selexyz was one of the first to tag individual items -- at a cost of about 19 cents per item -- and go live with a storewide deployment. "It's one of the first real store implementations out there," says Jeff Woods, an analyst at Gartner Inc.
RFID tags mounted on books at Selexyz.
Selexyz's distribution challenge is fairly unique, says Woods. "A typical retailer would impose on the warehouse to ship orders correctly. They have a kind of unique supply chain problem, and this is the right answer for it," he says. But the system also has another benefit: "When [a store] receives inventory, they're able to count it and sort it very quickly," says Woods.
IT director Jan Vink describes the RFID scanning tunnel as "a sort of a metal box with three antennas in it and a reader." While the tunnel receives and sorts the contents of incoming shipment boxes, portable readers (background) are used to scan books intended for specific shelves within specific departments.
Photos Courtesy of Selexyz
The RFID scanning system also solves another problem: sorting out special orders from the rest of the stock. Not only does the system flag special orders, but customers are also automatically notified. "The customer receives an SMS or an e-mail indicating that the book is ready," says Vink.
Once received at the store, the books are carried to the correct department, and each one is scanned again as it is placed on the shelf to establish its location. Because the RFID system continuously reads each tag, Vink uses Progress Software's Apama event-stream processing tool to filter out duplicate reads and ensure that every book is counted just once.
The project, which took about four months to complete, ran into its share of glitches. Some security functions were missing, and network bandwidth had to be bumped up from 512Kbit/sec. to 4Mbit/sec. to accommodate real-time flows of data to the back-end systems in Selexyz's corporate headquarters. Initially, the ASN was missing some data, Short Messaging Service was unstable, and wireless coverage to support scanners in the stores was incomplete. Vink also spent time debating what type of RFID labels to use and what type of glue to use to affix them securely to books. "If delay is not an option, you must reconsider things and come up with work-around solutions," he says. While Vink is still working with vendors to tune the systems, overall "the core technology is working as expected," he says.
Selexyz tracks books until they are sold to the customer; the tags are deactivated at the time of sale because of privacy requirements. "We don't want to have a link between the RFID and the customer information," Vink says.
Next, Selexyz plans in-store customer information kiosks. Driven by Progress Software's EasyAsk software, the kiosks will give customers access to book availability and location data provided by the RFID scanning system. "When a customer comes in, they can more accurately know whether a book is in stock. Or if a book is in stock but not on the shelf, you can find it," says Mark Palmer, vice president of event stream proc¿essing at Bedford, Mass.-based Progress.
While Vink says the transition has been worthwhile, he cautions others to be thoroughly prepared before moving forward.
"As an IT decision-maker, you are making a strategic decision," he says. Once you've committed, he warns, "you can't back out."
Read more about Mobile Apps in Computerworld's Mobile Apps Topic Center.
- Gartner Magic Quadrant for Mobile Application Development Platforms As unprecedented numbers of enterprises build mobile applications, the mobile application development platform market continues to grow and evolve rapidly.
- The Total Economic Impact of IBM's Worklight Platform Mobile is the fastest growing consumer technology in history. As enterprises build apps to engage these new users they are facing increased complexity...
- Improve Your Mobile Application Security with IBM Worklight IBM® Worklight helps organizations extend their business across multiple mobile devices. It provides an open, comprehensive and advanced mobile application platform to help...
- Unlock the Value of Enterprise Mobility Download this guide and learn how to manage the secure deployment of enterprise mobile apps and data, while still encouraging the levels of...
- It's Chaos Out There Worried about your mobile apps? You should be; it's chaos out there. Check out this humorous video and see if you can recognize...
- Cloud Knowledge Vault Learn how your organization can benefit from the scalability, flexibility, and performance that the cloud offers through the short videos and other resources... All Mobile Apps White Papers | Webcasts
Our new weekly Consumerization of IT newsletter covers a wide range of trends including BYOD, smartphones, tablets, MDM, cloud, social and what it all means for IT. Subscribe now and stay up to date!