JP2024065321A - Data management system and data management method - Google Patents

Abstract

[Problem] Supports inventory management of bulk items. [Solution] A data management system 1 that is characterized by comprising a total weight acquisition means for acquiring the total weight of a target item including a container, an item weight acquisition means for acquiring the weight of the target item only, a calculation processing means for calculating the container weight based on the total weight and the item weight, and an output means for outputting the container weight. [Selected Figure] Figure 3

Description

Application for application of Article 30, Paragraph 2 of the Patent Act submitted. Delivered to Totoya Co., Ltd. Kyoto Head Office on July 26, 2022.

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

Due to the problem of food waste, there is a growing trend to encourage sales by weight, whereby customers purchase only the amount they need. As a result, there is a need for technology to easily manage inventory of items sold by weight.
In this regard, as disclosed in Patent Document 1, a foodstuff management device is known that calculates the expiration date of foodstuffs and issues a medium on which the expiration date is printed.

JP 2017-021670 A

One of the objectives of the present invention is to provide a data management system that supports inventory management of bulk items.

To achieve the above object, the data management system according to the present invention is characterized by comprising a total weight acquisition means for acquiring the total weight of the target item including the tare, an item weight acquisition means for acquiring the item weight which is the weight of only the target item, a calculation processing means for calculating the tare weight based on the total weight and the item weight, and an output means for outputting the tare weight.

1 is a block diagram showing a hardware configuration of a data management system according to an embodiment of the present invention. FIG. 2 is a schematic front view showing an example of a terminal constituting the data management system. FIG. 2 is a block diagram showing a software configuration of the data management system. A figure showing an example of data stored in the above-mentioned data management system, including (a) an example of a table related to item information stored in the item information storage unit, (b) an example of a table related to order information stored in the order information storage unit, and (c) an example of a table related to inventory information stored in the inventory information storage unit. 11A and 11B are diagrams showing examples of labels issued by a printing device as an example of an output device constituting the data management system. 11 is a sequence diagram showing the flow of container label issuing processing executed by the data management system. FIG. 11 is a sequence diagram showing the flow of an inventory process executed by the data management system. FIG. 11A to 11D are diagrams showing examples of screens displayed on the terminal, where (a) is a first example, (b) is a second example, (c) is a third example, and (d) is a fourth example. 13A and 13B are diagrams showing examples of screens displayed on the terminal, in which (a) is a fifth example, and (b) is a sixth example.

Overview Hereinafter, a data management system according to an embodiment of the present invention and a data management device constituting the data management system will be described with reference to the drawings.
A data management system 1 according to this embodiment shown in FIG. 1 is a system for managing inventory of items sold by weight.
In this embodiment, the goods are products provided to customers in a store, and more specifically, foods such as dried fruits, nuts, and beans. However, the goods are not limited to these goods as long as they are suitable for selling by weight. Furthermore, the data management system 1 is not limited to goods sold by weight, so-called measured goods, but can also manage goods sold according to the number of pieces, so-called counted goods.

Hardware Configuration of the Weighing Device 5 First, the weighing device 5 connected to the data management system 1 will be described.
As shown in FIG. 1, the weighing device 5 includes an arithmetic unit such as a CPU (Central Processing Unit) for executing information processing, and memory devices such as a RAM (Random Access Memory) and a ROM (Read Only Memory), and is connected to a weighing unit 51, a display unit 52, and a communication unit 53 via an interface circuit.

The weighing unit 51 weighs the object to be weighed placed on the weighing device 5, for example, by a weight detection method using a load cell.
In detail, the weighing unit 51 is composed of a weight detection unit 511 and an AD converter 512 .
The weight detection unit 511 is realized by a load cell, and the AD converter 512 converts the analog signal input from the weight detection unit 511 into a digital signal. In the conversion to a digital signal, a range in which the weight value can be appropriately acquired is set, and the zero point and the maximum weighing value are recorded. The value converted into digital data is displayed on the display unit 52 as the weight (measured value).

In addition, instead of the above-mentioned method, the weighing unit 51 can adopt any suitable weighing configuration, such as a hanging scale.

The display unit 52 is a device that displays the weight of the item weighed by the weighing device 5, and is realized, for example, by an LCD screen or an 8-segment screen.

