JPH09319791A - Sales promotion supporting system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To consistently support sales promotion effective for a seller by extracting stock information and relish limit information of food from a system for managing merchandise at the store of a super market or a department store, leading out the combination of merchandise contributing to the sales promotion of the seller from these conditions in the frame of a cooking menu and visually providing information concerning the cooking menu. SOLUTION: A central processor 101 extracts a cooking menu using merchandise (material) from a storage device 105 by setting merchandise designated by an input device 102 to be a key. A cooking menu to retrieve is designated by the input device 102 and concerning merchandise necessary for the designated cooking menu, the central processor 101 extracts stock information and relish limit information of food from the storage device 105 to judge whether it is effective for utilizing sales promotion. The judging result is displayed on a display 103 and a sales promoter selects a cooking menu for utilizing for sales promotion. Detailed information on the selected cooking menu is outputted from a display 107 and a printer 109 installed at the store.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention provides a person in charge of sales with information about a product in a backyard of a supermarket or a department store, when the person in charge of sales promotion selects a product to be used for sales promotion of groceries. The present invention relates to a sales promotion support system that supports the decision making by processing and outputting, and further provides information on a cooking menu in which selected products are most effectively combined to consumers at a store.

[0002]

[Prior Art] When a sales promotion person plans a sales promotion in a grocery section, such as a supermarket or a department store, the item used for the sales promotion may be a low purchase price or a seasonal item. Products purchased in large quantities,
We select products whose inventory is increasing and products whose expiration date is approaching.

As a conventional technique for supporting the product selection of the person in charge of sales promotion, a stock information retrieval system for comparing the stock information on the day and the standard stock information or a standard stock is detected to indicate that the stock is excessive. Or an inventory information search system for searching for expiration date information.

As a conventional technique for supporting sales promotion in stores, an information terminal is installed to provide information such as food images and recipes that arouse the consumer's willingness to purchase depending on the season and the weather. It can be mentioned that the service such as “do” is being carried out.

However, since the selection of the sales promotion product and the provision of the cooking information at the store are performed from different viewpoints, there is a problem that the sales promotion is not always effective for the seller.

[0006]

SUMMARY OF THE INVENTION In order to solve the above-mentioned problems, according to the present invention, a system for managing goods in a backyard of a supermarket or a department store is used to purchase a large amount of purchased goods, overstocked goods, and overstocked goods. Supporting the decision-making of sales promotion staff by providing information that enables selection of combinations that can effectively promote sales promotion product candidates, such as probable products and products with expiry dates. Further, by providing the selected food menu to consumers from the information terminal installed in the store, the seller side supports the sales promotion efficiently and effectively.

[0007]

In order to achieve the above object, the present invention provides a dedicated terminal for a person who connects at least a display device and an input device in a backyard of a supermarket or a department store, and at least a display device and an output device in a store. Connect the consumer-only terminal connected to the storage device, the storage device that stores the inventory information and cooking information of the product that is a part of the product management system, the person-in-charge terminal and the storage device, and the consumer-only terminal and the storage device A sales promotion support system consisting of a communication line and a radio, which determines purchasing information, inventory amount information, expiration date information, etc. stored in a storage device according to a certain standard when the terminal dedicated to the person in charge is activated. The judgment result is displayed on the display device of the dedicated terminal to assist the person in charge in decision making.

[0008] The input of the menu requested by the person in charge is received from the input device, the detailed information of the food menu is read out from the storage device by using the menu code requested by the person in charge as a key, and the food menu information is used as the consumer-specific terminal. Display device and output to an output device.

[0009]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be described in detail below with reference to screens.

FIG. 1 is a block diagram of a sales promotion support system according to the present invention, which is a central processing unit 101 including a CPU, a disk storing a program, and a memory.
Input device 102, display device 1 in the backyard
03, a storage device 106 of an external system 105 connected by a communication line or wireless 104, a display 107, a touch panel 108, and a printer 109. The central processing unit 101, the input device 102, the display device 103, and the storage device 106 are installed in a backyard of a supermarket or a department store, or a host center, and the display 107, the touch panel 108, and the printer 109 are It is installed in supermarkets and department stores. The external system 1
Reference numeral 05 denotes a store management system or the like in a store of a supermarket or a department store.
A person skilled in the art can easily infer that it has a function of managing products such as S information.

FIG. 2 shows a product inventory table 2 stored in the storage device 106. The product inventory table 2 is
Identification number 21, product name 22, expected stock amount 23 for today predicted when ordering the product, actual inventory amount 2 for today registered today
4. It is a set of records composed of 25 days until the expiration date of inventory. The product inventory table has a relational database format. here,
The method of calculating the planned inventory quantity will be described.

It is considered that a person in charge of purchasing a product places an order when ordering a product, based on the stock amount on the day and the sales forecast amount after the day. In other words, "actual inventory amount on the day"-"sales forecast amount on the day" = "planned inventory amount on the next day" is derived, and actual ordering is performed while observing the transition of the planned inventory derived by repeating this. Think of things. The transition of the planned inventory is a numerical value calculated at the time of placing an order, and the numerical value is updated every time an order is placed. At the time of starting this system, the data stored in the cell of the column of the planned inventory amount 23 of the relevant product inventory table 2 by fetching the planned inventory amount, the actual inventory amount, and the expiration date information from the inventory DB of the store management system. Actual inventory 2
The data stored in the cells in column 4 and the expiration date 25
Update the data stored in the cell of the column.

