KR20090002305A

KR20090002305A - Wine information system and its method

Info

Publication number: KR20090002305A
Application number: KR1020070063325A
Authority: KR
Inventors: 김형덕
Original assignee: 김형덕
Priority date: 2007-06-26
Filing date: 2007-06-26
Publication date: 2009-01-09

Abstract

A wine information providing method and system are provided to search wine suited to a desired condition of a consumer and indicate the position of the wine so as to reduce a time required to select and purchase the wine and allow a seller to obtain correct purchase trend information. A wine information providing system includes a storage position indicator(22) for indicating the position where wine is stored and a store terminal(30) which has an input unit, a monitor and a computing unit and is installed in a store. The store terminal searches a database of the store or a database included in a remote server(10) for wine which meets a condition inputted through the input unit and outputs a driving signal to the storage position indicator corresponding to the searched wine.

Description

Wine information system and its method

1 is a block diagram showing a wine information providing system according to the present invention

2 is a diagram illustrating wine information data stored in a store terminal according to the present invention.

3A to 3G are diagrams illustrating a wine information searching process according to the present invention.

4 is a diagram showing trend information data recorded in a database of a server according to the present invention.

5 is a diagram illustrating an embodiment of a screen for searching for statistical information for each wine information in a database of a server;

6 is a diagram illustrating an embodiment of a screen for searching for statistical information for each sale information in a database of a server.

7A is a diagram illustrating a wine information tag

7B is a diagram representing a wine information label

7C shows a table tent

The present invention relates to a method and a system for providing wine information. More specifically, when a consumer searches with a desired search condition, a wine corresponding to the search condition is searched and displays a storage location of the storage location provided on the display rack. It relates to a wine information system and method that allows consumers to choose wine directly through means. The present invention also relates to a method and system for providing comprehensive wine information that enables the seller to formulate an appropriate wine marketing strategy by transmitting the search data of the consumer and the sales data of the store to a database, which is then processed into consumption trend information and provided to the seller. .

In the recent well-being era, interest and demand for wine are exploding. In response to this, the wine marketing method has become a very important task in the wine industry, such as effective inventory management while providing more choices to consumers.

Compared to other alcoholic beverages, the wines are very diverse, and there are more than 50,000 kinds of wines imported into the country at present, and the average wines in stores that handle wines are more than 400 kinds. Because wine is a sign product that depends on individual subjectivity and taste, wine has different specifications for each type of wine such as producing country, winery, vintage, type, variety, sweetness, acidity, body, aroma, finish, and matching food. As a result, many kinds of excessive inventory management are a major cause of poor earnings in the wine industry.

On the other hand, from the consumer's point of view, it is difficult to select more than 10 types of wines, unless you are an expert. So, with the perception that wine is difficult, and when you actually go to buy wine, it is vague to choose a number of wines, and the time to select wine becomes longer.

In our recent survey on wine consumption, we don't know which wine to pick first, because we can't enjoy the wine intimately and comfortably. , 4th table manners, etc. I do not know the wine common sense, the answer to the 5th wine is embarrassing and bothered.

Therefore, the wine industry needs a separate expert to help consumers choose wine, and bears another cost. In addition, even if a wine expert has a recommender or sommelier in the store, it is not easy to find a wine that satisfies consumers' various tastes and subjective criteria. For example, there is a sommelier that specializes in serving wine at hotels and restaurants, but restaurants with these are usually very limited and expensive. Instead, consumers can get information using the Internet without any price, time, and location restrictions, but it is often not helpful to purchase because the wine they searched on the internet is not actually in the store they visited.

In other words, those who are new to wine will be overwhelmed by many types of wine first, and after 5 minutes of actually choosing wine, consumers will become psychologically nervous. Thus, if wine selection is not made after 10-15 minutes, the wine selection is eventually abandoned. Based on the wine consumption behaviors (Consumer Behaviors) look at the customer loss table according to the wine selection time in 1000 domestic hypermarkets and specialty shops, the results are shown in Table 1.