The communication unit 53 is realized by one or more communication means for realizing a connection with each terminal or device. For example, the interconnection with the information terminal 2 is realized by a wired or wireless LAN. The communication unit 53 transmits, for example, the weight of the item measured by the weighing unit 51 to the information terminal 2 or the data management device 3.
When the communication unit 53 is realized by a wired LAN, the power source of the weighing device 5 may be secured by power over Ethernet (PoE) supply from the information terminal 2 connected to an external power source. However, this does not prevent the weighing device 5 from being directly connected to an external power source or being powered by an internal battery.

Configuration of Data Management System 1 The data management system 1 mainly comprises an information terminal 2, a data management device 3, and an output device 4.
1, the data management system 1 can also be configured with an information terminal 2 and a data management device 3. Furthermore, the information terminal 2, the data management device 3, and the output device 4 are not limited to being configured as independent hardware components, and two or three of the information terminal 2, the data management device 3, and the output device 4 may be realized by a single hardware configuration. Furthermore, each of the information terminal 2, the data management device 3, and the output device 4 may be realized by multiple pieces of hardware.
The data management system 1 also communicates with the weighing device 5 to obtain the weight of the weighed item.

Overview of Information Terminal 2 The information terminal 2, for example, accepts input from a user and transmits and receives information to the data management device 3 or the weighing device 5. The information terminal 2 may be realized by, for example, a dedicated mobile terminal, a smartphone, a tablet terminal, or the like.

●Hardware configuration of information terminal 2 As shown in Figure 1, the information terminal 2 is equipped with an arithmetic unit such as a CPU (Central Processing Unit) for executing information processing, and memory devices such as a RAM (Random Access Memory) and a ROM (Read Only Memory), and is connected to a display unit 21, a communication unit 22 and a scanner 23 via an interface circuit.

The display unit 21 is realized by a touch panel display or the like, and displays various information such as the weighing results and sales price of the items. The display unit 21 can also accept various operations from the customer, and in this respect can be said to constitute an operation unit.

The communication unit 22 is realized by one or more communication means that realizes a connection with each terminal or device. For example, the interconnection with the data management device 3 and the interconnection with the weighing device 5 may be performed wirelessly or by wired connection.

The scanner 23 is a functional unit that optically reads various types of information, and reads one-dimensional or two-dimensional codes that encode specific information. This makes it possible to obtain the tare weight, for example, by reading a code that contains information about the tare. The scanner 23 may employ an appropriate code reading technology, such as a CCD system or a laser system, or may be a camera. In this case, the information terminal 2 may obtain the information contained in the code using an appropriate image recognition technology, or may perform character recognition using OCR technology or the like.

In addition, the information terminal 2 may also be equipped with a sound emitting unit or the like depending on the sales style of the product or appropriate specifications. The sound emitting unit outputs predetermined information by voice. That is, the sound emitting unit outputs, for example, voice guidance or the like, or outputs error sounds or operation sounds.

Figure 2 is a schematic front view showing an example of an information terminal 2 in this embodiment. The information terminal 2 mainly includes a display unit 21, a scanner start button 24, a group of physical keys 25, etc.

The scanner start buttons 24 are located on the left and right sides of the information terminal 2. When either or both of the scanner start buttons 24 are pressed, the scanner 23 is activated and scanning is performed.

The physical key group 25 includes, for example, a scan start button, multiple arrow keys, multiple function keys, a numeric keypad for accepting numeric or character input, a TAB key for switching input areas, and the like. A user can input the number of items that he or she has counted via the physical key group 25.

In addition, the display unit 21 displays a wireless communication start button 26 and a weighing start button 27 below the display area for the scanned or weighed information, etc. When the wireless communication start button 26 is selected, the information terminal 2 starts wireless communication with the weighing device 5 by the communication processing unit 203 described later. The display unit 21 may display the success or failure of pairing, etc. The weighing start button 27 drives the weighing device 5 with which communication has been established, and transmits a command to weigh the weight of the item to be weighed set in the weighing device 5. In addition, the weighing start button 27 may be configured to acquire the weighed weight when pressed. In this case, the weight may be acquired when an item is placed on the weighing start button 27 after pressing the weighing start button 27 and the weight is stabilized. In addition, the weighing start button 27 may be configured to acquire the weight when the weight value is stabilized when the weighing start button 27 is pressed with the item to be weighed placed on the weighing device 5.

