JP2006171137A - Price sticker and price sticker creation system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a price sticker with which more information is provided for customers, and to provide a system for creating such a price sticker. <P>SOLUTION: In a food item to be stuck name-placing section for S1, food material name, place of manufacture and price information are allocated with a prescribed size. In a two-dimensional code placing section S2, a two dimensional code, in which detailed information of the food material is recorded, is printed. In a bar code placing section S3, the bar code which is coded from bar code information of the food material to be stuck is printed. In a required food placing section S4, information other than the food to be stuck which is used for cooking is printed. In a recipe-placing section S5, a recipe of the cooking is printed. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a price reel that is affixed to a food package for displaying a price in a store that sells the food, and a technology for creating a price seal.

  2. Description of the Related Art Conventionally, in stores selling grocery items such as supermarkets, a price seal for displaying a price is affixed to the package of the food, and the food is sold. Such price seals are generally printed with the price of the food, the name of the food, the content, the expiration date, the production area, the barcode, and the like.

On the other hand, the store side is making various sales efforts to promote sales of ingredients and improve customer convenience, but a recipe card is placed in the store to help customers think about menus. One of them is. This recipe card describes ingredients, how to make, and the like (see, for example, Patent Document 1).
JP 2004-74604 A

  However, the recipe card as described above is not necessarily seen by all customers, and even if it is actually placed in the food selection area, it may be overlooked at the time of purchase.

  In view of the above, it is an object of the present invention to provide a price seal that can provide more information to a customer and a system for creating such a price seal.

  In order to solve the above problems, in the present invention, the price of food to be pasted is displayed, and the price sticker that is pasted on the food is used as the food. A cooking recipe is posted, and a two-dimensional code in which detailed information on the food to be pasted is recorded is placed. In addition, the present invention provides a system for creating a price seal, a recipe database that records information on ingredients used for each dish, an ingredient inventory database that records the inventory status of ingredients, and an object to be pasted that is food to be pasted The present invention relates to a recipe extracting means for extracting a dish using food as an ingredient from the recipe database, an ingredient information extracting means for extracting information on ingredients used for the extracted recipe from the ingredient inventory database, and the pasting target food. Code conversion means for converting detailed information into a two-dimensional code; and allocation means for creating allocation data by allocating the price information of the food to be pasted, the extracted recipe, and the two-dimensional code obtained by the conversion to a predetermined layout And a price sticker printer for printing the allocation data on sticker paper. It is characterized in.

  According to the present invention, on the price seal, the recipe of the dish using the target ingredient is posted, and the two-dimensional code recording the detail information of the ingredient is posted, so more information for the customer It is possible to provide an effect. In addition, according to the present invention, when selecting a product on the sales floor by placing recommended recipe information on the price sticker on which the price and expiration date information that the consumer confirms when purchasing the product are listed, It is possible to effectively propose recipes to consumers, and to guide consumers to purchasing behavior. By giving the price sticker information indicating the store sales location of ingredients other than the ingredients listed in the recipe information, the customer can complete the purchase of the ingredients in a short time without any hesitation. Can be invited to bulk purchase. Information that cannot be posted on the sticker, such as the place of production, producer, and production method, is recorded in a two-dimensional code and can be read and viewed on the monitor of the mobile phone terminal.

DESCRIPTION OF EMBODIMENTS Hereinafter, preferred embodiments of the present invention will be described in detail with reference to the drawings.
(System configuration)
First, a price seal production system according to the present invention will be described. FIG. 1 is a functional block diagram showing an embodiment of a price seal producing system of the present invention. In FIG. 1, 10 is a recipe database, 20 is an ingredient database, 30 is an object ingredient input means, 40 is a recipe extraction means, 50 is an ingredient information extraction means, 60 is a code conversion means, 70 is an allocation processing means, and 80 is a price seal. A printer 90 is an in-store diagram storage means.

  The recipe database 10 is a database that records necessary ingredients and how to make them (so-called recipes) for each dish. The food database 20 is a database in which information related to foods sold at the store is recorded. The target food material input means 30 is for inputting information for specifying the food material to which the price sticker is to be attached. The recipe extraction unit 40 has a function of extracting information about the dish using the ingredients from the recipe database 10 using the ingredient information input from the target ingredient input means 30. The ingredient information extracting unit 50 has a function of extracting information on ingredients used in the dish extracted by the recipe extracting unit 40 from the ingredient database 20. The code converting means 60 has a function of converting predetermined information out of the information extracted by the food material information extracting means 50 into a two-dimensional code. The assignment processing means 70 has a function of creating assignment data in which the recipe information extracted by the recipe extracting means 40, the ingredient information extracted by the ingredient information extracting means 50, and the two-dimensional code converted by the code converting means 60 are laid out. Yes. The price sticker printer 80 has a function of printing the assignment data received from the assignment processing means 70 on a sticker sheet. The in-store diagram storage unit 90 is a storage unit that stores in-store diagram data representing the layout of the store.

  The system shown in FIG. 1 is actually realized by a computer executing dedicated software. That is, information registered in the recipe database 10 and the food database 20 is recorded in a storage area secured in an external storage device of a computer such as a hard disk, and the recipe extraction means 40, the food information extraction means 50, the code conversion means 60, The allocation processing means 70 is executed by a computer according to a dedicated program. The target food material input means 30 is realized by combining an input device such as a keyboard and a mouse with a GUI. As the price sticker printer 80, a dedicated printer for sticker printing can be employed.

  Here, information recorded in the recipe database 10 and the food database 20 will be described. FIG. 2A is a diagram illustrating an example of recipe information recorded in the recipe database 10. As shown in FIG. 2A, information on the dish name, how to make, the dish image, the season, the climate, the ingredients, and other items is recorded in association with the recipe ID that specifies the recipe information. Of the items shown in FIG. 2A, “how to make” expresses how to make in text and is recorded as text data. “Cooking image” is image data obtained by photographing the completed state of cooking. In the “season” item, seasons such as “spring”, “summer”, “autumn”, and “winter” are recorded. In the “climate” item, information that combines weather such as “sunny”, “cloudy”, “rainy”, and “hot” “cold” is recorded. In the “food” item, food necessary for the food is recorded with a food ID that identifies the food. There are a plurality of “food ingredients” items such as food ingredients A, food ingredients B,... Corresponding to the number of food ingredients required for cooking.

  FIG. 2B is a diagram illustrating an example of food information recorded in the food database 20. As shown in FIG. 2 (b), information on the ingredients name, display position, price, quantity in stock, production area, producer, pesticide, feed, sugar content, and other items corresponding to the ingredient ID that specifies the ingredient information. Is recorded. Other items include recorded nutrients such as vitamins and minerals. Among the items shown in FIG. 2B, the “display position” is a record of the display position in the store in association with an in-store diagram to be described later.

