Alcohol information management system and management method
An integrated management system using sales performance data from distributors manages brands across multiple distribution channels, addressing complex inventory management by centralizing data and enabling easy registration and display of alcoholic beverage brands without local installations.
Patent Information
- Application Number
- JP2023175781
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2023-10-11
- Publication Date
- 2025-01-17
- Estimated Expiration
- 2038-07-31
AI Technical Summary
Existing systems for managing inventory and product information require installation at each store or seller, leading to complex management, especially for alcoholic beverages, as described in Japanese Patent Application Publications 2003-16351 and 2003-85422.
An integrated management system utilizing sales performance information from distributors to manage brands across multiple distribution companies, allowing centralized management without installing systems at each store, using image recognition and data analysis to identify and display brand information on user terminals.
Enables efficient management of a wide range of products and brands across various distribution channels, providing users with comprehensive information on availability and popularity without the need for local inventory systems, facilitating easy registration and display of consumed and desired brands.
Smart Images

Figure 0007616708000001 
Figure 0007616708000002 
Figure 0007616708000003
Abstract
Description
[Technical field]
[0001] The present invention relates to an information management system and a management method for alcoholic beverages. [Background technology]
[0002] As a background technique of this technical field, there is Japanese Patent Laid-Open Publication No. 2003-16351 (Patent Document 1). This publication states, "We provide a product purchase support system that can guide users to stores where they can purchase their desired products. A product information management server 10 keeps track of stock availability and the like based on product management information transmitted from a store server 50 prepared for each store. When a navigation device 20 receives product identification information to be searched for from a user, the product identification information is transmitted to the product information management server 10, which then transmits store information relating to stores where the product can be purchased to the navigation device 20. The navigation device 20 can display the location of the store on a map, so that the user can know the location of the store where the product can be purchased. If necessary, route guidance to the store can also be provided. This eliminates the inconvenience of going all the way to a store only to be unable to purchase the product because it is out of stock."
[0003] Also, there is JP 2003-85422 A (Patent Document 2). This publication states, "We provide a product inventory confirmation system and a product inventory confirmation method that allow a user to instantly obtain information on the current stock of a specific product that the user wants to purchase and in which store, and to reliably purchase the specific product at a desired retailer. In a communication system 100 in which a business entity 2, whose business is to provide users with stock information on specific products at specific retailers, and a user 4 who wishes to receive stock information from the business entity 2, are arranged so as to be mutually connectable via a communication line 5, the business entity 2 creates a product-specific stock information database 8 based on stock information on specific products received in real time from multiple retailers 6, and in response to a request from the user 4, provides the user 4 with the retailer-specific stock information on the specified product." [Prior art documents] [Patent documents]
[0004] [Patent Document 1] JP 2003-16351 A [Patent Document 2] JP 2003-85422 A Summary of the Invention [Problem to be solved by the invention]
[0005] The above-mentioned Patent Document 1 describes a product purchase support system that receives product management information from a store server prepared for each store and performs inventory management. However, the product purchase support system of Patent Document 1 requires that a server be installed in each of the vast number of stores for inventory management, which makes management cumbersome.
[0006] Patent Document 2 describes a product inventory status confirmation system that creates a product inventory information database based on inventory information received from multiple sellers and provides the user with seller-specific inventory information for a specific product. However, even with the product inventory status confirmation system of Patent Document 2, it is necessary to install the system at each of the vast number of sellers for inventory management, which makes management cumbersome.
[0007] Therefore, the present invention provides a product management system and method that utilizes sales performance information of distributors who wholesale products to restaurants and retail stores. For example, it provides a mechanism for managing brands of alcoholic beverages sold in restaurants, izakayas, and liquor stores. [Means for solving the problem]
[0008] In order to solve the above problems, for example, the configurations described in the claims are adopted. The present application includes multiple means for solving the above-mentioned problems, and one example is an information management system in which an integrated management server has a data formatting means for receiving sales performance information from multiple distribution company terminals of multiple distribution companies that sell products to a store, a data matching means for updating brand master information for commonly managing alcoholic beverage brands sold to the store for the multiple distribution companies based on the received sales performance information, and a brand determination means for, when image-related information is received from a user terminal, analyzing the received image-related information and comparing it with characteristic information corresponding to the alcoholic beverage brand registered in the brand master information to identify the alcoholic beverage brand and transmitting information related to the identified alcoholic beverage brand to the user terminal, and the user terminal has a display means for displaying the transmitted information related to the alcoholic beverage brand. Effect of the Invention
[0009] According to the present invention, it is possible to provide management of a wide range of products based on sales performance information of distributors who wholesale products to restaurants and retail stores. As another example, it is possible to manage information on brands handled by restaurants and retail stores based on sales performance information of distributors without introducing an inventory management system to each of the vast number of restaurants and retail stores. As another example, it is possible to provide users with information on a wide range of products and alcohol brands using information from distributors. Problems, configurations and effects other than those described above will become apparent from the following description of the embodiments. [Brief description of the drawings]
[0010] [Figure 1] 1 is an example of a configuration diagram of an entire management system 1. [Diagram 2] 2 is an example of a hardware configuration of an integrated management server 101. [Diagram 3] 2 is an example of a hardware configuration of a user terminal 103. [Figure 4] 2 is an example of a hardware configuration of a distribution company terminal 102. [Diagram 5]2 is an example of a hardware configuration of a store terminal 104. [Figure 6] 2 is an example of a hardware configuration of a manufacturer terminal 105. [Figure 7] 7 is an example of a user master table 700. [Figure 8] 8 is an example of a stock master table 800. [Figure 9] 9 is an example of a store master table 900. [Figure 10] 1 is an example of a user-registered brand table 1000. [Figure 11] 11 is an example of a store-specific handled brand table 1100. [Figure 12] 12 is an example of a brand analysis table 1200. [Figure 13] 13 is an example of a distribution company product table 1300. [Figure 14] 14 is an example of a distribution company store table 1400. [Figure 15] 15 is an example of a distribution company person in charge table 1500. [Figure 16] 16 is an example of a distribution company sales performance table 1600. [Figure 17] 17 is an example of a brand master linking table 1700. [Figure 18] 18 is an example of a store master linking table 1800. [Figure 19] 13 is an example of a data formatting process flow. [Figure 20] 16 is an example of a data matching process flow for a distribution company sales performance table 1600. [Figure 21] 1 is an example of a data analysis process flow. [Figure 22] 13 is an example of a brand registration processing flow. [Figure 23] 13 is an example of a brand determination process flow. [Figure 24] 13 is an example of a brand analysis process flow. [Diagram 25] 13 is an example of a brand scan process flow. [Figure 26] 26 is an example of a registration list screen 2600. [Figure 27] 27 is an example of another display 2700 of the registration list screen. [Figure 28] This is an example of a screen that displays on a map stores where you can drink a selected brand of alcohol. [Figure 29] 13 is an example of a brand registration screen. [Diagram 30] 13 is an example of a screen displaying additional information of a stock in the stock registration process. [Diagram 31] 13 is an example of a stock scan screen. [Diagram 32] 13 is another display example of the stock scan screen. [Diagram 33] 13 is another display example of the stock scan screen. [Diagram 34] FIG. 12 is a diagram for explaining how popularity is determined in the brand analysis table 1200. [Diagram 35] 12 is a diagram for explaining the determination of rarity in the brand analysis table 1200. FIG. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0011] In recent years, apps (applications) that allow users to register and manage the brands of alcohol they have drunk have become popular. However, these apps only support specific categories of alcohol, such as an app for wine, an app for sake, and an app for whiskey, and do not allow users to register brands across categories. This means that users who drink a wide range of alcohol categories, such as those who drink both wine and sake, have to launch and manage a different app for each category, which is inconvenient. In addition, while these apps allow users to register brands of drinks that they have actually drunk, they are unable to easily register or check information about brands that users want to drink.
[0012] Therefore, in this embodiment, the user can easily register brands of alcohol that they have drunk or would like to drink, regardless of the category of alcohol, and information about alcohol brands that have been registered as brands that they have drunk or would like to drink can be displayed in a variety of ways. For example, it is possible to scan and display brands of beer you have drunk or would like to drink, and also to display on a map or in a list stores where you can drink the brand you would like to drink.
[0013] Hereinafter, the embodiments will be described with reference to the drawings. FIG. 1 is a diagram showing an example of a configuration of an entire management system 1. As shown in FIG. The management system 1 comprises a plurality of distributor terminals 102, a plurality of user terminals 103, a plurality of store terminals 104, a plurality of manufacturer terminals 105, and a plurality of other trader terminals 106, each of which is connected to an integrated management server 101 via a network. Note that the network may be wired or wireless, and each terminal can transmit and receive information via the network.
[0014] Each terminal of the management system 1 and the integrated management server 101 may be, for example, a mobile terminal such as a smartphone, tablet, mobile phone, or personal digital assistant (PDA), or a wearable terminal such as glasses, wristwatch, or clothing. They may also be stationary or mobile computers, or servers located on the cloud or network. Or they may be a combination of multiple terminals. For example, a combination of one smartphone and one wearable terminal may function logically as one terminal. They may also be other information processing terminals.
[0015] The distribution company terminal 102 is a terminal provided, for example, by each of distribution companies P, Q, and R. The distribution companies wholesale products such as alcoholic beverages to restaurants, retail stores, and other stores, and each company manages the stores where the products are sold, the products sold, and the sales results. In this specification, the management of alcoholic beverages is described in particular, but the products are not limited to alcoholic beverages, and the invention can be implemented in a similar configuration for food, ingredients, and the like. When implementing the present invention with products other than alcoholic beverages, identifying the brand of alcoholic beverages means identifying the type and contents of the product.
[0016] The user terminal 103 is a device owned or used by a user who purchases products such as alcoholic beverages from restaurants and retail stores. It registers and manages product information such as alcoholic beverages that the user has "drank" or "wants to drink." When implementing the present invention with products other than alcoholic beverages, the user will register and manage information on what they have "drank / eaten / purchased" and what they "wants to drink / eat / want to buy / want."
[0017] The store terminal 104 is a terminal provided by restaurants, retail stores, etc., which are the sales destinations of the distributor's products. The manufacturer terminal 105 is a terminal provided by a manufacturer company that produces and sells the products. The other trader terminal 106 is a terminal provided by a trader involved in the distribution process from the production of alcoholic beverages and other products to their sale to restaurants and retail stores.
[0018] The integrated management server 101 receives information on sales stores, products sold, and sales results from multiple distribution company terminals 102, formats the information into a common format, and manages it. It also receives image-related information on products such as alcoholic beverages from a user terminal 103, identifies the product name, etc., and transmits it to the user terminal 103 together with product-related information.
[0019] Each terminal and the integrated management server 101 of the management system 1 includes a processor that executes an operating system, applications, programs, etc., a main storage device such as a RAM (Random Access Memory), an auxiliary storage device such as an IC card, a hard disk drive, an SSD (Solid State Drive), a flash memory, etc., a communication control unit such as a network card, a wireless communication module, a mobile communication module, etc., input devices such as a touch panel, a keyboard, a mouse, voice input, and input by motion detection by imaging of a camera unit, and an output device such as a monitor or a display. Note that the output device may be a device or terminal that transmits information to be output to an external monitor, display, printer, device, etc.
[0020] The main memory stores various programs, applications, etc. (modules), and the processor executes these programs and applications to realize each functional element of the integrated management system 1. Note that each of these modules may be implemented in hardware by integration or the like. Also, each module may be an independent program or application, or may be implemented in the form of a subprogram or function within one integrated program or application. In this specification, each module is described as an entity (subject) that performs processing, but in reality, a processor that processes various programs, applications, etc. (modules) executes the processing.
[0021] Various databases (DB) are stored in the auxiliary storage device. A "database" is a functional element (storage unit) that stores a data set so that it can handle any data operation (e.g., extraction, addition, deletion, overwriting, etc.) from a processor or an external computer. There are no limitations on the method of implementing the database, and it may be, for example, a database management system or a text file such as XML.
[0022] FIG. 2 shows an example of the hardware configuration of the integrated management server 101. As shown in FIG. The integrated management server 101 is configured, for example, by a server placed on a cloud. The main memory device 201 stores programs and applications such as a data formatting module 211, a data matching module 212, a user data management module 213, a stock determination module 214, and a data analysis module 215, and each functional element of the integrated management server 101 is realized by the processor 203 executing these programs and applications.
[0023] The data shaping module 211 stores product information, store information, sales performance information, etc. received from each distribution company terminal 102 in a distribution company data reception DB 224. In addition, the data shaping module 211 shapes the information received from each distribution company terminal 102 into a common unified format and stores it in a distribution company data shaping DB 223.
[0024] The data matching module 212 matches the information stored in the distribution company data shaping DB 223 with the information in the cross-company master DB 222. If there is corresponding product information and store information in the brand master table 800 and store master table 900 of the cross-company master DB 222, the master ID is stored in the table of the distribution company data shaping DB 223. On the other hand, if there is no corresponding information in the cross-company master DB 222, a new record is added to the cross-company master DB 222 based on the information in the distribution company data format DB 223.
[0025] The user data management module 213 stores and manages user information, information on brands "drank" and "want to drink," and the like, received from the user terminal 103 in a registered brand table 1000 for each user. The brand determination module 214 determines the brand of alcoholic beverage depicted in the image based on the image or information about the image received from the user terminal 103. The data analysis module 215 analyzes the information stored in the cross-company master DB 222 and the distributor data formatting DB 223 to generate information useful to users, distributors, etc., and provides it to the user terminal 103, distributor terminal 102, etc.
[0026] The auxiliary storage device 202 includes databases such as an analysis data DB 221, a cross-company master DB 222, a distributor data formatting DB 223, a distributor data receipt DB 224, and the like. The distributor data reception DB 224 receives product information from multiple distributor terminals 102. The distribution company data formatting DB 223 stores product information, store information, sales performance information, etc. received from each distribution company terminal 102, formatted into a common unified format.
[0027] The cross-company master DB 222 stores master information on product information, store information, and user information managed by the integrated management server 101 . The product information, store information, and sales performance information received from the distributor terminal 102 has different formats, IDs, and key information depending on the distributor, so the information from multiple distributor terminals 102 cannot normally be compared, processed, or analyzed across distributors in its current state. In this embodiment, the format of this information is reformatted by the processing of the data reformatting module 211, and the information is saved in a common format in the cross-company master DB 222, making it possible to collectively process, analyze, and use sales performance information, etc. from multiple distributors. The analysis data DB 221 stores information obtained by analyzing information in a cross-company master DB 222 and a distribution company data format DB 223 .
[0028] FIG. 3 shows an example of the hardware configuration of the user terminal 103. The user terminal 103 is a terminal used by a user who purchases products such as alcoholic beverages from restaurants and retail stores. The main memory device 301 stores programs and applications such as a stock registration module 311, a stock scanning module 312, and a list display module 313, and each functional element of the user terminal 103 is realized by the processor 303 executing these programs and applications.
[0029] These modules are incorporated as sub-modules into a single "alcohol information management app," and users can use the functions of each of these modules by installing the alcohol information management app on their smartphones or other devices.
[0030] The brand registration module 311 registers brands that users "want to drink" or "have drunk," as well as comments. The brand scanning module 312 processes the image information acquired by the camera unit 307, and in cooperation with the brand determination module 214 of the integrated management server 101, displays information about the alcoholic beverage by superimposing it on the captured image. For example, the display may be performed using an AR (Augmented Reality) function. The list display module 313 displays brand information registered by the user, recommended information sent from the integrated management server 101, and the like.
[0031] User terminal data 321 is stored in the auxiliary storage device 302, and includes brands that users "want to drink" or "have drunk," comments, ratings, and the like.
[0032] FIG. 4 shows an example of the hardware configuration of the distribution company terminal 102. As shown in FIG. The distribution company terminal 102 is a terminal used by a distribution company that wholesales products such as alcoholic beverages to restaurants and retail stores. The main memory device 401 stores programs and applications such as a sales performance management module 411, a product management module 412, a customer store management module 413, and an integrated management server linkage module 414. The processor 403 executes these programs and applications to realize each functional element of the distribution company terminal 102.
[0033] The sales performance management module 411 registers and manages the sales performance of the distribution company in the sales performance data 421 . The product management module 412 registers and manages the product names and alcohol brand names of products sold and managed by a distribution company in a distribution company master 422. Note that this master DB is not essential, and a configuration may be adopted in which all information about products and stores is written and managed in the sales performance data. The customer store management module 413 registers and manages, in the distributor master 422, information on customers to whom the distributor sells products and alcoholic beverages.
[0034] The integrated management server cooperation module 414 transmits the sales performance data 421 and the product information and customer store information of the distributor master 422 stored in the auxiliary storage device 402 to the integrated management server 101 periodically or whenever the information is updated. It may also be transmitted at any other timing. Also, instead of using an application, the integrated management server may simply be accessed via a Web browser to cooperate with the integrated management server, and information may be sent using the functions of the Web browser.
[0035] The auxiliary storage device 402 stores a distributor master 422 that stores sales performance data 421 of distributors, product information, customer store information, etc. This information is basically managed by a format, ID information, and key information that differ for each distributor such as Company P, Company Q, and Company R in FIG.
[0036] Sales performance information, which is a record of sales to customer stores of a distribution company, includes product information on what was sold and customer store information on who it was sold to, but this product information and store information may be directly recorded in the sales performance information, or the product information and store information may be managed separately as other master data and associated with the sales performance information using ID information or the like. The example in Fig. 4 is an example in which sales performance is managed in sales performance data 421, and the master data on these products and stores is managed in a separate distribution company master data 422. All may be managed as a single piece of information in the distribution company master data 421.
[0037] Therefore, in this specification, "sales performance information" is described as including not only sales performance information, which is a record of sales, but also the accompanying master information, "product information" and "store information." However, depending on the context, it may be described separately as product information, store information, and sales performance information. Even in this case, when referring to "sales performance information," it may include or include product information and store information.
[0038] FIG. 5 shows an example of the hardware configuration of the shop terminal 104. The store terminal 104 is a terminal used in stores, such as restaurants and retail stores, that purchase alcoholic beverages and other merchandise from distribution companies and sell them to users. The main memory device 501 stores programs and applications such as an inventory management module 511, a product management module 512, and an integrated management server collaboration module 513, and each functional element of the store terminal 104 is realized by the processor 503 executing these programs and applications.
[0039] The inventory management module 511 registers and manages inventory and sales information of products and alcoholic beverages sold by store enterprises such as restaurants and retail stores in inventory data 521. The product management module 512 registers and manages the product names and alcohol brand names of products sold by store businesses in product data 522.
[0040] The integrated management server cooperation module 513 transmits the inventory data 521 and product data 522 stored in the auxiliary storage device 502 to the integrated management server 101 periodically or whenever the information is updated.
[0041] If the inventory data 521 is updated and the product is out of stock, the integrated management server linkage module 513 can link with the integrated management server 101 to rewrite the stock-out risk in the store-by-store handled stock table 1100 in the analysis database to the latest information, such as "stock out of stock confirmed." Furthermore, the integrated management server cooperation module 513 outputs stock information, analysis information, and the like sent from the integrated management server 101. Instead of being in the form of an application, the integrated management server may be accessed simply via a Web browser to cooperate with the integrated management server, thereby transmitting and receiving information using the functions of the Web browser. The auxiliary storage device stores inventory data for restaurants and retail stores.
[0042] FIG. 6 shows an example of the hardware configuration of the manufacturer terminal 105. The manufacturer terminal 105 is a terminal used by a company that manufactures and sells products such as alcoholic beverages. The main memory device 601 stores programs and applications such as an inventory management module 611, a product management module 612, and an integrated management server collaboration module 613, and each functional element of the manufacturer terminal 105 is realized by the processor 603 executing these programs and applications.
[0043] The inventory management module 611 registers and manages inventory and sales information of the products and alcoholic beverages produced and sold by the manufacturer in inventory data 621. The product management module 612 registers and manages the names of products and alcoholic beverage brands produced and sold by manufacturing companies in product data 622 .
[0044] The integrated management server cooperation module 613 transmits the product data 622 stored in the auxiliary storage device 602 to the integrated management server 101 periodically or whenever the information is updated. It may also be configured to transmit at any other timing. Also, instead of using an application, the integrated management server may simply be accessed via a Web browser to cooperate with the integrated management server, and information may be sent using the functions of the Web browser.
[0045] If the contents of the brand master table 800 managed by the integrated management server 101 are inaccurate or need to be updated, the integrated management server linkage module 613 can work with the integrated management server 101 to rewrite the contents of the brand master table 800. The auxiliary storage device 602 stores, as product data 622, names of products and alcohol brands produced and sold by manufacturing companies, as well as information and images related to the products and brands.
[0046] Although not shown, the vendor terminal 106 has the same hardware configuration as the manufacturer terminal 105 . The other trader terminal 106 is a terminal used by a company involved in the distribution of products such as alcoholic beverages. The main memory device stores programs and applications such as an inventory management module, a product management module, and an integrated management server linkage module, and the processor executes these programs and applications to realize each of the functional elements of the vendor terminal 106.
[0047] 7 to 9 are examples of various tables stored in the cross-company master DB 222 of the auxiliary storage device 202 of the integrated management server 101. FIG. FIG. 7 is an example of a user master table 700. The user master table 700 stores information about the users who use the user terminals 103 . The user master table 700 includes information such as a master user ID 701 that is used uniformly throughout the management system, as well as a user name 702, nationality 703, gender 704, and date of birth 705. In addition to the above, the table may also store a login password for each user to use an application on the user terminal 103, address information, and payment information such as credit card information.
[0048] FIG. 8 is an example of a brand master table 800 stored in the cross-company master DB 222. As shown in FIG. The brand master table 800 is a table for managing brands of alcoholic beverages and related information managed by the management system 1. Note that Fig. 8 shows an example of alcoholic beverages, but this is not limiting and the table can be implemented with other beverages, foods, etc. The brand master table 800 stores a master brand ID 801 that is used uniformly throughout the management system, as well as other related information such as brand name 802, category 803, parent brand name 804, brand name 805, manufacturer 806, country of origin 807, region 808, storehouse / brewery 809, ingredients 810, label image 811, and characteristic information 812.
[0049] The characteristic information 812 is characteristic information extracted from the image of each brand, and may be, for example, the shape and color of the bottle, the shape and color of the label, the content, shape and color of the logo or text written on the label, or coordinate information or position information extracted from such information of characteristic points, numerical information or data extracted by processing all or part of such information with a specific algorithm, etc. However, it is not limited to these, and any information that can be used for comparison when identifying the brand of alcoholic beverage may be used.
[0050] Information in the brand master table 800 is added and updated by the data matching module 212 of the integrated management server 101 based on product information and sales performance information received from the distributor terminal 102, but the distributor terminal 102 may itself perform the updates via the integrated management server cooperation module of the distributor terminal 102. Also, the manufacturer terminal 105 may itself perform the updates via the integrated management server cooperation module 613 of the manufacturer terminal 105.
[0051] FIG. 9 is an example of a store master table 900 stored in the cross-company master DB 222 . The store master table 900 is a table for managing store information such as restaurants and retail stores managed by the management system 1 and related information thereof. The store master table 900 stores a master store ID 901 that is used uniformly throughout the management system, as well as related information such as a category 902, a store name 903, a business type 904, an address 905, a location 906, and a telephone number 907.
[0052] Category 902 indicates whether the store is a restaurant or a retail store. Business type 904 indicates the type of store, such as a restaurant. Location 906 indicates information for identifying the location of the store on a map, such as latitude and longitude.
[0053] Information in the store master table 900 is added or updated by the data matching module 212 of the integrated management server 101 based on store information and sales performance information received from the distribution company terminal 102, but the distribution company terminal 102 may itself perform the updates via the integrated management server linkage module 414 of the distribution company terminal 102. Also, the store terminal 104 may itself perform the updates via the integrated management server linkage module 513 of the store terminal 104.
[0054] 10 to 12 are examples of various tables stored in the analysis data DB 221 of the auxiliary storage device 202 of the integrated management server 101. FIG. FIG. 10 is an example of a user-registered brand table 1000. The user-registered brand table 1000 is a table for managing information on "want to drink" or "has drunk" brands of alcoholic beverages sent from each user terminal 103, ratings, comments, and the like.
[0055] The registered stock table by user 1000 includes information such as a master user ID 1001 , a registration date 1002 , a master stock ID 1003 , a ranking 1004 , an evaluation comment 1005 , an evaluation score 1006 , a registration location 1007 , a posted image 1008 , a registration method 1009 , and a validity flag 1010 . The master user ID 1001 and the master brand ID 1003 store the IDs of the masters managed in the user master table 700 and the brand master table 800 managed in the cross-company master DB 222 .
[0056] The ranking 1004 stores information indicating that the brand has been "drink" or "wants to drink" registered by the user terminal 103, or "recommended" registered as a recommendation made by the system based on the user's preferences, etc.
[0057] The registration location 1007 stores the location where the information is registered, such as restaurant / outside / home, etc. In the case of a restaurant, the value of the store master table 900 is initially registered. The registration means 1009 stores the means by which information is registered, such as via a camera scan by a user, via direct input by a user to an app, or automatic registration by the system.
[0058] The valid flag 1010 is a flag for managing invalid data such as duplicate information. For example, if user B registers "want to drink" brand AA002 on May 23, 2018 (1011) and "drank" the same brand AA002 on June 6, 2018 (1012), the "want to drink" information is old information, so the valid flag is set to FALSE. Information registered as FALSE can be processed not to be displayed on the screen in subsequent display processing.
[0059] In addition, information similar to the user-specific registered stock table 1000 is also stored in the user terminal data 321 of the user terminal 103, and the list display module 313 of the user terminal 103 can display the information registered based on the user terminal data 321 on the user terminal 103.
[0060] FIG. 11 is an example of a brand-by-store handled table 1100. The store-specific brand table 1100 is a table created based on sales performance data sent from the distributor terminal 102, for managing which brands of alcohol are available at each store.
[0061] The store-by-store handled brand table 1100 stores a master store ID 1101, a master brand ID 1102, a registration method 1103, a registration date 1104, an update date 1105, a cumulative number of purchases 1106, an average purchase frequency 1107, a stock-out risk 1108, and the like. The master store ID 1101 and master brand ID 1102 store IDs of the masters managed in the store master table 900 and brand master table 800 managed in the cross-company master DB 222 .
[0062] The registration means 1103 includes information such as "distribution sales record," "store report," and "user posting." "Distribution sales record" is stored in information based on a distribution company sales record table 1600 that formats the sales record received from the distribution company terminal 102. When the integrated management server cooperation module 513 of the shop terminal 104 registers or updates information, the "shop declaration" is stored. When information is registered and updated by the stock registration module 311 and stock scan module 312 of the user terminal 103, "user posts" are stored.
[0063] The date on which information was first registered is stored in the registration date 1104. For example, the earliest purchase date is stored in the case of registration based on distribution sales results, the declaration date is stored in the case of registration based on store declaration, and the first posting date is stored in the case of registration based on user posting. The date on which the information of each brand was updated is stored in the update date 1105. For example, the most recent purchase date is stored in the case of registration based on distribution sales results, the most recent declaration date is stored in the case of registration based on store declaration, and the most recent posting date is stored in the case of registration based on user posting.
[0064] The accumulated number of purchases from the registration date 1104 to the update date 1105 is stored in the accumulated purchase count 1106. However, in another embodiment, the number of purchases may be managed based on the number of bottles of alcoholic beverages purchased instead of the number of purchases. It should be noted that it is sufficient to know the "amount" of cumulative purchases, and this is not limited to the above example. For example, the cumulative volume could be managed in "liters" or the number of barrels.
[0065] The average purchase frequency 1107 indicates the cumulative purchase count 1106 divided by the period elapsed from the registration date 1104 to the update date 1105. As another example, if the cumulative purchase quantity 1106 is managed by the number of bottles instead of the number of times, the cumulative purchase frequency 1107 will be the number of bottles purchased per month. However, as described above, it may also be the monthly purchase volume (liters / month) or the like.
[0066] Stockout risk 1108 displays the risk of stockout of each brand at the store. The stockout risk is calculated and evaluated based on, for example, average purchase frequency 1107 and the period of time that has elapsed since the latest information was registered.
[0067] FIG. 12 is an example of a brand analysis table 1200. The brand analysis table 1200 is a table for storing the evaluation, popularity, and rarity of each brand. The brand analysis table 1200 stores a master brand ID 1201, an average rating 1202, the percentage of people who want to drink 1203, the percentage of people who have drunk 1205, the handling rate at restaurants 1207, and the handling rate at retail stores 1208, and calculates and stores popularity 1204 and rarity 1206, 1208, and 1210 from these values.
[0068] 13 to 18 are examples of various tables stored in the formatted DB 223 of distribution company data. Each distribution company (Company P, Company Q, Company R in FIG. 1) manages products, customer stores, and sales results in its own format, order, and content. The data shaping module 211 shapes each piece of information received from these distribution company terminals 102 into a common format, which is stored in the distribution company data shaping DB 223 as shown in FIGS. 13 to 16. Storing the information of each company in a table with a common format makes it possible to perform various data analyses that integrate information from multiple distribution companies. The analyzed data is stored in the analysis data DB 221, and provided to the user terminal 103 and others.
[0069] The sales performance information (which may include product information, store information, and person in charge information associated with the sales performance) in a common format stored in the distribution company data formatting DB 223 is sometimes collectively called common sales performance information. The common sales performance information is a concept that includes all the various tables such as those shown in Figs. 13 to 16 stored in the distribution company data formatting DB 223.
[0070] FIG. 13 is an example of a distribution company product table 1300. The distributor product table 1300 is a table for managing the products handled by each distributor and information related to the products. The distributor product table 1300 stores information about products, such as a company ID 1301, a product ID 1302, a product name 1304, a manufacturer 1305, and a category 1306.
[0071] The company ID 1301 is an ID for identifying the distribution companies P, Q, R, etc. in FIG. The product ID 1302 is an ID managed by the distributor, and is linked to the master brand ID 801 of the brand master table 800 of the cross-company master DB 222 of the integrated management server 101 by the brand master linking table 1700.
[0072] FIG. 14 is an example of a distribution company store table 1400. The distribution company store table 1400 is a table for managing stores such as restaurants and retail stores that are business partners of each distribution company, and information related to the stores. The distribution company store table 1400 stores information about the store, such as a company ID 1401, a store ID 1402, a store name 1404, a business type 1405, an address 1406, a telephone number 1407, and a person in charge ID 1408.
[0073] The store ID 1402 is an ID managed by the distribution company, and is linked to the master store ID 901 in the store master table 900 in the cross-company master DB 222 of the integrated management server 101 by a store master linking table 1800.
[0074] FIG. 15 is an example of a distribution company person in charge table 1500. The distribution company person in charge table 1500 is a table for managing information on the person in charge of the business partner of each distribution company. The distribution company person in charge table 1500 stores information related to the person in charge, such as a company ID 1501, a person in charge ID 1502, a person in charge name 1503, and authentication information 1504.
[0075] Based on the authentication information 1504 recorded here, each person in charge logs in to the integrated management server linkage module 414, sends and receives data to and from the integrated management server 101, receives analysis results, and rewrites information in the cross-company master DB 222.
[0076] FIG. 16 is an example of a distributor sales performance table 1600. The distributor sales performance table 1600 is a table for managing the sales performance of each distributor. The distributor sales record table 1600 stores information related to sales records, such as a company ID 1601, an order date 1602, a product ID 1603, a master brand ID 1604, a store ID 1605, a master store ID 1606, an order quantity 1607, an order amount 1608, and a valid flag 1609.
[0077] The date on which the product was ordered is entered in the order date 1602, and basically, a record is added to this sales record table every time an order is placed. The company ID 1601 and product ID 1603 are IDs managed by the distribution company, and the master brand ID 1604 stores the master brand ID 801 of the brand master table 800 of the cross-company master DB 222 of the integrated management server 101 linked to the same product. Also, the master store ID 1606 stores the master store ID 901 of the store master table 900 of the cross-company master DB 222 of the integrated management server 101 linked to the same store.
[0078] It is not necessary to have both the product ID 1603 and the master brand ID 1604, and only one of the pieces of information will suffice as long as the correspondence is established as in the brand master matching table 1700 in FIG. Similarly, it is not necessary to have both the store ID 1605 and the master store ID 1606, and only one of the pieces of information will suffice as long as the correspondence is established as in the store master linking table 1800 of FIG. The validity flag 1609 is a flag for storing whether the record is valid or invalid. For invalid data such as order cancellation, FALSE is stored.
[0079] FIG. 17 is an example of a brand master linking table 1700. The brand master linking table 1700 stores the product ID 1302 unique to each company used for each company in the distributed company product table 1300 stored in the cross-company master DB 222 in association with the master brand ID 801 in the brand master table 800. By tracing the information in this brand master linking table 1700, the master brand ID 1604 can be stored in association with the product ID 1603 in the distributor sales performance table during the data matching process 2000.
[0080] FIG. 18 is an example of a store master linking table 1800. The store master linking table 1800 stores the store ID 1402 unique to each company used for each company in the distribution company store table 1400 stored in the cross-company master DB 222 in association with the master store ID 901 in the store master table 900. By tracing the information in this store master linking table 1800, the master store ID 1606 can be stored in association with the store ID 1605 in the distributor sales performance table during the data matching process 2000.
[0081] 19 to 25 show the flow of various processes carried out in the management system 1. In FIG. FIG. 19 shows an example of a data shaping process flow 1900 executed by the data shaping module 211 of the integrated management server 101 .
[0082] The data shaping module 211 receives logistics data such as sales record information, product information, and customer store information from the distribution company terminal 102 (step 1910). The received data stores products, customer stores, and sales records in the format, order, and content unique to each distribution company (Company P, Company Q, and Company R in FIG. 1). The module stores the received data in the receiving DB 224 of distributor data (step 1920).
[0083] This module rearranges the columns of the received data and replaces information to format it into a format (table structure) common to all companies, such as the distributor product table 1300, distributor store table 1400, and distributor sales performance table 1600 in the distributor data formatting DB 223 (step 1930). In other words, the received data is added as a new record so as to match these various table structures.
[0084] Then, the module stores the formatted data in the formatting DB 223 for distributor data (step 1940). Thereafter, the data matching module 212 performs matching processing. In the matching processing, data matching processing is performed on the records of each formatted table, and the master ID of the cross-company master DB 222 is inserted by performing name identification (step 1950).
[0085] FIG. 20 shows an example of a data matching process flow 2000 for matching information in the cross-company master DB 222 with the distributor sales performance table 1600 obtained by formatting information received from the distributor terminal 102 .
[0086] The data matching module 212 matches the distributor sales performance table 1600 in the distributor data formatting DB 223 with the information in the brand master table 800 in the cross-company master DB 222 (step 2010). At this time, the brand master linking table 1700 is also referenced.
[0087] This module checks whether there is a master brand ID that corresponds to the product in the distributor sales performance table 1600. In other words, it determines whether there is a product in the distributor product table 1300 associated with the product ID 1603 that corresponds to a brand managed in the brand master table 800 (step 2020).
[0088] For example, the brand master table 800 is searched for product-related information such as product names, manufacturer names, and categories in the distribution company product table 1300, and if there are similar products / brands, their master brand IDs are obtained. This determination may be made not only when the brand names match exactly, but also when there are highly similar products / brands. Similar products / brands may be identified by searching for matches or similarities using keywords in the table, or similar products / brands may be extracted by matching information in the brand master table 800 with information in the distribution company product table 1300 using repetitive calculations using AI, machine learning, deep learning, etc.
[0089] In addition, the product master information of a distributor such as the distributor product table 1300 is not a required component, and there are cases where the product information managed by the distributor is entered directly into the sales performance information. In such cases, the product information entered into the sales performance information is compared with the information in the brand master table 800. Furthermore, when corresponding information such as the brand master linking table 1700 is available, it is only necessary to check whether the information on the product ID 1603 has already been registered in the brand master linking table 1700 .
[0090] If a corresponding master issue ID is found, the data matching module 212 inserts the value of the master issue ID into the corresponding record in the distributor sales performance table 1600 (step 2040).
[0091] If a corresponding master issue ID does not exist, the data matching module 212 adds a new master issue ID to the issue master table 800 (step 2030), and stores the corresponding product information in the distributor product table 1300 in association with the new master issue ID (step 2035). Furthermore, if there is any information that is lacking as master information, the module may acquire and supplement the lacking information by processing such as making an inquiry to the manufacturer terminal 105 or searching the Internet, and store the information in the brand master table 800.
[0092] The module may similarly acquire and store label images, generate feature information used to identify products and brands based on the label images, etc., and store the same. The characteristic information is, for example, characteristic information extracted from an overall image of the brand or an image of the label, and may be, for example, the shape and color of the bottle, the shape and color of the label, the content, shape and color of the logo or text written on the label, or coordinate information or position information extracted from such information of characteristic points, or numerical information or data extracted by processing all or part of such information with a specific algorithm, etc. However, it is not limited to these, and any information that can be used for comparison when identifying the brand of alcoholic beverage may be used.
[0093] The data matching module 212 stores the newly added master brand ID in the distributor sales performance table 1600 (step 2040). Furthermore, when correspondence information such as the brand master linking table 1700 is held, the newly added master brand ID is stored in correspondence with the product ID 1704 .
[0094] Next, the data matching module 212 matches the information in the distributor sales performance table 1600 in the distributor DB 223 with the information in the store master table 900 in the master DB 222 (step 2050). At this time, the store master linking table 1800 is also referenced. This module checks whether there is a master store ID that corresponds to a store in the distributor sales record table 1600. In other words, it determines whether there is a store in the distributor store table 1400 associated with the store ID 1605 that corresponds to a store managed in the store master table 900 (step 2060).
[0095] For example, the store master table 900 is searched using store-related information such as the store name, business type, address, and telephone number in the distribution company store table 1400, and if a similar store is found, its master store ID is obtained. This determination may be made not only when the store name is an exact match, but also when there is a store with a high degree of similarity, and the store may be obtained. Similar stores may be identified by searching for matches or similarities using keywords in the table, or similar stores may be extracted by matching the information in the store master table 900 with the information in the distribution company store table 1400 using iterative calculations using AI, machine learning, or deep learning.
[0096] In addition, the store master information of a distribution company such as the distribution company store table 1400 is not a required configuration, and there are cases where the store information managed by the distribution company is entered directly into the sales performance information. In such a case, the store information entered into the sales performance information is compared with the information in the brand master table 900. Furthermore, when corresponding information such as the store master linking table 1800 is available, it is only necessary to check whether the information of the store ID 1605 has already been registered in the store master linking table 1800 .
[0097] If a corresponding master store ID is found, the data matching module 212 inserts the value of the master store ID into the corresponding record in the distributor sales performance table 1600 (step 2080).
[0098] If a corresponding master store ID does not exist, the data matching module 212 adds a new master store ID to the store master table 900 (step 2070), and stores the corresponding store information in the distribution company store table 1400 in association with the new master store ID (step 2075). Furthermore, if there is any information that is lacking in the master information, the module may acquire and supplement the lacking information by processing such as making an inquiry to the store terminal 104 or searching the Internet, and store the information in the store master table 900.
[0099] The data matching module 212 stores the newly added master store ID in the distributor sales performance table 1600 (step 2080). Furthermore, when correspondence information such as the store master linking table 1800 is held, the newly added master store ID is stored in correspondence with the store ID 1804 .
[0100] The data matching module 212 cooperates with the distribution company terminal 102 and the like to determine whether the orders stored in the records of the distribution company sales performance table are valid. If the order is valid, set the valid flag 1609 to TRUE; if the order is not valid, set the valid flag to FALSE. This process allows only the information on transactions for which orders have been officially accepted to be used in subsequent data analysis, etc.
[0101] FIG. 21 shows an example of a data analysis process flow 2100 for analyzing the status of brands of alcoholic beverages handled by each store based on the distributor sales performance table 1600 and generating the store-by-store handled brands table 1100 of the analysis data DB 221. The data analysis module 215 of the integrated management server 101 acquires all the information of the records having the master store ID to be analyzed from the distribution company sales performance table 1600 (step 2110).
[0102] If the acquired record information has the same master brand ID, the module adds the number of orders to the cumulative number of purchases (step 2120). In the example of the store-specific handled brand table 1100 in Fig. 11, a list of brands handled by store K is generated, and the cumulative number of purchases 1106 for each brand is calculated. If the registration date and update date have already been stored in the store-specific brand table 1100, only the difference in the number of purchases needs to be counted, and the number of orders received after the most recent update date is added to the cumulative number of purchases.
[0103] This module is for the order date 1602 of the record in which the number of orders has been added to the cumulative number of purchases. The update date 1105 in the store-specific brand handling table 1100 is updated with the information (step 2130). The module determines whether processing has been completed for all distributors (step 2140). If processing has not been completed for all distributors, the module repeats the same process until processing has been completed for all company IDs 1601 in distributor sales performance table 1600 (step 2150). This process makes it possible to generate a list of brands handled by store K, integrating logistics data such as product information, store information, and sales performance information obtained from multiple distributors P, Q, and R.
[0104] When the information in the store-by-store handled brand table 1100 is generated based on the distribution sales performance as described above, the data analysis module 215 sets “distribution sales performance” in the registration means 1103 . In the registration means 1103, when data is registered or updated by the integrated management server linkage module 513 of the store terminal 104, "store report" is set. When data is registered or updated by the brand registration module 311 or the brand scan module 312 of the user terminal 103, "user post" is set.
[0105] Next, the data analysis module 215 calculates the average purchase frequency 1107 by dividing the cumulative purchase count 1106 by the time elapsed between the registration date 1104 and the update date 1105 (step 2160). Instead of the time elapsed between the registration date 1104 and the update date 1105, the time elapsed from the registration date 1104 to the present may be used.
[0106] The data analysis module 215 calculates and stores the stock-out risk 1108 based on the average purchase frequency 1107 and the time that has elapsed since the update date 1105 (i.e., the date of the previous order) to the present (step 2170). For example, the stock-out risk 1108 is calculated by comparing the inverse of the average purchase frequency 1107 (i.e., the number of months it takes to consume one order of a brand) with the elapsed time. For example, the risk of stock shortage can be determined by the following judgments: If the elapsed period exceeds the number of months required for consumption of one order, the risk of discontinuance is deemed high. If the period of time that has elapsed is less than half the number of months, the risk is considered low. If the period that has elapsed is more than half the number of months but does not exceed the number of months, it is considered to be at medium risk. If more than one year has passed, the risk is considered high.
[0107] The end of sales risk 1108 can be updated by the integrated management server linkage module 513 of the store terminal 104, and can be rewritten to "end of sales confirmed" if the store determines that the brand of alcohol in question has been consumed.
[0108] The data analysis module 215 determines whether processing has been completed for all master store IDs 1604 (step 2180). If processing has not been completed for all stores, the same process is repeated until processing has been completed for all master store IDs in the distributor sales performance table 1600 (step 2190). This process makes it possible to integrate logistics data (sales performance information) such as product information, store information, and sales performance information obtained from multiple distributors P, Q, and R, generate a list of brands handled by each store, and also estimate and display the risk of stock shortages.
[0109] FIG. 22 shows an example of a brand registration process flow 2200 in which the brand registration module 311 of the user terminal 103 registers user information related to alcoholic beverages. FIG. 29 shows an example of a screen 2900 that is displayed on the display during brand registration processing. When the liquor information management application accepts a brand registration instruction from a user, the processing starts with the brand registration module 311. For example, when the plus mark 2901 at the bottom center of the screen in the example screen of Fig. 29 is tapped, the brand registration module 311 is activated and processing starts.
[0110] The brand registration module 311 displays a "Register brand you drank" button 2902 and a "Register brand you want to drink" button 2903 at the bottom of the screen in Fig. 29, and accepts the user's selection of "Register brand you drank" or "Register brand you want to drink" (step 2210). An image 2904 captured by the camera unit 307 is displayed in the background of the screen (step 2220). The selection of a button may be accepted by detecting that a button is being tapped, or by tapping the plus sign in Figure 29 to display each button and detecting a flick or swipe in the direction of the left or right button, and accepting the selection of either the left or right button.
[0111] The brand registration module 311 analyzes the displayed image, detects and highlights parts related to alcohol (step 2230). For example, by detecting the shape and color of the alcohol bottle, the shape and color of the label, etc., the relevant parts are highlighted as candidates for alcohol. This module accepts an image import instruction from the user (step 2240). For example, it determines that a tap on the image import button, the plus mark 2901 at the bottom center of the screen in Fig. 29, or a tap on a highlighted portion 2905 or 2906 is an image import instruction.
[0112] The module cuts out the image of the portion selected for brand determination, and transmits the image information to the integrated management server 101 (step 2250). As shown in FIG. 29, when multiple drinks are displayed on the screen and there are multiple highlighted areas, and an instruction to import an image is received by tapping the plus mark 2901, the images of the multiple highlighted areas are cut out, and then an image selection is received from the user. When one highlight portion out of multiple highlight portions is tapped, the image of that highlight portion can be cropped.
[0113] The image to be cut out may be any image sufficient to identify the brand of alcohol. For example, it may be just an image of the label, or a part of the label such as the logo or name. In cases where there is no need to worry about line capacity, the captured image may be sent to the integrated management server 101 as is without being cropped.
[0114] The brand determination module 214 of the integrated management server 101 that receives the image determines the brand of alcohol depicted in the received image, and sends the determination result and additional information related to the determined brand to the user terminal 103 (step 2260). The brand registration module 311 of the user terminal 103 displays the received judgment result and additional information on the display 305 or the like (step 2270).
[0115] The module accepts input of relevant information from the user, such as ratings and comments about the brand drunk, and the name of the store where the drink was registered (step 2280). The module stores the captured image, information identifying the stock such as the determined stock ID or stock name, and information related to the stock such as ratings, comments, store names, etc. in the user terminal data 321 of the user storage device and in the user-specific registered stock table 1000 in the analysis DB of the integrated management server 101 (step 2290).
[0116] When "Register brand drunk" 2902 is selected, the module sets "ranked" as the "position" 1004 in the user-specific registered brand table 1000, and when "Register brand desired to drink" 2903 is selected, the module sets "desire to drink" as the "position" 1004. "Registered location" 1007 stores the location where the brand was registered, identified from GPS information or the like, the store name, store ID, etc. The store name and store ID can be obtained by comparing the location information obtained by GPS with the location information 906 in the store master table 900. For stores that have not yet been registered, only the location information may be stored, or the user may fill it in.
[0117] FIG. 23 shows an example of a brand determination process flow 2300 executed by the brand determination module 214 of the integrated management server 101. The brand determination module 214 receives image related information of the portion relating to alcohol from the user terminal 103 (step 2310). The module extracts feature information from the image-related information (step 2320).
[0118] The characteristic information may be, for example, the shape and color of the bottle, the shape and color of the label, the content, shape and color of the logo or text written on the label, or coordinate information or position information extracted from the above information of characteristic points, numerical information or data extracted by processing all or part of the above information with a specific algorithm, etc. However, it is not limited to these, and any information that can be used for comparison when identifying the brand of alcoholic beverage may be used.
[0119] The module compares the characteristic information 812 with the issue master table 800 and determines whether there is an issue with similar characteristic information (step 2330). If similar characteristic information is not found, a determination result is generated to the effect that there is no corresponding brand information (step 2340).
[0120] If similar characteristic information is found, the brand of the record having the most similar characteristic information is identified (step 2350). Information in the issue master table 800 corresponding to the identified issue is acquired as additional information (step 2360). Also, information in the issue analysis table 1200 having the master issue ID of the identified issue may be acquired as additional information.
[0121] The stock determination module 214 transmits the determination result and additional information as information related to the identified stock to the user terminal 103 (step 2370). As the determination result, information for identifying the stock such as the identified stock name or master stock ID, or a message to that effect if there is no corresponding stock, is transmitted.
[0122] In addition, with this management system 1, not only photos of alcohol bottles but also information about alcohol contained in magazine articles, text information distributed by email or the Internet, etc. can be imported by using the "Register the brand you want to drink" button and registered as a brand you want to drink.
[0123] For example, in the case of a magazine article as shown in the example of Figure 33, by photographing the relevant part of the magazine article, this image 3304 is subjected to character recognition processing such as OCR in the brand determination process of the integrated management server 101, and information such as the brand name, category, brand name, manufacturer, storehouse / brewery, etc. related to the alcoholic beverage in the recognized text is detected. The detected portion containing the description of the alcohol can be highlighted and displayed over the image 3304 of the user terminal, as in the underlined or dashed frame 3306.
[0124] The detected information about the alcohol is collated with a brand master table 800 to identify the brand. Information about the identified stock can be displayed as 3305, overlaid on top of the image 3304 of the user terminal.
[0125] When a user selects a brand registration button 3301, a "register a brand you drank" button 3302, a "register a brand you want to drink" button 3303, etc., the specified brand information is registered along with the information "drank" and "want to drink."
[0126] The OCR process and the detection of content related to alcohol in the image may be performed on the user terminal 103 side, not on the integrated management server 101. In this case, the user terminal may transmit only the image of the portion detected for brand determination to the integrated management server 101, or may transmit only the text information after OCR process instead of the image.
[0127] In the case of text information distributed via email or the Internet, the brand registration module 311 of the user terminal 103 accepts the selection of the text relating to alcohol, or transmits the entire text information to the integrated management server 101 instead of an image. The brand determination module 214 of the integrated management server 101 compares the brand name, category, brand name, manufacturer, storehouse / brewery, and other information related to the alcohol in the transmitted text string with the brand master table 800, thereby identifying and registering the brand that the user wants to drink. Iterative calculations such as AI, machine learning, and deep learning can also be used to match and determine the similarity of these images and text.
[0128] In this embodiment, the process up to cutting out the image is performed by the user terminal 103, and the process up to extracting the characteristic information from the cut-out image and comparing it with the brand master table 800 is performed by the integrated management server 101. However, the process up to extracting the characteristic information may be performed by the brand registration module 311 of the user terminal 103, and the brand judgment module 214 of the integrated management server 101 may compare the extracted and sent characteristic information with the characteristic information in the brand master table 800.
[0129] In other words, the integrated management server 101 receives image-related information and performs judgment processing using a brand judgment module, and this image-related information includes the entire captured image, partial images cut out from that image, feature information extracted by processing all or part of these images, character string information obtained by analyzing the image, and so on.
[0130] By performing pre-processing such as partial extraction of an image and feature extraction on the user terminal 103 side as much as possible, the amount of data to be transmitted to the integrated management server 101 can be reduced. If the user terminal 103 has high machine specifications, the entire brand determination process may be performed within the user terminal 103. In this case, information to be compared for determination, such as the label image 811 and characteristic information 812 in the brand master table in FIG. 8, may be stored in the auxiliary storage means 302 of the user terminal 103.
[0131] Also, brand information and comparison information for major brands are stored in the user terminal 103, and a brand determination module of the user terminal 103 performs brand determination and display, so that processing for major alcohol brands is completed by the user terminal 103. On the other hand, for brands that cannot be determined as major alcohol brands and no determined brand is available, an inquiry may be made to the integrated management server 101, and the integrated management server's brand determination module may perform brand determination processing, in a hybrid configuration.
[0132] FIG. 24 shows an example of a brand analysis process flow 2400 executed by the data analysis module 215 of the integrated management server 101 . The data analysis module 215 acquires all the information of the records having the master issue ID 1003 of the issue to be analyzed from the user-registered issue table 1000 (step 2410).
[0133] The module calculates the average evaluation value of all users who have rated the stock, and stores it in the average evaluation field of the stock analysis table 1200 (step 2420).
[0134] Next, the module checks the information of all users in the registered brand table by user 1000, and totals the number of users who want to drink the brand for which "Want to drink" is stored in the positioning 1004. The module then calculates the percentage of people who want to drink the brand by dividing this value by the total number of users, and stores the calculation result in the percentage of people who want to drink 1203 in the brand analysis table 1200 (step 2430)).
[0135] Next, the module calculates the "popularity" of the brand from the percentage of people who want to drink it (step 2435). Popularity can be classified, for example, from the distribution when the proportion of people who want to drink is arranged in descending order. For example, as shown in the example of Fig. 34, from the brands for which "want to drink" is stored, they are divided into three groups, "high", "medium", and "low", so that the number of brands is equal, and are registered (3401, 3402, 3403). For the brand 3404 for which no "want to drink" is registered, the popularity may be set to "low", or the popularity may be set to "-" with no information. In addition, the popularity may be calculated not only by the percentage of people who want to drink, but also by using an index obtained by multiplying "people who want to drink" by "ratings from people who have drunk" as the vertical axis.
[0136] Next, the module checks the information of all users, and totals the number of users who drank the brand for which "drank" is stored in the ranking 1004. The module then divides this value by the total number of users to calculate the percentage of people who drank the brand, and stores the calculation result in the percentage of people who drank 1205 in the brand analysis table 1200 (step 2440).
[0137] Next, the module calculates the "rarity" of the brand from the percentage of people who have drunk it (step 2445). The rarity can be classified, for example, from the distribution when the ratio of people who drank the brand is arranged in descending order. For example, as shown in the example of Figure 35, from the brands for which "drank" is recorded, the total number of people who drank the brand is divided into three parts, "low," "medium," and "high," so that they are equal, and the three are registered as rarity 1 (3501, 3502, 3503). In this case, if the number of people who have drunk the drink is extremely small, it is highly likely that the rarity is not high and that the information has simply not been registered. Therefore, if the number of people who have drunk the drink is below a certain number or percentage (for example, 100 people or 0.1%) (3506), the rarity is not evaluated 3504 and "-" is stored in the rarity column of the brand analysis table 1200 in Figure 12.
[0138] Next, the module acquires all the information of the records having the master issue ID of the issue to be analyzed from the store-specific handled issue table 1100 (step 2450). The module totals the number of eating and drinking establishments that have purchased alcohol with this master brand ID since a specified period (e.g., the most recent year).Then, by dividing this total by the total number of eating and drinking establishments, it calculates the eating and drinking establishment handling rate for the most recent year, and stores the calculation result in the eating and drinking establishment handling rate in the brand analysis table 1200 (step 2460).
[0139] The module calculates the "rarity" of the brand based on the restaurant's handling rate (step 2465). The rarity is calculated by arranging the restaurants in descending order of their handling rate, as in the example in Figure 35. If so, it will be classified into three levels: "low," "medium," and "high," and registered as rarity level 2. In this case, if the rate at which restaurants handle the alcohol is extremely low, it may not be that the alcohol is rare, but rather that the information has simply not been registered. Therefore, if the number of restaurants that handle this alcohol is below a certain number or percentage (for example, 10 restaurants or 0.1%), the alcohol is not included in the rarity evaluation and a "-" is stored in brand analysis table 1200 in Figure 12.
[0140] In this example, the restaurant transaction rate for the most recent year was used, but the specified period can be another period, and if it is set to the most recent month, the restaurant transaction rate for the most recent month can be calculated. It may also be set to the entire period up to now. In addition, if it is possible to switch between these types of information, it will also be possible to display the restaurant handling rate and rarity for each period: the past year, six months, and January.
[0141] Next, the module totals the number of retail stores that have purchased alcohol with this master brand ID since a specified period (e.g., the most recent year), and then divides this total by the total number of retail stores to calculate the retail store handling rate for the most recent year, and stores the calculation result in the retail store handling rate in the brand analysis table 1200 (step 2470).
[0142] The module calculates the "rarity" of the brand from the retailer's handling rate (step 2475). As in the example of Figure 35, rarity is calculated by sorting the retailers by their handling rate in descending order and dividing the rarity into three levels, for example, "low," "medium," and "high," and registering the rarity as rarity 3. In this case, if the rate at which retailers handle the alcohol is extremely low, it may not be that the alcohol is rare, but rather that the information has simply not been registered. Therefore, if the number of retailers that handle this alcohol is below a certain number or percentage (for example, 10 stores or 0.1%), the alcohol is not evaluated for rarity and a "-" is stored in brand analysis table 1200 in Figure 12.
[0143] In this example, the retailer's transaction rate for the most recent year was used, but the specified period can be another period, and if it is set to the most recent month, the retailer's transaction rate for the most recent month can be calculated. It may also be set to the entire period up to now. In addition, if it is possible to switch between these types of information, it will also be possible to display retailer handling rates and rarity for each period: the past year, six months, and January.
[0144] In the store-by-store brand handling table 1100, whether each store is a restaurant or a retail store can be determined by searching the store master table 900 using the master store ID 901 as a key and looking at the information in the corresponding category 902.
[0145] Popularity and rarity may be classified according to the distribution or deviation of the number of people who want to drink each brand, people who have drunk it, restaurants and retailers that carry it, etc., or the top 10 brands may simply be classified as "high" in popularity or rarity.
[0146] The data analysis module 215 repeats the issue analysis process until the process is completed for all master issue IDs 1003. When the process is completed, the issue analysis table 1200 in FIG.
[0147] FIG. 25 shows an example of a brand scan process flow 2500 executed by the brand scan module 312 of the user terminal 103 . 31 to 33 are examples of screens displayed on the display 305 of the user terminal 103 during brand scanning processing. When the liquor information management application receives a brand scan instruction from a user, the brand scan module 312 starts processing (step 2510). For example, when the “Brand Scan” button 3110 in the upper right corner of the screen example of Fig. 31 is tapped, the brand scan module 312 is launched and starts processing.
[0148] The brand scan module 312 displays the image 3111 captured by the camera unit 307 on the display 305 as shown in FIG. 31 (step 2520). The module analyzes the image and detects parts related to alcohol (step 2530). For example, the module detects the shape and color of the alcohol bottle, the shape and color of the label, and the like, to detect the parts as candidates for alcohol. The module transmits the detected image information for brand determination to the integrated management server 101 (step 2540).
[0149] The brand determination module 214 of the integrated management server 101 analyzes the received image information, determines the brand of the alcoholic beverage depicted, and returns the determination result and additional information to the user terminal 103 (step 2550).
[0150] The brand scanning module 312 receives the determination result and the additional information (step 2560). The module superimposes the received information on the portion of the image on the display that is related to alcohol detected in step 2530 (step 2570). In this case, instead of displaying all received information, only information that is useful to the user is displayed, such as information about brands that the user has drunk in the past, information about brands with a "high" popularity rating, or information about brands with a "high" rarity rating.
[0151] The module can also display a screen for setting what to display. For example, Example 1: Display brands with a popularity rating of "medium" or "high." Example 2: Display brands with a "high" rarity rating. Example 3: Display items with an average rating of 4.5 or higher. It is possible to register and change the settings.
[0152] When such settings of the contents to be displayed have been made in advance, the brand determination module 214 of the integrated management server 101 can return only the brand information and additional information corresponding to the set contents, rather than returning all information of the brand corresponding to the received image information to the user terminal 103. For example, in the first setting example above, of the brand information identified by the image information shown on the screen, only information of brands with popularity levels of "medium" and "high" is returned to the user terminal 103.
[0153] In this way, by returning only the information corresponding to the setting information of the user terminal 103, the amount of data received from the integrated management server 101 can be reduced, and the processing speed up to display can be increased.
[0154] FIG. 31 shows an example 3100 of a screen during brand scanning processing, which is displayed when scanning the types lined up on a display shelf. For example, the labels of all the bottles of alcohol displayed are detected as images related to alcohol, and are sent to the integrated management server 101 to determine the brand. As a final result, the brands corresponding to the parts 3101, 3103, and 3105 have useful information, and in this example, only the information about these is displayed.
[0155] In 3101, the section related to the brand of drinks registered by the user, in 3103, the section related to the brand of drinks that the user registered that he / she wants to drink, and in 3105, the recommended brand of drinks recommended by the app are highlighted in a distinguishable manner.
[0156] The label image of 3101 is analyzed, and the number of times the user has drunk the drink in the past and the user's evaluation information are displayed as additional information corresponding to the identified brand. The number of times a user has drunk alcohol in the past can be calculated by accumulating the number of records in which "drank" is stored in "Position" 1004 for all records in the user-registered brand table 1000 that have a specified brand name and have a master brand ID, and dividing that number by the number of all records for all brands in which "drank" is stored. This makes it possible to calculate the percentage of alcohol of the specified brand that the user has drunk among all the alcoholic beverages for which "drank" has been registered.
[0157] As in Figure 34, by comparing this with the distribution of all brands "drank," the number of times the drink was consumed is calculated and displayed. Note that information similar to the user-registered brand table 1000 in the analysis data DB 221 is also stored in the user terminal data 321 in the user terminal 103, and may therefore be processed and displayed on the user terminal 103 side.
[0158] The user's evaluation is displayed by acquiring the evaluation score 1006 from the user-registered brand table 1000 or the user terminal data 321 of the user terminal 103 . In addition, if the user has left an evaluation comment 1005, this evaluation comment 1005 and its registration date 1002 may be obtained from the user-specific registered stock table 1000 or the user terminal data 321 of the user terminal 103, and the entire text or an abbreviated portion of it may be displayed.
[0159] In 3104, information about the brand of beer that the user has registered and that he or she would like to drink is displayed. When a user has registered a brand that the user "wants to drink," an evaluation comment 1005 and its registration date 1002 are obtained from a user-registered brand table 1000 or the user terminal data 321 of the user terminal 103, and the entire text or an abbreviated part of the text is displayed.
[0160] The average rating of all users is obtained as additional information from the average rating 1202 of the brand analysis table 1200, which corresponds to the master brand ID 1201 of the identified brand. The brand scan module 312 receives the additional information from the integrated management server 101 and displays the average rating value in 3104.
[0161] In 3106, information on recommended brands recommended by the alcohol information management application or the integrated management server 101 is displayed. Popularity and rarity are obtained as additional information from information such as popularity, rarity 1, rarity 2, rarity 3, etc. (1204, 1206, 1208, 1210) in the stock analysis table 1200 that corresponds to the master stock ID of the identified stock. The brand scan module 312 receives the additional information from the integrated management server 101 and displays the popularity and rarity in 3106 . In terms of rarity, it is possible to display all of the following rarity levels: rarity 1 (not many people drinking it), rarity 2 (not often handled by restaurants), and rarity 3 (not often handled by retailers). Alternatively, it is also possible to display only a portion of these, or to combine all or a portion of these by taking a weighted average.
[0162] In this way, by obtaining information about a brand, its popularity, rarity, etc. from logistics data such as product information from multiple distribution companies, customer store information, and sales performance, it is possible to continue to update the information in a timely manner at the same time as the logistics data is updated. In addition, by using logistics data received from multiple distribution companies, the handling rate at sales outlets and retail stores can be presented to the user as rarity.
[0163] The additional information is displayed by highlighting the cut-out portion of the identified brand or its vicinity as shown in FIG. 31 (3101, 3103, 3105) and displaying the additional information in its vicinity (3102, 3104, 3106). If the brand determination speed is slow, the captured image may move, but this can be handled by the brand scan module 312 continuing to track the position of the cutout part on the screen. In other words, even if the screen moves, the determination result and additional information can be displayed at the position of the cutout part after the tracked movement.
[0164] In addition, when performing brand registration processing, the smartphone, which is the user terminal 103, usually takes a picture of the bottle from the front, and in this case, the top of the bottle (the direction of the mouth) and the top of the smartphone often face in the same direction and are aligned. However, in the brand scanning process, the smartphone can be scanned not only with the smartphone facing upwards, but also sideways as shown in Figure 31. In this case, whether to take the picture with the smartphone facing right or left depends on the user's preference. In the brand registration example in Figure 29, a plus sign appears at the bottom of the smartphone, and Figure 31 shows a picture taken with the smartphone tilted to the left (with the right side facing up).
[0165] In this way, when the orientation of the smartphone changes each time a photo is taken, if part of the image is cut out and a brand determination is performed by the brand determination module 214 of the integrated management server 101, it may not be possible to determine in which direction the cut-out image is facing, which could result in poor accuracy of the determination or slow speed.
[0166] The label image 811 and characteristic information 812 of the brand master used for brand determination are registered in a direction that allows the characters on the label to be read as is. In other words, the label image with the mouth of the bottle facing up and the characteristic information extracted from it are registered. For example, if the orientation of the photo is unknown, it is not possible to determine which direction in the image is up, down, left, or right on the original bottle for the same image, so the image will have to be rotated 90 degrees at a time to check for a match in the feature information, which could take up to four times as long.
[0167] To solve this problem, in the brand scanning process, three-dimensional direction information obtained from the gyro of the user terminal 103 at the time of photographing may also be sent to the integrated management server 101. Since bottles are usually displayed with their mouths facing up, the opposite direction (upward) to the gravity of the gyro when the image was photographed is considered to be the upward direction of the image (the direction of the bottle's mouth), and a similarity determination with the characteristic information is performed.
[0168] Alternatively, an image of the entire bottle may be acquired and the top of the image may be determined from the shape of the bottle. In this case, the mouth of the bottle is considered to be the top of the image, and similarity determination is performed on the feature information of the cut-out image.
[0169] In the brand scanning process, brand determination is performed on multiple cut-out images, but when determining the similarity of the feature information for the first image, the direction in which the brand was identified can be assumed to be the top of the screen, and subsequent cut-out images can be processed assuming that this direction is the top of the screen. In this way, by performing image determination processing together with directional information, it is possible to improve the accuracy and speed of image determination.
[0170] 32 shows an example of another screen 3200 during brand scanning processing. In this example, when a bottle of a certain brand in FIG. 31 is tapped, information about the brand is displayed. The brand scanning module 312 can detect all alcoholic drinks on the screen and display information about them, so when it detects that the user has selected a brand by tapping, it can display information specific to that brand as well as additional information about the brands that are not highlighted in Figure 31, as well as those highlighted in Figure 31.
[0171] The information to be displayed may be information stored in the user-registered stock table 1000, the user terminal data 321, the stock analysis table 1200, the stock master table 800, etc., and may be acquired as additional information and displayed (3202).
[0172] FIG. 33 shows an example of a screen 3300 when brand scanning processing is performed on character strings printed on magazines, in addition to bottles and labels. For example, in the case of a magazine article, a photographed image of the magazine article is sent to the integrated management server 101, and the integrated management server 101 performs character recognition processing such as OCR in its brand determination process. The information on the brand name, category, brand name, manufacturer, storehouse / brewery, etc., related to the alcohol in the detected text is collated with the brand master table 800 to identify the brand that the user wants to drink. By acquiring the identified brand and its additional information, the information about the alcohol is displayed on the magazine article image (3305). Even a display of an alcohol menu at a store can be scanned in the same way.
[0173] After that, by pressing the plus sign 3301 at the bottom center of the screen in Figure 33 or by detecting a tap on the selection highlight portion, the brand registration module 311 will be launched, and from here, by accepting the selection of the ``Register brand you drank'' button 3302 or the ``Register brand you want to drink'' button 3303, you can register the brand as ``drank'' or ``want to drink.'' In the examples of Figures 31 and 32, it is also possible to register brands that have been drunk or that one would like to drink.
[0174] In this embodiment, by simply scanning liquor shelves, magazine articles, store menus, etc., it is possible to display brand information obtained from logistics data, and it is also possible to register brands identified from this as brands that have been "drinking" or "want to drink."
[0175] FIG. 26 is an example of a registration list screen 2600. When the alcoholic beverage information management app receives an instruction from the user to display a list of posts, for example by tapping "List of posts" 2601 at the bottom left of the screen in Figure 26, the list display module 313 of the user terminal 103 is launched. The list display module 313 obtains and displays corresponding information from the user terminal data 321 stored in the auxiliary storage device 302 of the user terminal 103 . The user terminal data 321 is also stored in the user-registered brand table 1000 in the analysis data DB 221 of the integrated management server 101, and information may be acquired from this data.
[0176] The registered stock name is displayed in 2602. This module displays, as the stock name, information stored in the user terminal data 321 of the user terminal 103, or information of the stock name 802 in the stock master table 800 associated with the master stock ID 1003 stored in the user-specific registered stock table 1000 of the integrated management server 101. A user name is displayed in 2603. This module displays, as the user name, information stored in the user terminal data 321 of the user terminal 103 or information of the user name 702 stored in the user master table 700 of the integrated management server 101.
[0177] Comments posted by users are displayed in 2604. This module displays information stored in the user terminal data 321 of the user terminal 103, or evaluation comments 1005 stored in the user-specific registered brand table 1000 of the integrated management server 101.
[0178] An SNS function is displayed in 2605. This alcohol information management app has an SNS function, and users can add "likes," "comments," or "want to drink" to posts and comments by other users. This list of posts 2600 can display not only posts by the user using the user terminal 103, but also posts by other users who use the app.
[0179] The posting date is displayed in 2606. The list display module 313 displays information stored in the user terminal data 321 of the user terminal 103, or the posting date 1002 stored in the user-specific registered brand table 1000 of the integrated management server 101.
[0180] The evaluation given by the user is displayed in 2607. This module displays information stored in the user terminal data 321 of the user terminal 103, or the evaluation comment 1005 stored in the user-specific registered brand table 1000 of the integrated management server 101.
[0181] Detailed information about the registered alcoholic beverage is displayed in 2608. This module displays, as detailed information, information stored in the user terminal data 321 of the user terminal 103, or information in the brand master table 800 associated with the master brand ID stored in the user-specific registered brand table 1000 of the integrated management server 101.
[0182] Posted images related to registered alcoholic beverages are displayed in 2609. This module displays information stored in the user terminal data 321 of the user terminal 103 or posted images 1008 stored in the user-specific registered brand table 1000 of the integrated management server 101 as detailed information.
[0183] In addition to these, information from various tables such as the user-registered stock table 1000, the user master table 700, the stock master table 800, and the stock analysis table 1200 may be displayed.
[0184] FIG. 27 is an example of another display 2700 of the registration list screen. When the alcohol information management app receives an instruction from the user to display a brand list, for example by tapping on "Brand List" 2701 at the bottom left of the screen in FIG. 27, the list display module 313 of the user terminal 103 is started. The list display module 313 obtains and displays corresponding information from the user terminal data 321 stored in the auxiliary storage device 302 of the user terminal 103 . The user terminal data 321 is also stored in the user-registered brand table 1000 in the analysis data DB 221 of the integrated management server 101, and information may be acquired from this data.
[0185] When the module accepts the selection of the "drank" button 2702, it obtains information on brands whose ranking 1004 in the user-registered brand table 1000 is "drank," and displays a list of the alcoholic beverages drunk.
[0186] In 2705 to 2707, detailed information on registered alcoholic beverages is displayed in the same manner as in Fig. 26. This module displays information stored in the user terminal data 321 of the user terminal 103 or information stored in the user-specific registered brand table 1000 of the integrated management server 101 as detailed information. In addition to these, information from various tables such as the user-registered stock table 1000, the user master table 700, the stock master table 800, and the stock analysis table 1200 may be displayed.
[0187] When the module accepts the selection of the "Want to drink" button 2703, it obtains information on brands that are "Want to drink" in the ranking 1004 of the brand registered by user table 1000, and displays a list of the alcoholic beverages that have been consumed.
[0188] When the module accepts the selection of the "recommended" button 2703, it obtains information on brands that are "recommended" in the ranking 1004 of the user-registered brand table 1000, and displays a list of the alcoholic beverages that have been consumed. The recommended information includes brands that match the user's preferences, such as brands that the user has drunk in the past. In addition, information on popular or rare brands that match the user's preferences may be registered and displayed.
[0189] FIG. 28 is an example of a screen 2800 that displays establishments on a map where a selected brand of alcohol is available. When the list display module 313 receives a selection to display "Bars where you can drink" such as 2610 in FIG. 26 or 2708 in FIG. 27, it displays a list of bars where you can drink on a map as shown in FIG. The list of establishments where you can drink can be generated by the list display module 313 querying the integrated management server 101, and the data analysis module 215 of the integrated management server 101 extracting information about establishments that carry the brand in question from the brand-by-store handling brand table 1100 in the analysis data DB 221.
[0190] The displayed store name, address, location on the map, telephone number, etc. are obtained from the store name 903, address 905, location 906, telephone number 907, etc. in the store master table 900 associated with the corresponding master store ID. The list display module 313 displays the acquired information at the coordinate position entered in the position 906 (2804).
[0191] Also, the risk of stock shortage may be displayed visually as shown in 2801 and 2802. The risk of stock shortage can be displayed by acquiring the information on the risk of stock shortage 1108 in the table 1100 of brands handled by shop. The risk of expiration 1108 can be "high," "medium," "low," or "end of transaction confirmed." All of this information may be displayed on the map, but it is also possible to configure the map so that "end of transaction confirmed" is not displayed, as in the example of FIG. 28.
[0192] 28, drinking establishments are arranged on a map, but a list may be displayed instead of a map. In this case, the current location obtained from the GPS of the user terminal 103 may be compared with the address 905 or the position 906, and the store list may be displayed in order of distance from the current location.
[0193] 29 shows an example of a brand registration screen. The explanation was given in the brand registration process flow in FIG.
[0194] FIG. 30 is an example of a screen that displays additional information about a stock during the stock registration process. When a selection is received by tapping or the like on the highlighted image portion, the stock registration module 311 displays additional information on the identified stock (3003). The information to be displayed may be information stored in the user-registered stock table 1000, the user terminal data 321, the stock analysis table 1200, the stock master table 800, etc., which may be acquired as additional information and displayed.
[0195] FIG. 31 is an example of a stock scan screen. FIG. 32 is another example of the brand scan screen. FIG. 33 is another example of the brand scan screen. 31 to 35 have been explained in the brand scan processing flow of FIG.
[0196] FIG. 34 is a diagram for explaining the determination of the popularity of the brand analysis table 1200. As shown in FIG. The data analysis module 215 calculates the "percentage of people who want to drink" for each brand, and stores it in the brand analysis table 1200 as "percentage of people who want to drink" 1203. The "percentage of people who want to drink" is the vertical axis, and the brands are arranged in descending order of percentage. The horizontal axis is the name of each brand. In addition, the popularity may be calculated not only by the percentage of people who want to drink, but also by using an index obtained by multiplying "people who want to drink" by "ratings from people who have drunk" as the vertical axis. Based on the distribution of this graph, brands are classified into "high," "medium," or "low" popularity within a specified range, starting from the highest percentage of people who want to drink the brand.
[0197] For example, for brands that are registered as "Want to drink" in the user-specific registered brand table 1000 (i.e., brands for which the percentage of people who want to drink is not "0"), the number of brands can be divided equally into thirds and classified in order of the highest percentage of people who want to drink them as "high," "medium," and "low." For example, if there are 300 stocks with "Want to Drink" registered, 100 stocks will be assigned to each of "High," "Medium," and "Low." Stocks without "Want to Drink" registered will be rated "Low."
[0198] In another example, for brands for which "want to drink" has been registered, the popularity may be divided into three parts so that the number of people who "want to drink" is equal, and the popularity may be assigned to "high," "medium," or "low." For example, in the example in Figure 34, for the portion where the percentage of people who want to drink is not "0", the bar graphs are classified into "high", "medium", and "low" so that the total area is equal. In addition, the evaluation may be performed by classifying the samples in a predetermined ratio or manner other than dividing the samples into three equal parts.
[0199] FIG. 35 is a diagram for explaining the determination of the rarity of the brand analysis table 1200. As shown in FIG. The data analysis module 215 calculates the "proportion of people who drank" for each brand and stores it in the brand analysis table 1200. The "proportion of people who drank" is the vertical axis, and the brands are arranged in descending order of proportion. The horizontal axis is the name of each brand. Based on the distribution of this graph, brands are classified into a specified range based on their rarity, from the highest percentage of people who have drunk the drink, as "low," "medium," or "high."
[0200] In this case, if the number of people who have drunk the drink is extremely small, it is not likely that the drink is rare, but rather that the information has simply not been registered. Therefore, if the number of people who have drunk the drink is below a certain number or percentage (for example, 100 people or 0.1%), it will not be taken into consideration. For example, for brands that are registered as "drank" in the user-specific registered brand table 1000 and have more than 100 people who have drunk them, the number of brands can be divided equally into thirds and classified in order of the highest percentage of people who have drunk them as "low," "medium," and "high." For example, if "drank" is registered and there are 300 brands with more than 100 people who "drank," 100 brands will be assigned to each of the rarity levels "low," "medium," and "high." Brands with fewer than 100 people who "drank" will be excluded from the evaluation and will be marked with "-."
[0201] In another example, for brands for which "drank" has been registered, the rarity may be divided into three parts so that the number of people who "drank" is equal, and the rarity may be "low," "medium," or "high." For example, in the example in Figure 35, for the portion of the population where more than 0.1% drank (if there are 100,000 users, the percentage of people who drank is more than 100), the total area of the bar graphs for "low," "medium," and "high" is classified equally.
[0202] In addition, the evaluation may be performed by classifying the samples in a predetermined ratio or manner other than dividing the samples into three equal parts. Popularity and rarity may be classified according to the distribution or deviation of the number of people who want to drink each brand, people who have drunk it, restaurants and retailers that carry it, etc., or the top 10 brands may simply be classified as "high" in popularity or rarity.
[0203] The present invention is not limited to the above-described embodiments, and includes various modified examples. For example, the above-described embodiments have been described in detail to clearly explain the present invention, and the present invention is not necessarily limited to those including all of the configurations described. It is also possible to replace a part of the configuration of one embodiment with the configuration of another embodiment, and it is also possible to add the configuration of another embodiment to the configuration of one embodiment. It is also possible to add, delete, or replace a part of the configuration of each embodiment with another configuration.
[0204] In addition, the above-mentioned configurations, functions, processing units, processing means, etc. may be realized in part or in whole by hardware, for example, by designing them as integrated circuits. In addition, the above-mentioned configurations, functions, etc. may be implemented as programs, and realized in software by a processor interpreting and executing the programs that realize the respective functions. Information such as programs, tables, files, etc. that realize the respective functions may be stored in a memory, a recording device such as a hard disk or SSD (Solid State Drive), or a recording medium such as an IC card, SD card, or DVD.
[0205] In addition, the control lines and information lines shown are those that are considered necessary for the explanation, and not all control lines and information lines in the product are necessarily shown. In reality, it can be considered that almost all components are connected to each other. [Explanation of symbols]
[0206] 1...Management system, 101...Integrated management server, 102...Distributor terminal, 103...User terminal, 104...Store terminal, 105...Manufacturer terminal, 211...Data formatting module, 212...Data matching module, 213...User data management module, 214...Brand determination module, 215...Data analysis module, 221...Analysis data DB, 222...Corporate cross-master DB, 223...Distributor data formatting DB, 224...Distributor data receipt DB, 311...Brand registration module, 312...Brand scan module, 313...List display module, 321...User terminal data
Claims
1. An integrated management server, A data formatting means for receiving sales performance information from a plurality of distribution company terminals of a plurality of distribution companies that sell products to the store; a data matching means for updating product master information for managing alcoholic beverages sold at the store in common among the plurality of distribution companies, the product master information including common identification information of the alcoholic beverages, based on the received sales performance information of each of the distribution companies; a product determination means for analyzing the product-related information received from the user terminal, identifying the alcoholic beverage product by comparing it with characteristic information corresponding to the alcoholic beverage product registered in the product master information, and transmitting information regarding the identified alcoholic beverage product to the user terminal; having the data reforming means stores the information acquired from each of the sales performance information in common sales performance information for common management by the plurality of distribution company terminals, the common sales performance information including common identification information of alcoholic beverage products; The data matching means includes: If an alcoholic beverage product registered in the product master information is present in the common sales record information, common identification information for identifying the corresponding alcoholic beverage product is stored in the common sales record information; If an alcoholic beverage product stored in the common sales record information does not exist in the product master information, common identification information of the non-existent alcoholic beverage product is added to the product master information. The product master information is updated by Further comprising a data analysis means for analyzing the data, The data analysis means determines a risk of stock shortage of a predetermined product at a predetermined store based on the sales performance information received from the plurality of distribution company terminals, The product determination means transmits, to the user terminal, information indicating a risk of the specified alcoholic beverage product being out of stock as information regarding the specified alcoholic beverage product.
2. An integrated management server comprising:
2. An integrated management server, A data formatting means for receiving sales performance information from a plurality of distribution company terminals of a plurality of distribution companies that sell products to the store; a data matching means for updating product master information for managing alcoholic beverages sold at the store in common among the plurality of distribution companies, the product master information including common identification information of the alcoholic beverages, based on the received sales performance information of each of the distribution companies; a product determination means for analyzing the product-related information received from the user terminal, identifying the alcoholic beverage product by comparing it with characteristic information corresponding to the alcoholic beverage product registered in the product master information, and transmitting information regarding the identified alcoholic beverage product to the user terminal; having the data reforming means stores the information acquired from each of the sales performance information in common sales performance information for common management by the plurality of distribution company terminals, the common sales performance information including common identification information of alcoholic beverage products; The data matching means includes: If an alcoholic beverage product registered in the product master information is present in the common sales record information, common identification information for identifying the corresponding alcoholic beverage product is stored in the common sales record information; If an alcoholic beverage product stored in the common sales record information does not exist in the product master information, common identification information regarding the non-existent alcoholic beverage product is added to the product master information. The product master information is updated by The product determination means transmits to the user terminal, as information regarding the specified alcoholic beverage product, information indicating a store that is likely to handle the specified alcoholic beverage product, based on the sales performance information received from each of the plurality of distribution company terminals.
2. An integrated management server comprising:
3. 3. The integrated management server according to claim 1, The integrated management server is characterized in that the product determination means transmits information regarding the recommended alcoholic beverage products to the user terminal.
4. 3. The integrated management server according to claim 2, A data analysis means for analyzing data, The data analysis means determines a risk of stock shortage of a predetermined product at a predetermined store based on the sales performance information received from the plurality of distribution company terminals, The product determination means transmits, to the user terminal, information indicating a risk of the specified alcoholic beverage product being out of stock as information regarding the specified alcoholic beverage product.
2. An integrated management server comprising:
5. 2. The integrated management server according to claim 1, The product determination means transmits to the user terminal, as information regarding the specified alcoholic beverage product, information indicating a store that is likely to handle the specified alcoholic beverage product, based on the sales performance information received from each of the plurality of distribution company terminals.
2. An integrated management server comprising:
6. 5. The integrated management server according to claim 1, The information indicating the store that is likely to handle the specified alcoholic beverage product is displayed in association with the information indicating the predetermined store on the map displayed on the user terminal.
2. An integrated management server comprising:
7. The integrated management server according to any one of claims 1 to 6, The product determination means transmits information about alcohol products handled at a specific store to the user terminal based on the sales performance information received from each of the plurality of distribution company terminals.
2. An integrated management server comprising:
8. The integrated management server according to any one of claims 1 to 7, The information about the identified alcoholic beverage products is at least one of the popularity, rarity, and average rating of each product.
2. An integrated management server comprising:
9. The integrated management server according to any one of claims 1 to 8, A receiving means receives from the user terminal a plurality of partial images related to alcoholic beverages detected from the scanned target image acquired from the camera unit of the user terminal; the product determination means analyzes the plurality of partial images as the product-related information, identifies the plurality of corresponding alcoholic beverage products, and transmits information relating to the identified plurality of alcoholic beverage products to the user terminal; The transmitted information about the plurality of alcoholic beverage products is displayed in association with the positions of the plurality of partial images on the scanned image.
2. An integrated management server comprising:
10. The integrated management server according to claim 9, The scanned image is at least one of an image showing a plurality of bottles of alcoholic beverages, an image showing an article about alcoholic beverages, and an image showing a menu; At least one of the label portions of the plurality of bottles, the portion of the character string written in the article, and the portion of the character string written in the menu of the scanned image is detected as the plurality of partial images.
2. An integrated management server comprising:
11. A management method executed by an integrated management server, comprising: a receiving step of receiving sales performance information from a plurality of distribution company terminals of a plurality of distribution companies that sell products to the store; a storage step of storing the information acquired from each of the sales performance information in common sales performance information for common management by the plurality of distribution company terminals, the common sales performance information including common identification information of alcoholic beverage products; an updating step of updating product master information for managing alcoholic beverages sold at the store in common among the plurality of distribution companies, the product master information including common identification information of the alcoholic beverages, based on the received sales performance information of each of the distribution companies; an identification step of identifying an alcoholic beverage product by analyzing the product-related information received from the user terminal and comparing it with characteristic information corresponding to the alcoholic beverage product registered in the product master information; A transmission step of transmitting information about the identified alcoholic beverage product to a user terminal; having In the updating step, If an alcoholic beverage product registered in the product master information is present in the common sales record information, common identification information for identifying the corresponding alcoholic beverage product is stored in the common sales record information; If an alcoholic beverage product stored in the common sales record information does not exist in the product master information, common identification information of the non-existent alcoholic beverage product is added to the product master information. The product master information is updated by The method further includes a step of determining a risk of stock shortage of a predetermined product at a predetermined store based on the sales performance information received from each of the plurality of distribution company terminals; In the transmission step, information indicating a risk of running out of the identified alcoholic beverage product is transmitted to the user terminal as information regarding the identified alcoholic beverage product. A management method comprising:
12. A management method executed by an integrated management server, comprising: a receiving step of receiving sales performance information from a plurality of distribution company terminals of a plurality of distribution companies that sell products to the store; a storage step of storing the information acquired from each of the sales performance information in common sales performance information for common management by the plurality of distribution company terminals, the common sales performance information including common identification information of alcoholic beverage products; an updating step of updating product master information for managing alcoholic beverages sold at the store in common among the plurality of distribution companies, the product master information including common identification information of the alcoholic beverages, based on the received sales performance information of each of the distribution companies; an identification step of identifying an alcoholic beverage product by analyzing the product-related information received from the user terminal and comparing it with characteristic information corresponding to the alcoholic beverage product registered in the product master information; A transmission step of transmitting information about the identified alcoholic beverage product to a user terminal; having In the updating step, If an alcoholic beverage product registered in the product master information is present in the common sales record information, common identification information for identifying the corresponding alcoholic beverage product is stored in the common sales record information; If an alcoholic beverage product stored in the common sales record information does not exist in the product master information, common identification information of the non-existent alcoholic beverage product is added to the product master information. The product master information is updated by In the transmission step, based on the sales performance information received from each of the plurality of distribution company terminals, information indicating a store that is likely to handle the specified alcoholic beverage product is transmitted to the user terminal as information regarding the specified alcoholic beverage product. A management method comprising:
13. The management method according to claim 12, The method further includes a step of determining a risk of stock shortage of a predetermined product at a predetermined store based on the sales performance information received from each of the plurality of distribution company terminals; In the transmission step, information indicating a risk of running out of the identified alcoholic beverage product is transmitted to the user terminal as information regarding the identified alcoholic beverage product. A management method comprising:
14. The management method according to claim 11, The information indicating the store that is likely to handle the specified alcoholic beverage product is displayed in association with the information indicating the predetermined store on the map displayed on the user terminal. A management method comprising:
Citation Information
Patent Citations
Device for managing merchandise file
JP2001126142A
Use history registration device and database retrieval- type automatic generation device
JP2001290836A
Article purchase support system, terminal device, and program
JP2003016351A
System and method for confirming stock status of merchandise
JP2003085422A
Information processing apparatus and method, and program
JP2006190126A