JP2014049039A - Shopping support device - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a convenient shopping support device capable of easily deciding a menu by food materials selected by a user, and simultaneously presents a recipe to prevent the user from forgetting to buy food materials when the user decides a menu of dinner at the household or the like.SOLUTION: A shopping support device displays a list of food materials which the user has recently bought and which has drawn attention of the user at storefront on a user's terminal, allows the user to select food materials which the user would like to use from the list, and compares the food materials which the user would like to use and food materials of cuisine in a database storing cuisine recipes, retrieves cuisine appropriate for the food materials which the user would like to use and presents it to the user, and simultaneously displays a recipe on the user's terminal to prevent the user from forgetting to buy food materials.

Description

The present invention relates to a shopping support device using a recipe for cooking, for users who are unable to decide on a menu of meals, based on ingredients selected from the past ingredients purchase history of the user and ingredients that were noticed in the store in advance. The present invention relates to providing a cooking recipe suitable for a user from among cooking recipes stored in a recipe database.

Regarding the purchase of ingredients, if you decide the menu in advance, you can decide the ingredients necessary for it, so refer to the inserts in the newspaper for each ingredient and purchase it so that it meets the conditions such as the sales price In general, a method of purchasing foods by comparing the above is considered. However, in the case of consumers, etc., the menu that had been decided in advance was changed by the attractive ingredients that were found in the store, or they went out for dinner without deciding the menu in advance and were displayed at the store's storefront. It is also common to decide on a menu after looking at a product.

As in the latter case, if the menu is not fixed in advance, it is convenient if the menu can be determined by selecting some products in the store or purchased ingredients and searching for dishes using them. In addition, if a new menu is decided, it will be more convenient if you can easily get information on whether or not the ingredients have been purchased so that you will not have to buy the necessary ingredients or buy the purchased ingredients again. It is.

In recent years, with the development of Internet technology, the store POS information that sells foods, information related to purchased foods, and cooking recipes that can be made using the purchased foods are searched via the network, and the recipe is stored in the user terminal. And systems and methods for recommending and proposing to users have been presented.

In Patent Document 1, by utilizing so-called POS information input at a store, information related to a product purchased by a user is presented on the user's information terminal, and a database for cooking menus and cooking recipes is provided. A product information provision system that reduces the work of creating menus for users by searching for and providing timely cooking recipes using purchased products based on cooking ingredients information such as foods and seasonings purchased by Has been.

Japanese Patent Application Laid-Open No. 2004-228688 includes a food purchase history database that stores a user's shopping history, a menu database that stores a menu for providing a menu, and a food database that stores the ingredients that make up the menu. A method is shown in which a database is compared with food stored in the food database, a menu containing common food is extracted from the menu database, and the menu is proposed to the user.

Further, Patent Document 3 discloses a product information providing system capable of determining a menu and supporting optimal home inventory management by comparing a recipe with a list of products on hand with a computer.

JP-A-11-96214 JP 2004-13331 A JP 2004-126686 A

However, the product information providing system disclosed in Patent Literature 1 searches for information on the products purchased by the user at the point of purchase in the store and cooking recipes that can be made using the purchased products from the database of cooking recipes. It presents a menu that takes nutrition into consideration. However, since it is difficult to respond to cases such as when you want to take in information that you want to use suddenly by looking at information on the materials you have purchased or products at the store, you lack flexibility and flexibility.

In the method disclosed in Patent Literature 2, a menu is recommended with reference to a food purchase history database storing a user's shopping history, and a part of a food recipe history database and a cooking recipe that is an accumulation of past purchase history. It is intended to match the food database that is. However, this method does not recommend menus that take into account the ingredients that you currently own, and because the information stored in the database is moderately updated, the recommended menus are biased. There is. In addition, it is possible to take into account the ingredients specified by the user, but it is necessary to specify after confirming the ingredients currently owned.

In the product information providing system of Patent Document 3, information related to purchased products is managed by a computer, and a system for supporting product management at home in which the computer recognizes the presence of materials necessary for cooking is shown. . However, every time a product is purchased, used or paid out, it is necessary to update the entry / exit information by a bar code reader or manual input, and it is practically difficult to continue the operation with high accuracy.

