1. Field of the Invention
The present invention relates to an inventory management system managing the commodity inventory of a store.
2. Description of the Related Art
Conventionally, a POS system has been widely introduced in a store such as a supermarket and a convenience store. In the POS system, by basically reading a bar-code attached to each commodity when receiving and selling a commodity, the commodity sale management, the commodity ordering management, the commodity sale analysis, and the like are executed. While the number of stocked commodities can be roughly comprehended by subtracting the number of sold commodities from the number of received commodities in the POS system, the calculated number and the actual number of stocked commodities of the POS system may not frequently correspond to each other due to the break, the loss, the theft, and the like of the commodities. Thus, the inventory work is executed by counting the number of stocked commodities with the manpower in a store. In this inventory work, the number of stocked commodities is inputted by using a portable terminal referred to as a handy terminal, and the data inputted to the portable terminal is reflected to the POS system. In the system disclosed by Japanese Patent Publication 2003-323480, a bar-code reader is provided to the handy terminal, and the inputting work is saved by causing the bar-code attached to a commodity to be read.
However, in the conventional POS system, the precise number of stocked commodities can be comprehended only immediately after the inventory work, and can not be comprehended if the interval of the inventory work becomes long. Thus, the loss of sales opportunity due to stock shortage, by contraries, the useless consumption of sales space and the commodity dead line due to overstocked commodities may be induced. The inventory work may be frequently executed to prevent such a disadvantage. However, the manpower is not only necessary for the inventory work, but also, in some kinds of stores, the stores are frequently closed, so that the sales may be reduced.
An object of the present invention is to provide an inventory management system in which the precise number of stocked commodities can be always comprehended.
To achieve the above object, the present invention proposes an inventory management system for managing the status of stocked commodities displayed in a showcase by using a computer, in which the showcase is provided with a commodity shelf for displaying a commodity to which an RFID tag is attached, a first antenna for communicating with the RFID tag attached to the commodity on the commodity shelf, first detecting means for detecting a unique identifier of the RFID tag by communicating with the RFID tag through the first antenna, and transmitting means for transmitting the detected unique identifier of the RFID tag to the computer through a network, and the computer is provided with first receiving means for storing a list of the unique identifier received from the first detecting means of the showcase in prescribed memorizing means, and inventory management means for managing commodity inventory based on the unique identifier of the RFID tag, the unique identifier being memorized in the memorizing means.
According to the present invention, the unique identifier of the RFID tag of a commodity displayed in the showcase is read by the first detecting means, and is transmitted to the computer. That is, the computer can always comprehend the unique identifier of the RFID tag of the commodity displayed in the showcase, so that, can always manage the stocked commodity based on the unique identifier of the RFID tag.
As an preferred embodiment of the present invention, the memorizing means of the computer memorizes a corresponding list in which the unique identifier of the RFID tag and an identification number indicating a type of a commodity to which the RFID tag is attached are related to each other, and the inventory management means counts the number of stocked commodities for each type of commodities. Furthermore, as another embodiment, the inventory management means counts the number of stocked commodities for each type of commodities and also for each showcase. According to such inventions, the number of stocked commodities for each commodity and the number of stocked commodities for each showcase can be surely managed.
The present invention proposes the inventory management system in which the inventory management means notifies a manager of a message when the number of stocked commodities becomes equal to or less than a prescribed threshold.
According to the present invention, when the number of stocked commodities displayed in the showcase becomes small, the manager is notified of the message, so that the management work such as the supplying of commodities from a warehouse and the ordering of commodities can be executed without delay. Meanwhile, the threshold may be set for each commodity, for each showcase, and for each commodity shelf.
In addition, the present invention proposes the inventory management system in which the showcase is provided with a second antenna for communicating with the RFID tag attached to a commodity, second detecting means for detecting the unique identifier of the RFID tag by communicating with the RFID tag through the second antenna, and a displaying apparatus for displaying commodity information of a commodity to which the RFID tag is attached based on the detected unique identifier of the RFID tag.
According to the present invention, since a customer moves a commodity close to the second antenna, the commodity information of the commodity is displayed on the displaying apparatus.
Meanwhile, the commodity information includes, for example, a production area display, a material display, a component display, an efficacy display, and an advertisement display of the commodity.
The present invention proposes the inventory management system provided with a tag retrieving box for storing the RFID tag retrieved from a commodity, and the tag retrieving box is provided with a third antenna for communicating with the RFID tag, third detecting means for detecting the unique identifier of the RFID tag by communicating with the RFID tag through the third antenna, and transmitting means for transmitting the detected unique identifier of the RFID tag to the computer through a network, and the computer is provided with second receiving means for deleting the unique identifier received from the tag retrieving box from a list of the unique identifier, the list being memorized in the memorizing means.
According to the present invention, if the RFID tag which becomes unnecessary after a commodity is sold is retrieved, and is stored in the tag retrieving box, the unique identifier of the RFID tag is detected by the third detecting means provided in the tag retrieving box, and the detected data is reflected to the computer. Thereby, the precise inventory status can be always comprehended.
The present invention proposes an inventory management system for managing the inventory status of a displayed commodity by using a computer, the inventory management system being provided with an antenna for communicating with an RFID tag attached to the commodity, detecting means for detecting the unique identifier from the RFID tag by communicating with the RFID tag through the antenna, memorizing means for memorizing a list of the unique identifier detected by the detecting means, and inventory management means for transmitting commodity inventory information to the computer through a network, the commodity inventory information being obtained by comparing the list of the unique identifier, the list being memorized in the memorizing means, with the list of the unique identifier detected by the detecting means.
According to the present invention, if the unique identifier of the RFID tag is detected by the detecting means, such a unique identifier is memorized in the memorizing means of the inventory management means. The commodity inventory information is transmitted to the computer, the inventory information being obtained by comparing information memorized in the memorizing means with information received from the detecting means. Thereby, the computer can always comprehend the unique identifier of the RFID tag of the commodity, so that the inventory management of the commodity becomes to be always available based on the unique identifier of the RFID tag.
As an example of a preferred aspect of the present invention, the present invention proposes a system in which the inventory management means issues a transmission request for transmitting the unique identifier to the detecting means, and the detecting means transmits the list of the unique identifier under detection to the inventory management means according to the transmission request.
A time for reading the unique identifier of the RFID tag influences the number of RFID tags to be detected in the detecting means, so that if data is sequentially transferred from the detecting means to the inventory management means, the process becomes complex in the inventory management means. In the present invention, the detecting means transfers the data at a time when the inventory management means issues the request, so that the process in the inventory management means can be simplified.
As an example of a preferred aspect of the present invention, the present invention proposes a system in which when some change is induced in the inventory status, the inventory management means transmits the inventory information related to the change to the computer.
According to the present invention, the inventory information transferred to the computer is limited only to such a case that some change is induced in the inventory status, so that an amount of data received by the computer can be considerably reduced. Thereby, network resource can be effectively utilized, and the process load for the computer can be reduced.
In an example of a preferred aspect of the present invention, a plurality of detecting means are provided to one inventory management means, or a plurality of antennas are provided to one detecting means. Such inventions are suitable to the inventory management for a commodity shelf such as a showcase. Specifically, a stage in which a commodity is stored can be comprehended by allocating the detecting means in each stage of the commodity shelf. By allocating a plurality of antennas in each stage of the commodity shelf, a location at which the commodity is stored can be comprehended without providing many expensive detecting means.
Other objects, configurations, and effects of the present invention except the above will be apparent in the following detailed description.
An inventory management system according to an embodiment of the present invention will be described as referring to the drawings. In the present embodiment, such a case will be described that a stocked commodity is managed in a store selling a health drink such as a nutritious drink.
In this inventory management system, a wireless LAN 900 is constructed in the store. The wireless LAN 900 is connected with the store computer 100, a handy terminal 200 for a store clerk, a showcase 300 displaying the commodity 10 in a cooling condition, an information displaying terminal 400 displaying a variety of pieces of information of the commodity 10, and a tag retrieving box 500 storing the RFID tag 12 retrieved from the commodity 10 after such a commodity 10 has been sold. The wireless LAN 900 can communicate with a headquarter computer 950 centrally managing the store computer 100 through a WAN 910 such as the Internet.
First, the handy terminal 200 will be described referring to
Next, the showcase 300 will be described. As illustrated in
As illustrated in
As illustrated in
As illustrated in
The central controlling apparatus 330 is further provided with the antenna 302 and the tag detecting unit 303 attached on the front upper part of the showcase 300, and a display controlling unit 335 connected to the displaying apparatus 304. The display controlling unit 335 requests the store computer 100 to transmit commodity information by using the unique number of the RFID tag 12, the unique number being read by the tag detecting unit 303, as a key. When obtaining information regarding the commodity 10 from the store computer 100, the display controlling unit 335 displays the obtained information in the displaying apparatus 304.
Next, the information displaying terminal 400 will be described as referring to
Next, the tag retrieving box 500 will be described as referring
Next, the store computer 100 will be described as referring to
The data memorized in the database 150 will be described. The database 150 records commodity information 151 illustrated in
As illustrated in
As illustrated in
The minimum stock number information 153 memorizes the minimum number of stocks for each commodity shelf 301 of each showcase 300, and as illustrated in
The tag corresponding information 154 memorizes the correspondence relation between the RFID tag 12 attached to the commodity 10 and the commodity type of the commodity 10, and as illustrated in
The shelf stock information 155 memorizes the unique number of the RFID tag 12 of a commodity displayed in each showcase 300, and as illustrated in
The history information 156 memorizes the history of an event induced for the RFID tag 12, and as illustrated in
When receiving the JAN code of the commodity 10 and the unique number of the RFID tag 12 attached to the commodity 10 from the handy terminal 200, the registration processing unit 110 stores this JAN code and unique number as the tag corresponding information 154 in the database 150. When receiving the JAN code and the unique number, the registration processing unit 110 adds a receiving date and time and the unique number of the data, and such a fact that the receiving event is induced to the history information 156 of the database 150.
When receiving the list of the unique number of the RFID tag 12 and the stage number of the commodity 10 displayed in the showcase 300 from such a showcase 300, the inventory information receiving unit 120 stores the receiving date and time of the data, the shelf number of the showcase 300 of a transmitting source, and the received data as the shelf stock information 155 in the database 150. Here, when the received unique number is not yet registered in the shelf stock information 155, the inventory information receiving unit 120 adds the receiving date and time and the unique number of the data, and such a fact that the initial detection event is induced to the history information 156 of the database 150. When receiving data from the showcase 300, and when the unique number recorded in the shelf stock information 155 as the inventory of the showcase 300 is not included in the received data, the inventory information receiving unit 120 adds the receiving date and time and the unique number of the data, and such a fact that the final detection event is induced to the history information 156 of the database 150.
When receiving a request for obtaining commodity information from the showcase 300 or the information displaying terminal 400, the information display processing unit 130 extracts commodity information of the commodity 10 such as advertisement information from the commodity information 151 of the database 150 by using the unique number of the RFID tag 12, the unique number being included in such an obtaining request, as a key, and transmits the commodity information to the requesting source.
When receiving the unique number of the RFID tag 12 from the tag retrieving box 500, the retrieved information receiving unit 140 deletes an entry including such a unique number from the shelf stock information 155. When receiving the unique number, the retrieved information receiving unit 140 adds the receiving date and the unique number of the data, and such a fact that the retrieval event is induced to the history information 156 of the database 150.
The inventory management unit 160 provides a variety of inventory management services based on the data stored in the database 150 according to the request from an employee of a store, and the like. Specific functions of the inventory management unit 160 are as follows: (a) a function for browsing and updating each information stored in the database 150; (b) a function for combining and browsing each information stored in the database 150; (c) a function for warning the lack of stock; and (d) a function for comprehending the buying behavior. The function of (b) is realized by using the relational function of the database 150, and information regarding the inventory management can be obtained from a variety of point of views by means of the function. For example, by incorporating the commodity information 151, the shelf information 152, the minimum stock number information 153, the tag corresponding information 154, and the shelf stock information 155, an inventory management table 159 as illustrated in
The inventory management unit 160 calculates the number of stocks by counting the shelf stock information 155 for each showcase 300, and the function for warning the lack of stock of the above (c) compares the number of stocks with the minimum number of stocks stored in the minimum stock number information 153, and decides the comparison result. When the number of stocks is equal to or less than the minimum number of stocks, the function for warning the lack of stock obtains a warning destination as referring to the shelf information 152, and notifies such a warning destination of a prescribed message. A variety of message notifying means can be selected according to the warning destination. For example, the massage may be displayed on a screen of the store computer 100, may be transmitted as a mail to a portable phone of a manager through a portable phone net, and may be transmitted to the handy terminal 200 through the wireless LAN 900.
The function for comprehending the buying behavior of the above (d) extracts the detection status of the RFID tag 12 detected by the showcase 300 from data of the history information 156, and guesses the customer interest level for the commodity 10 to which the RFID tag 12 is attached from the extracted data. Specifically, when the RFID tag 12 of a unique number is detected again after the RFID tag 12 of the unique number becomes not to be detected, it can be comprehended that a customer returns the commodity 10 to the commodity shelf 301 after picking up the commodity 10. It can be guessed that such a behavior is [A customer is interested in a commodity, but does not result in buying the commodity]. As another example, when the receiving time is different for the plurality of commodities 10 whose kinds are the same, by accumulating a data regarding what commodity 10 a customer first picks up, it can be guessed how strongly the customer needs the freshness for the commodity 10. Thereby, by utilizing a variety of statistical techniques, it becomes possible to comprehend the customer buying behavior and utilize the comprehended data for the marketing.
As described above, according to the inventory management system according to the present embodiment, the unique number is detected from the RFID tag 12 attached to the commodity 10 displayed in the showcase 300, and the detection status is recorded and accumulated in the store computer 100, so that the inventory information regarding the commodity 10 can be comprehended in real time. Particularly, in the inventory management system according to the present embodiment, the inventory status of the commodity 10 can be counted as needed from a variety of point of views such as each showcase 300 and each commodity, so that the convenience becomes high. In the inventory management system according to the present embodiment, the customer buying behavior can be comprehended, so that the comprehended data can be utilized for the marketing. In the inventory management system according to the present embodiment, if the number of commodities 10 becomes equal to or less than a previously-set prescribed number pf stocks, a message is transmitted to a previously-set warning destination, so that the appropriate inventory status can be easily maintained.
Furthermore, in the inventory management system according to the present embodiment, if a customer moves the commodity 10 close to the antenna 302 of the showcase 300 or the antenna 401 of the information displaying terminal 400, information regarding the commodity 10 is displayed in the displaying apparatus 304 or the displaying apparatus 403, so that the sales promotion effect can be anticipated.
As described above, while an embodiment of the present invention is described in detail, the present invention is not limited to this embodiment. While the handy terminal 200 is used only for the registering work when receiving the commodity 10 in the above embodiment, as needed, the handy terminal 200 may be used to detect the stocked commodities 10. That is, in some types for operating a store, all the commodities 10 are not always displayed in the showcase 300, so that for the commodity 10 placed on a warehouse or a shelf in which a reading apparatus of the RFID tag 12 is not provided, the handy terminal 200 reads the RFID tag 12 attached to such a commodity 10, and the read RFID tag 12 may be managed by the store computer 100.
In the above embodiment, data regarding the RFID tag 12, the data being memorized in the shelf stock information 155 of database 150, is deleted if such an RFID tag 12 is detected in the tag retrieving box 500, and such an RFID tag 12 becomes not to be identified as a stock on the system. However, when the detection-trouble is induced in the tag retrieving box 500, or the commodity 10 is stolen, even though the commodity 10 is lost, it is possible to be realized on the system that the stocked commodity 10 still exists. Thus, it is preferable to delete data, which can not be received as shelf inventory information in a prescribed time from the showcase 300, of data memorized in the shelf stock information 155. Meanwhile, in this case, it is preferable to add such a fact in the history information 156 that such an event is induced.
The inventory management system according to the above embodiment and the existing POS system may be caused to work with each other. In this case, by providing a register with the reading apparatus of the RFID tag 12, the event for selling the commodity 10 can be certainly comprehended. Thereby, it becomes possible to manage the inventory in a higher accuracy. Since the inventory status can be provided to the POS system in real time, it becomes possible to appropriately order.
In the above embodiment, while the antenna switching circuit 321 is provided to the reading apparatus 320, and also, the plurality of antenna units 310 are connected to the reading apparatus 320, the antenna switching circuit 321 may be separated from the reading apparatus 320. Specifically, as illustrated in
By the way, in the reading apparatus 320 of the above embodiment, if the number of commodities 10 placed on the commodity shelf 301 becomes many, the reading accuracy may be degraded. One of such causes is that the number of commodities 10 influences the impedance matching between the reading apparatus 320 and the loop antenna 312. Thus, as illustrated in
In the above embodiment, while the store computer 100, the showcase 300, and the like are connected by the wireless LAN 900, the network type is not limited. That is, the wireless LAN and the wired LAN may be used at the same time in consideration of the allocation of each apparatus, and the like.
Number | Date | Country | Kind |
---|---|---|---|
2007-026767 | Feb 2007 | JP | national |
2007-136628 | May 2007 | JP | national |