JP2020184173A - Product management system and product management method - Google Patents

Abstract

To provide a product management system and a product management method capable of carrying out inventory work in parallel with receiving work and shipping work.SOLUTION: A product management system 1 comprises: a storage unit 16 for storing unique information attached to a product G that has arrived at a store; a reading unit 42 for reading the unique information attached to the product G in the store; and a processing unit 14 for collating the unique information stored in the storage unit 16 with the unique information read by the reading unit 42 at the time when the reading unit 42 starts reading.SELECTED DRAWING: Figure 1

Description

The present invention relates to a product management system and a product management method.

There is inventory as a product management business in a store, and a system equipped with a management server and an input terminal is used as a system for performing the inventory. The input terminal is a terminal that reads the identification information attached to the product in the store and transmits the read identification information to the management server. In the management server, not only the product information such as the product name and price but also the inventory quantity of the product is managed in association with the identification information, and there is no excess or deficiency in the inventory quantity based on the identification information received from the input device. Check if.

For example, in Patent Document 1, an RFID reader is used as an input terminal for inventorying products. This RFID reader has a first communication mode in which identification information is collectively read from RF tags attached to a plurality of products and transmitted to a server, and identification information is individually read from RF tags attached to a plurality of products. It has a second communication mode for transmitting to the server. According to the technique described in Patent Document 1 as described above, it is possible to shorten the reading work time by reading in the first communication mode.

Japanese Unexamined Patent Publication No. 2016-177778

By the way, when products arrive at a store, it is necessary to add the number of arrivals to the inventory quantity of each product managed by the server. In this way, since the number of stocks fluctuates at the time of arrival, until now, the stocktaking work has been carried out after the stock quantity has been determined, and the stocktaking work and the inventory work can be carried out in parallel. However, it will take a considerable amount of time. This applies not only when the product arrives, but also when the product is shipped (at the time of sale), and there is a restriction that inventory work must be performed while avoiding the time of shipment (at the time of sale).

An object of the present invention is to provide a product management system and a product management method capable of performing inventory work in parallel with receiving work and shipping work.

In order to achieve the above object, the product management system of the present invention has a storage unit that stores unique information attached to a product at a base, a reading unit that reads the unique information, and a reading unit at the start of reading. It is characterized by including a processing unit for collating the unique information stored in the storage unit with the unique information read by the reading unit.

Further, when the processing unit detects a difference in the collation, the processing unit outputs the difference.

The product management method of the present invention is stored in the storage unit at the time of starting the step of storing the unique information attached to the product at the base in the storage unit, the step of reading the unique information, and the time when the reading of the unique information is started. It is characterized by including a step of collating the read unique information with the unique information.

According to the present invention, the inventory work can be carried out in parallel with the receiving work and the shipping work.

(A) Overall view of the product management system according to the present embodiment, (b) Diagram showing the product and unique information of the present embodiment. The figure which shows the management table and the unique information list which concerns on this Embodiment Flow diagram showing the processing flow of the management server provided in the product management system

Hereinafter, the product management system and the product management method according to the embodiment of the present invention will be described with reference to the drawings.

As shown in FIG. 1, the product management system 1 is a system that manages the product G in the store, and includes a management server 10 connected to a LAN constructed in the store.

The management server 10 is a server that manages the product G in the store, and as a CPU that functions as a processing unit 14 and a storage unit 16 in addition to a network module that functions as a communication unit 12 that performs communication via a LAN. It has a working memory.

The memory (storage unit 16) is provided with a management table 162 that manages the product G in the store for each type. As shown in FIG. 2, the management table 162 is provided with a record for each JAN code which is the type information of the product G, and is provided with columns for the name, price, and inventory quantity of the product G. In this way, the memory stores the name, price, and inventory quantity of the product G in association with the type information of the product G.

Returning to FIG. 1, the product management system 1 of the present embodiment includes an administrator terminal 20 capable of communicating with the management server 10 via a LAN. The administrator terminal 20 is typically a known computer installed in a store, and is operated by an administrator to access the management server 10 and information on the product G stored in the management table 162. Is acquired and displayed on a display (not shown).

In the product management system 1 of the present embodiment, in order to manage the products in the store, the RF tag 4 storing the unique information is attached to all the products G, and the consignment terminal 30 and the inventory that can communicate with the management server 10 are attached. It is equipped with a terminal 40.

The unique information is a code that is individually assigned to each product G, and the code system is configured by adding a serial number to the end of the JAN code as shown in FIG. 1 (b). .. The unique information is not limited to the code system, and a product number which is other type information may be used instead of the JAN code. Further, a random number may be used instead of the serial number. As described above, the code system of the unique information preferably has a configuration in which the type information of the product G and the identification information for identifying each product G in the same type of product G are combined. The unique information is written in the RF tag 4 when the product G is shipped from the factory, read by the receiving terminal 30 at the time of arrival, read by the inventory terminal 40 at the time of inventory, and managed by the management server 10.