Audience Virtual Loss Table division Daily average 1 month average 1 year average Number of businesses 1,000 30,000 360,000 Customer loss per store 5 people 150 people 1,800 people Average number of purchases per person 1.5 BOTTLE 45 BOTTLE 540 BOTTLE Loss per person 30,000 won 900,000 10,800,000 Total Ross Number 5,000 people 150,000 1,800,000 people Total purchase number 7500 BOTTLE 225,000BOTTLE 2,700,000 BOTTLE Total Loss Amount 150 million 4.5 billion 54 billion Assumptions: Businesses-1,000 potential customers at current wine handling companies (large marts, shops, bars, etc.) in the country-Average purchase price per 5 prospective customers per 1 average shop per day due to increased selection time- It is assumed that 30,000 won is converted to Ross.

Such characteristics of wine and consumer purchasing are the biggest obstacles to the distribution and industrial development of wine.

Although this problem is recognized as a big problem in the wine industry, there is no comprehensive wine information system or method for solving this problem.

However, a technology for transmitting information about a wine selected by a consumer to a mobile communication terminal is disclosed in Patent Registration No. 10-0706335 (Wine Information Providing System and Method Using a Mobile Communication Terminal). At this point it will give information about the wine. Even if the consumer chooses the wine type according to the provided information, if the actual wine is not desired after the selection, the new wine must be selected again to obtain the information, so that the consumer can greatly help in purchasing the wine offline. This has not been done.

On the other hand, the wine seller can improve the wine sales rate while minimizing the inventory only if you know the purchase trends for wine, such as by age, gender, region. For this purpose, Patent Application No. 10-2005-0057929 (Wine Marketing Information Provision Method) is disclosed. The technology stores wine search information using a telecommunications terminal in a database and stores consumers' tastes for each distribution channel according to the stored data. The wine information is provided to the wine supplier, that is, the seller to be used for marketing. In addition, when the customer requests the arbitrarily stored wine information, the information is provided to the mobile phone terminal, and the consumer's selection information including the consumer's wrong selection is not used as the information on the consumer's selection criteria. There are many differences from the consumer's actual consumption trend.

On the other hand, Patent Application No. 10-2005-0021576 (a wine refrigerator and a control method capable of automatic selection of storage location) is disclosed as a technology for storing and retrieving wine on-line. Since wine needs a storage location with proper humidity and temperature, it is a technology to find the optimal storage location.It detects the temperature and humidity of each part of the refrigerator and displays the optimal storage location of the wine according to the wine information on the display. The RFID tag is attached to each wine and alerts the user when the wine is not stored in the designated location. However, the technology merely provides information about the storage location offline.

The peculiarity of the wine industry is that wines of the same type or region do not treat the same wines as much as possible. For example, if a wine dealer deals with 400 to 1,000 wines in a store, the overlap rate will not reach 30%.

In addition, the wine must be added a new product in a very short cycle, the price fluctuations, it is difficult to provide accurate product information immediately. In other words, due to the vastness of the wine information, the limitations of the type of wine specification data, and the changing data, there is a difficulty that the fixed personnel cannot obtain and provide accurate information. In particular, the wine industry desperately needs professionals who have the ability to combine sommelier and wine knowledge as distribution specialists. However, there is a lot of problems in the wine industry due to the lack of procurement of professionals compared to the explosive growth of wine demand. .

In order to solve the above problems, the present invention is to significantly reduce the wine selection and purchase time by actually searching for wines suitable for the conditions desired by consumers on the offline and displaying the storage location. Indeed, a consumer who has come to buy wine for the first time can simply purchase a desired wine within 5 minutes by simply operating the system of the present invention, thereby making it possible to expand the wine population.

