JP6949077B2 - Product management system - Google Patents

Description

The present invention relates to a product management system.

Patent Document 1 discloses that sales data acquired by a POS system is sent to a consumer's mobile information device and recorded in the consumer's product management DB in the mobile information device. Further, it is disclosed that a product management DB is provided on the Internet and the product management DB is updated by the product management data sent from the POS system. Further, it is disclosed that the data sent from the POS system to the consumer's mobile information device includes the purchased product name, the expiration date, the price, the article information, and the like. Further, it is disclosed that the product management DB is updated (the consumed product is deleted) by reading the barcode of the product when the product is consumed.

Japanese Unexamined Patent Publication No. 2001-344410

In the technique of Patent Document 1, sales management data obtained at the time of sale by a POS system or the like can be provided to the purchaser and can be used for product management in the purchaser. It took time and effort to prepare. In addition, the seller only provides the data to the purchaser, and it was not expected that the seller would utilize the buyer's information.

An object of the present invention is to provide a product management system that can reduce the time and effort of a purchaser in product management and can utilize the information of the purchaser on the seller side as well.

The invention according to claim 1 is a product that can exchange data with a system used by a plurality of purchasers for each purchaser and is a system on the seller side used by a plurality of sellers for each seller. In the management system, the purchaser of the product uses the management information acquisition means for acquiring the management information of the product with the sale of the product and the management information acquired by the management information acquisition means for each purchaser. The update means for storing in the purchased goods management database in the system to update the purchased goods management database and the purchased goods management database in the system used by the purchaser for each purchaser according to predetermined conditions. It is a product management system characterized by comprising a consumption information acquisition means for referring to and acquiring information on the consumption of the product.
The invention according to claim 2 generates a purchased product management database that stores the management information when the purchased product management database to be updated by the updating means does not exist, and obtains information on the products purchased by the purchaser. The product management system according to claim 1, further comprising a database generation means for constructing a purchase product management server to be managed.
The invention according to claim 3 is the invention according to claim 1 or 2, wherein the consumption information acquisition means refers to the purchased product management database and acquires information on the consumed product. It is a product management system.
The invention according to claim 4 is the invention according to claim 1 or 2, wherein the consumption information acquisition means refers to the purchased product management database and acquires information on a product whose expiration date has passed. The described product management system.
The invention according to claim 5 is the product management system according to any one of claims 1 to 4, wherein the management information acquisition means is a reading device that reads a GS1 data bar.
The invention according to claim 6, the data exchange to the system in which a plurality of sellers are available per seller are possible, is purchasing side of a system in which a plurality of purchasers are available per purchaser In the product management system, the management information acquisition means for acquiring the management information of the purchased product, the management information storage means for storing the acquired management information, and the management information stored in the management information storage means are browsed. A screen generation means for generating a screen for the user, a reception means for receiving an editing operation for the management information stored in the management information storage means, and a management information storage means for the system used by the seller for each seller. The screen generation means includes an output means for outputting the management information stored in the management information, and the screen generation means exceeds the expiration date of the product on the screen based on the expiration date information included in the management information. The receiving means accepts an editing operation for deleting the information of the consumed goods, and the output means receives a request from the system used by the seller for each seller. , A product management system characterized in that information on products whose expiration date has been exceeded and information on the consumed products is output to a system used by the seller for each seller.
The invention according to claim 7 is a user management means for registering information on a purchaser of a product related to the management information and managing the management information as a user who can edit the management information stored in the management information storage means. The product management system according to claim 6, further comprising.
The invention according to claim 8 applies to each user when a plurality of users associated with the management information storage means for storing the management information of the product purchased by the user are registered in one of the user management means. The product management system according to claim 7, wherein a plurality of corresponding management information storage means are linked to form one management information storage means.

According to the present invention, it is possible to realize a product management system in which the time and effort of the purchaser in product management can be reduced and the information of the purchaser can be utilized on the seller side as well.

It is a figure which shows the whole structure of the product management system by this embodiment. It is a figure which shows the functional structure of the sales management server of the seller side system. It is a figure which shows the functional structure of the sales information input terminal. It is a figure which shows the functional structure of a seller information terminal. It is a figure which shows the functional structure of the purchase product management server of the purchaser side system. It is a figure which shows the functional structure of the purchaser information terminal. It is a figure which shows the data structure example of the sales information DB of a sales management server. It is a figure which shows the data structure example of the purchase product information DB of the purchase product management server. It is a sequence diagram which shows the operation when the purchase product information DB is updated based on the product sales information. It is a sequence diagram which shows the operation when constructing a purchase product management server based on the product sales information and providing it to a purchaser. It is a sequence diagram which shows the operation when the sales management server acquires the information of the consumed product from the purchase product management server.

Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings.
<System configuration>
FIG. 1 is a diagram showing an overall configuration of a product management system according to the present embodiment. The product management system of the present embodiment includes a seller-side system A and a purchaser-side system B. The seller-side system A includes a sales management server 100, a sales information input terminal 110, and a seller information terminal 120. The purchaser-side system B includes a purchase item management server 200 and a purchaser information terminal 210.