The consignment terminal 30 is a terminal used for recording the received product G, and is, for example, a gate-type RFID reader installed in the delivery route of the product G. The RFID reader includes a reader module that functions as a reading unit 32 that reads unique information from the RF tag 4 of the product G that has arrived at the store, and a memory that functions as a storage unit 34 that temporarily stores the read unique information. A network module that functions as a transmission unit 36 that collectively transmits all the read unique information to the management server 10, and a CPU that functions as a control unit 38 that controls the above-mentioned reader module, network module, and memory. ing.

The inventory terminal 40 is a terminal used for checking the product G in the store, and is a mobile type in which an employee reads unique information from the RF tag 4 attached to each product G while patrolling the store or the warehouse. RFID reader. The RFID reader includes a reader module that functions as a reading unit 42 that reads unique information from the RF tag 4 of the product G in the store, a memory that functions as a storage unit 44 that temporarily stores the read unique information, and a unique read unit. It includes a network module that functions as a transmission unit 46 that transmits information to the management server 10, and a CPU that functions as a control unit 48 that controls the reader module, the network module, and the memory. Here, when the CPU of the inventory terminal 40 controls the reader module and starts reading, the CPU of the inventory terminal 40 transmits the start information to the effect that the inventory is started to the management server 10.

The management server 10 receives start information from the inventory terminal 40, receives unique information from the consignment terminal 30 and the inventory terminal 40, and manages the product G in the store. The received unique information is stored in a file provided in the memory (storage unit 16) as the unique information list 164. Specifically, a management program for managing the arrival and inventory of the product G is stored in the memory of the management server 10, and the process described in FIG. 3 is executed by the CPU (processing unit 14) by the management program. Will be done.

First, the CPU of the management server 10 executes a process of confirming reception from the consignment terminal 30 and the inventory terminal 40 (s1).

When the unique information is received from the consignment terminal 30, the CPU of the management server 10 executes the list addition process (s2) and the table update process (s3) in this order. The list addition process (s2) is a process of adding the received unique information to the unique information list 164. The table update process (s3) is a process of updating the inventory quantity of the management table 162 based on the unique information list 164, and first, all the unique information in the unique information list 164 is extracted. Then, the type information is further extracted from all the extracted unique information. When the type information is extracted, the number is counted for each type information, and the count number is temporarily stored in the memory in association with the type information. Then, the count number is input to the inventory quantity of the product G corresponding to each type of information in the management table 162.

When the start information is received from the inventory terminal 40, the confirmation process (s4) for determining the unique information to be inventoried is executed. The unique information to be inventoried is the unique information of the product G existing in the store at the time of starting the inventory. In other words, it is the unique information included in the unique information list 164 when the management server 10 receives the start information. Therefore, the CPU of the management server 10 executes an extraction process for extracting the unique information from the unique information list 164 and a flag setting process for setting a flag for the unique information in the unique information list 164 to determine the unique information to be inventoried.

When the unique information is received from the inventory terminal 40, the collation process (s5) for collating the unique information confirmed in the confirmation process (s4) with the received unique information is executed. As a result of executing the collation process (s5), if there is no excess or deficiency in the unique information determined as the inventory target, a report indicating that there is no error in the unique information list 164 and the management table 162 is sent to the administrator terminal 20. The report process (s6) to be transmitted is executed.

On the other hand, as a result of executing the collation process, if there is an excess or deficiency in the unique information determined as the inventory target, the excess or deficiency update process is executed. The excess / deficiency update process is a process of updating the unique information list 164 and the management table 162 based on the unique information in which excess / deficiency has occurred, and is a report process (s7), a list update process (s8), and the above table update process. The table update process (s9) similar to (s3) is executed in this order. In the report processing (s7), the product name is extracted from the management table 162 using the type information in the excess / deficiency unique information as a search key, and the fact that the excess / deficiency has occurred in the extracted product name is managed as a report. This is a process of transmitting to the person terminal 20. The list update process (s8) is a process of adding the missing unique information to the unique information list 164 and / or deleting the unique information that should not be included in the unique information list 164.

According to the product management system 1 and the product management method of the present embodiment, the unique information to be inventoried is determined based on the start information transmitted from the inventory terminal 40 when the inventory is started (s4). The collation process (s5) is executed for the confirmed unique information. Therefore, even if the unique information list 164 is added due to the arrival of the product G, the information to be collated does not change, so that inventory can be carried out. That is, the inventory work and the arrival work can be performed in parallel.