(Processing operation)
Next, the processing operation of the price seal creation system shown in FIG. 1 will be described. First, the worker obtains a list of ingredients published in a leaflet distributed by inserting a newspaper for a period including the day. This can be obtained from, for example, a leaflet information database (not shown) that records leaflet publication information of ingredients. Subsequently, the worker inputs a food material ID for specifying a food material listed in the obtained food material list from the target food material input means 30. Then, the recipe extraction means 40 searches the recipe database 10 with the input food ID. Further, as a result of the search, the recipe extracting means 40 extracts a recipe according to the current season and climate from the corresponding recipes as a recipe to be posted on the price seal. For example, the season information is recorded in the recipe database 10 for the season, the one corresponding to the date information managed by the computer is extracted, and the weather, temperature, etc. are recorded in the recipe database 10 for the climate. In addition, it is only necessary to separately input the state of the current day and extract the one that matches it.

  Subsequently, the food material information extraction unit 50 searches the food material database 20 using the food material ID included in the recipe information extracted by the recipe extraction unit 40. As a result of the search, information on the corresponding food material is extracted. At this time, if a food product whose stock quantity is equal to or less than a predetermined number is included, that fact is passed to the recipe extracting means 40. Then, the recipe extracting unit 40 passes other recipe information to the food material information extracting unit 50. And when the stock quantity of all the foodstuffs finally used is more than predetermined value, those foodstuff information is extracted from the foodstuff database 20. FIG. At this time, along with other ingredients information recorded in the recipe information, information about the ingredients to be pasted is also extracted from the ingredients database 20, but the ingredients to be pasted are more detailed than other ingredients. Extract information. Specifically, for other ingredients, only the ingredient name, price, and display position need to be extracted, but for the ingredients to be attached, product images, barcode information, production areas, producers, and others (vegetables) In the case of, extract information on the agricultural chemicals used, in the case of meat, the feed provided, in the case of fruits, sugar content, etc.). At this time, information on the display position of the food is also extracted from the food database 20. In addition, it is also possible to create a recipe using the ingredients listed on the flyer. In this case, the above-mentioned leaflet information database stores a list of ingredients posted on the leaflet. The food material information extracting means 50 extracts food material information that matches the food material extracted from the leaflet information database from the food material database 20, and performs the same processing as described above.

  Next, the code conversion means 60 converts more detailed information extracted about the foods to be pasted out of the food information extracted by the food information extraction means 50 into a two-dimensional code. A process of converting predetermined information into a two-dimensional code is performed. More detailed information can be appropriately changed according to the setting, but in this embodiment, in the present embodiment, the production area of the ingredients, the producer, others (agricultural chemicals used in the case of vegetables, feeds and fruits given in the case of meat) In the case of sugar content). As the two-dimensional code, for example, a well-known QR code can be used. Since the technique for converting the predetermined information into the two-dimensional code is well known, detailed description thereof is omitted.

  The allocation processing means 70 receives the recipe information received from the recipe extracting means 40, the ingredient information received from the ingredient information extracting means 50, the two-dimensional code received from the code converting means 60, and the in-store diagram data extracted from the in-store diagram storage means 90. The allocation process is executed according to the layout set in advance. In the in-store map data, a process of arranging a corresponding number at a position corresponding to the display position of each food is performed. Thereby, allocation data in which each information is allocated to a predetermined position is obtained. This allocation data is transferred to the price sticker printer 80 and printed on a sticker sheet set in advance. As the sticker paper, a well-known paper having a structure having at least three layers of a base material layer to be printed, an adhesive layer for sticking, and a release layer for protecting the adhesive layer can be used. The operator peels off each price seal from the release paper (release layer) on the printed sticker paper, and affixes it to the package of the foodstuff to be sold.