The sales management server 100 of the seller side system A, the purchase item management server 200 of the purchaser side system B, and the purchaser information terminal 210 are connected by a network 300. The network 300 is, for example, the Internet. In the seller-side system A, the sales management server 100, the sales information input terminal 110, and the seller information terminal 120 are connected by a dedicated network (hereinafter, referred to as an internal network). In FIG. 1, the sales management server 100, the sales information input terminal 110, and the seller information terminal 120 are connected using an internal network provided separately from the network 300, but are set on the network 300. VPN (Virtual Private Network) may be used as an internal network. In the purchaser side system B, the purchase item management server 200 and the purchaser information terminal 210 are connected by a network 300.

In FIG. 1, one seller-side system A and one buyer-side system B are shown, but in reality, a plurality of seller-side systems A and a plurality of buyer-side systems B are connected to each other via the network 300. Be connected. Normally, the seller-side system A is provided for each seller of the product, and the purchaser-side system B is provided for each purchaser. Here, the seller is an entity of sales management by the seller-side system A (in other words, a user of the seller-side system A), and does not necessarily refer to an individual seller. For example, the seller who is the user of the seller-side system A may be a store or a complex (supermarket, department store, shopping district, etc.) in which several stores are gathered. Further, the purchaser is the main body of purchase product management by the purchaser side system B (in other words, the user of the purchaser side system B), and does not necessarily refer to an individual purchaser, but consists of a plurality of persons. It may be a group. Examples of such a group of buyers include a family member who shares a household budget and a group of people who jointly purchase products by contract or the like. However, in the following description, as a general case, a case where the seller is a store and the purchaser is an individual will be described as an example.

In the seller-side system A, the sales management server 100 is a server that manages sales information of products at the seller. The sales information input terminal 110 is a terminal device for inputting product sales information to the sales management server 100. As the sales information input terminal 110, for example, a POS (Point Of Sales) terminal or the like can be used. The seller information terminal 120 is an information processing device for an individual seller to access the sales management server 100 and view or edit the managed information. As the seller information terminal 120, for example, a personal computer or the like can be used. Here, the individual seller includes an individual belonging to such a seller when the seller is a store or the like. For example, the owner or employee of a store. In FIG. 1, one sales information input terminal 110 and one seller information terminal 120 are shown in the seller side system A, but a plurality of these devices exist in one seller side system A. You can do it.

In the purchaser-side system B, the purchase product management server 200 is a server that manages information on products purchased by the purchaser. The purchaser information terminal 210 is an information processing device for an individual purchaser to access the purchased item management server 200 to view and edit the managed information. As the purchaser information terminal 210, for example, an information device such as a personal computer or a smartphone may be used. In addition, in FIG. 1, one purchase product management server 200 and one purchaser information terminal 210 are shown in the purchaser side system B. However, the purchaser possesses a plurality of information processing devices and can use these to connect to the purchase item management server 200 as the purchaser information terminal 210. In this case, there are a plurality of purchaser information terminals 210. ..

<Sales management server configuration>
FIG. 2 is a diagram showing a functional configuration of the sales management server 100 of the seller-side system A. The sales management server 100 includes a sales information management unit 101, a sales information database (DB) 102, a purchase product information DB management unit 103, a purchase product management server construction unit 104, a purchase product information acquisition unit 105, and a communication unit. It includes 106.

The sales information management unit 101 stores and manages the sales information of the product, which is acquired with the sale of the product, in the sales information DB 102. The sales information management unit 101 is an example of management information acquisition means in the sales management server 100.

The sales information DB 102 is a database that stores sales information of products. Examples of the sales information include information on the products sold, the date and time of sale, the place where the product was sold, information that identifies the purchaser, and the like. The product information may include information such as product type and individual identification information, manufacturing information and distribution information, and if the product is food or consumer goods, the expiration date. The specific information to be used as sales information or product information may be individually determined based on the system usage, operating conditions, and the like. Here, it is assumed that the sales information includes at least the product information and the information that identifies the purchaser, and the product information includes at least the expiration date.