In the present invention, “Today's menu”, which is a problem of many consumers, can be easily determined at the store by selecting the food that has attracted interest in the store from the latest food purchase history of the user. It is an object of the present invention to provide a convenient shopping support apparatus that can prevent the user from forgetting to buy food by simultaneously presenting the determined recipe for cooking.

The invention of the present application for solving the above-mentioned problems is a transmission / reception means for accepting a plurality of types of requests through a network and returning response data corresponding to each request to a request source, and a purchase history update request specifying a member identifier. On the other hand, the purchase history acquisition means for acquiring the purchase history of the member specified by the member identifier from the POS management system of the store and creating the purchase history information of the member as response data, and the purchase food display specifying the member identifier In response to the request, the product identified by the product identification code in response to the purchase ingredient identification means for creating the list data of the ingredient name corresponding to the purchased product as response data and the product ingredient display request specifying the product identification code The product ingredient identification means that creates the list data of the ingredient names corresponding to the product as response data, the dishes that use the ingredients and ingredients, and the label of the dish In response to a recipe search request that specifies one or more ingredients names, a recipe search means that creates recipe list information of dishes that use the specified ingredients as response data, and each of the means And a control means for controlling the shopping support device. Here, the POS management system of the store stores and holds which member purchased what product when, and provides such information in response to a purchase history update request from the shopping support apparatus.

The recipe search means may compare one or more designated food ingredients with food ingredients stored in the database and create a recipe with a high matching rate as response data in descending order of the matching ratio. Here, the matching rate is a ratio at which a cooking ingredient and a designated ingredient match when a dish is selected from a database storing cooking recipes. For example, the cooking ingredient is composed of six kinds of cooking ingredients. If the specified ingredients match three of them, the ratio is calculated as 50%, and a dish with a large ratio is evaluated as having a high matching rate.

The recipe search means may create response data for a food for which purchase history information exists so that it can be seen that there is purchase history information.

According to the present invention, the user terminal requests the shopping support apparatus to provide information on recent purchase history, whereby the food purchased by the user is stored in the shopping support apparatus, and the most recently purchased food is displayed on the terminal. In addition, it reads the information of the product that attracted attention at the store, displays the name of the product's ingredients on the terminal, and the user selects one or more ingredients from the displayed ingredients, and the shopping support device It is possible to search for recipes of dishes using the selected ingredients. By repeating this procedure several times, the user can decide on a menu that has not been decided yet. Also, by showing the recipe, the user can avoid forgetting to buy the food and can expect the effective use of the food that has already been stocked. .

It is a figure which shows the whole structure of this embodiment. It is a figure which shows an example of the purchase history table. It is a figure which shows an example of the goods table. It is a figure which shows an example of the merchandise food stringing table 183. It is a figure which shows an example of the foodstuff table 184. FIG. It is a figure which shows an example of the recipe table 185. FIG. It is a figure which shows an example of the recipe material table 186. FIG. It is a block diagram which shows an example of the hardware constitutions of the shopping assistance apparatus 100 of this embodiment. It is a block diagram explaining the flow of processing of purchase history acquisition means. It is an example of the display screen of the user terminal 200 on which the TOP screen is displayed. It is a block diagram which shows the flow of a process of the merchandise foodstuff identification means. It is an example of the display screen of the user terminal 200 on which the food material read from the barcode is displayed. It is a block diagram which shows the flow of a process of the purchase ingredients specific | specification means 150. FIG. It is an example of the display screen of the user terminal 200 on which the recent purchase history is displayed. It is a block diagram which shows the flow of a process of the recipe search means. It is an example of the display screen of the user terminal 200 on which the recipe list is displayed. It is an example of the display screen of the user terminal 200 on which recipe details are displayed.

Hereinafter, the configuration of one embodiment of the present invention will be described in more detail with reference to the drawings. Further, in the present embodiment, only the minimum necessary items are illustrated in the explanation for various databases of the shopping support apparatus. However, in actual operation, various items derived from these are added and stored. Has been.