Software Configuration of Information Terminal 2 As shown in FIG. 3, the information terminal 2 includes a read control unit 201, a display control unit 202, and a communication processing unit 203 as software resources.

The reading control unit 201 is a control unit that controls the scanner 23 to read information. The reading control unit 201 particularly reads the code on the container label 6. The reading control unit 201 also acquires the item identification information and container weight contained in the code. Alternatively, the reading control unit 201 may acquire the contents of the container label 6 by performing image recognition on an image captured by a camera.

The display control unit 202 is a functional unit that outputs information to the display unit 21 of the information terminal 2. The display control unit 202 displays, for example, information read from the container label 6 and the weight measured by the weighing device 5 on the display unit 21.

The communication processing unit 203 is a functional unit that communicates with the data management device 3 and the weighing device 5, etc., and transmits and receives information. The communication processing unit 203 may employ one-to-one communication, as well as communication using a network. For example, the communication processing unit 203 may use Bluetooth (registered trademark) to pair with the weighing device 5 and communicate. Note that the communication processing unit 203 may use wired communication instead of wireless communication when communicating with either or both of the data management device 3 and the weighing device 5.

● Software configuration of data management device 3 As shown in Figure 3, the data management device 3 has, as software resources, an item information storage unit 3A, an order information storage unit 3B, an inventory information storage unit 3C, an order information acquisition unit 301, a weight acquisition unit 302, a calculation processing unit 303, a code generation unit 304, an output control unit 305, and a communication processing unit 306.

The item information storage unit 3A is a storage unit that stores basic information about items that are the subject of arrival or inventory, such as the name and unit price of the item.
As shown in FIG. 4(a), data items stored in this item information storage unit 3A include, for example, item identification information, item name, measurement category, unit price, and unit weight.

The item identification information is, for example, a PLU code.

The metrology category is a category related to metrology.
The measurement category "0" is a measurement category corresponding to "measured products". A measured product is a product for which sales and inventory are performed based on weight. The sales price of a measured product is determined based on a preset unit price per unit weight ("100g" in this embodiment) and the weight (measurement value) to be sold. For a product in the measurement category "0 (measured product)", the unit price per unit weight may be stored in the unit price column, and the unit weight may be stored in the unit weight column. For example, for an item with item identification information "SH001" (item name "AAA"), it is stored that the unit price per 100g is 250 yen. Therefore, for an item with item name "AAA", for example, if the weighing value is 50g, the selling price will be 125 yen, and if the weighing value is 200g, the selling price will be 500 yen.

Measurement category "1" is the measurement category that corresponds to "countable products." Countable products are products that are sold and stocked based on the number of units. Products in measurement category "1 (countable products)" may have the unit price per unit stored in the unit price field.

The order information storage unit 3B is a storage unit that stores order information that associates at least item identification information with order weight.
4(b), data items stored in the order information storage unit 3B include, for example, item identification information, arrival date, and order weight. The information stored in the order information storage unit 3B is referenced in the process of issuing container labels 6, which will be described later.

The inventory information memory unit 3C is a memory unit that stores inventory information that associates at least item identification information with inventory weight.
As shown in FIG. 4(c), items stored in the inventory information storage unit 3C include, for example, item identification information, inventory date, and inventory weight.

In addition, the information stored in the item information storage unit 3A, the order information storage unit 3B, or the inventory information storage unit 3C may be received from a management device installed in the store or a cloud server located outside the store.

The order information acquisition unit 301 is a functional unit that acquires the item weight, which is the weight of only the received target item. More specifically, the order information acquisition unit 301 acquires the order information stored in the order information storage unit 3B. The order information acquisition unit 301 may acquire the order information, for example, from an appropriate external device that manages orders. The order information acquisition unit 301 may also be configured to receive order information input by a user via the information terminal 2. Furthermore, the order information acquisition unit 301 may be configured to accept input of order information from a user via an appropriate input unit included in the data management device 3. The order information acquired by the order information acquisition unit 301 may include information such as the ordered quantity and unit weight.
The order information acquiring unit 301 is an example of an item weight acquiring unit. In addition, since the order information includes the arrival date, the order information acquiring unit 301 is an example of an arrival date acquiring unit.