The purchase item information DB management unit 103 manages the purchase item information DB (described later) of the purchaser registered in the sales information DB 102. The purchase product information DB management unit 103 connects to and updates the purchase product information DB of the purchaser who purchased the product based on the purchaser information included in the sales information stored in the sales information DB 102. Specifically, the purchased product information DB management unit 103 stores the information of the product purchased by the purchaser in the purchased product information DB as the purchased product information of the purchaser. The purchase item information DB management unit 103 is an example of the updating means. The database of purchasers to be managed is usually a purchase item information DB included in the purchase item management server 200 constructed by the purchase item management server construction unit 104, which will be described later, but the purchaser prepares the database by himself / herself. The database for managing purchased items may be registered as a purchased item information DB and used as a management target.

When the purchaser's DB does not exist, the purchase item management server construction unit 104 constructs and provides the purchase item management server 200 for the purchaser. The case where the purchaser's DB does not exist may be, for example, the case where the purchaser first purchases the product managed by the sales management server 100. The purchase product management server 200 is constructed as, for example, a virtual server or the like on the network 300. The purchase product management server construction unit 104 is an example of a database generation means.

The purchased product information acquisition unit 105 connects to the purchased product information DB managed by the purchased product information DB management unit 103, and acquires information on consumption of the product (purchased product). The purchase product information acquisition unit 105 refers to the purchase product management DB according to predetermined conditions. As conditions for referring to the purchased product management DB, for example, timing conditions (referred regularly, referenced on a fixed day of the week or time, etc.), notification from the purchaser side system B, etc. are set. can do. The information on the consumption of the product corresponds to, for example, the information of the product actually consumed by the purchaser and the information of the product whose expiration date has passed. The purchased item information acquisition unit 105 is an example of the consumption information acquisition means.

The communication unit 106 is a network interface for connecting to an external device. The communication unit 106 connects to the purchase product management server 200 and the purchaser information terminal 210 of the purchaser side system B via the network 300, and transmits / receives commands and data. Further, the communication unit 106 connects to the sales information input terminal 110 and the seller information terminal 120 via the internal network of the seller side system A, and transmits / receives commands and data.

The sales management server 100 having the above functions may be configured by a single server machine, or may be configured as a system in which the functions are distributed to a plurality of servers. In either case, the server includes a CPU (Central Processing Unit) which is a computing means, a main storage device (main memory) which is a storage means, and an external storage device. The CPU reads the program stored in the external storage device into the main storage device and executes it. As the main storage device, for example, a RAM (Random Access Memory) is used. As the external storage device, for example, a magnetic disk device, an SSD (Solid State Drive), or the like is used. When the CPU executes the program, each function of the sales information management unit 101, the purchase product information DB management unit 103, the purchase product management server construction unit 104, and the purchase product information acquisition unit 105 is realized. The sales information DB 102 is realized by, for example, a storage means such as a magnetic disk device or an SSD.

<Structure of sales information input terminal>
FIG. 3 is a diagram showing a functional configuration of the sales information input terminal 110. The sales information input terminal 110 includes a reading unit 111, an ID acquisition unit 112, a communication unit 113, and a control unit 114. As described above, as the sales information input terminal 110, a POS terminal or the like can be used. The sales information input terminal 110 is an example of management information acquisition means in the entire seller-side system A.

The reading unit 111 is a device that reads sales information of products. Specifically, for example, it is a barcode reader or the like that reads a barcode attached to a product. As the barcode attached to the product, for example, a GS1 data bar is used. Unlike the JAN (Japanese Article Number) code and the EAN (European Article Number) code, the GS1 data bar can record product attribute information such as expiration date and lot number in addition to the product identification code. Therefore, if the GS1 data bar is used as the barcode to be read, the information related to the product among the sales information stored in the sales information DB 102 can be acquired only by the operation of reading the barcode by the reading unit 111.

The ID acquisition unit 112 is a device that acquires identification information (ID) of a purchaser who has purchased a product. The identification information may be any information that identifies the purchaser who is the user of the purchase information DB managed by the purchase information DB management unit 103 of the sales management server 100, and the information format, recording method, acquisition method, etc. Does not matter. For example, an ID card in which the identification information is recorded may be distributed to the purchaser, and the identification information may be acquired by reading the identification information using the ID acquisition unit 112 as a means for reading the ID card at the time of purchasing the product. As a method of recording the identification information on the ID card, for example, the identification information is recorded on an IC chip, a magnetic tape, or the like, or a code composed of a barcode or a character string is printed and recorded. Various methods may be used. Further, the ID acquisition unit 112 may be provided with an input device such as a keyboard, and the identification information may be acquired by having the purchaser input the password. Further, the purchaser's identification information may be acquired from the external device by cooperating with the authentication function of the external system such as SNS (Social Networking Service).

The communication unit 113 is a network interface for connecting to the sales management server 100 via the internal network of the seller side system A. The communication unit 113 connects to the sales management server 100 and transmits / receives commands and data.