FIG. 1 is a diagram showing an overall configuration of the present embodiment. In FIG. 1, reference numeral 100 denotes a shopping support apparatus, which provides a shopping support service to one or more user terminals 200 on the Internet. The apparatus includes a computer program (detailed description will be described later) and several databases (detailed description will be described later). Further, the shopping support apparatus 100 of the present embodiment realizes a service in a store (store group) managed by the same member identifier (ID), and is connected to the in-store system 400 including the POS management system of the store. Send and receive information between them. The store POS management system is an application program related to a purchase information database in a store that operates on a computer of the in-store system 400, and which member has purchased what product when a request from the shopping support apparatus 100 is received. Information is provided to the shopping support apparatus 100.

Although the network 500 is shown in a simplified manner, it is a combination of a plurality of networks via a gateway such as the Internet, and is composed of a LAN (Local Area Network), a telephone line, a mobile communication network, etc. This is to enable transmission / reception of information between the terminal 200 and the shopping support apparatus 100.

The shopping support apparatus 100 is a server that provides a shopping support service to the user terminal 200, and has a member identifier (ID), a product name purchased by the user, a product code uniquely assigned to a product sold by the store, and a purchase date. The purchase history table 181 that stores the product, the product table 182 that stores information including the product codes of all products sold by the store, and the product name registered in the product table 182 and the food identifier (ID) are linked. A product ingredient linking table 183 to be attached, an ingredient table 184 that associates an ingredient identifier (ID) and an ingredient name, a recipe table 185 that stores recipe identifiers (ID), dish names, and how to make dishes for each dish, and dishes Recipe material table 18 listing recipe identifiers (ID), material names, and food material identifiers (ID) for the ingredients to be used. Provided with each of the database.

FIG. 2 is a diagram illustrating an example of the purchase history table 181. One record (one record) in the purchase history table 181 is an example in which the member ID, purchased product name, product code, and purchase date of the purchased member are configured. Records of the purchase history table 181 are generated by the purchase history acquisition means 130 (detailed functions will be described later), and information on a plurality of members can be stored simultaneously.

FIG. 3 is a diagram illustrating an example of the product table 182. One record (1 record) in the product table 182 is an example in which the product name, product code, manufacturer or sales company name, quantity and capacity, and other information in the store are configured.

FIG. 4 is a diagram showing an example of the commodity food stringing table 183. One record (one record) in the product table 183 is an example in which the product code and the food item ID in the store are configured. If the products with different product codes are the same as the food, the same food ID is assigned.

FIG. 5 is a diagram illustrating an example of the food table 184. In this example, one record (one record) in the food table 184 is composed of a food ID and a food name.

FIG. 6 is a diagram illustrating an example of the recipe table 185. In this example, one record (one record) in the recipe table 185 is composed of a recipe ID, a dish name, and a method of making (text information).

FIG. 7 is a diagram illustrating an example of the recipe material table 186. One record (one record) in the recipe material table 186 is an example in which it is composed of a recipe ID, a material name, a food material ID, and a quantity. The recipe material table 186 is obtained by dropping the food ingredients presented in the recipe table 185 into the food ingredient ID. That is, for the ingredients included in the text information registered as a method of creating the recipe table 185, the ingredient name and the corresponding ingredient ID are listed side by side.

The shopping support apparatus 100 also includes a purchase history acquisition unit 130 for registering information on products purchased by the user in the purchase history table 181, a product ingredient specifying unit 140 for specifying the ingredient name of the product that the user wants to use, and a user Purchased ingredient specifying means 150 for specifying the names of ingredients of purchased products, recipe search means 160 for presenting dishes that can be made using ingredients that the user wants to use, and control means 120 for controlling these means in association with the database And a program module functioning as each of the transmission / reception means 110 for transmitting / receiving data to / from the user terminal 200 and the in-store system 400 via the network 500.

Although not particularly illustrated, the user terminal 200 includes a communication unit that transmits and receives data to and from the shopping support apparatus 100.

FIG. 8 is a diagram illustrating a hardware configuration of the shopping support apparatus 100. The shopping support apparatus 100 is a single computer system as hardware. As shown in FIG. 8, the shopping support apparatus 100 includes a control unit 101, a storage unit 102, a peripheral device I / F unit 103, an input unit 104, a display unit 105, and a communication unit 106, which are connected via a bus 109. Is done. Note that the hardware configuration in FIG. 8 is merely an example, and various configurations can be employed depending on the purpose.