Another object of the present invention is to enable the actual search conditions and sales information of the consumer to be immediately reprocessed and transmitted to obtain accurate purchase trend information from the seller's point of view. In the present invention, since the consumer is required to directly enter the wine search conditions to search and select, the very accurate information is provided in conjunction with the actual sales data in the store, this information is processed in the server again statistical information almost no errors The collected data can be processed into national statistics, allowing wine dealers to develop marketing strategies that can increase sales rates while minimizing inventory.

A feature of the present invention for achieving the above object is to install a storage location display means for each wine storage location provided in the store shelves, and if the wine information search conditions are entered into the store terminal to search for wines that meet the conditions By providing a wine information providing system and method for displaying the storage location of the wine to the consumer through the storage location display means to help the consumer's wine selection and shorten the purchase time.

Meanwhile, in the above configuration, the store terminal displays the wine storage location as a text message to the mobile communication terminal registered by the consumer in the process of displaying the wine storage location so that the waiting time of other consumers for the wine search can be shortened.

Further, the search information of the store terminal is processed and stored to be used as consumer trend information in a database through the server, and the seller's sales information is also processed and stored as purchase trend information in the database of the server, so that the seller is a store terminal. Or, it is possible to determine the consumer's consumption trend through the seller terminal, so that an accurate marketing strategy can be established, thereby improving the sales rate.

In addition, the wine information tag to provide information on the origin, quality, price, etc. of the wine through the store terminal, the label attached to distinguish each wine bottle, and on the table for promotion in restaurants or stores It is possible to output the table tent provided, thereby improving the efficiency of store management.

Meanwhile, in the above configuration, the store terminal is provided in the store and used by the seller or the consumer to use the wine information search, the sales information record, and the consumption trend search, or the consumer may use the wine information search only. If the seller terminal is provided separately.

An embodiment of the present invention having the features as described above will be described in more detail with reference to the accompanying drawings.

1 is a block diagram showing a wine information providing system according to the present invention.

Wine information providing system according to the present invention is a variety of wine information (brand name, country of origin, type, variety, sugar, body, price, etc.) and the statistical data for each of the above wine information, sex, age, occupation, blood type, A database 12 including wine consumption trend information including purchase trend information including purchase statistics by purchase root, old motives, and period sales statistics is processed, and the data input on / offline is processed to the database 12. A server 10 for storing and retrieving data corresponding to the input search condition from the database 12 and outputting the data;

A storage position display means 22 in which driving is controlled according to an operation control signal inputted by a position display unit for each wine storage position of the display stand 20 provided in the store;

Like a typical computer system, it is equipped with an input means, a display means, a calculation means, etc. and is installed in a store, and wines that meet the conditions inputted through the input means are stored in the wine database which is provided on its own or online from a remote database connected to it. A store terminal 30 for outputting a driving signal to the storage position display means 22 at the closed position and transmitting the search information to the server 10;

Records various personal information such as customer's name, age and occupation, customer information including purchase history and trend information such as date, product, price and country, and various sales information such as product name and price In addition, it is composed of a seller terminal 40, such as a conventional computer system that transmits the sales information to the server 10 and retrieves and confirms the wine consumption trend information through the server 10.

In the above configuration, the display rack 20 is provided with an artificial wine cell capable of temperature control, the storage position display means 22 of the display stand usually uses light emitting means such as LED, and the wine previously retrieved in the "ON" state This is displayed, when the consumer selects the desired view after the wine search through the kiosk-type store terminal 30, that is, when the kiosk is searched, it blinks. If you are not using a kiosk, LEDs for a specific time (5 minutes, etc.) can perform equalizers, sequential lights, etc. to attract the attention and attention of consumers in the store. It is also desirable to be designed to add sophistication to the atmosphere of the wine shop or dealership.

In the above configuration, the store terminal 30 is used by the consumer and may be used only for the search and location information acquisition of wine, or may be simultaneously used by the seller and the consumer to perform the role of the seller terminal 40. In the embodiment of the present invention, the terminal 30 is preferably used for the wine kiosk for wine information search and location information acquisition.

In addition, the seller terminal 40 is used only for the seller and preferably used only for the purpose of obtaining consumption trends.