The control unit 114 is a control device that controls each function of the sales information input terminal 110. The control unit 114 includes a calculation means such as a CPU and an ASIC (Application Specific Integrated Circuit), and controls acquisition of various types of information and data communication described above.

<Structure of seller information terminal>
FIG. 4 is a diagram showing a functional configuration of the seller information terminal 120. The seller information terminal 120 includes a processing unit 121, a display unit 122, an operation receiving unit 123, and a communication unit 124. As described above, as the seller information terminal 120, an information device such as a personal computer can be used.

The processing unit 121 includes a CPU as a calculation means and a main storage device, and executes various data processing and control. The display unit 122 displays a screen for referring to the data of the sales information DB 102 acquired from the sales management server 100. As the display unit 122, a display device such as a liquid crystal display is used. The operation receiving unit 123 receives an operation for displaying the screen on the display unit 122 and an operation such as data editing performed on the screen displayed on the display unit 122. As the operation receiving unit 123, for example, an input device such as a keyboard, a mouse, or a touch panel is used. The communication unit 124 is a network interface for connecting to the sales management server 100 via the internal network of the seller side system A. The communication unit 124 connects to the sales management server 100 and transmits / receives commands and data.

<Configuration of purchase management server>
FIG. 5 is a diagram showing a functional configuration of the purchased product management server 200 of the purchaser side system B. The purchase product management server 200 includes a purchase product information management unit 201, a purchase product information database (DB) 202, a user management unit 203, a cooperation management unit 204, a screen generation unit 205, an input / output control unit 206, and the like. It includes a communication unit 207.

The purchased product information management unit 201 stores and manages the purchased product information (purchased product information), which is the purchased product, as the management information in the purchased product information DB 202. Further, the purchased item information management unit 201 accepts the editing operation performed by using the purchaser information terminal 210, and reflects the edited contents in the purchased item information stored in the purchased item information DB 202. Specifically, for example, when the purchase product information management unit 201 performs an editing operation for deleting the information of the consumed product, the purchase product information management unit 201 of the purchase product information management unit 201 stores the corresponding product in the purchase product information DB 202. Update the information to indicate that the item has been consumed. The purchased item information management unit 201 is an example of the receiving means in the purchased item management server 200.

The purchased item information DB 202 is a database for storing purchased item information. Examples of the purchased product information include information on the purchased product, the date and time of purchase, the place of purchase, and the like. Product information includes product identification information, manufacturing information, expiration date, and the like. Specifically, what kind of information should be used as purchased item information or product information may be individually determined based on the use of the system, operating conditions, and the like. Here, it is assumed that the purchased product information includes at least the product information and the information indicating the place of purchase, and the product information includes at least the expiration date. The purchased item information DB 202 is an example of the management information storage means.

The user management unit 203 registers and manages the users of the purchased product management server 200. Here, the user of the purchased product management server 200 is a person who has the editing authority of the purchased product information DB 202, and is usually a purchaser (purchaser) of the product related to the purchased product information stored in the purchased product information DB 202. Is. The user management unit 203 is an example of the user management means. The user management unit 203 may register a plurality of users as users of the own server. In this case, no matter which of the plurality of users purchases the product, the purchased product information of the product is managed by one purchased product management server 200 in which each user is registered. The plurality of users may be registered only on one purchase product management server 200, or may have their own purchase product management server 200 individually. The user who has his / her own purchase product management server 200 is, in other words, a user who is associated with the purchase product information DB 202 in which his / her own purchase product information is stored.

In the latter case, for example, each user has his / her own purchase product management server 200 in advance and manages purchase product information. Then, by registering another user in the purchase product management server 200 of one of the users, the number of users managed by the purchase product management server 200 of the one user becomes a plurality of users. When another user who has his / her own purchase item management server 200 is registered in the purchase item management server 200 of one user, the purchase item information DB 202s of each of the registered users' own purchase item management server 200 are linked with each other. , It is treated as one purchased item information DB 202.

As described above, the linkage management unit 204 manages the linkage between the purchase product management servers 200 when a plurality of users are registered in the purchase product management server 200 of one user. The specific method for linking the purchased item information DB 202 is not particularly limited. As an example, the purchased product information stored in each purchased product information DB 202 is shared by all the purchased product information DB 202, and when one purchased product information DB 202 is updated, the updated contents are updated to all the purchased product information DB 202. It is conceivable to reflect it in. In this case, it may be possible to distinguish which of the purchased item information DB 202 originally stored each purchased item information. Further, as another example, it is conceivable to connect the purchase product management servers 200 of each user to each other so that the purchase product information stored in the purchase product information DB 202 of each purchase product management server 200 can be mutually grasped. .. In this case, even if it is possible to extend the authority of each user to the purchase product management server 200 and connect to the purchase product management server 200 of another user to view or edit the contents of the purchase product information DB 202. good. Further, each user may have restrictions on the authority for connecting to the purchase product management server 200 of another user. For example, when a specific user connects to the purchase product management server 200 of another specific user, a restriction may be imposed such that viewing of the purchased product information is permitted but editing is not permitted.