The weight acquisition unit 302 is a functional unit that acquires the weight measured by the weighing device 5. When the weighing device 5 weighs a target item placed in a tare, the weight acquisition unit 302 acquires the total weight of the target item, which is the sum of the item weight and the tare weight. In other words, the weight acquisition unit 302 is an example of a total weight acquisition means.

The calculation processing unit 303 is a functional unit that calculates the tare weight based on the measured total weight and the weight of the target item. The weight of the target item is, for example, the order weight included in the order information. The calculation processing unit 303 calculates the tare weight by subtracting the weight of the target item from the measured value. With this configuration, when the weight of the target item is known, the tare weight can be easily calculated based on that weight and the total weight.

The calculation processing unit 303 also calculates the item weight excluding the tare weight based on the measured total weight and tare weight. With this configuration, the item weight can be easily calculated from the total weight and tare weight. In particular, even in an operation in which the target item is stored in the same tare as when it was received and only the target item is taken out and sold, the item weight of the target item can be easily estimated by referring to the tare weight estimated in advance. In other words, there is no need to prepare an outer bag similar to the tare bag containing the item and perform tare subtraction in order to measure the item weight by tare subtraction. Therefore, inventory work can be easily performed even for items sold by weight that are managed in an outer bag.

The code generation unit 304 is a functional unit that generates a code including item identification information and tare weight information. The code is, for example, a one-dimensional barcode, but may also be a two-dimensional barcode or any other suitable pattern that allows information to be mechanically read.

The output control unit 305 is a functional unit that generates printing information related to the content to be printed on the container label 6, and outputs it to the output device 4. The printing information generated at this time includes at least information related to the tare weight of the item calculated by the calculation processing unit 303, as well as information on the name and identification information of the item stored in the item information storage unit 3A, and a code including the tare weight and item identification information.
The print information generated by the output control unit 305 is output to the output device 4. The output control unit 305 is an example of an output unit.

Figure 5 shows an example of a container label 6 printed by the output device 4. The container label 6 displays the item name, item identification information, container weight, arrival date, and one-dimensional barcode. The multi-digit sequence 60 represented by the one-dimensional barcode is, for example, a flag 61, a product code 62, a managed weight 63, and a check digit 64, listed in this order from the left. This barcode system is the same as the barcode system of the barcode issued when selling by weight, indicating the sales weight. In the container label 6, the managed weight 63 is the container weight. In the barcode indicating the sales weight, the managed weight 63 includes the sales weight of the product. With this configuration, the barcode system used at the time of sale can be reused to manage the tare weight, making it unnecessary to manage multiple barcode systems, and simplifying the system.

In addition, the managed weight 63 may be appropriate identification information linked to the weight, instead of a numerical value that directly indicates the weight. For example, if the tare weight and the tare number are managed in association with each other, the tare number may be displayed as the managed weight 63.

In addition, when the barcode indicating the tare weight and the barcode indicating the sales weight are represented using the same barcode system, the barcode may indicate information as to whether it is a barcode indicating a tare weight or a barcode indicating a sales weight. For example, this information may be displayed in the number on the left side of the managed weight 63. For example, the number may be "0" to indicate sales weight, and "1" to indicate tare weight. The information terminal 2 or the data management device 3 that has acquired the barcode information refers to the number to determine whether it is a barcode indicating a sales weight or a barcode indicating a tare weight.

In addition, when the barcode indicating the tare weight and the barcode indicating the sales weight are expressed by the same barcode system, the information terminal 2 may determine whether the read barcode indicates the tare weight or the sales weight based on the state of the information terminal 2. More specifically, when the information terminal 2 is in a state in which the terminal 2 is ready to accept input related to inventory work, the information terminal 2 may determine that the barcode indicates the tare weight. For example, the information terminal 2 may determine that the barcode read after the selection to perform inventory input on an appropriate menu screen (see FIG. 8(a)) is a barcode indicating the tare weight. In addition, when the information terminal 2 is in a state other than a state in which the terminal 2 is ready to accept input related to inventory work, the information terminal 2 may determine that the read barcode is a barcode indicating the sales weight.