The database in which the storage location information of the wine is recorded may be provided in the store terminal 30 itself, or may be used only by the seller and is provided only in the seller terminal 40 installed in the store or remotely. Although they may be connected to the seller terminal 40 to search, the embodiment of the present invention will be described as an example that the database is provided in the store terminal 30 as described above.

On the other hand, in the above configuration, the store terminal 30 further includes a short message service unit, and transmits a message corresponding to the searched wine location to the mobile communication terminal of the number entered through the input means when searching.

In the storage position display means 22, the position display unit may use light emitting means such as a light emitting diode (LED), a lamp, or the like provided in the display stand 20, or a display means may be used.

The wine information search method using the system as described above will be described below.

When the seller of the store has a new wine, the product information such as the origin, quality, price, and sweetness of the wine and the storage location are basically recorded in the database of the store terminal through the input means. As shown in the wine product data is entered (S101), the input wine product information is searched for information recorded in its own database (S102) to determine whether there is the same information, if there is the same information to retrieve the retrieved information is corrected Input the item to complete the final product input (S103), if there is no information in the database to complete the input of the product (not shown) by inputting the necessary items on its own, or input the information for more accurate information Data sent to the server (S104) (S105), and the same product-related data based on the information input from the server Collect and compare the data fields (S106) and fill the necessary items for product input or delete unnecessary items (S107), and then transfer the definitive data for the wine to the expert system equipped with experts. Checking such as error correction is performed from (S108). When the data of which the inspection is confirmed is transmitted, the corresponding data is recorded in the database of the server (S109), and recorded in the database of the store terminal as shown in FIG.

On the other hand, the expert system in the above-described configuration is also a conventional computer system having an input means, display means, storage means, calculation means, etc., to check whether there is an error from the data on the transmitted wine, if there is an error, the final Send the result to the server.

Then, the consumer enters the membership process while inputting consumer information such as age, gender, name, occupation, etc. before searching for wine information through the store terminal. The characteristic of the wine market is that the number of potential customers is very large compared to other restaurants. For example, if the ratio of regular customers and fixed customers is 10:90 in the general restaurant business, wine is formed in the reverse direction of 70-90: 10-30. Therefore, it is important to have a fixed customer and prospect list with a simple customer registration process.

Thereafter, the registered member through login, the non-subscribed consumer selects the desired search menu on the store terminal main screen of FIG. 4A after the above-described consumer information input process.

The consumer selects a condition he / she wants through an input means (in the present invention, a touchpad) of a store terminal in a search menu (multi-search). The time required is only about 1 to 3 minutes.

As shown in Fig. 4B, desired search conditions such as price, type, variety, country, and sugar can be entered. In addition, if you execute the event item menu to check the information that is sold as an event item in the store, information about the event item is displayed as shown in Figure 4c, to find a wine similar to his favorite wine in Figure 4d As shown, when using the family wine search menu, the information of the corresponding wine is displayed, and in order to confirm the search order of the corresponding store, the search ranking wine menu shown in FIG. 4E is executed, and to confirm the search information in the corresponding store, As shown in FIG. 4F, the search history menu is executed. The wine education menu of the main menu displays detailed information and manners of the wine as shown in FIG. 4G.

As described above, after the customer searches for wines in a desired condition and selects the location view of the menu, the storage location display means of the location where the selected wine is stored is turned on, and the user can move to the storage location to find the selected wine. Will be. As such, the location information is automatically displayed in the wine cell equipped with artificial intelligence, and the time required for the consumer to select and purchase the wine searched by the actual light is not more than 1 minute to 2 minutes.

On the other hand, before using the wine information search menu, in the sign-up step or the consumer information input step, the consumer enters the mobile terminal number provided by him, and when the location view is executed, the store terminal displays the storage location of the display rack In addition to lighting and by sending the data on the storage location to the mobile terminal of the consumer as a text message, when there are many consumers to minimize the waiting time in the wine search process.