The screen generation unit 205 generates a screen for referring to or editing the purchased item information in the purchased item information DB 202. Based on the expiry date information included in the purchased item information, the screen generation unit 205 identifiablely displays the product whose expiry date has been exceeded and the product which has not exceeded the expiry date on the generated screen. The screen generation unit 205 is an example of the screen generation means.

The input / output control unit 206 controls the input / output of information performed by communication with the sales management server 100. Specifically, the input / output control unit 206 acquires information on purchased items from the sales management server 100. Further, the input / output control unit 206 receives a request from the sales management server 100. Then, the input / output control unit 206 outputs the information of the product whose expiration date has passed and the consumed product to the sales management server in response to the received request. The input / output control unit 206 is an example of management information acquisition means and an example of output means.

The communication unit 207 is a network interface for connecting to an external device. The communication unit 207 connects to the sales management server 100 of the seller side system A and the purchaser information terminal 210 of the purchaser side system B via the network 300, and transmits / receives commands and data.

<Configuration of purchaser information terminal>
FIG. 6 is a diagram showing a functional configuration of the purchaser information terminal 210. The purchaser information terminal 210 includes a processing unit 211, a display unit 212, an operation receiving unit 213, and a communication unit 214. As described above, as the purchaser information terminal 210, an information device such as a personal computer or a smartphone can be used.

The processing unit 211 includes a CPU as a calculation means and a main storage device, and executes various data processing and control. The display unit 212 acquires and displays a screen for referring to the data of the purchased item information DB 202 acquired from the purchased item management server 200. As the display unit 212, a display device such as a liquid crystal display is used. The operation receiving unit 213 accepts operations for displaying the screen on the display unit 212 and operations such as data editing performed on the screen displayed on the display unit 212. Here, the editing operation accepted by the operation receiving unit 213 includes changing the status of the purchased item and deleting the item of the consumed purchased item. As the operation receiving unit 213, for example, an input device such as a keyboard, a mouse, or a touch panel is used. The operation receiving unit 213 is an example of the receiving means in the entire purchaser side system B. The communication unit 214 is a network interface for connecting to an external device. The communication unit 214 connects to the sales management server 100 of the seller side system A and the purchase product management server 200 of the purchaser side system B, and transmits / receives commands and data.

<Data structure of sales information DB>
FIG. 7 is a diagram showing a data configuration example of the sales information DB 102 of the sales management server 100. In the sales information DB 102 shown in FIG. 7, the "product code" of the sold product, the "manufacturing date", the "purchasing date", the "expiration date", and the product were purchased for each store. The "purchaser ID", which is the identification information of the purchaser, and the "consumption information" of the product are recorded. As the "product code" recorded as the identification information of the sold product, information for specifying the type of the product or individual identification information of the product can be recorded. "Consumption information" is information indicating that the sold product has been consumed. The "consumption information" is acquired from the purchased product management server 200 of the purchaser of the product and recorded. The contents of the sales management server 100 shown in FIG. 7 are merely examples, and are actually set specifically according to the type of product, the specifications of the system A on the seller side, the operation policy, and the like. For example, information on distribution, information on the product itself such as weight and volume, lot information, ordering information, and the like may be registered, or some of the illustrated items may be excluded from the registration target.

<Data structure of purchase information DB>
FIG. 8 is a diagram showing a data configuration example of the purchased product information DB 202 of the purchased product management server 200. In the purchased product information DB 202 shown in FIG. 8, a "product name", a "purchase date", an "expiration date", a "state", a "purchaser", and a "purchaser" are recorded for each purchased product. NS. The "state" is information indicating the state (status) of the product, for example, information indicating the state such as unopened, opened, and consumed, and information indicating the state such as unused and used are recorded. .. The "purchase destination" is identification information that identifies the store where the product was purchased. The "purchaser" is identification information that identifies the purchaser (purchaser) of the product, but in particular, when the purchase product information DB 202 corresponds to a plurality of purchasers, the purchaser is set for each product. Recorded when a distinction is required. If the purchase item information DB 202 corresponds to only one purchaser, or if it is not necessary to distinguish each of the plurality of purchasers, the purchaser is specified for each purchase item information DB 202, so no record is made. You may. In this case, the user of the purchased product management server 200 is usually the purchaser. Although not particularly specified in the example of FIG. 8, when displaying the contents of the purchased item information DB 202 on the display unit 212 of the purchaser information terminal 210, the products whose expiration date has passed may be displayed in an identifiable manner. .. For example, items of products that have passed the expiration date can be shaded, grayed out, changed in font and display color, changed in cell display color, etc. so that they can be visually distinguished from other product items. Conceivable.