The control unit 101 includes a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory), and the like. The CPU calls a program stored in the storage unit 102, ROM, recording medium or the like to a work memory area on the RAM, executes it, drives and controls each device connected via the bus 109, and performs processing performed by the computer. Realize. The ROM is a non-volatile memory, and permanently stores programs such as a boot program and BIOS of the shopping support apparatus 100, data, and the like. The RAM is a volatile memory, and temporarily stores a program, data, and the like loaded from the storage unit 102, ROM, recording medium, and the like, and includes a work area used by the control unit 101 for performing various processes.

  The storage unit 102 is an HDD (hard disk drive), and stores a program executed by the control unit 101, data necessary for program execution, an OS (operating system), and the like. With respect to the program, it functions as a control program corresponding to an OS (operating system), a program code that functions as a purchase history acquisition unit 130 described later, a program code that functions as a product ingredient specifying unit 140, and a purchase ingredient specifying unit 150. A program code that functions as the recipe search means 160 is stored. Each of these program codes is read by the control unit 101 as necessary, transferred to the RAM, and read and executed by the CPU to function as various means.

  The peripheral device I / F (interface) unit 103 is a port for connecting the peripheral device to the shopping support apparatus 100, and the computer transmits and receives data to and from the peripheral device via the peripheral device I / F unit 103. The peripheral device I / F unit 103 is configured by USB, IEEE 1394, RS-232C, or the like, and usually has a plurality of peripheral devices I / F. The connection form with the peripheral device may be wired or wireless.

  The input unit 104 inputs data, and includes, for example, a keyboard, a pointing device such as a mouse, and an input device such as a numeric keypad. An operation instruction, an operation instruction, data input, and the like can be performed on the shopping support apparatus 100 via the input unit 104. The display unit 105 includes a display device such as a liquid crystal panel, and a logic circuit (such as a video adapter) for realizing the video function of the shopping support device 100 in cooperation with the display device.

  The communication unit 106 includes a communication control device, a communication port, and the like, and is a wired or wireless communication interface that mediates communication between the shopping support device 100 and the network 500, and communicates with other computers via the network 500. Perform communication control. The bus 109 is a path that mediates transmission / reception of control signals, data signals, and the like between the devices.

Although not specifically shown, the user terminal 200 has a hardware configuration similar to that of the shopping support device 100, and the communication unit includes a communication control device, a communication port, and the like. A communication interface that mediates communication between them, and includes a communication unit that performs communication control with another computer, in particular, the shopping support apparatus 100 via the network 500.

FIG. 9 is a block diagram illustrating a processing flow of the purchase history acquisition unit 130. The user activates an application program that receives a shopping support service, which is one of the services in the store, from the user terminal 200 (S31). When the application program is started, the user terminal 200 transmits a purchase history acquisition request specifying a store member identifier (ID) to the shopping support apparatus 100 using the communication means of the user terminal. When the shopping support apparatus 100 receives a purchase history acquisition request including a member identifier via the transmission / reception means 110, the shopping support apparatus 100 activates the purchase history acquisition means 130 via the control means 120.

The purchase history acquisition unit 130 transmits the member identifier received from the user terminal 200 to the in-store system 400 via the transmission / reception unit 110 (S32). The in-store system 400 refers to the member database 410 and authenticates whether the member is a legitimate member (S33). If authenticated, the in-store system 400 acquires purchase history data of the member from the POS management system 410 and returns the history data to the shopping support apparatus 100. (S34). When the shopping support apparatus 100 receives the purchase history data via the transmission / reception means 110, it passes the data to the purchase history acquisition means 130 through the control means 120, and the purchase history acquisition means 130 stores the received purchase history data in the purchase history table 181. Are written in such a manner that there is no duplication, or after deleting the record related to the previous member (S35). When these processes are completed, the purchase history acquisition unit 130 creates a TOP screen (S36, FIG. 10) and transmits it to be displayed on the user terminal 200 via the transmission / reception unit 110.