The tare label 6 is a label for easily understanding the tare weight, particularly during inventory work, and does not display the weight of the item. The tare label 6 is attached to the tare by an appropriate method such as pasting, and is linked to the tare. According to a configuration for issuing tare labels 6 on which item identification information and tare weight are displayed, the item identification information and tare weight are clear at a glance, making inventory work easy to perform. Furthermore, if a code including the item identification information and tare weight is displayed on the tare label 6, the item identification information and tare weight can be obtained simply by mechanically reading the tare label 6, the tare weight calculation is automatically performed, and the item weight can be stored in correspondence with the item identification information, making inventory work even easier.

The communication processing unit 306 executes data transmission and reception with the print control unit 401 according to a predetermined communication protocol.
The communication processing unit 306 may further transmit and receive data to and from a higher-level device or the like via a wired or wireless LAN (Local Area Network), Bluetooth (registered trademark), or the like. Also, the communication processing unit 306 may transmit and receive data to and from an external server via a network such as the Internet.

Hardware configuration of output device 4 As shown in FIG. 1, the output device 4 includes a calculation unit such as a CPU (Central Processing Unit) for executing information processing, and a storage device such as a RAM (Random Access Memory) and a ROM (Read Only Memory), and is connected to a printing unit 41 and a communication unit 42 via an interface circuit.

The printing unit 41 is a mechanism that includes, for example, a thermal head and a platen roller, and issues labels while pulling out the label roll. The label roll is, for example, a long, strip-shaped backing on which labels are temporarily attached at regular intervals, and the label paper is wound into a roll. The label roll may also be a roll on which linerless labels without a backing are wound. Furthermore, the printing unit 41 may be realized by a thermal method using a thermal head, an inkjet method, or any other appropriate method.

The communication unit 42 is realized by one or more communication means for establishing a connection with each terminal or device. The output device 4 may be connected to the data management device 3 wirelessly or via a wired connection, for example.

In this embodiment, the output device 4 has been described as a printing device that prints a label, but the technical scope of the present invention is not limited to this, and may be any appropriate output mode for displaying the tare weight in a recognizable manner on the outer bag of the item. For example, the output device 4 may be an electronic shelf label that displays information generated by the output control unit 305. In this case, the output device 4 may not have a printing unit 41.

Software Configuration of Output Device 4 As shown in FIG. 2, the output device 4 includes a print control unit 401 and a communication processing unit 402 as software resources.
The output device 4 receives the print information generated by the output control unit 305 via the communication processing unit 402. The output device 4 also controls the print control unit 401 to print the print information on a predetermined medium and issue a container label 6.

The software resources possessed by the data management device 3 described above can be distributed or consolidated into any of the hardware resources by appropriate design, and the hardware resources can also be configured as physically integrated devices or separate devices.

Flow of Processing for Issuing Tare Label 6 The process for weighing received goods and issuing a tare label 6 in the data management system 1 according to this embodiment will be described with reference to FIG.

As shown in FIG. 6, for example, the information terminal 2 receives an instruction to specify item information of an incoming item for which a container label 6 is to be issued (S101). The item information includes at least the identification information and name of the incoming item. The item information may be specified by reading an appropriate code or character with the information terminal 2, or may be specified by the user. When specified by the user, a list of items that may be incoming items may be obtained from the data management device 3 or an appropriate external device, and a selection may be made.

Furthermore, when the information terminal 2 receives a weighing command, it transmits a command to the weighing device 5 to weigh the objects to be weighed (S102). The weighing device 5 weighs the objects to be weighed in response to the weighing command (S103). The objects to be weighed are items placed in an outer bag, and the weight of the objects to be weighed includes the weight of the incoming items and the tare weight. The weighing device 5 transmits the total weight of the objects to be weighed, including the tare weight, to the information terminal 2, which displays this (S104).
It should be noted that step S101 and steps S102 to S104 may be performed in any order, and step S101 may be performed, for example, after steps S102 to S4 or simultaneously therewith.

Next, the information terminal 2 transmits a label issuance command to the data management device 3 to issue a container label 6 (S105). The label issuance command may be transmitted in response to an input from the user, or may be transmitted when a weight value is received from the weighing device 5.