(Price seal)
A plan view of the price seal prepared as described above is shown in FIG. In FIG. 3 (a), S1 is a pasting target ingredient name posting section, S2 is a two-dimensional code posting section, S3 is a barcode posting section, S4 is a necessary ingredient posting section, and S5 is a making method posting section. In the pasting target food name publishing section S1, information on the name of the food, the place of production, and the price extracted from the food database 20 are assigned with a predetermined size. The name of the ingredient is displayed in a state where the name of the dish using the ingredient is added in addition to the name of the ingredient. The two-dimensional code received from the code conversion means 60 is printed on the two-dimensional code posting part S2. In the bar code posting part S3, bar code information of the pasting target food material extracted from the food material database 20 is printed as a bar code. In the necessary ingredient listing unit S4, information about ingredients other than the ingredients to be pasted extracted from the ingredient database 20 is printed. In the example of FIG. 3A, the necessary ingredient listing unit S4 shows the unit price of each ingredient. However, the total price of these ingredients may also be printed. In the production posting section S5, the production extracted from the recipe database 10 is printed. FIG. 3B shows an image when the price seal is used. As shown in FIG. 3 (b), the price seal of the present invention is affixed to the upper surface of the package of the product to be affixed, similarly to the conventional price seal.

  The information assigned to the price seal can be changed by setting. FIG. 4 shows another type of price seal different from that shown in FIG. The example of FIG. 4 is characterized in that in addition to what is shown in FIG. 3A, a dish image posting part S6 and a food display position posting part S7 are provided. The dish image extracted from the recipe database 10 is printed in the dish image posting unit S6. In the food display position posting unit S7, the display positions of foods other than the food to be pasted extracted from the food database 20 are indicated by corresponding numbers. Instead of the two-dimensional code, a non-contact type IC tag may be attached to the price seal, and information such as a food production place and a producer may be embedded in the non-contact type IC tag.

(Use of price seal)
As shown in FIG.3 (b), a price seal is stuck and used for a foodstuff. With the price seal according to the present invention, the user can know not only the name and price of the food but also the dish using the food and the recipe. In addition, when the user has a terminal equipped with a two-dimensional code recognition function, the two-dimensional code posted on the price sticker is read using this and the food recorded in the two-dimensional code is used. You can learn more about the locality, producer and other details. In recent years, since mobile phones capable of recognizing a two-dimensional code have become widespread, it is possible to display information recorded on the two-dimensional code on the screen of the mobile phone by using such a mobile phone. . In this case, in the present invention, the access information recorded in the two-dimensional code is used to access another computer and the information is not obtained, but the information is directly two-dimensionally encoded and recorded. Therefore, it is possible to obtain information directly. This eliminates the need for a communication fee for accessing other computers.

It is a functional block diagram which shows one Embodiment of the price seal production system of this invention. It is a figure which shows an example of the information currently recorded on the recipe database 10 and the foodstuff database. It is a figure which shows an example of the state which looked at the price seal from the plane, and the utilization state of a price seal. It is a top view which shows the other example of a price seal.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 ... Recipe database 20 ... Ingredient database 30 ... Target food input means 40 ... Recipe extraction means 50 ... Ingredient information extraction means 60 ... Code conversion means 70 ... Assignment processing means 80 ... Price seal printer 90 ... Store diagram storage means

Claims (5)

A price sticker that displays the price of food to be affixed and is affixed to the food.
Price sticker characterized in that a recipe for cooking using food to be applied as a food ingredient is posted and a two-dimensional code in which detailed information about the food to be applied is recorded is posted .   The price seal according to claim 1, wherein the recipe includes information on how to prepare a dish and necessary ingredients, and prices of each ingredient are listed for the ingredients. Recipe database that records information about ingredients used for each dish,
An ingredient database that records the inventory status of ingredients;
Recipe extraction means for extracting, from the recipe database, a dish that uses the food to be applied, which is the food to be applied, as an ingredient,
Ingredient information extracting means for extracting information on ingredients used for the extracted recipe from the ingredient inventory database;
Code conversion means for converting detailed information about the food to be pasted into a two-dimensional code;
Price information of the food to be pasted, the extracted recipe, an allocation processing means for allocating a two-dimensional code obtained by the conversion to a predetermined layout and creating allocation data;
A price sticker printer for printing the allocation data on sticker paper;
A price seal production system characterized by comprising: The food information extraction means is for extracting display position information in the store of the food for the food used in the recipe,
4. The price seal creation system according to claim 3, wherein the allocating unit performs a process of marking a position specified by the display position information on an in-store diagram representing an in-store layout. It also has a flyer information database that records information on food leaflets,
5. The recipe extracting unit according to claim 3, wherein the recipe extracting unit extracts, from the recipe database, a dish that uses ingredients included in the ingredient list extracted from the flyer information database. Price seal creation system.

Images