<Operation of product management system>
Next, the operation of the product management system will be described focusing on the data exchange performed between the seller side system A and the purchaser side system B. The data exchange between the seller side system A and the purchaser side system B is mainly when the product is sold and the purchased product information DB 202 is updated based on the sales information, and when the product is consumed and the consumed product. This is performed when the sales management server 100 acquires the information of the above from the purchased product management server 200. Hereinafter, the operation of the device of each system will be described separately for each scene.

<Actions performed according to product sales>
FIG. 9 is a sequence diagram showing an operation when the purchased product information DB 202 is updated based on the product sales information. When the product is sold and the bar code attached to the product is read by the sales information input terminal 110, the sales information of the read product is transmitted from the sales information input terminal 110 to the sales management server 100. The product sales information includes information recorded by the bar code (purchased item information) and information obtained by executing the bar code reading process by the sales information input terminal 110 (input time and input sales information input terminal). 110 identification information, store information, etc.) are included. Further, the sales information input terminal 110 transmits the purchaser identification information acquired by the ID acquisition unit 112 together with the sales information to the sales management server 100.

The sales management server 100 updates the sales information DB 102 with the sales information of the product received from the sales information input terminal 110, and purchases the product of the purchaser who purchased the product based on the information of the purchaser extracted from the sales information of the product. Connect to the management server 200 and call the purchase product information DB 202.

When the sales management server 100 receives the response from the purchase product management server 200, the sales management server 100 extracts the information for updating the purchase product information DB 202 from the sales information and sends it to the purchase product management server 200 to update the purchase product information DB 202. Let me. As a result, information on the product purchased by the purchaser is added to the purchased product information DB 202.

In the operation example shown in FIG. 9, the purchaser already has the purchased product management server 200 (purchased product information DB 202), and the sales management server 100 performs an operation to update the purchased product information DB 202. On the other hand, when the purchaser does not have the purchase item management server 200 (purchase item information DB 202), the sales management server 100 constructs the purchase item management server 200 of the purchaser, and the purchase item information DB 202 contains the product. Record information and provide it to buyers.

FIG. 10 is a sequence diagram showing an operation when the purchased product management server 200 is constructed based on the sales information of the product and provided to the purchaser. The operation until the bar code attached to the product is read by the sales information input terminal 110 with the sale of the product and the sales information DB 102 is updated by the sales information is the same as the operation example shown in FIG.

Further, the sales management server 100 connects to and purchases the purchased product management server 200 of the purchaser who purchased the product based on the buyer information extracted from the sales information of the product, as in the operation example shown in FIG. Attempts to call the product information DB 202. However, at this point, the purchase product management server 200 of this purchaser does not exist, so this process fails. Then, when a certain period of time elapses without receiving a response after the sales management server 100 tries to connect to the purchase product management server 200, the purchase product management server construction unit 104 of the sales management server 100 adds the product sales information. Based on this, the purchased product information DB 202 is generated, and the purchased product management server 200 is constructed.

When the purchased product management server 200 is constructed, there is a response from the constructed purchased product management server 200 to the sales management server 100. Upon receiving this response, the sales management server 100 transmits link information for connecting to the purchase product management server 200 to the purchaser information terminal 210 of the user corresponding to the constructed purchase product management server 200. Here, the user corresponding to the purchased product management server 200 is a purchaser who has purchased a product that has triggered the construction of the purchased product management server 200. As the link information, for example, the URL (Uniform Resource Locator) of the constructed purchase product management server 200 is used. The transmission of the link information is performed, for example, by e-mail. Further, when the SNS authentication information is used as the purchaser's identification information, the notification may be made using the message function of the corresponding SNS.

The above operation described with reference to FIGS. 9 and 10 is merely an example. For example, in the above operation example, it is decided to construct the purchase product management server 200 when a certain time elapses without receiving a response after the sales management server 100 tries to connect to the purchase product management server 200. .. On the other hand, regardless of the elapsed time, the purchase product management server 200 may be constructed when the connection to the purchase product management server 200 is attempted a certain number of times and the connection cannot be established. Further, in the above operation example, in principle, the operation is performed when the purchased product management server 200 (purchased product information DB 202) exists (see the operation of FIG. 9), and as an exceptional operation when the purchased product management server 200 does not exist. It was explained to construct the purchase product management server 200 (see the operation of FIG. 10). On the other hand, the sales management server 100 first confirms the existence of the purchased product management server 200, connects to the purchased product management server 200 if it exists, updates the purchased product information DB 202, and constructs the purchased product management server 200 if it does not exist. You may.