FIG. 10 is an example of a display screen of the user terminal 200 on which the TOP screen is displayed. First, when considering the menu, the ingredients to be used for cooking are selected (D10). For this purpose, a button (D11) for requesting selection of ingredients to be used by reading a barcode attached to the product at the store and a purchase history display request for selecting the ingredients to be used from the latest purchase history are requested. The button (D12) to be displayed is displayed and can be selected. In this example, this screen is also used for a recipe list display request (D21).

FIG. 11 is a block diagram illustrating a processing flow of the commodity food specifying unit 140. “Bar code reading” (D11 in FIG. 10) selected from the user terminal 200 by reading the barcode given to the product at the storefront from the TOP screen (FIG. 10) when selecting the ingredients to be used for the above-mentioned cooking. Is selected, the application program of the user terminal 200 displays the screen of FIG. While this screen is displayed, the barcode reading mode is set (the “New Reading” (D37) button is selected), and after the barcode is photographed, the scanned barcode is analyzed, and the barcode information (product code) and the product are displayed. The food item specifying request is transmitted to the shopping support apparatus 100. When the shopping support apparatus 100 receives the barcode information via the transmission / reception means 110, the shopping support apparatus 100 activates the commodity food specifying means 140 through the control means 120, and specifies which food the product hits. Specifically, the corresponding product is specified in the product table 182 using the received product code as a key (S41), and the food product linking table 183 is referenced to specify which food product the product corresponds to (S42). . When this process is completed, the commodity food specifying unit 140 creates a list screen of the read foods (S43, FIG. 12). If a list screen of ingredients already read has been created at this time, a list screen is created so that a list of new ingredients is added thereto, and this screen data is transmitted to the user terminal 200 via the transmission / reception means 110. Send to display on.

FIG. 12 is an example of a display screen of the user terminal 200 on which a “read food” screen when a product barcode is read at a store is displayed. The names as food ingredients are listed in order of the read merchandise (D30). Here, a check box can be checked and selected to use the displayed ingredients as a “recipe selection” key (D31). Further, when it is desired to continue reading the next food, the “new reading” (D37) button is selected, and when returning to the TOP screen, the “TOP” (D39) button is selected.

FIG. 13 is a block diagram showing the flow of processing of the purchased food specifying means 150. When selecting the ingredients to be used for the above-mentioned cooking, the user selects “Select from purchase history” (D12 in FIG. 10) that requests the purchase ingredients display to select from the most recent purchase history from the TOP screen (FIG. 10). The application program of the terminal 200 transmits a purchase food display request to the shopping support apparatus 100 together with the member identifier of the user (S51). When the shopping support apparatus 100 receives this request via the transmission / reception means 110, it activates the purchased food specifying means 150 through the control means 120, and acquires the name of the purchased product by referring to the record relating to the member in the purchase history table 181. Then, the product name linking table 183 and the food table 184 are used to convert the name into a food name, and a purchase history list screen (S52, FIG. 14) is created and displayed on the user terminal 200 via the transmission / reception means 110. Send. Regarding the creation of a purchase history list screen, for example, 20 items of items having the member identifier are extracted from the purchase history table 181 in order of purchase date, or all products within one week from the purchase date are extracted. List using rules.

FIG. 14 is an example of a display screen of the user terminal 200 that requests the purchase history display and displays the “recent purchase history” screen. The purchase dates are listed in order of new ingredients (D40). Here, a check box can be checked and selected to use the displayed ingredients as a “recipe selection” key (D41 and D42). In addition, this screen can be scrolled to display and select all the listed ingredients. Here, to return to the TOP screen, the “TOP” (D49) button is selected.

FIG. 15 is a block diagram showing the flow of processing of the recipe search means 160. In the user terminal 200, after selecting one or more ingredients as keys on the “read ingredients” screen and the “recent purchase history” screen (S61), the process returns to the TOP screen (FIG. 10), and the recipe list is displayed. When the display is requested (D21), the application program of the user terminal 200 transmits the selected food data to the shopping support apparatus 100 together with a recipe list display request.