The product management system 1 of the present embodiment may include a POS terminal capable of communicating with the management server 10 via a LAN. The POS terminal transmits a reader module that functions as a reading unit that reads unique information from the RF tag 4 attached to the product G, a memory that stores the read unique information, and the read unique information to the management server 10. A network module that functions as a receiver that receives the transmitter and the product name and price corresponding to the unique information from the management server 10, a display that functions as a display that displays the received product name and price to the customer, and the like. It includes a reader module, a memory, a network module, and a CPU that functions as a control unit that controls a display.

The POS terminal can read the unique information of the product G that the customer intends to purchase, receive the name and price of the product G from the server based on the read unique information, and present it to the customer. When the purchase price is paid by the customer, the CPU of the POS terminal transmits the payment information to the management server 10. The payment information is information including the unique information of the purchased product G, and the unique information can be obtained by extracting the information stored in the memory after reading.

When the CPU of the management server 10 receives the payment information from the POS terminal, it executes a list deletion process of deleting the unique information included in the payment information from the unique information list 164, and is the same as the above-mentioned table update process (s3). Execute the process. As a result, in the management table 162, the number of inventories corresponding to the sold product G is reduced.

Even in the embodiment having the POS terminal as described above, the unique information to be inventoried is determined based on the start information transmitted from the inventory terminal 40 when the inventory is started, and the determined unique information is obtained. The collation process (s5) is executed. Therefore, even if the product G is deleted from the unique information list 164 due to the sale of the product G, the information to be collated does not change, so that inventory can be carried out. That is, the inventory work and the sales work can be performed in parallel.

The present invention may be a modification of the above-described embodiment.

<Modification example 1>
In the above embodiment, if an excess or deficiency occurs as a result of executing the collation process, a report process is executed. For example, information on the excess or deficiency product is transmitted to the network printer connected to the LAN. , The information may be printed. That is, if a difference is detected between the collation target information (unique information that was in the unique information list at the start of reading) and the read information (information read from the product in inventory) in the collation process, the difference is found. You may execute the process of outputting the contents of. By outputting the content of the difference detected in the collation process in this way, it is possible to use it as evidence for fluctuations in store assets due to fluctuations in the number of managed product inventories.

<Modification 2>
In the above embodiment, the POS terminal may include a barcode reader in addition to the RFID reader. In such an embodiment, for example, when the RF tag attached to the product is out of order, it is possible to read the type information from the JAN code of the product by using a barcode reader instead of the RFID reader. It is possible to execute payment processing based on the type information.

Here, when the payment process is executed using the barcode reader, the management server cannot receive the unique information from the POS terminal, so that the unique information list cannot be updated. Therefore, the management server executes a table update process for reducing the number of products in stock corresponding to the type information based on the type information (JAN code) received from the POS terminal.

As a result, the number of unique information stored in the unique information list is larger than the number of stocks stored in the management table. However, by carrying out the inventory work, reading the unique information from all the products in the store, and executing the collation process, the surplus unique information in the unique information list can be detected, and the surplus unique information can be obtained as described above. It is possible to specify it as unique information of the product settled by the type information (JAN code).

<Modification example 3>
In the above embodiment, the product management has been described by taking the arrival and sale at the store as an example, but the product management is not limited to the sales and may be the receipt / shipment management of the product. In addition, in order to manage the shipment, a shipping terminal having the same configuration as the receiving terminal is provided in the shipping route of the product, the unique information of the product shipped from the store is read, and the read unique information is transmitted to the management server. The products issued in step 1 can be managed by the management server.

<Modification example 4>
In the above embodiment, the store which is the sales base has been described as an example, but for example, it may be used for product management in a factory which is a production base and warehousing / delivery management of products in a distribution warehouse which is a distribution base.

The present invention can also be carried out in a mode in which various improvements, modifications, or modifications are made based on the knowledge of those skilled in the art without departing from the spirit of the present invention. Further, within the range in which the same action or effect is produced, any of the invention-specific matters may be replaced with another technique.

1 ... Product management system 14 ... Processing unit 16 ... Storage unit 42 ... Reading unit

Claims (3)

A storage unit that stores unique information attached to products at the base,
A reading unit that reads the unique information
A processing unit that collates the unique information stored in the storage unit with the unique information read by the reading unit at the time of starting reading by the reading unit.
Product management system equipped with. The product management system according to claim 1, wherein the processing unit outputs the difference when the difference is detected in the collation. Steps to store unique information attached to products at the base in the storage unit,
Steps to read the unique information,
A step of collating the unique information stored in the storage unit with the read unique information at the time when the reading of the unique information is started.
Product management methods including.

Images