<Actions performed according to product consumption>
FIG. 11 is a sequence diagram showing an operation when the sales management server 100 acquires information on the consumed products from the purchased product management server 200. The sales management server 100 inquires of the purchased product management server 200 of information regarding consumption of the product (purchased product) based on predetermined conditions such as timing conditions (for example, periodically). If there are no newly consumed products since the previous inquiry, the purchased product management server 200 returns a response that there is no consumption to the sales management server 100.

Here, consider a case where a user of the purchased product management server 200 consumes a product whose information is stored in the purchased product information DB 202 of the purchased product management server 200 and updates the purchased product information DB 202. The user connects to the purchase product management server 200 from his / her purchaser information terminal 210 and calls a screen for displaying the purchase product information. The purchase product management server 200 generates a screen in response to a request from the purchaser information terminal 210 and transmits the screen to the purchaser information terminal 210.

The purchaser information terminal 210 displays the screen received from the purchase item management server 200. The user performs an editing operation with reference to the displayed purchase item information screen, and changes the state (status) of the consumed product to the content indicating that the product has been consumed. After that, the editing result of the purchased item information is transmitted from the purchaser information terminal 210 to the purchased item management server 200 by the operation of the user. The purchase product management server 200 updates the purchase product information DB 202 based on the received edit result of the purchase product information. As a result of this update, the state of the product with respect to the consumed information of the purchased product among the information held in the purchased product information DB 202 becomes the content indicating that the product has been consumed.

After that, when the sales management server 100 again inquires of the purchased product management server 200 for information on the consumption of the product (purchased product), the purchased product management server 200 responds that there is a consumed product and the state is consumed. Information indicating the product changed to the content indicating completed is transmitted to the sales management server 100. The sales management server 100 updates the sales information DB 102 based on the information received together with this response.

In the purchased item information DB 202, the consumed purchased item information is, for example, deleted from the purchased item information DB 202 after the state is considered to be consumed as described above and the information is transmitted to the sales management server 100. The condition for erasing the purchased item information whose state has been consumed may be, in addition to the information being transmitted to the sales management server 100, after a certain period of time has passed since the state has been consumed. In this case, if a certain period as the erasure condition is set longer than the interval at which the sales management server 100 makes an inquiry, it is possible to prevent the sales management server 100 from leaking information acquisition.

When the information on the consumed products is reflected in the sales information DB 102 of the sales management server 100, the seller knows the consumption status of the sold products by connecting to the sales management server 100 using the seller information terminal 120. obtain. Therefore, the seller can use the information on the consumption status for inventory management and the like, such as ordering and replenishing the consumed products.

In the above operation example, it has been described assuming that the purchased item is actually consumed and the purchased item information DB 202 is notified that the purchased item has been consumed by the operation of the purchaser information terminal 210 by the user. On the other hand, regardless of whether or not the purchased item is actually consumed, the purchased item whose expiration date has passed may be treated in the same manner as the actually consumed purchased item. Specifically, the state of the purchased item whose expiration date has been exceeded is regarded as "expired", and in response to an inquiry from the sales management server 100, the purchase whose state has expired together with the information of the purchased item whose state has been consumed. Product information is sent from the purchased product management server 200 to the sales management server 100. Then, in the sales information DB 102 of the sales management server 100, the information on the expired products is updated together with the information on the consumed products.

Since it is unknown whether or not the purchased product whose consumption has expired is actually consumed, the purchased product management server 200 notifies the purchaser information terminal 210 of the expiration of the consumption and requests confirmation of consumption. You may want to give a notification. Purchased items that have expired are expected to be consumed or disposed of immediately, even if they are not actually consumed. Therefore, in the sales management server 100, the information of the product (purchased product) whose consumption has expired may be treated in the same manner as the information of the consumable product, and may be taken into consideration in inventory management and the like.

Further, in the above operation example, only whether or not the purchased item has been consumed is dealt with as the state of the purchased item, but as the state of the consumed purchased item, the state of being completely consumed and the state of being consumed are being consumed. It may be distinguished from the state of (the state of being opened and partially consumed). In this case, depending on the type of purchased item, the consumption amount (for example, what percentage of the total is consumed) or the residual amount (for example, what percentage of the total remains) may be shown as the consumption status. good. These pieces of information can be reflected in the purchased item information DB 202 by, for example, operating the purchaser information terminal 210 by the user. In addition, when a purchased item is opened and partially consumed, the expiration date has passed after a certain period of time (for example, one week) has passed since the item was opened, regardless of the expiration date set in advance for the purchased item. It may be handled by the purchased item information DB 202 and the sales information DB 102.