The data management device 3 acquires the order information (S106). The order information includes at least the identification information of the incoming goods and the order weight of the incoming goods. If the order information is stored in advance in the order information storage unit 3B, the order information may be acquired by referring to the order information storage unit 3B. In this case, the order information includes the arrival date and time and the order weight in association with each other, and the user may be able to select when to issue the tare label 6 for the incoming goods.
In step S106, information input to the information terminal 2 may be acquired as order information.

Next, the calculation processing unit 303 of the data management device 3 calculates the tare weight based on the measured total weight and the order weight (S107). More specifically, the calculation processing unit 303 calculates the tare weight by subtracting the order weight from the total weight.

Next, the code generation unit 304 generates a code including the identification information of the incoming item and the tare weight information (S108). The output control unit 305 also generates printing information for the tare label 6 (see FIG. 5) including the code and the text information of the item's identification information and the tare weight (S109). This printing information is sent to the output device 4. The output device 4 prints the tare label 6 based on the received printing information (S110).

The above series of processes allows the tare weight to be estimated based on the order weight of the ordered items and the total weight including the tare weight. In addition, by printing the estimated tare weight on a label and issuing it, the label can be referred to during inventory, making it easy to carry out inventory work that takes the tare weight into consideration.

Flow of Inventory Processing Here, the process of calculating the weight of the items to be inventoryed, that is, the inventory items, will be described.
7, first, the information terminal 2 reads the container label 6 (S201). In particular, the information terminal 2 reads the code printed on the container label 6 using the scanner 23 to obtain the identification information and container weight of the inventory item. Additionally, the information terminal 2 displays the identification information, item name, and container weight of the inventory item on the display unit 21 of the information terminal 2.

Next, the information terminal 2 transmits a weighing command to the weighing device 5 (S202). Steps S201 and S202 are processes that are executed in response to input from the user, and may be executed in any order. Also, step S202 may be configured to be executed automatically when the tare label 6 is read.

In response to receiving a weighing command, the weighing device 5 weighs the total weight of the inventory items, including the bag (S203). The inventory items are weighed in the same outer bag as when they were received. At this time, the total weight may be displayed on the display unit 52 of the weighing device 5. The information terminal 2 receives the total weight from the weighing device 5 and displays it on the display unit 21 (S204).

When an inventory registration command is sent from the information terminal 2 to the data management device 3 (S205), the weight acquisition unit 302 of the data management device 3 receives the total weight. The calculation processing unit 303 of the data management device 3 subtracts the tare weight read from the tare label 6 from the total weight to calculate the weight of the inventory items only (S206). The weight of the inventory items is sent to the information terminal 2 and displayed on the display unit 21 of the information terminal 2 (S207). The weight of the inventory items is also stored in the inventory information storage unit 3C of the data management device 3 (S208).

According to the above-mentioned series of processes, the item identification information and tare weight of the inventory item can be obtained by reading the tare label 6. Therefore, by measuring the total weight with the weighing device 5, the item weight minus the tare weight can be stored in association with the item identification information. In other words, the inventory work can be performed easily.
The above process is also useful for cases where products are placed in a different container from when they arrived and then removed from the container for sale. For example, a container label 6 is printed on the container and the inventory amount can be easily obtained by reading the container label 6.

Screen Examples Examples of screens displayed on the display unit 21 of the information terminal 2 during inventory work will be described using Figures 8(a)-(d) and 9(a)-(b). Note that in each figure, the explanation will focus on the parts that are different from other screens, and the reference numerals and explanations for similar parts will be omitted as appropriate.
8(a) to (d) show examples of screens when inventorying weighed items.
8A is an example of a menu screen for selecting a menu to be performed on the information terminal 2. For example, the screen G1 is displayed when the user logs in to the information terminal 2. The screen G1 displays a product number search button G11 and an individual item inventory input button G12. When the individual item inventory input button G12 is selected, the screen transitions to screen G2.

The screen G2 shown in FIG. 8(b) mainly displays the store information column G21 where the inventory is registered, the inventory date column G22, the addition/overwrite selection column G23, the inventory item identification information column G24, the total weight column G25, the tare weight column G26, the inventory item weight column G27, the updated quantity column G28, the theoretical stock quantity column G29, the inventory difference column G30, etc.