FIG. 3 shows the product master table 3 stored in the storage device 106. The product master table 3
Is an identification number 31, a product name 32, an inventory standard value 33 that is an upper limit inventory amount that can be added to the planned inventory amount, and a number of days before the expiration date when it is necessary to pay attention to the expiration date. It is a set of records constituted by the expiration date reference value x34 and the expiration date grace days y35 when it is absolutely necessary to take a move. It is necessary for the person in charge to store the data as reference values in advance in the cells in the columns of the inventory reference value 33, the expiration date reference value x34, and the expiration date reference value y35. The format of the product master table is a relational database format.

FIG. 4 shows the cooking master table 4 stored in the storage device 106. The food master table has an identification number m41, a food genre name 42, an identification number n.
It is a collection of records composed of 43, cooking name 44, material / unit 45, quantity 46, cooking procedure 47, and season 48. If the dish name 44 has seasonality, the number of months corresponding to the cell in the column of season 48 is stored. For example, if the dish name 44 is chow hot pot, 11-2 is stored in the cell in the column of season 48, which indicates that the season dishes are from November to February. In addition, if there is no seasonality, 1-12 is stored. Since the dishes are classified according to genre and the season information is added in the dish master table, information can be provided in a useful form to assist the salesperson in charge in selecting the dish menu. .

FIG. 5 is a flow chart showing the processing steps during operation of the sales promotion support system according to this embodiment.

At the time of sales promotion planning, the sales promotion person activates the sales promotion support system, displays the candidate product input screen of FIG. 6 on the display device 103, and inputs the candidate product. (Step 501) FIG. 6 shows an example of the candidate product input screen. The sales person in charge selects one of the candidate products from the candidate products and uses the input device 102 to display the product.
Input of the product information selected by the person in charge from the product names 61 displayed in No. 3 is accepted. When proceeding to the next operation, the input of the decision 62 is accepted via the input device 102.

The dish master table 4 stored in the storage device 106 is fetched into the central processing unit 101, and only the records containing the ingredients selected in step 501 are extracted from the dish master table 4. Further, the season 48 in the record is matched with the calendar information built in the central processing unit 101, only the corresponding record is extracted from the dish master table 4 and the candidate menu selection screen of FIG. 7 is displayed. In this embodiment,
Suppose you select "carrot" as the product you want to use. At this time, "carrot" from the dish master table
Search for food name 44 with "" as a key and search for "beef stew"
Although it is extracted as "Porny pot" and others, if the day is H8.7.21, and it matches with the cell information "11-2" of season 48, it will be deleted because it is not applicable and will be displayed on the candidate menu selection screen 7. Is not displayed.

Next, on the displayed candidate menu selection screen 7, if the person wants to specify by the food genre or the food name, the sales promotion person selects it and the input device 102 is selected.
Genre code 7 displayed on the display device 103 via
1 or the input of information selected by the person in charge from the identification number 72 is accepted. When proceeding to the next operation, the input of the decision 73 is accepted via the input device 102. (Step 502) The product inventory table 2 and the product master table 3 stored in the storage device 106 are loaded into the central processing unit 101, and only the records relating to the ingredients included in the dish name selected in step 502 are stored in the product inventory table. 2. Extract from the product master table 3 and repeat the following process.

From the product inventory table 2, the planned inventory amount 22 and the actual inventory amount 23 corresponding to the identification numbers of the ingredients included in the selected dish name are extracted, and the selected dish is selected from the product master table 3. The inventory reference value 33 corresponding to the identification number of the material included in the name is extracted, and the search product table 8 is created as shown in FIG. FIG. 8 corresponds to the identification number 81, the product name 82, the inventory priority order 83 in the order of excess inventory quantity, the inventory quantity a84, the expiration date priority order 85 in the order of expiring expiration date, and the expiration date order. It is an aggregate of records constituted by the inventory quantity b86. The format of the search product table is a relational database format.

The information of the cell of the inventory priority order 83 in the retrieved product table 8 is derived from the actual inventory amount 23 of the item inventory table, the planned inventory amount 22, and the inventory reference value 33 of the item master table.

If “actual inventory amount 23 ≧ planned inventory amount 22 + stock standard value 33”, the cell information of the inventory priority order 83 is “1”, and “planned inventory amount 22 <actual inventory amount 23 <planned inventory amount”. If the quantity 22 + the stock standard value 33 ", the information of the cell of the stock priority order 83 is" 2 ", and if the" actual stock quantity 23 <the planned stock quantity 22 ", the information of the cell of the stock priority order 83 is It becomes "3". (Step 503) Next, the information of the cell of the expiration date priority 85 and the inventory amount b86 in 8 in the search product table is the actual inventory amount 24, the expiration date 25 of the product inventory table, and the expiration date of the product master table. It is derived from the expiration date reference value x34 and the expiration date reference value y35.

