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.
- Use the Mobile App Mix to Choose an Enterprise App Store Strategy In this research report Gartner outlines how organizations can optimally secure, distribute, and manage mobile applications for employees and contracted workers.
- The Case for Mobile Apps Today's mobile apps turn handheld devices into e-book readers, portable navigation systems, digital wallets and more. And for organizations with mobile workers, they...
- The 5 Big Lies About Going Mobile You've heard about the power of mobile to change your business. But have you realized your mobile potential? It's about much more than...
- Transforming enterprise applications for mobile environments This new white paper explains how Dell Application Modernization and Development Solution Set can help you understand when to develop new mobile apps,...
- IBM FlashSystem V840: Leveraging Software-Defined Flash to Drive Your Business With end-to-end, tightly integrated functionality and super-fast flash technology, products like IBM FlashSystem V840 Enterprise Performance Solution empower businesses to leverage the efficiency...
- Leveraging Flash Storage to Accelerate Oracle Real Application Clusters Join this webinar to understand the latest solid-state storage trends, the specific applications driving solid-state storage deployments and the benefits of deploying the... 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!