The Add/Overwrite selection field G23 is a field that accepts the alternative selection of Add or Overwrite regarding the handling of the weighed weight. If "Add" is selected, the weight to be weighed this time is added to the weight weighed previously and displayed in the updated quantity field G28. In other words, when inventorying items stored in multiple bags, it is necessary to add the weighing results of the multiple bags and compare them with the theoretical inventory, so "Add" is selected. If "Overwrite" is selected, the weight to be weighed this time is displayed in the updated quantity field G28. In other words, when redoing a weighing, it is necessary to overwrite the previous weighing result, so "Overwrite" should be selected.

The inventory item identification information field G24 displays the item identification information read from the tare label 6. The total weight field G25 is a field where the weight measured by the weighing device 5 is displayed, and displays the total weight including the tare weight and the weight of the inventory items. The tare weight field G26 displays the tare weight read from the tare label 6. The inventory item weight field G27 displays the value obtained by subtracting the tare weight from the total weight, i.e., the item weight of the inventory items. The updated quantity field G28 displays the item weight of the inventory items depending on the selection made in the addition/overwrite selection field G23.

Theoretical stock quantity field G29 is a field that displays the theoretical stock quantity or theoretical stock weight calculated based on the order weight and the identified reduction. Reductions in theoretical stock quantity or theoretical stock weight occur due to, for example, sales, transfers, disposals, and other circumstances. The inventory difference field G30 is a field that displays the difference between the value in the updated quantity field G28 and the value in the theoretical stock quantity field G29, and displays the difference between the theoretical stock and the actual stock.

In the screen G2, the identification information field G24 is shaded. This display indicates to the user that it is necessary to determine the identification information of the inventory item while the screen G2 is being displayed, and in particular urges the user to read the container label 6.
When the container label 6 is read while the screen G2 is displayed, the screen transitions to the screen G3 shown in FIG. 8(c).

The identification information field G24 of screen G3 shown in FIG. 8(c) displays the identification information of the item read from the tare label 6. The item name field G31 displays the item name linked to the identification information. The tare weight field G26 displays the tare weight read from the tare label 6. The theoretical stock quantity field G29 displays the weight of the theoretical stock. The inventory difference field G30 displays the difference between the theoretical stock and the actual stock. Since weighing has not yet been performed on screen G3, the total weight field G25, inventory item weight field G27, and updated quantity field G28 are blank, and the inventory difference obtained by subtracting the theoretical stock from the updated quantity is negative.

In the screen G3, the total weight field G25 is shaded. This display indicates to the user that it is necessary to obtain the weight while the screen G3 is being displayed, and in particular urges the user to use the weighing device 5 to weigh the item.
When a weighing value is acquired while screen G3 is being displayed, the screen transitions to screen G4 of FIG. 8(d).

In screen G4 shown in FIG. 8(d), the total weight field G25 displays the measured value, i.e., the total weight. In addition, the inventory item weight field G27 displays the total weight minus the tare weight. The value in the updated quantity field G28 is the same as the value in the inventory item weight field G27. The inventory difference field G30 displays the updated quantity minus the theoretical stock. By selecting the appropriate "Update" button displayed on screen G4, the values displayed on screen G4 are stored in the inventory information storage unit 3C.

Screen G5 shown in FIG. 9(a) shows an example of the screen when "Add" is selected in the Add/Overwrite selection field G23. When tare labels 6 associated with the same item are read consecutively, screen G5 displays the updated quantity value obtained by the most recent weighing in the current inventory quantity field G51. The updated quantity field G28 displays the sum of the value in the current inventory quantity field G51 and the value in the inventory item weight field G27.

Screen G6 shown in FIG. 9(b) is an example of a screen when the item linked to the read tare label 6 is a counted item. In screen G6, a quantity column G61 is displayed instead of the total weight column G25, tare weight column G26, and inventory item weight column G27. In this case, the user counts the number of inventory items and inputs the number from the physical key group 25 of the information terminal 2. The numerical value input from the physical key group 25 of the information terminal 2 is displayed in the quantity column G61.