Although the embodiments of the present invention have been described above, the technical scope of the present invention is not limited to the above embodiments. For example, in the above embodiment, the purchaser information terminal 210 has been described as an information processing device possessed by the purchaser. On the other hand, if an interface that enables connection with the purchase product management server 200 is set by logging in to the purchase product management server 200 using the purchaser's authentication information, various operations for such login are possible. Information equipment can be used as the purchaser information terminal 210. Further, if the screen generation unit 205 of the purchase product management server 200 is configured to generate and provide a login screen for performing a login operation, an information device capable of displaying the login screen and operating the login screen can be provided. It can be used as a purchaser information terminal 210.

Further, the purchased item is food, and a communication function is provided in a refrigerator capable of mechanically managing the receipt and delivery of food using a camera or a sensor so that the purchase item management server 200 can be connected to the purchaser information terminal 210. It is also possible to do. In this case, the information of the newly received food is associated with the information of the purchased product newly registered in the purchased product information DB 202 by the sales management server 100, and when the food is delivered, the food is dealt with. The state of the purchased item may be regarded as consumed. In addition, various changes and alternative configurations that do not deviate from the scope of the technical idea of the present invention are included in the present invention.

100 ... Sales management server, 101 ... Sales information management department, 102 ... Sales information database (DB), 103 ... Purchased goods information DB management department, 104 ... Purchased goods management server construction department, 105 ... Purchased goods information acquisition department, 106 ... Communication unit, 110 ... Sales information input terminal, 111 ... Reading unit, 112 ... ID acquisition unit, 113 ... Communication unit, 114 ... Control unit, 120 ... Seller information terminal, 121 ... Processing unit, 122 ... Display unit, 123 ... Operation reception unit, 124 ... communication unit, 200 ... purchased product management server, 201 ... purchased product information management department, 202 ... purchased product information database (DB), 203 ... user management department, 204 ... cooperation management department, 205 ... screen generation Unit, 206 ... Input / output control unit, 207 ... Communication unit, 210 ... Purchaser information terminal, 211 ... Processing unit, 212 ... Display unit, 213 ... Operation reception unit, 214 ... Communication unit, 300 ... Network

Claims (8)

It is a product management system that can exchange data with a system used by multiple buyers for each purchaser and is a system on the seller side that is used by multiple sellers for each seller.
Management information acquisition means for acquiring management information of the product when the product is sold,
An update means for storing the management information acquired by the management information acquisition means in a purchase product management database in a system used by the purchaser of the product for each purchaser and updating the purchase product management database.
Consumption information acquisition means for acquiring information on product consumption by referring to the purchased product management database in the system used by the purchaser for each purchaser according to predetermined conditions.
A product management system characterized by being equipped with. When the purchase product management database to be updated by the update means does not exist, a purchase product management database that stores the management information is generated, and a purchase product management server that manages information on the products purchased by the purchaser is constructed. The product management system according to claim 1, further comprising a database generation means. The product management system according to claim 1 or 2, wherein the consumption information acquisition means refers to the purchased product management database and acquires information on the consumed products. The product management system according to claim 1 or 2, wherein the consumption information acquisition means refers to the purchased product management database and acquires information on products whose expiration date has passed. The product management system according to any one of claims 1 to 4, wherein the management information acquisition means is a reading device that reads a GS1 data bar. It is a product management system that can exchange data with a system used by multiple sellers for each seller, and is a system on the buyer side that is used by multiple buyers for each purchaser.
Management information acquisition means to acquire management information of purchased products,
A management information storage means for storing the acquired management information and
A screen generation means for generating a screen for viewing the management information stored in the management information storage means, and a screen generation means.
A receiving means for accepting an editing operation for the management information stored in the management information storage means, and
It is provided with an output means for outputting the management information stored in the management information storage means to a system used by the seller for each seller.
Based on the expiry date information included in the management information, the screen generation means can distinguish between products that have exceeded the expiry date and products that have not exceeded the expiry date on the screen.
The receiving means accepts an editing operation for deleting the information of the consumed product,
The output means is to a system in which the seller uses information on products that have exceeded the expiration date and the products that have been consumed, in response to a request from the system that the seller uses for each seller. A product management system characterized by outputting. A user management means for registering information on a purchaser of a product related to the management information and managing the management information as a user who can edit the management information stored in the management information storage means is further provided. The product management system according to claim 6. When a plurality of users associated with the management information storage means for storing the management information of the products purchased by themselves are registered in one of the user management means, a plurality of the management information storage means corresponding to each user. The product management system according to claim 7, wherein the products are linked to form one management information storage means.

Images