The wine search information is recorded in the database of the store terminal for each item and transmitted to the database of the server every predetermined time period or every moment, and the transmitted information is classified as wine information in the database and stored as statistical information. On the other hand, when the actual purchase is made in addition to the data transmitted from the above-described store terminal, the seller terminal in the consumer purchase motivation (for example, wedding anniversary, holiday gifts, sommelier recommendation, tasting, birthday gifts, etc.) and the purchase path (newspaper, advertisement) , Magazines, flyers, introductions, etc.), and actual product information and sales information such as purchase motivation and purchase path are transmitted from the seller terminal to the server, and statistical information for each sales information is recorded in the database. An example of the statistical information is shown in FIG. 5, in FIG. 5, the U-sommelier represents a seller terminal of the present invention, and a wine apple represents a store terminal.

On the other hand, the information transmitted to the database of the server recorded and the statistics are obtained and used as consumption trend information, the example will be described in detail below.

First, the sales information data transmitted from the seller terminal is divided into sales statistics, customer information and statistics, and purchase trend analysis, and recorded in the database, and the data transmitted from the store terminals are search statistics, customer information and statistics, and customer propensity (by gender). , Age group, blood type, occupation group, purchase motivation, purchase route, etc.) and are stored in different areas of the database.

As such, the sales information data transmitted from the seller terminal using the information stored in the database is recorded as the actual sales information. Therefore, this data is used to identify actual purchase trends, and the search data transmitted from the store terminals records the expected purchase trend. Used as grasping data.

Among the customer information and statistical data, the data transmitted from the seller terminal is used to identify the actual customer trend through the sales linked customer analysis, and the data transmitted from the store terminal is used as the expected customer trend information through the search linked customer analysis. do.

In addition, the purchase trend tendency analysis data transmitted from the seller terminal is used to identify the expected trends of the actual customers through the analysis of the propensity of the real customers, and the customer tendency analysis data transmitted from the store terminals is simulated by the expected customer propensity analysis. Used to identify customer trends.

In this way, the data stored in the database is used by the seller terminal to access the server and used as data for demand forecasting. For example, it is provided on the homepage of the server such as wines that women in their 20s like, popular wines by price range, and popular wines by purchase motive. It is possible to search using the search menu shown in Figs. 6 and 7.

On the other hand, if the seller needs a wine information tag, label, and table tent, the seller uses the corresponding wine information tag, label, and table tent data and wine data recorded in the store terminal as a simple selection and editing operation through input means. As shown in Figs. 8A to 8C, the wine information tag, label, and table tent can be output.

Since 15 to 20 pieces of wine information is usually required for consumers to purchase wine, it is necessary to provide a wine information tag (VMD) with a VMD (Visual MerchanDising) technique to contain such a lot of information. In the absence of a wine information tag, consumers have greatly reduced their intention to purchase due to the absence of wine product information and an increase in purchase time.In the case of sellers, timely information is required due to lack of time, cost, and manpower for the production of various wine information tags. Difficult to build and attach tags The seller automatically uses the wine specification data registered at the time of product registration, automatically outputs the wine information tag by using the information entered as a higher concept than the price tag for the product information in the wine kiosk, and can also make various changes. First select the desired tag style, bring up the wine list, edit the text color, border, position, background color, etc., and print it. Cut the output and attach it to the wine.

The wine label can be used directly as a POP (Point of Purchase) strategy to increase the merchandise of the wine and increase the purchasing power of the consumer.The special label (marriage, birthday, etc.) of the consumer is added to provide special value and satisfaction to the consumer. Grant. In the label production process, first select the desired label style, input the date, title, text content, sender, and then select the number of outputs you want to print.

According to the present invention configured as described above, when a consumer visits a store and inputs only the desired wine conditions, the corresponding wine is guided and displayed to the storage location, so that the time for purchasing wine is shortened, and it is difficult to purchase wine. There is an effect that the satisfaction is improved.