In addition, when inventorying the items to be counted, instead of having the user count them, the items may be weighed and the number of items may be estimated based on the unit weight of the items to be counted. In this case, the calculation processing unit 303 can estimate the number of items to be counted by subtracting the tare weight from the total weight and dividing the result by the unit weight.

Overview of the embodiment The present invention relates to a data management system and a data management method.

Due to the problem of food waste, there is a growing trend to encourage sales by weight, whereby customers purchase only the amount they need. As a result, there is a need for technology to easily manage inventory of items sold by weight.
In this regard, as disclosed in Patent Document 1 (JP 2017-021670 A), a foodstuff management device is known that calculates the expiration date of foodstuffs and issues a medium on which the expiration date is printed.

One of the objectives of the present invention is to provide a data management system that supports inventory management of bulk items.

To achieve the above object, the data management system according to the present invention is characterized by comprising a total weight acquisition means for acquiring the total weight of the target item including the tare, an item weight acquisition means for acquiring the item weight which is the weight of only the target item, a calculation processing means for calculating the tare weight based on the total weight and the item weight, and an output means for outputting the tare weight.

The item weight acquisition means may acquire the item weight included in the order information for the target item.

The output means outputs printing information for the container label to a printing device, and the container label may display a code including identification information for the target item and the container weight.

The device may further include an arrival date acquisition means for acquiring the arrival date of the target item, and the arrival date may be displayed on the container label.

The device may further include a read control means for acquiring the identification information and the tare weight by reading the tare label, and when the total weight acquisition means acquires the total weight of the second item including the tare weight, the calculation processing means may calculate the weight of only the second item based on the total weight and the tare weight of the second item.

To achieve the above object, the data management method of the present invention executes a total weight acquisition process to acquire the total weight of a first item including a tare, an identification information acquisition process to acquire identification information of the first item, an item weight acquisition process to acquire an item weight that is the weight of only the first item, a calculation process to calculate a tare weight based on the total weight and the item weight, an output process to output the identification information and the tare weight as a tare label, a reading process to acquire the identification information and the tare weight by reading the tare label, a process to acquire the total weight of a second item including the tare, and a process to calculate the weight of only the second item based on the total weight and the tare weight of the second item.

The data management system according to the embodiment of the present invention described above can assist in inventory management of items sold by weight.

1 Data management system 2 Information terminal 201 Reading control unit (reading control means)
3 Data management device 301 Order information acquisition unit (item weight acquisition means, arrival date acquisition means)
302 Weight acquisition unit (total weight acquisition means)
303 Calculation processing unit (calculation processing means)
304 Code generation unit 305 Output control unit (output means)
306 Communication processing unit 4 Output device (printing device)
5. Measuring device

Claims (6)

A total weight acquisition means for acquiring a total weight of the target object including the container;
An item weight acquisition means for acquiring an item weight, which is the weight of only the target item;
A calculation processing means for calculating a tare weight based on the total weight and the item weight;
an output means for outputting the tare weight;
A data management system comprising:
The item weight acquisition means acquires the item weight included in the order information of the target item.
The data management system according to claim 1.
The output means outputs printing information for the container label to a printing device,
A code including identification information of the target item and the tare weight is displayed on the container label.
3. The data management system according to claim 1 or 2.
The system further includes a delivery date acquisition means for acquiring the delivery date of the target item,
The arrival date is displayed on the tare label.
The data management system according to claim 3.
a read control means for reading the container label to obtain the identification information and the container weight,
When the total weight acquisition means acquires the total weight of the second item including the container, the calculation processing means calculates the weight of only the second item based on the total weight of the second item and the container weight.
The data management system according to claim 3.
a total weight acquisition process for acquiring a total weight of the first item including the container;
An identification information acquisition process for acquiring identification information of the first item;
An item weight acquisition process for acquiring an item weight which is the weight of only the first item;
A calculation process for calculating a tare weight based on the total weight and the item weight;
an output process of outputting the identification information and the tare weight as a tare label;
a reading process for acquiring the identification information and the tare weight by reading the tare label;
obtaining a total weight of the second item including the container;
calculating a weight of only the second item based on the total weight and the tare weight of the second item;
A data management method that performs the above.

Images