"0 <best-before date 25 ≤ best-before date y3
If it is "5", the information of the cell of the expiration date priority order 85 is "1", and the corresponding stock amount is stored in the stock amount b86.

In addition, "expiration date value y <expiration date value 25≤
If the expiration date value is “34”, the information of the cell of the expiration date priority level 85 is “2”.
It is stored in 86. "Best-before date 25> Best-before date x3
In the case of "4", the information of the cell of the expiration date priority 85 is "3", and the corresponding stock amount is stored in the stock amount b86. (Step 504) According to the results searched in steps 503 and 504, corresponding information in the searched product table is extracted for each food name in the food master table 4, and a sales promotion menu selection table is displayed as shown in FIG. create. FIG. 9 shows an identification number 91, a dish name 92, a material name 93, a judgment point 9
It is an aggregate of records composed of 4. The format of the sales promotion menu selection table is a relational database format.

The information of the cell of the judgment point in the sales promotion menu selection table is as follows: the inventory priority order 83, the expiration date priority order 85, and the inventory quantity b8 in the search product table 8.
It is derived from 6. The inventory quantity b86 for each expiration date priority order 85 in the search product table 8 is compared, and at least one 1 is included in the cell information of the largest expiration date priority order 85 and inventory priority order 83 of the inventory quantity b86. The case is "3", the case where even one is included is "2", and the other cases are "1". Further, the numerical value of the cell of the judgment point 94 is added up for each dish name 92 of the sales promotion menu selection table 9 and sorted in descending order of numerical value.

According to the sorted result, the top several food names are displayed on the display device 103 from the sales promotion menu selection table. (Step 505) In this embodiment, the top five are shown as an example in FIG. In step 506, if there is a food name to be used for sales promotion among the several foods displayed on the display device 103, the input of the food name is accepted from the input device 102, and the determination device 1004 is input from the input device 102. Accept and proceed to the next step.
If not decided, the screen 100 is displayed before the input device 102.
2 and the input of the next screen 1003 are accepted, and the display device 10
The corresponding information is displayed from step 3, and the process is repeated until the person in charge has a food name that he / she wants to utilize for sales promotion.

Using the food name input in step 506 as a key, the information on the food name is called from the food menu table 4 and displayed on the display 107 as a screen as shown in FIG. (Step 507) If the consumer needs the information of the content shown on the screen 11, the input of the print 1104 is accepted from the touch panel 108, and the printout process is performed from the printer 104.
The printed out information is considered to be a useful guide for consumers when they purchase products around the store, and is considered to be an effective means for effective sales promotion. Also, by selecting multiple dishes menu information,
The consumer can search the information displayed on the touch panel 108. In this case, the touch panel 10
From 8, the input of the previous screen 1102 or the next screen 1103 is accepted, and the corresponding data is displayed on the screen 11.

The above is FIG. 5 "Flowchart showing processing steps during operation of the sales promotion support system according to this example".
Is the explanation.

[0028]

EFFECTS OF THE INVENTION According to the present invention, as compared with the conventional sales promotion for single food items in supermarkets, department stores, etc., the product that contributes most to the sales promotion on the sales floor side within the framework of the cooking menu. Effective sales promotion can be realized by deriving a combination and visually providing the consumer with the information on the above-mentioned cooking menu through the information terminal at the store.

[Brief description of drawings]

FIG. 1 is a diagram showing a configuration of a sales promotion support system.

FIG. 2 is a diagram showing a data format and specific data of a product inventory table.

FIG. 3 is a diagram showing a data format and specific data of a product master table.

FIG. 4 is a diagram showing a data format and specific data of a cooking master table.

FIG. 5 is a flowchart showing processing steps of the sales promotion support system.

FIG. 6 is a diagram showing a candidate product input screen of the sales promotion support system.

FIG. 7 is a diagram showing a candidate menu selection screen of the sales promotion support system.

FIG. 8 is a diagram showing a data format and specific data of a search product table.

FIG. 9 is a diagram showing a data format and specific data of a sales promotion menu table.

FIG. 10 is a diagram showing a sales promotion menu selection screen of the sales promotion support system.

FIG. 11 is a diagram showing an output screen of detailed information of cooking information of the sales promotion support system.

[Explanation of reference numerals] 101 ... Central processing unit, 102 ... Input device.

 ─────────────────────────────────────────────────── ─── Continuation of the front page (72) Inventor Fumio Komiya 2-2 Kagahara, Tsuzuki-ku, Yokohama-shi, Kanagawa Hitachi, Ltd. Business system development center

Claims (1)

[Claims] [Claim 1] A sales promotion support system utilized by a person in charge of sales promotion in a supermarket or the like when planning sales promotion of food products, based on conditions such as purchase information, product inventory, and product expiration date. A reference for selecting an effective product to be promoted by selecting a combination of products most suitable for sales promotion and displaying image information that can effectively appeal the product on a display device installed at the store A sales promotion support system that provides information and sells itself.