In addition, in the case of the seller, the selling time is increased because the purchase time is shortened, and accurate buying trend data can be obtained, so that accurate marketing power can be established, thereby minimizing the stock rate and increasing the selling rate.

In addition, wine information tags, labels, and event event table tents for new wines and selected wines can be output with a simple operation, so that consumers can easily obtain their own labels, and the seller can also satisfy the consumers with new wines. At the time of receipt, necessary information tags and table tents can be obtained without requesting a separate advertising agency or printing company, thereby reducing costs and time.

Claims

Storage position display means for controlling the driving in accordance with the operation control signal input is installed by the position display unit for each wine storage position provided in the store,

It is equipped with an input means, a monitor, a calculation means, etc., and it is installed in a store and finds a wine meeting the conditions inputted through the input means from a database of the store or a database provided on a remote server, and stores the wine storage location. Wine information providing system, characterized in that consisting of a store terminal for outputting a drive signal to the position display means.

The wine information providing system of claim 1, wherein the store terminal comprises a short message service unit and transmits a message corresponding to the retrieved wine location to a mobile communication terminal input through an input unit when searching.

In the wine information providing method, which is connected to a database including information on various wines and a server, the server processes the data input on / offline and stores it in the database and retrieves the data corresponding to the input search condition from the database. In

Recording the wine product information for each wine storage location provided in the store in its own database or a remote database that can be accessed online through a store terminal including an input unit, a monitor, and a calculation unit provided in the store;

A search condition input step of receiving a wine search condition through an input means of a store terminal;

An information retrieval step in which the store terminal searches for wines corresponding to the input search condition from a database;

Method of providing wine information, characterized in that consisting of a display step for displaying the storage location of the wine by driving the store terminal display unit storage location display means corresponding to the retrieved wine.

The method of claim 3, wherein in the search condition input step, the consumer further inputs the number of the mobile communication terminal provided by the consumer, and in the display step, the store terminal text message the storage location of the wine using the inputted mobile communication terminal number. Wine information providing method characterized in that the output.

The method of claim 3, further comprising: inputting and storing information such as age, gender, occupation, blood type, etc. of the consumer before performing the search condition input step, and the search condition and the consumer input for each store in the search condition input step The information is transmitted to the server through the store terminal and processed into the purchase trend information in the database of the server and recorded.

When the seller makes an actual purchase through the input means and the display means, the seller records the sales information including the purchase customer's information and the sold product information, and the sales information is transmitted from the seller terminal used in common or alone with the store terminal. Is recorded as consumption trend information in the database of the server,

When there is a request for consumption trend information from a separate seller terminal or a store terminal connected to the server, the server further includes a purchase trend information transmission step of retrieving the corresponding request information from the database and transmitting the requested trend information to the requested store terminal or seller terminal. Characterized by the wine information providing method.

According to claim 3, Store terminal or seller terminal in the wine information tag for providing information, such as the country of origin, quality, price, label attached to distinguish each wine bottle, and for promotion in restaurants or stores Table tent data provided on the table is recorded, so that any one selected from the wine information tag, label or table tent according to the input wine to output and edit after the wine information providing method.

The method of claim 3, wherein in the recording of the wine product information in a database,

Wine product information entered through the input means is to search the information recorded in its own database to determine whether there is the same information, if there is the same information, retrieve the retrieved information and input the corrections to complete the final product input,

If there is no information in the database, enter the necessary items on its own to complete product input, or send the input information to the server, collect data on the same product based on the information input from the server, and compare the data fields. After filling the necessary items for input or deleting unnecessary items, send the confirmation data about the wine to the expert system equipped by the expert. The wine information providing method characterized in that the data is recorded in the database of the server after the data is recorded in the database of the server to the store terminal.

6. The method of claim 5, wherein the wine consumption trend information is wine information statistical data, including product name, country of origin, type, variety, sugar, body, price;

Wine information providing method characterized in that it comprises a; statistical information by sales information, including sales statistics by sex, age, occupation, blood type, purchase root, purchase motivation, period.