COMMENT ON THIS ARTICLE A chain of drive-through convenience stores across the U.S. counts on a point-of-sale and retail management tool to keep its shelves stocked at all times. The head office of Swiss Farms, in Broomall, PA., now receives real-time sales data from its 12 stores, and can manage inventory, product rollouts and promotions using Star-Link. Star-Link is a system that consolidates and communicates inventory information, sales updates, and product promotions – developed by Medicine Hat, Alta.-based Auto-Star Compusystems Inc., a provider of grocery, pharmacy and convenience store-management software. Prior to implementing the tool last April, inventory management was tackled on a store-by-store basis, says Scott Davi, management information systems director at Swiss Farms. "It was hard to get a grasp of the company as a whole. Many different reports would come from individual stores that had to be consolidated." The old system Swiss Farms stores used lacked the real-time reporting element, meaning that sales data would become available through a "batch process" at certain times of the day, says Robert Symmonds, president, Auto-Star Compusystems. "It wasn't until the next day past noon when the head office would get reliable sales information on how the stores were doing," he says. "The head office now knows exactly what its stores are selling and what their sales margins are. If it needs to get more inventory to stores before [stock] runs out, it can do that on a real-time basis versus having to wait a day and a half for information," says Symmonds. Individual store managers can still purchase products on their own, however, for the most part, says Davi, inventory is handled at the head office with Star Link. Besides deploying the retail management component at the head office, a point-of-sale tool, Star-Plus, was implemented at the store level that's designed to manage cash, track product quantity and retail costs, and run reports. Retail stores can use the system to automatically place product orders with vendors or with their head-office, as is the case with Swiss Farms. While it offers real-time tracking capabilities, Star-Plus is dependable because it makes data redundant, ensuring the tills can operate independently, says Davi. "Before this, if one till had a problem, the whole store would go down." According to Davi, besides its ability to consolidate data from multiple stores, maintain inventory from the head office, and keep implementation and upkeep costs low, another value proposition is the development platform on which the Star-Plus system is based. "It was built on Microsoft SQL server – that is critical to our business and our other applications," says Davi. According to Symmonds, All-Star customers in search of cost savings had requested that the applications be Linux-based. "But we found that total cost of ownership of a Windows-based solution is a lot cheaper for everyone." | 
icon.