When the shopping support apparatus 100 receives a recipe list display request via the transmission / reception means 110, the shopping support apparatus 100 activates the recipe search means 160 through the control means 120, and searches for and lists the recipes for the dishes using the selected ingredients. Specifically, the selected food material is converted into a food material ID in the food material table 184, and the food material ID included in the record having the same recipe ID and the selected food material ID are referred to by referring to the recipe material table 186. A matching recipe ID is extracted, and a recipe having this recipe ID is extracted from the recipe table 185. When this process is completed, the recipe search means 160 displays the recipe list screen (S62, FIG. 16) and detailed information on each recipe. A recipe detail screen to be presented (S62, FIG. 17) is created and transmitted to be displayed on the user terminal 200 via the transmission / reception means 110.

In the recipe search method, for example, 10 recipes having a high rate of matching the food ID included in each recipe ID with the selected food ID may be searched and presented in order of high matching rate. Good.

FIG. 16 is an example of a display screen of the user terminal 200 on which the “recipe list” screen is displayed. Information on the recipe searched by the recipe search means 160 is displayed (D50). When it is desired to acquire detailed information of these recipes, the corresponding dish name is selected (D51), and the “recipe details” button (D59) is selected.

FIG. 17 is an example of a display screen of the user terminal 200 on which the “recipe details” screen is displayed. Detailed information on the recipe of the dish selected on the recipe list screen is displayed (D60). To return to the recipe list, the “recipe list” (D69) button is selected.

In the “recipe details” screen, for a food item having a recently purchased history, that fact may be clearly indicated on the screen. (☆ mark of D61 in Fig. 17)

According to this embodiment, it is possible to easily display a list of recently purchased ingredients on the screen of a mobile phone (smartphone) by the user and to carry the mobile phone by reading the attached barcode even when an attractive product is seen at the store. Similarly, a list of ingredients can be displayed on the telephone screen, and by selecting some of those ingredients, recipes for cooking using them can be searched and displayed. If you use this function, for example, you can search for recipes based on recently purchased ingredients or search for recipes mainly for ingredients that you noticed at the store, even if you haven't decided on a menu for dinner. The menu can be determined, and the recipe is displayed on the screen, so that it is possible to prevent the user from forgetting to buy the food and to effectively use the food that has already been stocked.

The present invention is not limited to the above-described embodiments, and various modifications and applications are possible within the scope of the claims. For example, in the present embodiment, the operation in a store that can be managed with the same member identifier (ID) is taken as an example, but if managed with the same member identifier (ID), the operation is performed across a plurality of store groups. be able to. Moreover, even if it is portable terminals, such as a tablet-type personal computer, as a user terminal, it is possible to implement this invention similarly.

DESCRIPTION OF SYMBOLS 100 Shopping support apparatus 101 Control part 102 Memory | storage part 103 Peripheral equipment I / F part 104 Input part 105 Display part 106 Communication part 110 Transmission / reception means 120 Control means 130 Purchase history acquisition means 140 Commodity food identification means 150 Purchase food identification means 160 Recipe search Means 181 Purchase history table 182 Commodity table 183 Commodity food linking table 184 Food table 185 Recipe table 186 Recipe material table 200 User terminal 400 In-store system 410 POS management system 420 Member database 500 Network

Claims (3)

A transmission / reception means for accepting a plurality of types of requests through the network and returning response data corresponding to each request to the request source;
Purchasing history acquisition means for acquiring a purchasing history of a member specified by the member identifier from a predetermined POS management system in response to a purchasing history acquisition request specifying the member identifier, and creating the purchasing history information of the member as response data When,
In response to a product ingredient specification request that specifies a product identification code, a product ingredient identification unit that adds list data of the ingredient name corresponding to the product identified by the product identification code and creates response data;
In response to a purchase ingredient display request specifying a member identifier, a purchase ingredient specifying means for creating list data of the ingredient name corresponding to the purchased product as response data,
A database of ingredients and dishes that use ingredients and cooking recipes;
In response to a recipe search request that specifies one or more ingredients names, a recipe search means that creates recipe list information of dishes that use the specified ingredients as response data;
A shopping support apparatus comprising: control means for controlling the means. 2. The recipe retrieval unit according to claim 1, wherein the recipe search unit compares the one or more designated ingredients with the ingredients of the dish stored in the database and creates a recipe with a high matching rate as response data in descending order of the matching rate. Shopping support equipment. 2. The shopping support apparatus according to claim 1, wherein the recipe search unit creates response data so that it can be understood that the purchase history information is present for the ingredients having the purchase history information.

Images